Querying SQL Server 2012 Online Courses
2KO Mauritius offers online Querying SQL 2012 courses in Mauritius. We also offer full time Querying SQL 2012 courses in Port Louis for groups of four or more delegates. 2KO Mauritius's Querying SQL Server course is offered to our international and local students. 2KO Africa is an IT training company, that offers IT consulting along with a range of business services. Our training is conducted across multiple IT platforms. 2KO's courses are available world-wide by means of full time, hands-on classes, as well as online e-learning, to ensure students have access to the best Querying SQL certification training in Mauritius.
|Price in Mauritian Rupee - as at 21 August||Rs 1,560|
2KO Mauritius's MS SQL Server course in Mauritius 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
Creates and alters
Design T-SQL stored procedures, views
Implementing aggregate queries, error handling, sequence generation and data types
Modify data by using INSERT, UPDATE, DELETE and MERGE statements
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).
Create and modify constraints (simple statements).
Create and alter DML triggers.
Work with Data
Query data by using SELECT statements.
Implement data types.
Implement aggregate queries.
Query and manage XML data.
Create and alter stored procedures (simple statements).
Modify data by using INSERT, UPDATE, and DELETE statements.
Work with functions.
Troubleshoot & Optimize
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
Introduction to SQL Server 2012
Editions and Licensing
SQL Server Objects
SQL Server Data Tools
Projects and Solutions
Predicates and Operators
Basic SELECT Statement
Returning Distinct Results
WHERE Syntax IN
Filtering NULL Values
Data Type Comparison
Filtering Data with WHERE
Join and Set Operators
Categories of Joins
Set Operators Demo
Subqueries and Table Expressions
Self Contained Subquery
Common Table Expressions
System Function Demo
IIF, CHOOSE and CASE
Logical Function Demo
Introduction to Transactions
INSERT and UPDATE
DELETE and TRUNCATE
Managing Transactions Demo
Execution Plans Demo