> > > SQL12FT

Fast Track: MCSA SQL Server 2012 (SQL12FT)

Descrizione del Corso Schedulazione
 

Course Overview

This intensive boot camp helps to achieve the MCSA SQL Server 2014 (MCSA) certification combining contents from the following official courses:

  • !MS-10774
  • !MS-10775
  • !MS-10777

Chi dovrebbe partecipare

IT professionals with practical experience in running MS Windows Server and SQL database servers.

Prerequisiti

  • Practical experience in the administration of MS SQL Server 2008 or 2012.
  • High level of motivation to attend a workshop that goes beyond the normal course period.

Obiettivi del Corso

  • Optimal preparation for certification in just 5 days
  • Efficient summary of the MOC10774 / 10775 / 10777 courses with a focus on the relative exam topics
  • Efficient time-cost learning / certification method

Contenuti del Corso

To prepare for the exam 70-461:

  • Introduction to Microsoft SQL Server 2012
  • Introduction to Transact-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server Denali Data Types
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Use Set Operators
  • Using Window Ranking, Offset and Aggregate Functions
  • Pivoting and Grouping Sets
  • Querying SQL Server Metadata
  • Executing Stored Procedures
  • Programming with T-SQL
  • Implementing Error Handling
  • Implementing Transactions
  • Improving Query Performance

To prepare for the exam 70-462:

  • Introduction to SQL Server 2012 and its Toolset
  • Preparing Systems for SQL Server 2012
  • Installing and Configuring SQL Server 2012
  • Working with Databases
  • Understanding SQL Server 2012 Recovery Models
  • Backup of SQL Server 2012 Databases
  • Restoring SQL Server 2012 Databases
  • Importing and Exporting Data
  • Authenticating and Authorizing Users
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Auditing SQL Server Environments
  • Automating SQL Server 2012 Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server 2012 with Alerts and Notifications
  • Performing Ongoing Database Maintenance
  • Tracing Access to SQL Server 2012
  • Monitoring SQL Server 2012
  • Managing Multiple Servers
  • Troubleshooting Common SQL Server 2012 Administrative Issues

To prepare for the exam 70-463:

  • Introduction to Data Warehousing
  • Data Warehouse Hardware Considerations
  • Designing and Implementing a Data Warehouse
  • Design and implement a schema for a data warehouse
  • Implementing Control Flow in an SSIS Package
  • Debugging and Troubleshooting SSIS Packages
  • Implementing an Incremental ETL Process
  • Incorporating Data from the Cloud in a Data Warehouse
  • Enforcing Data Quality
  • Using Master Data Services
  • Extending SSIS
  • Deploying and Configuring SSIS Packages
  • Consuming Data in a Data Warehouse
Formazione in Aula
Modality: C

Durata 5 Giorni

Prezzo (IVA esclusa)
  • Italia: 2.880,- €
Date e prenotazione
 
Schedulazione

Per informazioni scrivere a info@flane.it

 

I cookies ci aiutano a fornirti un servizio adeguato. Utilizzando i nostri servizi acconsenti all'utilizzo dei cookies.   Acconsento.