SQL Programming Language
Structured Query Language (SQL) is the language used to manipulate data in relational databases. Learn to use SQL to select, update, insert, and delete data from database tables, and acquire hands-on experience with both Oracle and MySQL. Learn how to select data from multiple tables using both inner and outer joins and unions, understand how to create subqueries to develop more complex retrieval capabilities, and use DDL to create your own database and to populate tables. In addition, learn about database design, primary keys, foreign keys, indexes, table relationships, referential integrity, and normalization/denormalization techniques. This course prepares you to work with any relational database, such as Oracle, DB2, SQL Server, Sybase, or MySQL.
You'll Walk Away with
- Knowledge of SQL code based on ANSI/ISO standards to build Microsoft SQL Server or Oracle database structures
- The ability to update database content with SQL and transaction handling
- The skills necessary to retrieve data with filter conditions and from multiple tables using various types of join
Ideal for
- Those unfamiliar with SQL syntax
- Students looking for a quick refresher on SQL and important database concepts
1 section
-
Spring 2025
-
Section
001 -
Semester
Spring 2025 -
Date
Feb 25 - Apr 29 -
Day
Tuesday -
Time
6:30PM-9:30PM -
Sessions
10 -
Faculty
Sultan, Samuel -
Location
Instructor Led
-
-
-
Section
2 -
Semester
Fall 2024 -
Date
Sep 19 - Nov 21 -
Day
Thursday -
Time
6:30PM-9:30PM -
Sessions
10 -
Faculty
Sultan, Samuel -
Location
Instructor Led
Tuition $960 -