Advanced SQL Querying
Course Description
This course builds on the Introduction to SQL course, and provides students with the additional skills needed for the handling of more complex database tasks. It introduces the more advanced topics of Stored Procedures and Triggers, and also provides grounding in the theory of database relationships so that the student can have a better understanding of database structures.Duration: 1 day
Content
NormalizationQuerying with unions and advanced joins
Querying with sub-queries
Adding data
Updating and removing data
Manipulating tables and views
Manipulating indices
Transactions and data integrity
Triggers
Stored procedures
Creating databases
Permissions