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