SQL Advanced Course

SQL Advanced Course Description

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques.
We also learn Data Definition Language and Data Manipulation Language statements,
as well as course automation of queries using T-SQL.
Hands-on, Practical SQL Advanced Course.
PCWorkshops SQL Advanced Course Certificate.
Max 4 people per course, we keep it personalised.

Who should attend the SQL Advanced Course?

Most attendees good working SQL knowledge.

SQL Data Course Details

Our Style: Hands-on, Practical
Location: Online, Instructor-led
Duration: 2 Days
Group Size: Maximum 4 people per group.
Qualification: PCWorkshops SQL Advanced Certification.
Times: Check the booking link

SQL ADVANCED COURSE TOPICS

• Database Concepts Revision:
  What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
• 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.)

Contact us or customise SQL Courses

Powered byEMF HTML Contact Form

Where is our London Classroom

Golden Cross House, 8 Duncannon Street, London, WC2n 4JF

More About Our SQL Courses

Contact PCWorkshops