• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
No Classes Available in this Courses.

In MCSA: SQL 2012/2014 Boot Camp quickened learning condition, you will construct your abilities and get ready for the MCSA: SQL Server 2012/2014 accreditation exams. MCSA: SQL 2012/2014 Boot Camp expanded hours training camp drove by senior Global Knowledge educators incorporates focused on addresses utilizing Microsoft Learning prescribed substance and additionally a year of access to more than 40 hands-on remote labs. 

MCSA: SQL 2012/2014 Boot Camp training camp incorporates all the exam vouchers required for accreditation, alongside one free retake voucher if necessary. It additionally incorporates access to our Microsoft Boot Camp Exclusives, giving crucial affirmation exam prep. 

Note: Microsoft Learning has rebranded the MCSA confirmation to MCSA: SQL Server 2012/2014. 

WHAT YOU'LL LEARN 

  • The specialized abilities required to compose essential Transact-SQL inquiries for Microsoft SQL Server 2012 
  • The information and abilities to keep up Microsoft SQL Server 2012 databases 
  • Make an information stockroom with SQL Server 2012 
  • Actualize ETL with SQL Server Integration Services 
  • Approve and wash down information with SQL Server Data Quality Services and SQL Server Master Data Services 
  • Key subjects and ideas tended to on the MCSA: SQL Server 2012 exams 

Questioning Microsoft SQL Server (M20461) 

   Lab 1: SQL Server 2014 Tools 

   Lab 2: Transact-SQL Querying 

   Lab 3: Write Basic SELECT articulations 

   Lab 4: Query Multiple Tables 

   Lab 5: Sort and Filter Data 

   Lab 6: Work with SQL Server 2014 Data Types 

   Lab 7: Modify Data utilizing DML 

   Lab 8: Built-In Functions 

   Lab 9: Group and Aggregate Data 

   Lab 10: Subqueries 

   Lab 11: Table Expressions 

   Lab 12: Set Operators 

   Lab 13: Use Window Ranking, Offset, and Aggregate Functions 

   Lab 14: Pivot and Group Sets 

   Lab 15: Execute Stored Procedures 

   Lab 16: Program with T-SQL 

   Lab 17: Implement Error Handling 

   Lab 18: Implement Transactions 

   Lab 19: Improve Query Performance 

   Lab 20: Query SQL Server Metadata 

Managing Microsoft SQL Server Databases (M20462) 

   Lab 1: Use SQL Server Administrative Tools 

   Lab 2: Install SQL Server 2014 

   Lab 4: Manage Database Storage 

   Lab 4: Back Up SQL Server Databases 

   Lab 5: Restore SQL Server 2014 Databases 

   Lab 6: Import and Export Data 

   Lab 7: Monitor SQL Server 2014 

   Lab 8: Trace SQL Server Workload Activity 

   Lab 9: Manage SQL Server Security 

   Lab 10: Audit Data Access and Encrypting Data 

   Lab 11: Perform Ongoing Database Maintenance 

   Lab 12: Automate SQL Server Management 

   Lab 13: Monitor SQL Agent utilizing Alerts and Notifications 

Actualizing a Data Warehouse with Microsoft SQL Server (M20463) 

   Lab 1: Exploring a Data Warehousing Solution 

   Lab 2: Planning Data Warehouse Infrastructure 

   Lab 3: Implementing a Data Warehouse 

   Lab 4: Implement Data Flow in a SSIS Package 

   Lab 5A: Implementing Control Flow in a SSIS Package 

   Lab 5B: Using Transactions and Checkpoints 

   Lab 6: Debugging and Troubleshooting a SSIS Package 

   Lab 7: Extracting Modified Data 

   Lab 8: Loading a Data Warehouse 

   Lab 9: Cleansing Data and Deduplicating Data 

   Lab 10: Implementing Master Data Services 

   Lab 11: Using Custom Scripts 

   Lab 12: Deploying and Configuring SSIS Packages 

   Lab 13: Using a Data Warehouse

You will get ready for these exams: 

  • 70-461: Querying Microsoft SQL Server 2014 
  • 70-462: Administering Microsoft SQL Server 2012/2014 Databases 
  • 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012/2014

Awards