Structured Query Language (SQL) is the programming language for managing data in relational databases. In this course, we will practice writing SQL queries to retrieve, summarize, modify data, and analyze business data. We will also discuss the theory and logic behind the language and its elements. We will use SQL Server and T-SQL (Microsoft’s SQL dialect) for class exercises, but the material is useful for anyone using other relational database systems (e.g. Oracle, MySQL, Access, MariaDB).
This course is appropriate for anyone responsible for writing queries using SQL.
Performance Objectives: Upon completion of this course you should be able to:
Intended Audience: This course is appropriate for anyone responsible for writing queries using SQL.
Prerequisites: A basic knowledge of relational database structures and terminology.
Other classes you may be interested in: Business Intelligence, SQL Server Reporting Services, and SQL Server Integration Services.