SQL Server 2014/2012: Implementation Training
- Participants / Prerequisite
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.
- 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
- Architecture of SQL Server 2012.
- Development and administration tools
Getting started with the configuration manager and Management Studio.
- Identifiers: Naming SQL Server objects.
- Creating the database. SQL schemas.
- Lifecycle of a database's objects.
- 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.
Creating user types. Creating tables and views. Adding constraints. Setting up primary keys and uniqueness constraints.
- The BULK INSERT command.
- Importing/exporting from the command line with BCP.
- OPEN functions for querying outside data.
- Overview of Integration Services.
Loading data using BULK INSERT and BCP. Using OPENROWSET.
- Index structure: Balanced tree, clustered index, etc.
- Creating an index: Approach to creation, etc.
- Performance analysis.
- Using the Database Tuning Advisor.
Setting up indices in the database and observations about performance.
- OLAP groupings and OUTPUT, SELECT INTO clauses, etc.
- SQL MERGE order. Data encryption.
- Functions, stored procedures, cursors, triggers.
Creating advanced TransactSQL requests. Producing a multiinstruction table function. Stored procedure for combined insertion.
- Transactions. Insulation levels. Exception management. Nested transactions.
Integrating exception management and transactions in triggers and stored procedures.