Course : SQL Server 2014/2012: Implementation

SQL Server 2014/2012: Implementation

5 / 5

This course will provide you with all the knowledge you need to fully use SQL Server in its 2012 or 2014 version. You'll learn how to write SQL orders and use language extensions, edit structures and enter integrity conditions, load data and use transactions.

Inter

In-house

Custom

Practical course in person or remote class

Ref. QSM

Price : 3110 € E.T.

5d - 35h00

Dates and Registration

Teaching objectives

At the end of the training, the participant will be able to:

Become familiar with the Management Studio environment
Create the database's tables, and set up primary keys and uniqueness constraints
Load data into the database using BULK INSERT and BCP
Implement indices on the database to improve its performance.
Create queries and stored procedures, triggers and functions, to update the database
Integrate exception management and transactions in triggers and procedures

Intended audience

This course is intended for system engineers and developers who are to use or implement SQL Server 2012.

Prerequisites

Good knowledge of the SQL language or knowledge equivalent to that provided by the course "SQL Server: SQL Programming" (code: PSQ).

Course schedule

Overview of SQL Server 2012

Architecture of SQL Server 2012.
Development and administration tools

Hands-on work

Getting started with the configuration manager and Management Studio.

SQL databases and schemas

Identifiers: Naming SQL Server objects.
Creating the database. SQL schemas.
Lifecycle of a database's objects.

Tables, views, and constraints

DDL language: Creating objects and constraints.
Types of native data and user types.
Creating tables and views.
Domain and column constraints.
Primary key and alternative keys. Managing referential integrity.

Hands-on work

Creating user types. Creating tables and views. Adding constraints. Setting up primary keys and uniqueness constraints.

Loading data and exports

The BULK INSERT command.
Importing/exporting from the command line with BCP.
OPEN functions for querying outside data.
Overview of Integration Services.

Hands-on work

Loading data using BULK INSERT and BCP. Using OPENROWSET.

Indexing and query plans

Index structure: Balanced tree, clustered index, etc.
Creating an index: Approach to creation, etc.
Performance analysis.
Using the Database Tuning Advisor.

Hands-on work

Setting up indices in the database and observations about performance.

Advanced SQL with Transact SQL, procedural code

OLAP groupings and OUTPUT, SELECT INTO clauses, etc.
SQL MERGE order. Data encryption.
Functions, stored procedures, cursors, triggers.

Hands-on work

Creating advanced TransactSQL requests. Producing a multiinstruction table function. Stored procedure for combined insertion.

Transactions and exception management.

Transactions. Insulation levels. Exception management. Nested transactions.

Hands-on work

Integrating exception management and transactions in triggers and stored procedures.

Introduction to advanced techniques

Overview of the Geographic Information System.GIS Use of XML within SQL Server 2012.

Hands-on work

Use of the SIG. XML querying.

Customer reviews

5 / 5

Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.

Dates and locations

Select your location or opt for the remote class then choose your date.

Remote class