Course description
SQL Advanced Querying
Students will learn advanced queries and how to add, update, and delete data, tables, views, and indexes.
Upcoming start dates
Suitability - Who should attend?
Students should already understand the basics of querying a database with the SQL command language. They should be comfortable issuing SELECT queries against one or more tables and understand query concepts, such as joins.
Prerequisites
SQL Fundamentals of Querying or equivalent knowledge.
Outcome / Qualification etc.
Students will learn how to change, update and manipulate an SQL database.
Training Course Content
Querying with unions and advanced joins
- Querying multiple tables with unions
- Advanced Joins
- Calculating with COMPUTE
Querying with subqueries
Subqueries
Adding data
- Inserting data
- SELECT INTO
Updating and removing data
- Updating records
- Deleting records
- Deleting the contents of tables
Manipulating tables and views
- Creating tables
- Modifying tables
- Deleting tables
- Adding and removing views
Ensuring data integrity with transactions
Transactions
Creating databases
- Creating a database with SQL
- Deleting a database
Reviews
Request info
Welcome to Systematix, your gateway to a world of boundless learning and professional growth! At Systematix, we believe that knowledge is the key to success, and we are dedicated to providing top-notch training solutions designed to empower individuals and organisations...