Microsoft 70-461: Querying SQL Server 2012
Training
Online
Description
-
Type
Training
-
Level
Beginner
-
Methodology
Online
-
Class hours
1h
-
Duration
Flexible
-
Start date
Different dates available
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.
Facilities
Location
Start date
Start date
About this course
Through this course you will get a good overview of:
Working with T-SQL
Working with PIVOT, UNPIVOT, and Grouping Sets
Managing Error Handling and Transactions
Everyone can take this course, although it is most suitable for
Science & Technology Professionals
Reviews
Subjects
- Transactions
- Server
- Database
- SQL
- Database Administration
- Database training
- Flash
- Syntax
- Industry
- Business Intelligence
- SQL Server
- Control Flow
- SQL Instances
- Customizing SSDT
- SQLCMD
- T-SQL
- Database Development
Course programme
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
Expert Instructor-Led Training
Oxford Applied Training uses only the industry’s finest instructors in the IT industry. They have a minimum of 15 years real-world experience and are subject matter experts in their fields. Unlike a live class, you can fast-forward, repeat or rewind all your lectures. This creates a personal learning experience and gives you all the benefit of hands-on training with the flexibility of doing it around your schedule 24/7.
Visual Demonstrations & Multimedia Presentations
Our courseware includes instructor-led demonstrations and visual presentations that allow students to develop their skills based on real world scenarios explained by the instructor.Oxford Applied Training always focuses on real world scenarios and skill-set development.
Quizzes & Exam Simulators
Oxford Applied Training custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. You will have practice quizzes after each module to ensure you are confident on the topic you have completed before proceeding.
This will allow you to gauge your effectiveness before moving to the next module in your course. Oxford Applied Training courses also include practice exams designed to replicate and mirror the environment in the testing center. These exams are on average 100 questions to ensure you are 100% prepared before taking your certification exam.
Social Learning & Networking
Oxford Applied Training has designed a world class Learning Management System (LMS). This system allows you to interact and collaborate with other students and Oxford Applied Training employees, form study groups, engage in discussions in our NOW@ Forums, rate and “like” different courses and stay up to date with all the latest industry knowledge through our forums, student contributions, and announcement features. This LMS is unmatched in the industry and makes learning fun and enjoyable.
Flash Cards & Educational Games
Oxford Applied Training knows that education is not a one size fits all approach. Students learn in different ways through different tools. That is why we provide flash cards and educational games throughout our courses. This will allow you to train in ways that keep you engaged and focused. Each course will have dozens of flash cards so you can sharpen your skill-sets throughout your training as well as educational games designed to make sure your retention level of the course material extremely high.
Navigation & Controls
Oxford Applied Training self-paced training programs are designed in a modular fashion to allow you the flexibility to work with expert level instruction anytime 24/7. All courses are arranged in defined sections with navigation controls allowing you to control the pace of your training. This allows students to learn at their own pace around their schedule.
Microsoft 70-461: Querying SQL Server 2012