Microsoft 70-461: Querying SQL Server 2012
Oxford Applied Training
Summary
Price
£499 inc VAT
Study method
Online
Duration
Self-paced
Qualification
No formal qualification
Overview
This course is in preparation for exam 70-461. This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 and is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
Description
Course Syllabus
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
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
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Add to basket or enquire
Course provided by
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
FAQs
Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.
CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.
A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.
An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
