MCSA: Querying Microsoft SQL Server 2012 (Exam 70-461)
Vocational qualification
Online
Description
-
Type
Vocational qualification
-
Methodology
Online
-
Start date
Different dates available
Employers worldwide are searching for IT professionals with validated skills, with a Microsoft certification in hand, you'll certainly stand out from the crowd. SQL Server 2012 is a software product designed by Microsoft which is used to store, extract and manage data from a database that may be running on the same computer, or other computers that are connected to the same network.
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.
Gaining the MCSA: Querying Microsoft SQL Server 2012 certification will show employers you have acquired the knowledge and skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 in an organisation's databases effectively.
After completing this course, you will learn the skills and knowledge required to work effectively in a professional IT environment and prepared for the Microsoft 70-461 exam. Once certified, you'll be qualified for jobs such as Database Administrator and Database Analyst, earning an average salary of about £42,500.00 per year.
The great thing about our MCSA: Querying Microsoft SQL Server 2012 (Exam 70-461) course is that you are in charge of your start and finish date, with no deadline pressures!
We train our students to the very best standards, offering expert instructor-led training via our state of the art eLearning platform.
By achieving the MCSA: Querying Microsoft SQL Server 2012 (Exam 70-461) certification, you will create more career opportunities and be better positioned when applying for work.
Enrol today and prepare for a future you deserve.WHY STUDY WITH MY TRAINING ACADEMY?
Flexible training- study anytime, anywhere and from any device. Expert Instructor-Led TrainingÐ our courses are delivered...
Important information
Price for Emagister users:
Facilities
Location
Start date
Start date
Reviews
Subjects
- Transactions
- Server
- Database
- SQL
- Database training
- MCSA training
- MCSA
- Hacking
- Data Protection
- Computer Engineering
- IT Security
- Data security
- Computer Systems
- IT Systems
- Computer Science
- Network Engineering
- Computering
Course programme
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 ReviewModule 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 ReviewModule 3
SELECT Statements
Basic SELECT Statement
Specifying Columns
Derived Columns
Aliasing Columns
Calculated Columns
Ordering Results
Returning Distinct Results
Exam Scenarios
Module ReviewModule 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 ReviewModule 5
Join and Set Operators
Using Joins
Categories of Joins
INNER JOIN
OUTER JOIN
JOIN Demo
Set Operators
Set Operators Demo
Exam Scenarios
Module ReviewModule 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 ReviewModule 7
System Functions
Scalar Functions
ROWSET
System Function Demo
Aggregate Functions
DISTINCT
Aggregation Demo
GROUP BY
HAVING
Conversion Functions
Exam Scenarios
Module ReviewModule 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 ReviewModule 9
Transactions
Introduction to Transactions
INSERT and UPDATE
DELETE and TRUNCATE
Transactions Demo
Managing Transactions
XACT_ABORT
Managing Transactions Demo
Exam Scenarios
Module ReviewModule 10
Query Performance
Indexing
Index Strategies
Indexes Demo
Execution Plans
Statistics IO
Execution Plans Demo
Exam Scenarios
Module Review
Program ReviewENTRY REQUIREMENTSThe MCSA Querying Microsoft SQL Server 2012 is intended for learners who are seeking to validate their skills and knowledge in writing queries, such as SQL server database administrators, system engineers and developers with two or more years of experience.MULTI-USER TRAINING PACKAGESThis online course can be integrated in your professional training plan. M.T.A. can provide you with a tailored learning solution, that can be customised to meet each team member's requirements. Choosing a multi-user training package, you can get significant discounts for 5+ users and even further discounts for 10+ users Ð and an excellent return on your investment.
MCSA: Querying Microsoft SQL Server 2012 (Exam 70-461)