Enquire Now
The Developing SQL Databases Training is a four-day course, part 2 of the series of two courses of MCSA 2016: SQL Database Development, that imparts knowledge of the advanced SQL Server 2016 product features and tools that are used by professionals to develop databases in an organisation. The training will equip students and professionals to optimally utilise the SQL Server features in the successful implementation of databases.
Module 1: Introduction to Database Development
This module introduces the entire SQL Server platform and its major tools. It will cover editions, versions, and concepts of services and service accounts.
Lessons
Module 2: Designing and Implementing Tables
This module introduces the design and implementation of tables. (Note: partitioned tables are not covered).
Lessons
Module 3: Advanced Table Designs
This module defines more advanced table designs.
Lessons
Module 4: Ensuring Data Integrity through Constraints
This module explains the design and implementation of constraints.
Lessons
Module 5: Introduction to Indexes
This module explains the concept of an index and discusses selectivity, density and statistics. It focuses on appropriate data type choices and all the choices surrounding composite index structures.
Lessons
Module 6: Designing Optimized Index Strategies
This module discusses covering indexes and the INCLUDE clause, hints, padding / fillfactor, statistics. It also execution plans and the DTE Lessons.
Lessons
Module 7: Column store Indexes
This module introduces Column store indexes.
Lessons
Module 8: Designing and Implementing Views
This module describes the design and implementation of views.
Lessons
Module 9: Designing and Implementing Stored Procedures
This module introduces the design and implementation of stored procedures.
Lessons
Module 10: Designing and Implementing User-Defined Functions
This module introduces the designing and implementation of functions.
Lessons
Module 11: Responding to Data Manipulation via Triggers
This module introduces the design and implementation of triggers.
Lessons
Module 12: Using In-Memory Tables
This module focuses on the creation of in-memory tables and native stored procedures. Furthermore, advantages of in-memory tables are discussed, for example the removal of transaction blocking.
Lessons
Module 13: Implementing Managed Code in SQL Server
This module explains the implementation of and target use-cases for SQL CLR integration.
Lessons
Module 14: Storing and Querying XML Data in SQL Server
This module describes the XML data type, schema collections, typed and un-typed columns and appropriate use cases for XML in SQL Server.
Lessons
Module 15: Storing and Querying Spatial Data in SQL Server
This module explores spatial data and how this data can be implemented within SQL Server.
Lessons
Module 16: Storing and Querying BLOBs and Text Documents in SQL Server
This module describes full text indexes and queries.
Lessons
The primary audience for this course is IT Professionals who want to acquire requisite skills on SQL Server 2016 for implementing a database.
The secondary audiences for this course are professionals who are developers belonging to other product platforms looking forward to get skilled in the implementation of a SQL Server 2016 database.
| Name | Code | Fee |
|---|---|---|
| Developing SQL Databases | 70-762 | USD 108 |
On All Courses
OR