Special Offers | My Account | Log In
  0 items in your cart

Search: Boson Sites | Products

Preview our new look!

Microsoft > MCSA > MCSA SQL 2016 Database Development Bootcamp

Upcoming Dates:

Don’t see the date you want? Contact us.
Price: $3695

Call 813-925-0700 (opt 2) to request this class.

MCSA SQL 2016 Database Development Bootcamp

Bootcamp Guarantee
Class Delivery Methods
Request a private class

Contact Us:

813-925-0700 (opt 2)
877-333-EXAM (opt 2)
FAX: 813-925-3957
EMAIL: Boson Training

Full Course List

Request More Information

MCSA SQL 2016 Database Development Bootcamp

About This IT Training:

Exam Numbers: 70-761, 70-762
Certifications: MCSA
Single-User License  

MCSA SQL 2016 Database Development Certification

The Microsoft Official MCSA: SQL 2016 Database Development certification boot camp is a five-day comprehensive deep dive into the SQL Server developer topics such as writing queries, subqueries, expressions, operators, stored procs, etc. This camp is well suited for SQL power users, report writers, business analysts and client application developers. This instructor led training program will teach you the skills needed to support SQL 2016 developer task.

To successfully complete the certification you take two exams to test and certify for the Microsoft  MCSA SQL 2016 Database Development.

What’s Included

  • Comprehensive study materials, including official Microsoft courseware
  • On-site certification testing with up to four vouchers that are valid for one year from original class date

Topics Covered

  • 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

Related Products

Practice Lab for Microsoft 70-761
Practice Lab for Microsoft 70-762

Be the first to review this product. If you have used this product, you can review it on your account page. You must be logged in to review products.