SQL II

SQL II

Course Description:

Structured Query Language (SQL) is a standard programming language. In this hands-on class you will be provided with advanced features and clauses of the SELECT statement. This course focuses on SQL used by more than 100 databases, languages and software applications. Key topics covered: inner, left outer, right outer, natural, cross and self joins; correlated sub queries and writing SQL to generate SQL.

Real-World Application:

This course is designed for persons who work in any relational database environment, including Oracle, SQL Server, Access, and many others.

Course Objectives:

Upon successful completion of the course, you will be able to:

  • Write SQL Select statements, including correlated subqueries, inner joins, natural joins, cross joins, outer joins, self joins
  • Write SQL Select statements to create SQL

Course Content:

  • Select Statements
    • Basic Join and SubQuery
  • Select Statements
    • Inner Join, Natural Join and Cross Join
  • Select Statements
    • Correlated Subquery
  • Select Statements
    • Outer Join
  • Select Statements
    • Self Join
  • Select Statements
    • SQL generating SQL

Schedule:

Fall 2024
Spring 2025

Dates: November 18-21, 2024

Time: 9:00 am- 12:00 pm

Location: Cleveland State University, Monte Ahuja College of Business, 1860 E. 18th. St. BU 16, Cleveland, OH 44115

Cost: $650

CEUs: 1.2

 

Dates: April 14-17, 2025

Time: 9:00 am- 12:00 pm

Location: Cleveland State University, Monte Ahuja College of Business, 1860 E. 18th. St. BU 16, Cleveland, OH 44115

Cost: $650

CEUs: 1.2

Enroll Today

Enroll Today

 

Mailing Address
Cleveland State University
Monte Ahuja College of Business
2121 Euclid Avenue, BU 308
Cleveland, OH 44115-2214

Campus Location
Monte Ahuja Hall, BU 308
1860 E. 18th Street
Cleveland, OH 44114
Phone: 216-687-6957
prodev.business@csuohio.edu