Trusted Training Partners
Home / Uncategorized / Microsoft SQL Server 2012 Training Course Course
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 16,700.00 EX VAT 3 Person R 11,644.28 EX VAT 10 Person R 7,836.00 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
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
Duration: 3 day(s)
Delegates: 1
Cost (incl):