Querying Microsoft SQL Server 2000 with Transact-SQL

PT2845
Summary
SQL is the standard language in use by all major relational database vendors. It is the only command language available for programming and managing the SQL Server. This course provides an introduction to the ANSI Standard SQL used by Microsoft SQL Server. The course provides an introduction to querying relational databases, focusing primarily on the select statement, its syntax, and the use of joins.
Prerequisites
There are no prerequisites for this course.
Duration
2 Days/Lecture & Lab
Audience
This course is intended for programmers, system administrators, and database administrators.
Topics
  • Structured Query Language
  • Subqueries
  • Union combining result sets with SQL union
  • Sorting Rows With Order By Joins
  • Selecting Rows With Where
  • The Select Statement
  • Aggregates Functions
  • Modifying Data With SQL
  • Views
  • Triggers and Stored Procedures
  • Programming Constructs
  • Retrieving Data
  • TSQL Extensions
  • Labs real-world examples

Related Scheduled Courses