TOTAL DAYS: 1 | TOTAL HOURS: 6.5
SQL Querying: Advanced
In the course SQL Querying: Fundamentals (Second Edition), you learned the basics of SQL querying. In this course, you will build on this foundation, learning advanced querying techniques, such as writing nested queries, using JOINs to combine data from multiple tables, summarizing query results, using advanced filtering, and using views to simplify repetitive querying tasks. You will also learn how to perform common database administration tasks such as duplicating tables, modifying table structures, inserting, updating, or deleting data, and indexing tables to optimize query performance. You will also learn how to work with multiple tasks as a transaction.
This course is the second part of a two-course series that covers the skills needed to gain a foundational understanding of SQL Querying.
– SQL Querying: Fundamentals
– SQL Querying: Advanced (this course)
Completion of this course will earn 7.5 CPEs.