25,000+ Courses Nationwide
0345 4506120

SQL Server Intermediate

In this MS SQL Server Course, offered as SQL Intermediate, delves into SQL beyond the basics. You will learn how to get valuable business information, trends, summaries, statistics and insights from data sets using SQL.
This course is ideal for managers and data analysts who need to get business intelligence from data.
We use MS SQL Server, unless you request a different database.

WHAT IS INCLUDED IN THE SQL COURSES:
  • SQL Course Certificate on completion
  • SQL Course notes
  • Practical SQL Course exercises, SQL Code Examples
  • After the course, 1 free session for questions online SQL Course via Gotomeeting.com.
  • Max group size, online and in classroom, on this SQL Course is 4.

Select specific date to see price, venue and full details.

Pre-Requisites

We use MS SQL Server, unless you request a different database.

Course Content

Session 1:

Database Concepts
What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
SQL Getting started and Logging in, Selecting a database, Executing SQL statements

Session 2:

Basic SQL SELECT statement
The SQL SELECT statement, WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<,IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT / TOP, Distinct

Session 3:

Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”).

Session 4:

SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count), Group By, Having.

Session 5: Joins

SQL Cartesian products,
SQL Joins (Inner join, Left join, Right join, Full join) Table aliases,
Natural joins, Multi-table joins.
Union, Union All, Except, Intersect.

Session 6:

SQL Subqueries, Nested Subqueries, “WITH AS”, Correlated and uncorrelated subqueries. Global and Local Temp Tables.

Session 7:

SQL Built-in Functions: Numeric Functions (ABS, SIGN, MOD, etc.) and String Functions (Locate, Left, Right, Concat, etc), DATE and TIME functions.

Session 8:

SQL Views (Create, alter and drop), Stored Procedures (Create, alter and drop, Input and Output parameters); Custom Functions (Create, alter and drop).

Session 9: Managing Data

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

Session 10:

SQL Indexes (Create, alter and drop).

Session 11:

Creating Databases and Tables (Create, alter and drop); Constraints (Add, alter and drop).

Session 12:

Import data into SQL and Export from SQL.
Exporting using SQL, Importing using SQL, Exporting from the command line, Importing from the command line.

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best