Description
This course is aimed at learners who have a good grounding in SQL and wish to grow their skills further. The course will include learning how to carry out advanced data queries, advanced techniques to insert, delete and modify data and optimising database performance.
Full Day Course Price: €500 per person
Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.
To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.
Dates
- 14 June 2023, 1 day
- 11 September 2023, 1 day
- 31 October 2023, 1 day
- 12 December 2023, 1 day
TARGET AUDIENCE
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.
PREREQUISITES
A good basic knowledge of SQL and relational databases. Ideally, learners should have attended an SQL Introduction course as well.
GOALS AND OBJECTIVES
- Learn how to carry out advanced data queries.
- Learn advanced techniques to insert, delete and modify data.
- Learn how to optimise your database performance.
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
Summarising Data
Using the COMPUTE clause
CUBE and ROLLUP clauses
PIVOT table
Advanced Table Joins
Self Join
Joining Multiple Tables
Correlated sub-queries
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
Data Integrity
Unique Constraints
Check Constraints
Default Constraints
Transaction Processing in details
Transaction save points
Setting Transaction Isolation Levels
Triggers
Creating Triggers
Using the Inserted and Deleted Tables
Database Performance
Using Indices
Best Practices for optimising Performance
Performance Monitoring
Summary and Review