fbpx

Course Statues

Registration Open

Duration

7 Days, 49 Hours

Timing

9:00 AM - 04:00 PM

Availability

Weekdays - Weekends

Course Overview

Transact-SQL is an essential skill-set for data developers and professionals. The primary purpose of this course is to give students a good understanding of the Transact-SQL language, which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course is part of the Microsoft Certificate in Data Science, Big Data and Data Analytics.

Learning Outcome

Upon successful completion of Transact-SQL students will be able to:

  • Describe the basic architecture and concepts of Microsoft SQL Server
  • Write SELECT queries and Query multiple tables
  • Describe the similarities and differences between Transact-SQL and other computer languages
  • 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, table expressions and set operators
  • Use window ranking, offset and aggregate functions
  • Implement pivoting, and grouping sets Execute stored procedures
  • Program with T-SQL
  • Implement error handling and transactions
Prerequisite
  • Must have good knowledge of relational Database or have one year IT industry experience in relational Database.
Course Content
  • Course Content
  • Introduction to Microsoft SQL Server
  • Introduction to T-SQL Querying
  • Writing SELECT Queries
  • Querying Multiple Tables
  • Sorting and Filtering Data
  • Working with SQL Server Data Types
  • Using DML to Modify Data
  • Using Built-In Functions
  • Grouping and Aggregating Data
  • Using Subqueries
  • Using Table Expressions
  • Using Set Operators
  • Using Set Operators
  • Pivoting and Grouping Sets
  • Executing Stored Procedures
  • Executing Stored Procedures
  • Implementing Error Handling
  • Implementing Transactions

Book your course today

Loading...

Enquire Now

Courses you maybe interested