- Learn how to carry out advanced data queries.
- Learn advanced techniques to insert, delete and modify data.
- Learn how to optimise your database performance.
Price €325 per person
This course is designed for participants who have completed the SQL Introduction course or who are familiar with writing simple SQL queries to query and maintain a relational database.
Basic understanding of computers and the ability to open and close programs on your computer.
GOALS AND OBJECTIVES
Advanced Selects – Revision
Recap on SQL main Clauses
Conditional processing with CASE
Advanced Select New Topics
Modified Comparison operators (ANY, ALL, SOME)
Restricting records using TOP (with ties)
Expanding searches using Wildcards ( % , _ , [ ] , [ ^ ] )
RANK and DENSE RANK functions
Using the COMPUTE clause
CUBE and ROLLUP clauses
Advanced Table Joins
Joining Multiple Tables
Using the Merge Command
Using Temporary tables
Different types of temporary tables
When to use temporary tables
Advanced Data Manipulation Commands
Using the OUTPUT clause with INSERT, UPDATE, DELETE
TRUNCATE TABLE command
Transaction Processing in details
Transaction save points
Setting Transaction Isolation Levels
Using the Inserted and Deleted Tables
Best Practices for optimising Performance
Summary and Review