Introduction: Microsoft SQL Server 2012 Training Course
SQL Server® 2012 is introduced. The following is described: logical table design, indexing and query plans. It also deals with the production of database objects, which consists of views,
Procedures that are stored, function and parameters. In addition the course deals with other areas of procedure coding, eg. transactions, concurrency, error handling, triggers, and SQL CLR.
Outline: Microsoft SQL Server 2012 Training Course
Johannesburg (Sandton), Cape Town, Durban, Port Elizabeth, Pretoria – South Africa
Key outcomes of the course include:
Unit 1: Introduction to SQL Server 2012 and Its Toolset
Unit 2: Working with Data Types
Unit 3: Designing and Implementing Tables
Unit 4: Ensuring Data Integrity through Constraints
Unit 5: Planning for SQL Server 2012 Indexing
Unit 6: Implementing Table Structures in SQL Server 2012
Unit 7: Reading SQL Server 2012 Execution Plans
Unit 8: Improving Performance through Non-clustered Indexes
Unit 9: Designing and Implementing Views
Module 10: Designing and Implementing Stored Procedures
This module describes the potential advantages of the use of stored procedures along with guidelines on creating them.
Introduction to Stored Procedures
Working With Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context
Module 11: Merging Data and Passing Tables
This module reviews the techniques that provide the ability to process sets of data rather than individual
rows. Also it focusses on how these techniques can be used in combination with TABLE parameter
types to minimize the number of required stored procedure calls in typical applications.
Using the MERGE Statement
Implementing Table Types
Using TABLE Types As Parameters
Module 12: Designing and Implementing User-Defined Functions
This module explains how to design and implement user-defined functions that enforce business rules
or data consistency, and modify and maintain existing functions written by other developers.
Overview of Functions
Designing and Implementing Scalar Functions
Designing and Implementing Table- Valued Functions
Implementation Considerations for Functions
Alternatives to Functions
Module 13: Creating Highly Concurrent SQL Server 2012 Applications
This module explains how to use transactions and the SQL Server locking mechanisms to meet the
performance and data integrity requirements of your applications.
Introduction to Transactions
Introduction to Locks
Management of Locking
Transaction Isolation Levels
Module 14: Handling Errors in T-SQL Code
This module explores T-SQL error handling, looks at how it has traditionally been implemented, and how structured exception handling can be used.
Understanding T-SQL Error Handling
Implementing T-SQL Error Handling
Implementing Structured Exception Handling
Module 15: Responding to Data Manipulation via Triggers
This module, explains what DML triggers are and how they enforce data integrity. Also it focusses on the different types of triggers available, and how to define triggers in a database.
Designing DML Triggers
Implementing DML Triggers
Advanced Trigger Concepts
Module 16: Implementing Managed Code in SQL Server 2012
This module explains how to use CLR integrated code to create userdefined database objects that are managed by the .NET Framework.
Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration
Module 17: Storing XML Data in SQL Server 2012
This module introduces XML and shows how XML data can be stored within SQL Server.
Introduction to XML and XML Schemas
Storing XML Data and Schemas in SQL Server
Implementing the XML Data Type
Module 18: Querying XML Data in SQL Server
This module shows how XML data can be queried, including queries written in a language called XQuery.
Using the T-SQL FOR XML Statement
Getting Started with XQuery
Module 19: Working with SQL Server 2012 Spatial Data
This module introduces Spatial Data, and explains how to work with SQL Server Spatial Data Types.
Introduction to Spatial Data
Working with SQL Server Spatial Data Types
Using Spatial Data in Applications
Module 20: Working with Full-Text Indexes and Queries
This module introduces Full-Text Indexing and how to implement Full- Text Indexes in SQL Server.
Introduction to Full-Text Indexing
Implementing Full-Text Indexes in SQL Server
Working with Full-Text Queries
Course duration and fees: Microsoft SQL Server 2012 Training Course
Our two day training course is designed so that the knowledge acquired is applied practically, so that the business environment can be enhanced.
Please consult schedule for course costs or contact BOTI for a quote.
Recommended Prior Experience and Knowledge: Microsoft SQL Server 2012 Training Course
The course (Microsoft SQL Server 2012 Training Course) is designed for the following attendees:
This course is aimed at Information Technology Professionals who wish to become skilled on SQL Server
2012 technologies and product features for implementing a database.
For the Microsoft SQL Server 2012 Training Course it is advisable that you have the following experience/knowledge:
Professional experience, together with following technical knowledge is required:
Understanding of writing T-SQL queries and basic relational database concepts.
- 13th Feb 2017 at Johannesburg (Sandton), Pretoria, Durban, Cape Town
- 13th Mar 2017 at Johannesburg (Sandton), Pretoria, Durban, Cape Town
- 10th Apr 2017 at Johannesburg (Sandton), Pretoria, Durban, Cape Town
- 8th May 2017 at Johannesburg (Sandton), Pretoria, Durban, Cape Town
View Calendar for the latest course