SQL Databases Training

This instructor-led Developing SQL Databases training course provides students with the knowledge and skills to develop a Microsoft SQL Server database. This SQL Server database development course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.

Plus, get prepped for Microsoft exam 70-762, a requirement for MCSA: SQL 2016 Database Development and MCSE: Data Management and Analytics.

Microsoft SQL Server is one of the most popular Relational Database Management System (RDBMS). The SQL Server Training and Certification courses enable you to install, build and design databases and include a detailed understanding of the Transact-SQL skills required to create database objects such as Tables, Views and Stored procedures and functions in SQL server

Attend this course and learn basic Transact-SQL queries for Microsoft SQL Server.

The Developing SQL Databases training is suited for IT professionals looking to become skilled in SQL Server product features and database technologies. You can also benefit from taking this course if you’re a developer working with other platforms who wants experience implementing SQL Server databases

Why the Developing SQL Databases Training

Gain the internationally recognized Microsoft 70-762 Developing SQL Database Certification
Benefit from the guidance and feedback of experienced Microsoft Trainer

Developing SQL Databases Training Learning Outcome

At the end of this program, participants will not only be eligible for the MS-70762 certification exam but also possess knowledge on:

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 .

Prerequisites

Before attending this course, students must have the following:

Basic knowledge of the Microsoft Windows operating system and its core functionality.
Working knowledge of Transact-SQL
Working knowledge of relational databases

Developing SQL Databases Training Course Outline

MODULE 1: Introduction to Database Development.
MODULE 2: Designing and Implementing Tables
MODULE 3: Advanced Table Designs
MODULE 4: Ensuring Data Integrity through Constraints.
MODULE 5: Introduction to Indexes
MODULE 6: Designing Optimized Index Strategies
MODULE 7: Column store indexes
MODULE 8: Designing and Implementing Views
MODULE 9: Designing and Implementing Stored Procedures
MODULE 10: Designing and Implementing User-Defined Functions
MODULE 11: Responding to Data Manipulation via Triggers.
MODULE 12: Using In-Memory Tables
MODULE 13: Implementing Managed Code in SQL Server
MODULE 14: Storing and Querying XML Data in SQL Server
MODULE 15: Storing and Querying Spatial Data in SQL Server
MODULE 16: Storing and Querying BLOBs and Text Documents in SQL Server
MODULE 17: SQL Server Concurrency
MODULE 18: Performance and Monitoring