Querying SQL Server 2012 Online Course

Querying SQL Server 2012 Online Courses

 

2KO South Africa offers online Querying SQL 2012 courses in South Africa. We also offer full time Querying SQL 2012 courses in Cape Town for groups of four or more delegates. 2KO South Africa's Querying SQL Server course is offered to our international and local students. 2KO Africa is a network of companies that offers a substantial series of computer courses across the entire African region, and is a leading provider of internationally recognised online IT training, online, IT training, to ensure the best Querying SQL certification training in South Africa.
 

2KO South Africa's MS SQL Server course in South Africa is intended for SQL Server database administrators, implementers, system engineers, and developers. This new 2KO Africa SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries.

 

This course provides the knowledge and understanding for some of these important job functions:

Apply built-in scalar functions

Apply ranking functions

Combine datasets

Creates and alters

Design T-SQL stored procedures, views

Implementing aggregate queries, error handling, sequence generation and data types

Manage transactions

Modify data by using INSERT, UPDATE, DELETE and MERGE statements

Optimizing queries

Query data using SELECT statements and Managing XML data

OUTPUT clause to return data

 

This learning course from 2KO Africa delivers the knowledge for the 70-461 Exam on Queries on Microsoft SQL Server 2012:

Create Database Objects

Create and alter tables using T-SQL syntax (simple statements).

Create and alter views (simple statements).

Design views.

Create and modify constraints (simple statements).

Create and alter DML triggers.

Work with Data

Query data by using SELECT statements.

Implement sub-queries.

Implement data types.

Implement aggregate queries.

Query and manage XML data.

Modify Data

Create and alter stored procedures (simple statements).

Modify data by using INSERT, UPDATE, and DELETE statements.

Combine datasets.

Work with functions.

Troubleshoot & Optimize

Optimize queries.

Manage transactions.

Evaluate the use of row-based operations vs. set-based operations.

Implement error handling.

 

2KO Africa creates the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed. 

 

Microsoft 70-461: Querying SQL Server 2012

 

Module 1

Introduction to SQL Server 2012

SQL Instances

Editions and Licensing

SQL Server Objects

System Databases

SQL Server Data Tools

Object Explorer

Object Scripting

Template Explorer

Query Tabs

Projects and Solutions

Customizing SSDT

Debugging T-SQL

SQLCMD

Exam Scenarios

Module Review

 

Module 2

T-SQL Overview

T-SQL Elements

Batch Separators

Line Terminator

Variables

Control Flow

Expressions

Functions

Predicates and Operators

SELECT

Column Aliasing

SELECT Execution

Exam Scenarios

Module Review

 

Module 3

SELECT Statements

Basic SELECT Statement

Specifying Columns

Derived Columns

Aliasing Columns

Calculated Columns

Ordering Results

Returning Distinct Results

Exam Scenarios

Module Review

 

Module 4

Filtering

WHERE Syntax

BETWEEN

WHERE Syntax IN

Filtering NULL Values

LIKE

Data Type Comparison

Filtering Data with WHERE

TOP

OFFSET-FETCH

Exam Scenarios

Module Review

 

Module 5

Join and Set Operators

Using Joins

Categories of Joins

INNER JOIN

OUTER JOIN

JOIN Demo

Set Operators

Set Operators Demo

Exam Scenarios

Module Review

 

Module 6

Subqueries and Table Expressions

Subqueries

Self Contained Subquery

Correlated Subquery

Subquery Demo

EXISTS

Common Table Expressions

Temporary Tables

Table Variables

Table Demo

Exam Scenarios

Module Review

 

Module 7

System Functions

Scalar Functions

ROWSET

System Function Demo

Aggregate Functions

DISTINCT

Aggregation Demo

GROUP BY

HAVING

Conversion Functions

Exam Scenarios

Module Review

 

Module 8

T-SQL Programming

Logical Functions

IIF, CHOOSE and CASE

Logical Function Demo

Using Views

Stored Procedures

Functions

Triggers

Views Demo

TRY CATCH

Exam Scenarios

Module Review

 

Module 9

Transactions

Introduction to Transactions

INSERT and UPDATE

DELETE and TRUNCATE

Transactions Demo

Managing Transactions

XACT_ABORT

Managing Transactions Demo

Exam Scenarios

Module Review

 

Module 10

Query Performance

Indexing

Index Strategies

Indexes Demo

Execution Plans

Statistics IO

Execution Plans Demo

Exam Scenarios

Module Review

Program Review