MCSA SQL 2012 Certification - 9 Day Training Boot Camp

9 Days

Description

Course Length: 9 days

Certifications:

  • MCSA: SQL Server 2012

Exams Included & Administered During Camp:

  • 70-461: Querying Microsoft SQL Server 2012
  • 70-462: Administering a Microsoft SQL Server 2012 Database
  • 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012

What's Included:

  • Airfare - Your Location To Tampa, FL*
  • 3 Microsoft Test Vouchers
  • Microsoft Training Books
  • 9 Nights of Lodging
  • 3 Retake Vouchers (if needed)
  • Microsoft Study Labs & Simulations
  • Ground Transportation
  • Onsite Pearson Vue Test Center
  • Instructor Led Classroom Training

The MCSA SQL Server 2012 certification boot camp is a 9 day comprehensive deep dive into the SQL Server covering topics such as writing queries, administration and data warehousing. This instructor led face to face training camp will teach you the skills needed to support a SQL 2012 environment.

The MCSA SQL boot camp incorporates Microsoft Official Courses:

  • 20461 Querying Microsoft SQL Server
  • 20462 Administering Microsoft SQL Server Databases
  • 20463 Implementing a Data Warehouse with Microsoft SQL Server

While attending this training program - you take three exams to test and certify for the Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 official certification. If your goal is to learn how to use SQL Server 2012 and pass the certification exams (70-461, 70-462 & 70-463) - you've found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives.  

CAMPUS - Certification Camps invested $150,000 into a complete training center construction build out. Larger classrooms, no sound transference between training rooms, new desk / executive leather chairs & great common areas.

CLASSROOM SERVERS - Students work on a dedicated Dell 8500 / 8700 with an Intel i7 (4th generation), minimum of 16GB memory (Most with 32 GB) and most with 512GB SSD drives.

CAMPUS INTERNET - The campus is connected with a 300Mbs Verizon Fios Business Connection which provides complete internet (including VPN) access for students.

COMMON AREA - Unlike any training facility ever - break room with Mame Arcade, high end "kitchen" with snacks, drinks (Starbucks Coffee, 100% juices, sodas, etc) and breathtaking terrace.

LODGING - We use the Marriott Fairfield Inn & Suites Lakewood Ranch. This "upgraded" hotel offers extremely comfortable beds, great breakfast and very fast (Verizon) internet access.

NEAR BY AMENITIES - Many shops, restaurants and grocery options are available within walking distance. Additionally - the hotel provided scheduled shuttle services. Restaurants like Bone Fish Grill, Ruby Tuesday's, Five Guys, Chipotle, Quiznos, Chili's and over 20 additional choices in the immediate area. All of these options are offered in a pedestrian walking village.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCSA SQL 2012 Certification - 9 Day Training Boot Camp class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • Topics covered in this boot camp:
    • Describe the basic architecture and concepts of Microsoft SQL Server 2014
    • Understand the similarities and differences between Transact-SQL and other computer languages
    • Write SELECT queries
    • Query multiple tables
    • Sort and filter data
    • Describe the use of data types in SQL Server
    • Modify data using Transact-SQL
    • Use built-in functions
    • Group and aggregate data
    • Use subqueries
    • Use table expressions
    • Use set operators
    • Use window ranking, offset and aggregate functions
    • Implement pivoting and grouping sets
    • Execute stored procedures
    • Program with T-SQL
    • Implement error handling
    • Implement transactions
    • Describe core database administration tasks and tools
    • Install and configure SQL Server 2014
    • Configure SQL Server databases and storage
    • Plan and implement a backup strategy
    • Restore databases from backups
    • Import and export data
    • Monitor SQL Server
    • Trace SQL Server activity
    • Manage SQL Server security
    • Audit data access and encrypt data
    • Perform ongoing database maintenance
    • Automate SQL Server maintenance with SQL Server Agent Jobs
    • Configure Database Mail, alerts and notifications
    • Describe data warehouse concepts and architecture considerations
    • Select an appropriate hardware platform for a data warehouse
    • Design and implement a data warehouse
    • Implement Data Flow in an SSIS Package
    • Implement Control Flow in an SSIS Package
    • Debug and Troubleshoot SSIS packages
    • Implement an ETL solution that supports incremental data extraction
    • Implement an ETL solution that supports incremental data loading
    • Implement data cleansing by using Microsoft Data Quality Services
    • Implement Master Data Services to enforce data integrity
    • Extend SSIS with custom scripts and components
    • Deploy and Configure SSIS packages
    • Describe how BI solutions can consume data from the data warehouse

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCSA SQL 2012 Certification - 9 Day Training Boot Camp class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

The candidate works in a development environment that uses SQL Server technologies. The candidate should have at least one year of experience developing SQL objects and understanding of normalization.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a MCSA SQL 2012 Certification - 9 Day Training Boot Camp class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date