Introduction To Querying Data With Transact-SQL

PT26995
Training Summary
SQL is an acronym for Structured Query Language. SQL is used to communicate with relational databases. SQL statements are used to perform tasks such as update data in a database or retrieve data from a database. This course is design to introduced learners of all ages how to work and create solutions using DBMS Database Management Systems and the essentials of working with Transact-SQL.
Prerequisites
Before taking this course, students should have knowledge of writing T-SQL queries, and working knowledge of relational databases.
Duration
5 Days/Lecture & Lab
Audience
This course is design to introduced learners of all ages how to work and create solutions using DBMS Database Management Systems and the essentials of working with Transact-SQL.
Course Topics
  • Understanding SQL Server Technologies
  • Understanding Query Writing With T-SQL
  • Writing Queries Using T-SQL Statements
  • Introduction To Joins
  • Introduction T-SQL Clauses
  • Introduction To Subqueries
  • Understanding T-SQL Commands
  • Using Built-In Functions
  • Introduction To Groups and Aggregates
  • Using Subqueries
  • Introduction To Expressions and Operators
  • Introduction To Database Programming
  • Implementing Transactions

Related Scheduled Courses