Shopping Cart  [0]

Call 800.698.5501

MCSA SQL 2016 Database Development Boot Camp - Training Camp

MCSA Certification Training
TrainingCamp Twitter Feed

Our 5-Day MCSA SQL 2016 Database Development Certification Boot Camp covers developer topics such as writing queries, subqueries, expressions, operators, stored procs, etc. This program is well suited for SQL power users, report writers, business analysts and client application developers.

During this course you will take the following Official Microsoft exams onsite during the class:

70-761: Querying Data with Transact-SQL
70-762: Developing SQL Databases

This comprehensive training focuses on learning beyond the core content of standard Microsoft courses. Our program incorporates interactive demonstrations with exam foucused explanations using Training Camp's award-winning comprehensive exam preparation best practices.

In addition to our public course schedule , we can also offer Private Group Training with Microsoft exams hosted at any location in the world, with no student minimum number.

Enrollment Information

Training Pricing View Pricing
Training Pricing Course Schedule


Duration: 6 days
Exam Voucher: Included
Testing: Delivered On-Site
GI Bill Eligible: Exam Fees
GSA Catalog: GS-02F-0044T

Other Delivery Formats

Hosted  Boot Camp Private Group Training
Microsof Certification Training

Official Microsoft Training Includes:
  • Official Microsoft Courseware
  • Hands-On Labs
  • SATV Redemption Options
  • Education Guarantee

  • Training Camp Exclusive Boot Camp Add-ons:
  • Official Exam Testing Onsite During Class
  • Practice Exams/Evening Review Sessions
  • Hotel/Travel Packages
  • Pre-Class Self-Paced Video Access
  • Training on your terms.

    Training Camp offers the full spectrum of learning [delivery] options - providing our customers with end-to-end solutions to assist in achieving education goals.

    Instructor-Led Boot Camp
    Check out our dates and locations for this MCSA SQL 2016 Database Development Certification Boot Camp.

    Microsoft SATV
    These benefits may cover up to 100% of tuition & courseware, plus other training-related costs as well.

    Group Training
    We offer Microsoft training with onsite exam delivery options to support your team training requirements.

    Microsoft Winner
    As a Microsoft Gold Partner, Training Camp has successfully delivered hands-on, Microsoft database training for Microsoft Certification since 1999. Training Camp pioneered the first exam-focused Microsoft "Exam Prep" Boot Camps, and has since successfully certified thousands of professionals.

    Microsoft Instructors
    Experienced Microsoft MCT & MCSE Certified Instructors

    Our instructors are well-versed in accelerated learning concepts and exam preparation. During our MCSA SQL 2016 Database Development boot camp, the experience of working with thousands of exam takers give our team unique insight into the learning requirements needed for success. This program delivery accommodates every student's learning needs through individualized instruction, lab partner and group exercises, independent study, self-testing, and question/answer drills.

    MICROSOFT Certification Practice Tests
    Detailed Practice Exams/Evening Review Sessions
    *Training Camp Exclusive Feature

    Our MCSA SQL 2016 Database Development Certification Boot Camp training boot camp includes custom practice exams - representative of the actual exam questions from Microsoft. During our evening review sessions we drill down on these questions, which is the key to Microsoft exam preparation.

    Microsoft Exam
    Onsite Exams/Retake Vouchers
    *Training Camp Exclusive Feature

    We host the official Our MCSA SQL 2016 Database Development Certification Boot Camp training 70-761 & 70-762 exams during the class for our students. These exams are delivered at our site - with Pearson VUE/Microsoft approval - not at 'local' testing centers that are subject to seat availability. With our award winning exam prep, , you will be ready to take on this required Microsoft SQL track of exams. Our goal is for students to leave class with knowledge & certification.

    MCSA Server 2016 Candidate
    This certification is intended for SQL Server users who are seeking to validate their skills and knowledge with SQl Server 2016 using the SQL 2016 developer task.

    Course Outline

    Describe the basic architecture and concepts of Microsoft SQL Server 2016.
    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

    Design and Implement Tables.
    Describe advanced table designs
    Ensure Data Integrity through Constraints.
    Describe indexes, including Optimized and Columnstore indexes
    Design and Implement Views.
    Design and Implement Stored Procedures.
    Design and Implement User Defined Functions.
    Respond to data manipulation using triggers.
    Design and Implement In-Memory Tables.
    Implement Managed Code in SQL Server.
    Store and Query XML Data.
    Work with Spatial Data.
    Store and Query Blobs and Text Documents.