Writing SQL Queries
Advanced Course
Length - 2 Day
About the course
This DataShed Advanced SQL Queries course provides participants with the skills to create and execute
high level query tasks with Microsoft SQL Server 2016, along with practical examples. It is expected
participants will have a good working knowledge and understanding of SQL Management Studio and basic
SQL query writing. The course covers many aspects of writing practical high level SQL queries to even
further enhance your data management system. It includes instruction on how to apply several
expressions to make data interrogation more efficient.
At the completion of this course participants should be able to:
• Understand and Implement the use of Expressions including;
o TOP
o Advanced Joins
o Sub-Queries
o Dynamic SQL
• Execute Plans
• Transactions
Who should attend?
Users of DataShed who have a strong working knowledge of writing and implementing SQL queries or
have attended the DataShed Introductory Queries Course and wish to advance their knowledge and
ability to interrogate SQL databases.
About our trainers
Our course leaders are selected from our team of highly skilled data consultants.
Course Content
Day 1
1. TOP, Aggregate and Ranking Functions
2. Joins - Revision
3. Advanced Joins
4. Sub-Queries
Day 2
1. Dynamic SQL
2. Execute Plans
3. Transactions
4. Review and Questions
+61 8 9432 1777 training@maxgeo.com maxgeo.com
Day 1
Advanced Query Functions
TOP, AGGREGATE and RANKING FUNCTIONS
• Revision of Basic Query Tools
• TOP clause
• Grouping/Aggregate Functions
o DISTINCT keyword
o GROUP BY Clause
o ROLLUP/CUBE
o HAVING clause
• Ranking functions
• OVER/PARTITION BY
ADVANCED JOINS and SUB-QUERIES
• Revision of Basic Joins
• Self-Joins
• Non-Equi Joins
• CROSS Joins
• Non-Correlated Sub-Queries
• Correlated Sub-Queries
• Derived Tables
• Common Table Expressions
Day 2
More Advanced Query Functions
DYNAMIC SQL - EXECUTION PLANS - TRANSACTIONS
• SELECTing SELECTs
• EXEC
• Execution Plans
• Transactions
• Autocommit/Implicit/Explicit
• BEGIN TRANSACTION
• COMMIT/ROLLBACK
• SAVEPOINT
TRANSACTIONS - PRACTICAL APPLICATIONS
• Nested Transactions
• Using Transactions
• Review and Questions
+61 8 9432 1777 training@maxgeo.com maxgeo.com
