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

  • Length: 3 day(s)

  • Price: 1 Person R 15,365.00 EX VAT 3 Person R 8,680.00 EX VAT 10 Person R 5,734.61 EX VAT

  • Certification Type:Accredited

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

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

Get Free & personalised
Training Advice

Enjoy incredible savings the more delegates
you send. See for yourself...

BOTi COURSE COST CALCULATOR

Simply Select a date to see cost

Select Date *

Premises Provided by *

Laptop Provided by *

Region *

Administrative Courses

Human Resources Courses

Leadership & Management Courses

RPL & Learnerships Courses

Soft Skills Courses

Software & IT Courses

Specialist Courses

Top Rated