Sign In  |  View Cart  |    |  Help  |  
 
Course Catalog
Print Course information
E-mail to a friend
Return to Course Catalog

Courses and Programs > Computers > Databases

SQL Structured Query Language Level 1   

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.

At the end of this course, you should be able to:

  • Retrieve data using SELECT statement
  • Use 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 queries
  • Use set operations such as UNION, INTERSECT, and EXCEPT
  • Modify data with the INSERT, DELETE and UPDATE statements
  • Use math related and other functions like SUM, AVG, GETDATE()

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.

 

SQL Structured Query Language Level 1

Item: 36394 James Parshall
8:00 AM - 4:30 PM SOONL
Sessions: 2 Th F Location: Online
,
1/25/2024 - 1/26/2024 Fee: $595.00

Number of Sessions: 2 Online - ThFr 8:00AM - 4:30PM

Refund Policy: Cancellations must be received five business days prior to the first day of class in order to receive a full refund.

 

SQL Structured Query Language Level 1

Item: 39324 Bernie Benson
8:00 AM - 4:30 PM SOL01
Sessions: 2 Tu W Location: L01-170
,
2/20/2024 - 2/21/2024 Fee: $595.00

Number of Sessions: 2 L01-170 - TuWe 8:00AM - 4:30PM

Refund Policy: Cancellations must be received five business days prior to the first day of class in order to receive a full refund.

 

SQL Structured Query Language Level 1

Item: 43497 Bernie Benson
12:00 AM - 12:00 AM SOL01
Sessions: 2 Th F Location: L01-170
,
3/28/2024 - 3/29/2024 Fee: $595.00

Number of Sessions: 2 L01-170 - ThFr 12:00AM - 12:00AM

Refund Policy: Cancellations must be received five business days prior to the first day of class in order to receive a full refund.

 

Some Title