MCSA SQL 2016 Database Development Bootcamp

About This Bootcamp

Length: 6 days

This boot camp is designed to introduce students to Transact-SQL. This instructor-led boot camp also provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The boot camp focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database. 

The primary goal of this boot camp is to help each student pass the exams required to earn the MCSA SQL 2016 Database Development certification. To do this, your knowledgeable instructor will blend hands-on labs with lecture and practice exams to prepare you to pass each exam. The practice exams identify knowledge gaps that the instructor will fill with customized, hands-on labs and tailored lectures.

Required Exams

To earn the certification, students must pass the following exam(s):

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

Course Objectives

After completing this boot camp, students will be able to:

  • Describe key capabilities and components of SQL Server 2016.
  • Describe T-SQL, sets, and predicate logic.
  • Write a single table SELECT statement.
  • Write a multi-table SELECT statement.
  • Write SELECT statements with filtering and sorting.
  • Describe how SQL Server uses data types.
  • Write DML statements.
  • Write queries that use built-in functions.
  • Write queries that aggregate data.
  • Write subqueries.
  • Create and implement views and table-valued functions.
  • Use set operators to combine query results.
  • Write queries that use window ranking, offset, and aggregate functions.
  • Transform data by implementing pivot, un-pivot, rollup and cube.
  • Create and implement stored procedures.
  • Add programming constructs such as variables, conditions, and loops to T-SQL code.
  • Design and Implement Tables.
  • Describe advanced table designs
  • Ensure Data Integrity through Constraints.
  • Describe indexes, including Optimized and Column-store 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.

Who should take this bootcamp.

The main purpose of the boot camp is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this boot camp is: Database Administrators, Database Developers and BI professionals.

MCSA SQL 2016 Database Development Bootcamp
Select a Date:
Choose a Location:
Enter the text in the image


Please fill out the form below to contact a training consultant directly or call 888-862-3784

Full Name

Company

Location

Email

Phone

Message

Enter the text in the image