Developing Microsoft SQL Server 2012 Course

Developing Microsoft SQL Server 2012 Online Course in South Africa

 

2KO South Africa offers online Developing SQL Databases courses in South Africa. We also offer full time Developing SQL Databases courses in Cape Town for groups of four or more delegates. 2KO South Africa's SQL course is offered to our international and local students. 2KO Africa presents user level and technical computer classes, and is a top provider of internationally certified online computer courses, to ensure the best Developing SQL training in South Africa.

 

2KO South Africa's Developing SQL Databases course in South Africa 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 South Africa 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

Collations

Unicode Characters

Null Values

Converting Data Types

Introduction to Tables

Normalization

Temporary Tables

Working with Tables

Schemas

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

Assemblies

Permissions

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

TRY PARSE and TRY CONVERT

@@ ERROR

Alerts

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

Transactions

Implicit Transactions

Explicit Transactions

Locking

Working with Transactions and Locking within SQL

Exam Scenarios

Module Review

Course Review