SQL – Intermediate (February 2016)

This course is full

Title SQL  – Intermediate
Duration 21 hours
Emploi-Québec fee $42 (taxes incl.)
General Public fee $455.01 (taxes incl.)
Schedule Monday and Wednesday
6 p.m. to 10:15 p.m. (last class 6 .m. to 10 p.m.)
Dates February 22, 29, March 2, 7, 9 (no class February 24)
Prerequisites SQL Level 1 or working knowledge of relational databases (database design skills)
Target Audience
Participants interested in acquiring the  knowledge and skills needed to implement a Microsoft SQL Server database

NB:  Certificate provided for all participants who have completed 80% of course hours

The primary objective of this course is to provide students with the knowledge and skills to design and create a database using Microsoft SQL Server.  Participants will learn how to create SQL Databases, database files, design Tables, and write queries using SQL language.

We recommend that students purchase the following textbook for this course:

SQL Server 2014 Development Essentials | Basit A. Masood-Al-Farooq | ISBN 978-1-78217-255-0 © 2014 Packt Publishing

Topics covered in this course:

Module 1

Overview Of Microsoft SQL Server Management Studio (SSMS)

Comparison of different versions

Create database with the Wizard

Create database with SQL language

How to save queries

Module 2

Introduction to Microsoft Transact-SQL (T-SQL) Language

Data definition language including create, alter, delete, clauses

Data manipulation language including select, update, delete etc.

Data control language including grant, deny permissions

Module 3

Database and Database file creation

Create database using object explorer

Create database using SQL statements

Name the database, the data row, log file, size etc.

Create Tables and define the data types

Create and name tables, define columns in the data types

Set the primary add foreign keys

Module 4

Implementing Data Integrity by Using Constraints

Types of Data Integrity

Implementing Constraints

Performing Basic Queries

Retrieving Data, Formatting Result Sets, and Modifying Data

Module 5

Join Tables

Alter the table definition

Set the relationship between tables