Professional Development Center
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
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