|SQL Structured Query Language Level 1 Structured Query Language
(SQL) is the programming language for managing data in
relational databases. In this course, you will practice writing
your own SQL queries to retrieve, summarize and even modify
data, and answer questions concerning your agency’s business
information. You 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,
such as Oracle, MySQL or Access. This course is appropriate for
anyone responsible for writing queries using SQL. At the end of
this course you should be able to: A basic knowledge of
relational database structures and terminology. - • Retrieve
data using SELECT statement and WHERE, GROUP BY, HAVING, ORDER
BY, and TOP clauses - Handle null values - Join multiple tables
using cross, inner, and outer joins - Work with self-contained,
correlated and aggregate sub q