RISPARMIA 51%
My Training Academy

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

My Training Academy
Online
Prezzo Emagister

447 € 221 
+IVA
*Prezzo Orientativo
Importo originale in GBP:
£ 395  £ 195

Informazioni importanti

Tipologia Vocational qualification
Metodologia Online
Inizio Scegli data
  • Vocational qualification
  • Online
  • Inizio:
    Scegli data
Descrizione

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

Informazioni importanti

Prezzo per gli utenti Emagister:

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Online
Inizio Scegli data
Luogo
Online

Cosa impari in questo corso?

Transactions
Server
Database
SQL
Database training
MCSA training
MCSA
Hacking
Data Protection
Computer Engineering
IT Security
Data security
Computer Systems
IT Systems
Computer Science
Transactions
Network Engineering
Computering
Computering

Programma

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.