Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Microsoft SQL Server 2012 Training Course
Quick Look Course Summary:Microsoft SQL Server 2012 Training Course
-
Next Public Course Date:
-
Length: 3 day(s)
-
Price (at your venue): 1 Person R 17,953 EX VAT 3 Person R 12,518 EX VAT 10 Person R 8,424 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
About this course
This course is not accredited. It is delivered as a professional skills programme, and delegates receive a BOTI certificate of attendance.
If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, please see our accredited qualifications and skills programmes, or read about BOTI accreditations.
Frequently Asked Questions
Is this course accredited?
No. This course is delivered as a practical, facilitator-led skills programme and delegates receive a BOTI certificate of attendance. If you need a credit-bearing outcome for B-BBEE skills development, SETA grant or learnership purposes, ask us about our accredited qualifications, skills programmes and unit standards.
Can this course be delivered in-house at our premises?
Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.
How do I book or get a quote?
Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.
Can this training count towards our B-BBEE scorecard?
Spend on this course still counts as skills development expenditure for B-BBEE purposes, but it does not count as accredited training spend, and the Codes limit how much non-accredited training can contribute. Please confirm the treatment with your skills development facilitator or B-BBEE verification agency.
Do you tailor the training to our industry?
Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.