Olas Software Training and Development | SQL Level 2
00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

SQL Advanced

 

Description

  • 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

Dates

  • Book a place on this course and pay with your credit card.17th February 2017 , 1 Day
  • Book a place on this course and pay with your credit card.11th April 2017 , 1 Day
  • Book a place on this course and pay with your credit card.20th June 2017 , 1 Day
  • Book a place on this course and pay with your credit card.12th October 2017 , 1 Day
  • Book a place on this course and pay with your credit card.14th December 2017 , 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

Basic understanding of computers and the ability to open and close programs on your computer.

GOALS AND OBJECTIVES

Course Outline
Click here to download course oultline

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

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.