Designing Microsoft T-SQL Objects

About this Course

This training lets you get familiar with table creation and design, managing indexes, and retrieving details about the database execution plans. This course also focuses on the creation of views, and TSQL programming units such as Stored Procedures, Functions, and Triggers. Other common aspects of database development, such as concurrency and XML management are also covered in this course.

In this course, each module is reinforced with structured hands-on exercises.

Audience Profile

This course is mainly intended for Database Administrators, Database Developers, Business Intelligence professionals, QA professionals, Data Analysts, and other roles responsible for developing SQL Server Databases.

Module 1 - Designing Tables

Data Types
Working with Schemas
Creating and Altering Tables
Partitioning Data
Compressing Data

Module 2 - Data Integrity and Constraints

Understanding the role of Constraints in RDBMS
Implementing Primary Key, NOT NULL, Unique, Check and Foreign Key

Module 3 - Introduction to Indexing

Core Indexing Concepts
Managing Indexes
Working with Execution Plans

Module 4 - Designing and Implementing Views

Introduction to Views
Creating and Managing Views
Performance Considerations

Module 5 - Designing Stored Procedures

Introduction to Stored Procedures
Working With Stored Procedures
Implementing Parameterized Stored Procedures

Module 6 - Designing User-Defined Functions

Overview of Functions
Designing and Implementing Scalar Functions
Designing and Implementing Table-Valued Functions
Implementation Considerations for Functions
Alternatives to Functions

Module 7 - Working with Triggers

Designing DML triggers
Designing DML triggers

Contact Us

Contact Us

Latest courses

About Us

UpScale Analytics specializes in training solutions for organizations and individuals in the fields of data.

UpScale Analytics is also one of the largest platforms in the world for learning SQL by doing.

Popular Courses

Desicion Making with Basic SQL

PL/SQL Programming

Advanced Power BI

Quick Links

Upscale Analytics 2022 © All Rights Reserved