Business Intelligence training -  Fast-track SQL

SQL Training

Fast track SQL course (3 days)

3 days

We recognise that not everyone can devote two days to attend our SQL Introduction course and another two days to sit on our two-day Advanced SQL course, so we've combined the contents together into this single, intensive three-day SQL course.  The course will cover everything from creating basic SELECT statements all the way through to writing stored procedures and using CTEs, temporary tables and table variables. 

Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).

Course Contents

This fast-track course combines topics from the following other Wise Owl courses:

From our INTRODUCTION TO SQL course

Using SQL Server

  • Training topicUsing Object Explorer
  • Training topicHiding system objects

Creating databases - overview

  • Training topicDesigning databases
  • Training topicPrimary keys
  • Training topicIndexing fields

Working with tables

  • Training topicCreating tables
  • Training topicAllowing nulls or not
  • Training topicIdentity fields

Database diagrams

  • Training topicCreating database diagrams
  • Training topicJoining tables with relationships

Simple Queries

  • Training topicCreating queries
  • Training topicComments
  • Training topicIndentation and case

Setting criteria using WHERE

  • Training topicWildcards (% and _)
  • Training topicSetting criteria for dates
  • Training topicCoping with nulls

Outputting to Excel

  • Training topicResults, text and grid options
  • Training topicCopying and pasting column headings
  • Training topicExporting using SQL
  • Training topicExporting using the menu

Calculations

  • Training topicCalculated columns
  • Training topicUsing aliases
  • Training topicString functions and concatenation

Calculations using dates

  • Training topicGetDate
  • Training topicConverting dates
  • Training topicUseful date functions

Basic joins

  • Training topicInner joins
  • Training topicTable aliases
  • Training topicLeft and right outer joins

More exotic joins

  • Training topicCross joins
  • Training topicFull outer joins
  • Training topicSelf joins

Aggregation and grouping

  • Training topicSUM, AVG, MIN, MAX
  • Training topicVarious ways to count
  • Training topicGrouping by fields
  • Training topicUsing HAVING to filter results

Views

  • Training topicThe view designer
  • Training topicLimitations of the designer
  • Training topicScripting views

Subqueries

  • Training topicThe concept of a subquery
  • Training topicUsing ALL, ANY and IN
  • Training topicUsing EXISTS
  • Training topicCorrelated subqueries

Derived tables and CTEs

  • Training topicUsing derived tables
  • Training topicCommon Table Expressions (CTEs)
  • Training topicMultiple CTEs in a single query
From our ADVANCED SQL course

Stored procedures

  • Training topicCreating stored procedures
  • Training topicExecuting stored procedures
  • Training topicSystem stored procedures

Variables

  • Training topicDeclaring variables
  • Training topicSET versus SELECT
  • Training topicTricks with variables
  • Training topicSo-called global variables

Parameters and return values

  • Training topicPassing parameters
  • Training topicDefault values / WHERE clauses
  • Training topicOutput parameters
  • Training topicUsing RETURN

Covered if time allows If time

Scalar functions

  • Training topicWhat they are
  • Training topicWriting user-defined functions
  • Training topicWorked examples
  • Training topicPros and cons of scalar functions

Testing conditions

  • Training topicIF / ELSE statement
  • Training topicUsing CASE where possible

Looping

  • Training topicSyntax of WHILE
  • Training topicBreaking out of a loop

Covered if time allows If time

Error-handling

  • Training topicUsing TRY / CATCH
  • Training topicSystem error functions
  • Training topicCustom error messages

Deleting using SQL

  • Training topicWays to drop tables
  • Training topicDELETE versus TRUNCATE

Updating data in SQL

  • Training topicThe UPDATE statement
  • Training topicUpdating using joins

Inserting data

  • Training topicMaking tables (SELECT INTO)
  • Training topicAppending data (INSERT INTO)
  • Training topicInserting individual rows

Creating tables

  • Training topicCreating tables in SQL
  • Training topicPrimary keys and indexes
  • Training topicAdding relationships

Covered if time allows If time

Transactions

  • Training topicBeginning a transaction
  • Training topicCommitting / rolling back

Temporary tables and table variables

  • Training topicScope (local versus global)
  • Training topicUsing temporary tables
  • Training topicCreating table variables
  • Training topicPros and cons of each approach

Covered if time allows If time

Table-valued functions

  • Training topicIn-line table-valued functions
  • Training topicMult-statement table-valued functions

Covered if time allows If time

Dynamic SQL

  • Training topicBuilding up dynamic SQL
  • Training topicExecuting dynamic SQL
  • Training topicDisadvantages of dynamic SQL

Covered if time allows If time

Pivots

  • Training topicAssembling data for pivoting
  • Training topicUsing PIVOT
  • Training topicDynamic column headers

Covered if time allows If time

Triggers

  • Training topicInsert, update and delete triggers
  • Training topicUsing the generated tables (eg INSERTED)
  • Training topicUsing INSTEAD OF

There are no special pre-requisites for you to satisfy to attend this course, other than to have a good level of IT literacy.  If you don't find it easy to create Excel formulae you should avoid this course!

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Excellent course delivery and content."

Richard Teulon (Welsh Ambulance Service NHS Trust)

"I was worried about covering this subject (SSRS) as I knew nothing but now I feel like I know so much. I can't wait to get back and practice. "

Victoria Wass (CHP)

"The trainer was fantastic - very engaging and informative. Excellent training - thank you."

Victoria Elliott (Bloom Services)

"I thoroughly enjoyed the course. Wise Owl provided an excellent service from the booking process to the end of the course. The trainer had excellent interaction with everyone on the course and his knowledge was unquestionable. He was very engaging and I enjoyed the course due to his delivery on the subject. He was able to answer any question and apply it to real world examples. The course was presented at a pace which meant you could take in the information and had time to ask questions. Before the course I had been writing SQL scripts and was worried that I might not learn much from it, but I am happy to say I was able to learn new information that has already improved my effectiveness and I am already using these new skills. This was by far one of the most useful courses I have ever attended. I am looking forward to booking another course with Wise Owl in the near future. "

Rachael Shaw (Berrymans Lace Mawer (BLM))

"A brilliant course & engaging trainer."

David Clarke (Great Western Railway (GWR))

There are lots more where these came from (or just refresh this page to change the quotes shown).

Related Courses

Introduction to SQL

Introduction

2 day course

Advanced SQL

Advanced

2 day course

Other SQL training resources

SQL exercises

SQL exercises

You can see the exercises we use for our SQL training here.

View SQL exercises

SQL videos

SQL videos

As an alternative to our classroom training, you could watch our SQL videos.

View Selecting data in SQL, SQL Server 2016, Advanced SQL (programming) or SQL Server 2017 videos

SQL skills assessment

SQL skills assessment

To see if you need fast-track training, take our SQL skils test.

View Test your SQL skills skills assessment tests

SQL blogs

SQL blogs

We've got lots of blogs on matters SQL on our website.

View SQL blogs

This page has 0 threads Add post