Developing Microsoft SQL Server 2012 Course

Developing Microsoft SQL Server 2012 Online Course in Ghana


2KO Ghana offers online Developing SQL Databases courses in Ghana. We also offer full time Developing SQL Databases courses in Accra for groups of four or more delegates. 2KO Ghana's SQL course is offered to our international and local students. 2KO Africa is a professional training company, delivering cutting edge programs in the IT space and in selected business applications. Our training is offered online, live online and also by instructor led classes. 2KO Africa's business courses are available world-wide, many of them leading to European Certification, to ensure students have access to the best Developing SQL training in Ghana.


Register for an Online Microsoft Technical Course Here



2KO Ghana's Developing SQL Databases course in Ghana is intended specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around Developing Microsoft SQL Server 2012 Databases. 2KO Ghana also offers online courses to our international and local students. This course is designed for Database developers who build and implement databases across the organization, while ensuring high levels of data availability. They perform tasks including creating database files, create data types, tables, plan create and optimize indexes, implement data integrity, implement views, stored procedures and functions, manage transactions and locks.

Primary responsibilities may include:

Optimizing and tuning queries.

Creating and altering indexes and stored procedures.

Maintaining database integrity.

Optimizing indexing strategies.

Creating and altering tables.

Maintaining indexes.

Creating and modifying constraints.


The 2KO Africa course on developing Microsoft SQL Server 2012 Databases prepares participants for the Microsoft Exam 70-464.

This course will provide all the skills and knowledge for the following areas:

Creating and altering tables (complex statements)

Designing, implementing, and troubleshooting security

Designing the locking granularity level

Maintaining indexes

Implementing data types

Creating and modifying constraints (complex statements)

Working with XML Data

Writing automation scripts

Designing and implementing stored procedures

Designing T-SQL table-valued and scalar functions

Creating, using, and altering user-defined functions (UDFs)

Creating and altering views (complex statements)

Designing tables

Designing for concurrency

Creating and altering indexes

Designing data integrity

Designing for implicit and explicit transactions

Optimizing and tuning queries

Troubleshooting and resolving performance problems

Optimizing indexing strategies

Capturing and analyzing execution plans

Collecting performance and system information


Microsoft 70-464: Developing Microsoft SQL Server 2012 Databases

Module 1

Introduction to SQL Server 2012

SQL Instances

SQL Editions

SQL Server Tools

SQL Server Management Studio

SQL Data Tools

SQL Command

Utilizing SQL Server Tools

Exam Scenarios

Module Review


Module 2

Introduction to Data Types and Tables


Unicode Characters

Null Values

Converting Data Types

Introduction to Tables


Temporary Tables

Working with Tables


Primary and Foreign Keys

UNIQUE Constraint/Index

In Depth Look

Exam Scenarios

Module Review


Module 3

SQL Server Indexing

Introduction to Indexing

Clustered Indexes

Non Clustered Indexes

Maintaining Indexes

Index Fragmentation

Index Tuning

Creating and Altering Indexes

Exam Scenarios

Module Review


Module 4

Query Performance

Execution Plans

Reading Execution Plans

Execution Plan Operators

Plan Reuse

Query Performance

Exam Scenarios

Module Review


Module 5

Common Language Runtime (CLR) Integration



CLR Objects

Integrating the CLR within SQL Server

Exam Scenarios

Module Review


Module 6

Transact-SQL (T-SQL) Error Handling

Error Severity

TRY CATCH Error Handling




Error Handling in T-SQL

Exam Scenarios

Module Review


Module 7

Views and Functions

Types of Views

Working with Views

Introduction to Functions

Working with Functions

Working with Views and Functions

Exam Scenarios

Module Review


Module 8

Stored Procedures and Triggers

Working with Stored Procedures

Introduction to Triggers

Working with Triggers

Stored Procedures and Triggers Demo

Exam Scenarios

Module Review


Module 9

Working with XML

XML Concepts

Schemas and Schema Collections

FOR XML Clause

FLOWR Queries

Working with XML in SQL Server

Exam Scenarios

Module Review


Module 10


Implicit Transactions

Explicit Transactions


Working with Transactions and Locking within SQL

Exam Scenarios

Module Review

Course Review