651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

MCSE Data Mgmt & Analytics (SQL Developer) Training & Certification Boot Camp Classroom Live Tampa, FL December 14, 2020

Price: $4,995

This course runs for a duration of 6 Days.

The class will run daily from 9:00 am EST to 5:00 pm EST.

Class Location: Tampa - Tampa, FL.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

The MCSE Data Mgmt & Analytics (Developer) certification boot camp is a 6 day comprehensive deep dive into on-premises and cloud based SQL Server development (for developers). Students create database objects including views, stored procedures, along with parameters, and functions.Additionally - students learn other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers.  This instructor led face to face training camp will teach you the skills needed to support an SQL Server environment as an SQL Developer.

This MCSE Data Mgmt & Analytics (Developer) boot camp incorporates Microsoft Courses -

While attending this training program - you take two exams to test and certify for the Microsoft Certified Solutions Expert: MCSE Data Platform official certification. If your goal is to learn SQL Server and pass the certification exam - you've found the right place. This course is a hybrid of actual hands on learning combined with focused materials mapped to exam objectives. 

Course length: 6 days

Certifications:

  • MCSE: Data Management & Analytics (Developer)

Exams Included & Administered During Camp:

  • 70-464: Developing Microsoft SQL Server 2012 Databases
  • 70-465: Designing Database Solutions for Microsoft SQL Server 2012

What's Included:

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

Attend the Instructor Led Live face to face training camp near Tampa, FL -or- Online Instructor Led Live anywhere (Maximum 2 students attend online live).

 

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.

Course Overview

  • Topics covered in this boot camp:
    • Introduce the entire SQL Server platform and its major tools. It will cover editions, versions, basics of network listeners, and concepts of services
    • Determine appropriate data types to be used when designing tables, convert data between data types, and create alias data types
    • Be aware of good design practices regarding SQL Server tables and be able to create tables using T-SQL. (Note: partitioned tables are not covered)
    • Implement PRIMARY KEY, FOREIGN KEY, DEFAULT, CHECK and UNIQUE constraints, and investigate cascading FOREIGN KEY constraints
    • Determine appropriate single column and composite indexes strategies
    • Create tables as heaps and tables with clustered indexes. Also consider the design of a table and suggest an appropriate structure
    • Read and interpret details of common elements from execution plans
    • Design effective non-clustered indexes
    • Design and implement views
    • Design and implement stored procedures
    • Work with table types, table valued parameters and use the MERGE statement to create stored procedures that update data warehouses
    • Design and implement functions, both scalar and table-valued. (Also describe where they can lead to performance issues)
    • Perform basic investigation of a deadlock situation and learn how transaction isolation levels affect application concurrency
    • Use both traditional T-SQL error handling code and structured exception handling
    • Design and implement DML triggers
    • Learn appropriate uses for SQL CLR integration and implement an existing .NET assembly within SQL Server
    • Store XML data and schemas in SQL Server
    • Perform basic queries on XML data in SQL Server
    • Work with the GEOGRAPHY and GEOMETRY data types
    • Implement and query a full-text index
    • Assess an existing enterprise environment
    • Plan and implement Policy-Based Management
    • Describe the considerations for consolidating workloads with SQL Server
    • Describe considerations for including SQL Server  in a private cloud
    • Use Microsoft Azure storage with SQL Server
    • Implement and configure databases in Microsoft Azure SQL Database
    • Implement and configure databases in Microsoft Azure virtual machines
    • Describe high availability technologies in SQL Server and implement log shipping
    • Describe Windows Server Failover Clustering and Implement an AlwaysOn Failover Cluster Instance
    • Implement an Always On Availability Group
    • Plan high availability and disaster recovery solutions
    • Plan and implement database replication

Prerequisites

  • IMPORTANT - While you can attend this camp without holding the MCSA certification, you must have the MCSA: SQL Server to earn MCSE: Data Platform certification.