course-premium

SQL Advanced Course

5.0
1 review
  • I am familiar with SQL and after taking this advance course, I feel more confident with my old skills and feel even better that I learnt something new. Thank you.
    |

Short course

In Jersey Guernsey (UK Offshore Dependencies) and Birmingham

Save 8%
£ 685 VAT exempt

Enrol into this course to level up in your SQL knowledge!

  • Type

    Short course

  • Level

    Intermediate

Subqueries, CTE, Procedures, Functions,Temp Tables

Are you ready to level up in the SQL world? learn more about it with this course offered by Emagister and imparted by PCWorkshops is for you!

At the beginning you’ll learn about SQL Sub- Queries, in the Where, select from or Having clauses, different clauses in the self- contained sub-queries. Correlated sub-queries and the ones with EXISTS predicate.

Furthermore, you’ll learn about Derived tables and CTEs (Common Table Expressions) using SQL derived tables, creating, altering and dropping views and indexes. Parameters and return values, looping, cursors and many other factors that will boost your skills.

This course includes an assessment-based SQL course certificate, including the notes, practical exercises, revisions of your work and also coffee and tea.

In order to prepare you for the certification, you’ll have one free session via Skype or TeamViewer for questions online. (Maximum groups of 4 students).

So, if you want to learn more, don’t hesitate to contact PCWorkshops through Emagister.

Facilities

Location

Start date

Birmingham (West Midlands)
See map
One Victoria Square, B1 1BD

Start date

Different dates availableEnrolment now closed
Jersey Guernsey (Channel Islands)
See map

Start date

Different dates availableEnrolment now closed

About this course

In works professionals. University students

SQL Queries, Aggregates, Joins.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

5.0
  • I am familiar with SQL and after taking this advance course, I feel more confident with my old skills and feel even better that I learnt something new. Thank you.
    |
100%
5.0
excellent

Course rating

Recommended

Centre rating

A. Kraney

5.0
13/09/2017
What I would highlight: I am familiar with SQL and after taking this advance course, I feel more confident with my old skills and feel even better that I learnt something new. Thank you.
What could be improved: n/a
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2018

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 6 years

Subjects

  • Database Management
  • Database
  • SQL
  • Database training
  • SQLite
  • Primary
  • Programming
  • SQL Database
  • SQL Server
  • Data Types
  • SQL queries
  • Testing conditions
  • Basic transactions
  • Beginning a transaction
  • Committing
  • Rolling back

Teachers and trainers (1)

Mary  Smith

Mary Smith

Tutor

How Mary Smith teaches: I am consultative, flexible and understanding. I appreciate the trust given to me. What Mary Smith teaches: Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder. Java Coding Basics.

Course programme

SQL Sub-queries ·Sub-queries in the WHERE, SELECT, From or Having clauses ·Using SOME, ALL, ANY and IN clauses in the Where Clause ·Self-contained sub-queries ·Correlated sub-queries ·Sub-queries with the EXISTS predicate
Derived Tables and CTEs ·Using SQL derived tables ·SQL Common Table Expressions (CTEs) ·Recursive CTEs
Views: Create, alter and drop Views, Indexes
SQL Stored Procedure Basics ·Stored Procedure Principles ·Creating stored procedures ·Executing stored procedures ·System stored procedures
Variables ·Declaring variables ·SET versus SELECT
Parameters and Return Values ·Passing parameters ·Default values and WHERE clauses ·Output parameters ·Using RETURN Testing Conditions ·The IF/ELSE statement ·CASE ·CHOOSE
Looping ·Syntax of SQL WHILE ·Breaking out of a loop ·Basic transactions ·Beginning a transaction ·Committing/rolling back ·Deleting and updating ·Using DELETE and UPDATE ·Sys.Objects ·Dropping objects User defined Functions Table Valued Functions ·In-line table-valued functions ·Multi- Statement table-valued functions ·Limitations of user-defined functions Scalar Functions ·What are scalar functions? ·Some examples ·Disadvantages of scalar functions ·Three advantages
Cursors ·Syntax of fetching rows ·When to use (and when not to)
Triggers Create or replace triggers
Creating Tables in SQL ·Create, alter and drop Tables ·Inserting values, single rows and multiple rows using queries
Constraints: Not Null Unique Default Check Primary Key Foreign Key Identity / Auto-increments
Sequencing Indexes
SQL Temporary Tables and Table Variables ·Create and use SQL temporary tables ·Create and use SQL table variables ·SQL Tables vs. Table Variables
Error-Handling ·SQL TRY/CATCH ·SQL System error functions ·Customizing SQL error messages ·@@ error function
Debugging ·The SQL Server debugger, Debugging (breakpoints, etc.)

Additional information

Sub-Queries, CTE's, Views, Stored Procedures, Functions, Creating Tables, Local and Global Temp Tables

SQL Advanced Course

£ 685 VAT exempt