Linkedin Learning Free Certification Course -SQL Essential Training Course (100% Discount)
Course details
- 3h
- Beginner
- Released: 12/3/2019
4.7
(10,040)
Knowing how to code and manage relational databases and database-driven applications is a valuable skill for any career in tech. Completely updated for 2019, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. All the lessons have been recorded in SQLiteStudio, an intuitive and easy-to-install database manager. Instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and using subselects and views. He offers a solid working knowledge of the language and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple application using SQL.
This course was created by Bill Weinman. We are pleased to offer this training in our library.
Learning objectives
- How databases are organized
- Selecting rows and columns
- Creating new tables
- Inserting and updating data
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Using CRUD functions
Skills covered
Completion Certificate
You can earn a certificate on completing this content
Also Read: Giveaway For Tricky Man Subscribers! Premium Certified Course For 100% FREE
Also Read : IIT Kanpur Launched Free Online Certification Course | Get Free Certificate & Learning by H.C Verma
Also Read : IET India Scholarship Awards 2022 | Special Scholarship for Engineering Students