
Home / Software & IT / Software & IT Courses / 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: 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
Duration: 3
Delegates: 1
Cost (incl): R