SQL Server Training: The Complete TSQL Programming Course


Course Delivery

Live Instructor-Led Training

Course Description

The course The Complete TSQL Programming Course (SQL Server Training) covers every aspect of the TSQL development language. Beginning with database basics like creating databases and tables, we proceed to a thorough investigation of the TSQL language. We discuss variable declaration, conditional and looping expressions and the use of native SQL functions. You learn advanced topics such as string and date time manipulation, the use of NULL values in tables and scripts and the use of stored procedures and BLOB data. This is a busy and rewarding week.

Course Dates and Pricing


Nov 6 - 9, 2018$2,775.00Dec 4 - 7, 2018$2,775.00Jan 15 - 18, 2019$2,775.00Feb 12 - 15, 2019$2,775.00Mar 12 - 15, 2019$2,775.00Apr 9 - 12, 2019$2,775.00

Course Outline

RDBMS Essentials

About the Relational Database Management System
SQL Server and the .NET Framework
SQL Server Terminology: Databases, Tables, Columns, Rows, Keys, Etc
Application Development and SQL Server
OLTP: The Transactional Server
OLAP: The Analysis Server
XML Integration
Core SQL Server Services
Other SQL Server Services
The Role of ADO .NET

Database Planning

Planning Overview
Normal Forms
The Analysis
The Design
ER Notation
Generalizations
Aggregations
Putting It Together

Creating the Database

Planning the Installation
SQL Server Installation
Data Storage Architecture
Creating Database Files
Using File Groups
Optimizing Data Storage

Creating Tables

Integrity Overview
Creating Data Types
Creating Rules and Defaults
Creating a Table
Primary and Foreign Keys
About Constraints: Default and Check
Creating Triggers

Structured Query Language Basics

SQL Overview
The Select Statement
Aggregate Values
The Insert Statement
The Update Statement
The Delete Statement
Using Views

TSQL Language Elements

SQL Data Types
Stored Procedures and Metadata Views
Using Variables
Type Conversion
Dealing with Null Values
Dealing with Dates
Conditional Constructs
Looping Constructs
Useful Functions
Error Handling

Advanced Structured Query Language

Join Strategies
Inner, Outer and Cross Joins
About Self-joins
Sub-queries
Using Temporary Objects

Stored Procedures

Architectural Overview
Benefits of Stored Procedures
Using Built-in Stored Procedures
Creating Stored Procedures
Using Input and Output Parameters
Stored Procedure Optimization

Indexing

Index Overview
Index Architecture
Clustered Indexes
Non-clustered Indexes
Unique Indexes
Indexes and Keys
Indexed Views

Optimizing Performance

Optimization Overview
Using Query Analyzer
Gathering Performance Data
Optimizing for Select
Optimizing for Insert, Update and Delete
Query Hints
Join Strategies
SQL Server Transactions and Locks
Deadlocks and Livelocks

Practical SQL

Planning the Work
Process Oriented Tasks
Analysis Related Tasks
Statistical Tasks
Data Integrity Checks
Using SSIS

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related SQL Server Training

SQL Server Training: Mastering Always-On Technologies

The course Mastering Always-On Technologies (SQL Server Training) allows database professionals to design, implement and monitor a robust database infrastructure that can serve clients 24/7. The training introduces the concepts of always on infrastructure design with SQL Server and discusses the full implementation & maintenance of the design with SQL Server. The course includes topology design, installation & configuration in a SQL Server Always-On context. Training course titled SQL Server Training: Mastering Always-On Technologies that will allow you to hone your professional skills.

Oct 30 - Nov 2, 2018$1,250.00Nov 27 - 30, 2018$1,250.00Jan 8 - 11, 2019$2,775.00Feb 5 - 8, 2019$2,775.00Mar 5 - 8, 2019$2,775.00Apr 2 - 5, 2019$2,775.00

SQL Server Training: Performance Tuning & Optimization

The course Performance Tuning & Optimization (SQL Server Training) explores SQL Server performance. The training includes a general discussion of SQL Server architecture & configuration as it related to tuning activities. The course covers clustered & non-clustered indexes, SQL execution plans, join strategies & data storage considerations. Further, the training includes a discussion of the relative performance characteristics of stored procedures, joins, sub-queries, correlated sub-queries, covering indexes & more in a SQL Server environment. Training course titled SQL Server Training: Performance Tuning & Optimization that will allow you to hone your professional skills.

Nov 6 - 9, 2018$2,775.00Dec 4 - 7, 2018$2,775.00Jan 15 - 18, 2019$2,775.00Feb 12 - 15, 2019$2,775.00Mar 12 - 15, 2019$2,775.00Apr 9 - 12, 2019$2,775.00

Oracle Training: Replication, Clustering & High Availability

The course Replication, Clustering & High Availability (Oracle Training) is an exploration of clustering & high availability with MySQL. The training includes clustering basic concepts and discusses the hardware, topology & software requirements of a clustered MySQL implementation. The course covers MySQL cluster design, installation, configuration & implementation. This MySQL course also includes a full discussion on MySQL cluster monitoring, troubleshooting & optimization. Training course titled Oracle Training: Replication, Clustering & High Availability that will allow you to hone your professional skills.

Oct 30 - Nov 2, 2018$3,350.00Nov 27 - 30, 2018$3,350.00Jan 8 - 11, 2019$3,350.00Feb 5 - 8, 2019$3,350.00Mar 5 - 8, 2019$3,350.00Apr 2 - 5, 2019$3,350.00

SharePoint Training: SQL Server Administration

The course SQL Server Administration (SharePoint Training) covers database administration from A to Z on SQL Server. The training explores the installation & configuration of SQL Server as well as the design & creation of SQL Server data & log files using files & filegroups. The course also discusses data import & export, backup & recovery, SQL Server security, and SQL Server performance tuning & monitoring. The training concludes with a detailed discussion of indexes, index types & data storage optimization. Training course titled SharePoint Training: SQL Server Administration that will allow you to hone your professional skills.

Nov 6 - 9, 2018$2,775.00Dec 4 - 7, 2018$2,775.00Jan 15 - 18, 2019$2,775.00Feb 12 - 15, 2019$2,775.00Mar 12 - 15, 2019$2,775.00Apr 9 - 12, 2019$2,775.00

SQL Server Training: Database Querying

The course Database Querying (SQL Server Training) covers every aspect of the SQL language. The training begins with a detailed discussion of creating databases & tables. The course studies every element of the SQL language with SQL Server. The training includes SQL data manipulation & modification statements, string & date time manipulation and the use of NULL values in SQL Server tables and TSQL scripts. The course also discusses advanced joins, filtering & sorting & aggregate data calculations with TSQL on SQL Server. Training course titled SQL Server Training: Database Querying that will allow you to hone your professional skills.

Nov 5 - 6, 2018$1,150.00Dec 3 - 4, 2018$1,150.00Jan 14 - 15, 2019$1,150.00Feb 11 - 12, 2019$1,150.00Mar 11 - 12, 2019$1,150.00Apr 8 - 9, 2019$1,150.00

SQL Server Training: Transforming Data with SSIS

The course Transforming Data with SSIS (SQL Server Training) covers the full range of SSIS concepts from the basics of data sources to advanced data flows and control flows. The course begins with a tour of Visual Studio .NET and its many windows, dialog boxes and features. From there, you learn to import data from delimited & positional files, to export data to external data sources and to implement simple error conditions. The training includes how to implement complex data transformation tasks and how to handle NULL values & encoding changes. The course also discusses data load operations that are common to SQL Server data warehouses that make use of a Star schema. Training course titled SQL Server Training: Transforming Data with SSIS that will allow you to hone your professional skills.

Oct 31 - Nov 2, 2018$2,250.00Nov 28 - 30, 2018$2,250.00Jan 9 - 11, 2019$2,250.00Feb 6 - 8, 2019$2,250.00Mar 6 - 8, 2019$2,250.00Apr 3 - 5, 2019$2,250.00