Book now

SQL Server Intermediate 3-day Course (Using MS SQL Management Studio)

Course summary

Learn how to get valuable information, trends, summaries, statistics and insights from your company data. This course is ideal for managers and data analysts who need to get business intelligence from data.

Course Desciption

Session 1: Database Concepts

What is a database? Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema

Session 2: Using the SQL client

SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts

Session 3: Basic SELECT

The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions, The select clause, The FROM clause, Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<,IN, and BETWEEN).The ORDER BY clause, Column aliases, Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”), Precedence of operators

Session 4: LIMIT/TOP, UNION and AGGERGATE Functions

The LIMIT and TOP clauses, Aggregate (Sum, Average, Maximum, Minimum, Count) , Group By, Rollup with Group By, Having.

Session 5: Subqueries, Basic Subqueries, Nested Subqueries, “WITH AS”

Joins: Cartesian products, Joins (Inner join, Left join, Right join, Full join) Table aliases, Natural joins, Join using, Join on, Multi-table joins, Union, Union All, Except, Intersect

Session 6: Numeric Functions (ABS, SIGN, MOD, etc.) and String Functions (Locate, Left, Right, Concat, etc), DATE and TIME functions

Session 7: Views, Stored Proecdures with Input and Output parameters

Session 8: Creating Databases and Tables

Session 9: Indexes and Views

Session 10: Managing Data

Inserting rows, Replacing rows, Updating rows, Deleting rows, The truncate statement, The COMMIT and ROLLBACK commands, Savepoints, Implicit commits

Session 11: Access Control

Creating users, Renaming users, Dropping users, Granting privileges, Revoking privileges

Session 12: Import and Export

Exporting using SQL, Importing using SQL, Exporting from the command line, Importing from the command line

What is included:

Certificate on completion (assessment based)
Course notes
Practical Class exercises, Homework / Revision work
Teac, coffees, but no lunch
To assist after the course : 1 free session for questions online via Skype or Teamviewer. Online videos

Duration: 3 days. Max group size is 4.

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Buy a voucher
Starting How long Where Price

Wed 13th Dec
11:00am - 6:00pm

3 days
Part time day
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 20th Dec
11:00am - 6:00pm

3 days
Part time day
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 27th Dec
11:00am - 6:00pm

3 days
Part time day
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 27th Dec
11:00am - 6:00pm

3 days
Part time day
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 27th Dec
11:00am - 6:00pm

3 days
Full time
Milton Keynes,
MK9 2UB
Map

£875
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 27th Dec
11:00am - 6:00pm

3 days
Full time
Manchester,
M2 2AN
Map

£875
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 27th Dec
11:00am - 6:00pm

3 days
Full time
Southend-On-Sea,
SS1 1NE
Map

£875
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 27th Dec
11:00am - 6:00pm

3 days
Full time
Portsmouth,
PO6 3EZ
Map

£1300
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 03rd Jan 2018
11:00am - 6:00pm

3 days
Part time day
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Wed 10th Jan 2018
11:00am - 6:00pm

3 days
Part time day
London,
WC2N 5BY
Map

£750
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher