• My account
  • Cart
English courses / USD

MCSA: Querying Microsoft SQL Server 2012 (Exam 70-461)

Regular Price: $556

Special Price: $275

  • 2 students have purchased
  • Express
Centre
My Training Academy
Town
Potters Bar
Address
Maple House High Street, Potters Bar Hertfordshire United Kingdom, EN6 5BS EN6 5BS See in Google maps
Contact
sales@mytrainingacademy.org.uk
http://www.mytrainingacademy.org.uk/
Map
Description
OUR MISSION: Our mission is to help you learn the skills you need to reach your full potential. WHO WE ARE: We are one of the fastest growing online training providers. We offer engaging, effective and flexible online training solutions to both individuals and businesses. We develop courses that help individuals to prepare for and complete their certification exams with ease. Our unique, flexible approach to learning means you don’t have to put your life on hold to get certified. You can study full time and part time, from home and work and on the move; online and on mobile devices. We provide world class education developed by highly skilled and experienced instructors. Our courses are upgraded regularly to ensure our learners are up-to-date with the latest industry requirements and best practices. WHAT WE BELIEVE We believe technology has paved the way for individuals and businesses all over the world to tap into high quality learning at their fingertips.

Benefits

  • 12 Months unlimited access
  • Make your own study schedule and take advantage of online tutoring hours
  • Obtain a certified diploma once you finish the course.

Details

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...

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 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.

Conditions

Thanks to this offer, valid exclusively for one person, you will obtain a MCSA: Querying Microsoft SQL Server 2012 (Exam 70-461) Online Course.

How to register

By buying the course in Emagister Express, you will obtain an access coupon. We will send you the codes and keys to the coupon. Send the coupon code and the key to info@mytrainingacademy.org.uk. The training provider will then give you access to the course.

This course has not been reviewed yet
Hi! According to your location, we have changed your payment currency to USD.
You can change to other currency by using the option on the header.