SQL Query Language

Course Objectives

On completion of this 2 Day SQL Query Language training course, delegates should be able to: 

• Describe the uses of and ways to execute the SQL language.

• Use querying tools.

• Write SELECT queries to retrieve data.

• Group and summarize data by using SQL.

• Join data from multiple tables.

• Modify data in tables.

• Query text fields with full-text search.

• Describe how to create programming objects.

Intended Audience

This SQL training course is intended for:

• SQL Server database administrators

• SQL Server implementers

• SQL Server system engineers

• SQL Server developers

Course Prequisities

Before attending this course, delegates are expected to have:

• Experience using a Microsoft Windows operating system.

An understanding of basic relational database concepts, including:

• Logical and physical database design

• Data integrity concepts

• Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many)

• How data is stored in tables (rows and columns).