menu logo orsys formation
CONTACT - +33 (0)1 49 07 73 73
CONTACT - 📞 +33 (0)1 49 07 73 73    drapeau francais   drapeau anglais
Consult our trainings :

SQL Server 2014/2012: Implementation Training

Hands-on course
Duration : 5 days
Ref : QSM
Price  2019 : Contact us
  • Program
  • Participants / Prerequisite
  • Intra/Tailored
Program

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.

Learning objectives

  • 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
PROGRAM

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.

Participants / Prerequisite

» Participants

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

» Prerequisite

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

Contact Informations

By checking this box, I certify that I have read and accepted the conditions for the use of my data regarding the General Data Protection Regulation (GDPR).
You can at any time modify the use of your data and exercise your rights by sending an email to rgpd@orsys.fr
By checking this box, I agree to receive commercial and promotional communications from ORSYS Training*. You can unsubscribe at any time by using the link included in our communications.

Book your place

Submit your request

Time schedule

Generally, courses take place from 9:00 to 12:30 and from 14:00 to 17:30.
However, on the first day attendees are welcomed from 8:45, and there is a presentation of the session between 9:15 and 9:30.
The course itself begins at 9:30. For the 4- or 5-day hands-on courses, the sessions finish at 15:30 on the last day
linkedin orsys
twitter orsys
it! orsys
instagram orsys
pinterest orsys
facebook orsys
youtube orsys