Trusted Training Partners

Quick Look Course Summary:Microsoft SQL Server 2012 Training Course Course
  • Next Public Course Date:

  • Length: 3 day(s)

  • Price (at your venue): 1 Person R 15,365.00 EX VAT 3 Person R 9,344.72 EX VAT 10 Person R 6,014.09 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

Knowing your course will help us prepare for our consultation and phone call.

The more people you send on our courses, the cheaper the unit cost.

YesNo

Input this code: captcha

Microsoft SQL Server 2012 Training Course Course: Introduction

Our SQL server 2012 course stresses on the fact that before beginning to work with SQLServer in either a development or an administration role, it is important to understand the overall SQL Server platform. In particular, it is useful to understand that SQL Server is not just a database engine but it is a complete platform for managing enterprise data.

Microsoft SQL Server 2012 Training Course Course :Course Outline

Module 1: Introduction to SQL Server 2012 and Its Toolset

Introduction to the SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services

Module 2: Working with Data Types

Working with Character Data
Converting Data Types
Specialized Data Types

Module 3: Designing and Implementing Tables

Designing Tables
Working with Schemas
Creating and Altering Tables

Module 4: Ensuring Data Integrity through Constraints.

Enforcing Data Integrity
Implementing Domain Integrity
Implementing Entity and Referential
Integrity

Module 5: Planning for SQL Server 2012 Indexing

Core Indexing Concepts
Data Types and Indexes
Single Column and Composite Indexes

Module 6: Implementing Table Structures in SQL Server 2012

SQL Server Table Structures
Working with Clustered Indexes
Designing Effective Clustered Indexes

Module 7: Reading SQL Server 2012 Execution Plans

Execution Plan Core Concepts
Common Execution Plan Elements
Working with Execution Plans

Module 8: Improving Performance through Nonclustered Indexes

Designing Effective NonclusteredIndexes
Implementing Nonclustered Indexes
Using the Database Engine Tuning Advisor

Module 9: Designing and Implementing Views

Introduction to Views
Creating and Managing Views
Performance Considerations for Views

Microsoft SQL Server 2012 Training Course Course: Course Duration

3 day/s

Who should attend: Microsoft SQL Server 2012 Training Course Course

This course is intended for programmers, SQL Server.

**Quote does not include Any Exam Fees (if applicable)

IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal

Realize incredible savings by sending more delegates

Do you want to save costs by doing training at your premises?

Save costs by providing own laptop

Region *

Accredited Courses

Additional Courses

Software & IT Courses

Top Rated