> > > SQL12FT

Fast Track: MCSA SQL Server 2012 (SQL12FT)

 

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

Durata 5 Giorni

Prezzo (IVA esclusa)
  • Italia: 2.880,- €
 
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.