callicon +1 210-504-8191
whatsAppIcon +1 210-504-8191
emailIcon info@koenig-solutions.com
koenig-logo
logo-30-years
Login
koenig-logo
whatsAppIcon +1 210-504-8191
phoneIcon +1 210-504-8191

20762C: Developing SQL 2016 Databases Course Overview

20762C: Developing SQL 2016 Databases Course Overview

The 20762C: Developing SQL 2016 Databases course is a comprehensive program designed for professionals seeking to enhance their skills in developing Microsoft SQL Server databases. It covers a broad range of topics essential for effective database development, including designing and implementing tables, enforcing data integrity, optimizing indexes, and utilizing advanced features such as in-memory tables and stored procedures. Through a series of modules and hands-on labs, learners will gain practical experience in managing and maintaining databases, which is crucial for pursuing MCSA SQL Database Administration certification. The knowledge gained from this course will equip individuals to build robust, high-performance databases, making them valuable assets in the field of database development and administration.

4.6 Ratings

Koenig's Unique Offerings

images-1-1

1-on-1 Training

Schedule personalized sessions based upon your availability.

images-1-1

Customized Training

Tailor your learning experience. Dive deeper in topics of greater interest to you.

images-1-1

4-Hour Sessions

Optimize learning with Koenig's 4-hour sessions, balancing knowledge retention and time constraints.

images-1-1

Free Demo Class

Join our training with confidence. Attend a free demo class to experience our expert trainers and get all your queries answered.

Purchase This Course

2,500 ♱

♱

  • Live Online Training (Duration : 40 Hours)
  • Per Participant
  • Guaranteed-to-Run (GTR)
  • date-img
  • date-img

♱ Excluding VAT/GST

Classroom Training price is on request

  • Live Online Training (Duration : 40 Hours)
  • Per Participant

♱ Excluding VAT/GST

Classroom Training price is on request

Request More Information

Email:  WhatsApp:

Winner of the Microsoft’s Asia Superstar Campaign in FY 22

Course Prerequisites

To ensure that you can successfully undertake training in the 20762C: Developing SQL 2016 Databases course, the following prerequisites are recommended:


  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working experience with Transact-SQL, such as writing T-SQL queries.
  • Familiarity with relational databases and basic database design principles.
  • Some experience with database design, which includes knowing normalized database design concepts.
  • Understanding of basic programming constructs, such as looping and branching.

These prerequisites are designed to provide you with the foundational knowledge required to maximize your learning experience during the course. If you're new to these concepts, we encourage you to explore introductory materials or courses on SQL Server and basic programming before enrolling in this course.


Target Audience for 20762C: Developing SQL 2016 Databases

Course 20762C: Developing SQL 2016 Databases is designed for IT professionals who want to enhance their skills in building and implementing databases in SQL Server 2016.


  • Database Developers
  • Database Analysts
  • SQL Server Programmers
  • IT Professionals responsible for database development
  • Software Engineers who integrate databases into their applications
  • Data Architects designing and optimizing database schemas
  • System Administrators involved in database maintenance and setup
  • Technical Consultants implementing database solutions for clients
  • Business Intelligence Professionals working with SQL Server data structures
  • Data Scientists requiring knowledge of database development for data analysis tasks
  • Database Administrators looking to deepen their understanding of database development


Learning Objectives - What you will Learn in this 20762C: Developing SQL 2016 Databases?

Learning Outcomes Introduction

Gain in-depth skills in SQL Server 2016 database development, including table design, indexing, query tuning, stored procedures, and advanced data types, to optimize and secure data storage and retrieval.

Learning Objectives and Outcomes

  • Understand the SQL Server Platform: Grasp the fundamentals of the SQL Server platform and the key tasks involved in database development.
  • Design and Implement Tables: Learn to design tables with appropriate data types and schemas, and understand how to create and alter tables effectively.
  • Advanced Table Designs: Master partitioning, compressing, and temporal table functionalities to manage large data sets efficiently.
  • Data Integrity Constraints: Implement constraints to maintain data integrity, including entity, domain, and referential integrity.
  • Indexing Strategies: Develop core indexing concepts, create optimized index strategies, and manage indexes to improve query performance.
  • Columnstore Indexes: Utilize columnstore indexes to enable high-performance data warehousing and analytics.
  • Views and Stored Procedures: Create and manage views and stored procedures, optimizing them for performance and controlling execution context.
  • User-Defined Functions: Design and implement scalar and table-valued functions, and understand when to use them over other constructs.
  • Triggers and In-Memory Tables: Respond to data manipulation with DML triggers and leverage memory-optimized tables for faster access.
  • Performance and Monitoring: Employ monitoring tools such as Extended Events and Live Query Statistics, and understand how to optimize database file configurations for peak performance.