SQL Server

Fast Track offer a range of courses ….

  • SQL – Part 1 : Introduction to Query Writing
  • SQL – Part 2 : Gaining more from your Database with more complex Queries
  • SQL – Part 3 : More Features and Advanced Queries

SQL – Part 1 : Introduction to Query Writing

Target Audience

The course is designed as an introduction to the important features of relational databases and specifically Microsoft SQL Server.

The course is designed for delegates who need to understand the basic concepts of SQL Server and writing basic queries to retrieve data from the server.

.

pdf download

The Content

Introduction to databases and SQL

  • What is a Database?
  • Relational database basics
  • Overview of Table Structure
  • Other Database Objects

Overview of SQL Server Management Studio

Introduction to the SELECT statement

Writing basic SELECT Queries using

  • SELECT
  • FROM
  • WHERE
  • GROUP BY
  • HAVING
  • ORDER BY

Introduction to SQL Expressions

Retrieving data from multiple tables using join queries

  • INNER JOINS
  • OUTER JOINS

Tables versus Views

  • What is a view
  • Writing queries using views

Using the Query Designer to start your Query

Delegate Pre-Requisites

No previous experience of SQL Server or relational databases is required.

Course Duration

This is a One Day Course

Course Details

Courses commence at 9:30 a.m. through to 4:30 p.m.

All delegates will receive comprehensive Training Courseware together with a Course Attendance Certificate

SQL – Part 2 : Gaining more from your Database with more complex Queries

Target Audience

The course is designed for delegates who need to extend on the basic concepts of SQL Server query writing.

pdf download

The Content

Review Multi-table queries  using INNER/OUTER Joins

Writing Cross Join & Self Join Queries

Combining Queries with SET operators

  • UNION
  • UNION ALL
  • INTERSECT
  • EXCEPT

Creating more expressions using Functions

  • String Functions
  • Maths Functions
  • Date Functions
  • Conversion Functions

Writing Subqueries

  • Subquery overview & rules
  • Simple subqueries
  • Creating multilevel subqueries
  • Correlated subqueries

Performing Analysis with Analytic & Window Functions

  • OVER Clause
  • PARTITION BY clause
  • ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, LEAD, FIRST_VALUE and LAST_VALUE functions

Extending the ‘reach’ of your Queries using Temporary Named Result Sets

  • Creating Derived tables
  • Creating Common Table Expressions (CTE’s)

Writing Queries to gain insights into the structure and configuration of the Database

  • Viewing Schema Information
  • Checking Object Dependencies

SQL Guidelines

  • These guidelines can help improve the quality and efficiency of SQL code and contribute to the overall success of database projects

Delegate Pre-Requisites

Delegates have previously attended the SQL – Part 1 – Introduction to Query Writing course or have experience writing queries using the concepts covered in this previous course.

Course Duration

This is a Two Day Course

Course Details

Courses commence at 9:30 a.m. through to 4:30 p.m.

A laptop computer is provided for each delegate attending on this packed programme to try out the tips and techniques demonstrated

All delegates will receive comprehensive Training Courseware to refer to during the course, together with a Course Attendance Certificate

SQL – Part 3 : More Features and Advanced Queries

Target Audience

The course is designed for delegates who need to extend on the basic concepts of SQL Server query writing.

The course includes writing queries for use with Microsoft SQL Server to be able to further analyse and manipulate data including more advanced T-SQL knowledge for those who have attended the SQL – Part 2 : Gaining more from your Database with more complex Queries course

pdf download

The Content

Review Session

  • Subqueries
  • Derived tables
  • Common Tables Expressions
  • Views

Traversing hierarchies using  CTE’s

Temporary Tables

  • Temp Tables
  • Tables variables

Working with GROUP BY

  • GROUP BY ALL
  • Using ROLLUP or CUBE
  • Grouping Functions

Using CASE Statements

Creating PIVOT/ UNPIVOT Queries

Introduction to Stored Procedures

Implementing Error Handling

Introduction to User Defined Functions

Looping Techniques

Simple Query Execution Analysis

Accessing SQL data in excel

Introduction to Transactions*

  • *If required/ time allows

Delegate Pre-Requisites

Note : this is not a beginners course.  Delegates should have knowledge to the level of our SQL – Part 2 course, or have attended the SQL – Part 2 course. For those requiring a more basic level of SQL for reporting then please consider the SQL – Part 1 / Part 2 courses

Course Duration

This is a Two Day Course

Course Details

Courses commence at 9:30 a.m. through to 4:30 p.m.

All delegates will receive comprehensive Training Courseware together with a Course Attendance Certificate