Premium Subqueries, CTE, Procedures, Functions,Temp Tables Save 8%

SQL Advanced Course

5.0
1 opinion
  • 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.
    |

In London, Milton Keynes, Portsmouth and 5 other venues

Special Emagister price

£ 685 £ 750 VAT exempt
  • Typology

    Short course

  • Level

    Intermediate

Description

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.

Important information

Price for Emagister users: 10% Discount,

Facilities

Location

Starts

Berlin (Germany)
See map
Timetable: Email us to arrange

Starts

Different dates availablePlaces sold out
Birmingham (West Midlands)
See map
One Victoria Square, B1 1BD

Starts

Different dates availablePlaces sold out
Hannover (Germany)
See map
Timetable: Email us to arrange

Starts

Different dates availablePlaces sold out
Köln (Germany)
See map
Timetable: Email us to arrange

Starts

Different dates availablePlaces sold out
London
See map
8 Duncannon Street, WC2N 4JF

Starts

Different dates availablePlaces sold out
Manchester (Greater Manchester)
See map
Pall Mall, 82 King Street, M2 4WQ

Starts

Different dates availablePlaces sold out
Milton Keynes (Buckinghamshire)
See map
Exchange House, 494 Midsummer Boulevard, MK9 2EA

Starts

Different dates availablePlaces sold out
Portsmouth (Hampshire)
See map
Lakeside North Harbour Western Road Building 1000 Ground Floor, PO6 3EZ

Starts

Different dates availablePlaces sold out
See all (8)

To take into account

In works professionals. University students

SQL Queries, Aggregates, Joins.

Questions & Answers

Ask a question and other users will answer you

We will only publish your name and question

Opinions

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
Reviews gathered by Emagister & iAgora

Achievements for this centre

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 3 years

What you'll learn on the course

  • 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

Special Emagister price

£ 685 £ 750 VAT exempt

Call the centre

for further information on the course