Sparen Sie 66%
WGS Career Academy

MCSA SQL Server 2012 (Live Labs Included)

WGS Career Academy
Online
Emagister-Preis

679 € 232 
*Orientierungspreis
Originalpreis in GBP:
£ 600  £ 205

Wichtige informationen

Tipologie Kurs
Niveau Intermediate
Methodologie Online
Unterrichtsstunden 45h
Dauer 1
Beginn nach Wahl
Online Campus Ja
Beratungsservice Ja
Virtueller Unterricht Ja
  • Kurs
  • Intermediate
  • Online
  • 45h
  • Dauer:
    1
  • Beginn:
    nach Wahl
  • Online Campus
  • Beratungsservice
  • Virtueller Unterricht
Beschreibung

Develop the skills needed to become a fully qualified SQL Server 2012 database administrator with the official Microsoft Certified Systems Associate qualification. Upon completion of this intensive hands-on course, students will be ready to sit the exams required to achieve the MCSA qualification.

From the core fundamentals of querying tables through to building an enterprise-class data warehouse, the SQL Server 2012 database administrator course is perfect for administrators, implementers, system engineers and developers who want to improve their skills and earn an industry-recognised qualification.

More than simply providing access to course materials however,’ Practice-Labs help students develop their practical skills with access to dedicated live equipment, allowing them to put their knowledge to the test and recreate the scenarios they encounter in their studies. By completing this course students will not only fully understand the concepts behind Microsoft SQL Server 2012, but also develop the skills needed to properly manage, maintain and manipulate a database in a real world environment.

Wichtige informationen
Welche Ziele verfolgt der Kurs?

The MCSA SQL Server 2012 qualification is built around three exams, and this course is tailored to help students understand the concepts and techniques required to pass them all.

Training begins with the fundamental techniques needed to access, manipulate and transform data stored in SQL Server 2012. Students will master:

The Transact-SQL (T-SQL) language, and how to build efficient queries, stored procedures and views that return key information quickly.
How to combine datasets, rank results and extend tables programmatically.
Optimise T-SQL statements for the most efficient operation.
Extend reporting and data transfer capabilities using XML.
Moving on, the course will then introduce trainees to the technology behind Microsoft SQL Server 2012. By practicing deployment and configuration of the database server, students will:

Appreciate the correct way to install and use add-on components, instances and services.
Build systems for high availability environments using AlwaysOn, mirroring and replication to keep data online at all times.
How to protect information from loss using database backup, restore and disaster recovery (DR) techniques.
Securing database contents by configuring permissions, alerts, logins, roles and more.
Practical troubleshooting, maintenance and optimisation techniques will ensure that trainees can deliver performance and reliability improvements for real-world deployments.

Ist dieser Kurs für mich?

The MCSA SQL Server 2012 course is essential for IT professionals who want to improve their database management skills, or gain the knowledge and experience required to pass their MCSA exam.

Preis für Emagister-Nutzer:

Voraussetzungen: Internet Explorer 8 or above Google Chrome Safari 6 or above Mozilla Firefox

Einrichtungen (1)
Wo und wann
Beginn Lage
nach Wahl
Online
Beginn nach Wahl
Lage
Online

Was lernen Sie in diesem Kurs?

Access
Server
Database
SQL
Database training
MCSA training
MCSA
SQL Server
Queries
T-SQL
SQL Data Types

Themenkreis

Units of Study

Microsoft 70-461: Querying SQL Server 2012
  • Getting Started with SQL Server 2012
  • Working with T-SQL
  • Writing SELECT Queries
  • Working with SQL Data Types
  • Sorting and Filtering Data
  • Querying Data from Multiple Tables
  • Modifying Data
  • Working with SQL Server Built-in Functions
  • Programming in T-SQL
  • Implementing Stored Procedures
  • Working with Subqueries and Table Expressions
  • Working with Set Operators, Conditional Operators, and Window Functions
  • Working with PIVOT, UNPIVOT, and Grouping Sets
  • Managing Error Handling and Transactions
  • Querying SQL Server System
  • Optimizing Query Performance
Microsoft 70-462: Administering SQL Server 2012 Databases
  • Identifying the SQL Server Platform
  • Deploying SQL Server
  • Configuring SQL Server
  • Managing Databases in SQL Server 2012
  • Managing SQL Server Security
  • Implementing Advanced Security Settings
  • Applying Encryption and Compression
  • Working with Indexes and Log Files
  • Working with Backup and Restore
  • Implementing High Availability
  • Optimizing Server Performance
  • Troubleshooting Issues and Recovering Databases
  • Performing Advanced Database Management Tasks
Microsoft 70-463: Implementing a Data Warehouse with SQL Server 2012
  • Introduction to Data Warehouse
  • Creating Dimensions and Changing Granularity of Dimensions
  • Creating Fact Tables and ColumnStore Indexes
  • Implementing Data Warehouse in SQL Server 2012
  • Working with Integration Services
  • Managing Control Flow
  • Working with Dynamic Variables
  • Implementing Data Flow
  • Managing Data Flow
  • Managing SSIS Package Execution
  • Debugging and Troubleshooting
  • Deploying Packages
  • Securing Packages and Databases
  • Working with MDS and Windows