$1,500.00 Software Assurance Training Vouchers Accepted

    Legend

    Location Start date End Date Class Times Class Details Action
    No class dates currently scheduled. Click here to request a date

    Overview

    Exams Included:

    • 70-762: Developing SQL Databases

    TechSherpas ’ boot camps are geared towards providing students with the necessary skills and knowledge to not only pass the Microsoft Certification exams, but to also excel in their IT career paths. All of our boot camps are all-inclusive and include benefits such as:

    • 100% Test Pass Guarantee
    • All course materials, practice exams and official certification exams
    • Onsite Prometric Testing Center
    • Hands-on instruction by a certified instructor
    • Breakfast and Lunch provided each day
    • Airfare, lodging and transportation packages available (Option 2)

     

    Audience Profile

    This exam is intended for database professionals who build and implement databases across organizations and who ensure high levels of data availability. Their responsibilities include creating database files, data types, and tables; planning, creating, and optimizing indexes; ensuring data integrity; implementing views, stored procedures, and functions; and managing transactions and locks.

     

    At Course Completion

    After completing this course, students will be able to:

    • 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.

    Description

    Course Description

    This accelerated boot camp will prepare students to pass the 70-762 exam, and provide students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

    Design and implement database objects

    • Design and implement a relational database schema
    • Design and implement indexes
    • Design and implement views
    • Implement columnstore indexes

     

    Implement programmability objects

    • Ensure data integrity with constraints
    • Create stored procedures
    • Create triggers and user-defined functions

     

    Manage database concurrency

    • Implement transactions
    • Manage isolation levels
    • Optimize concurrency and locking behavior
    • Implement memory-optimized tables and native stored procedures

     

    Optimize database objects and SQL infrastructure

    • Optimize statistics and indexes
    • Analyze and troubleshoot query plans
    • Manage performance for database instances
    • Monitor and trace SQL Server baseline performance metrics