Course Details

Are you interested to expand your knowledge of Structured Query Language (SQL), the industry standard database programming language? Then this is obviously the right course for you.
This course involves a step-by-step guide on techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. In the beginning, you'll explore how to write and implement complex queries on multiple tables simultaneously and how to apply advanced filtering techniques. You'll also receive training on how to create union queries that combine records from multiple queries, and you'll discover how to use union queries to exclude or include duplicate records. In addition, you'll find out how to use text strings within union queries. 
At the next stage, you'll learn how to master advanced techniques for updating various types of data stored in your tables. You'll learn how to update a single field, multiple fields, multiple records, date fields, and calculated fields; apart from updating and setting NULL values using an update statement. 
This course also teaches you to use advanced insertion techniques to add data to your tables and learn how to create, query, and modify temporary tables. You'll also see how to implement techniques to handle duplicate values stored in a table and how to limit the results of a result set. Other benefits of this course include learning how to use string functions to perform complicated searches on strings, how to implement date and time functions to insert and extract portions of a date, and how to create queries that accept input from users.