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
-
Summer 2024
-
Section
001 -
Semester
Summer 2024 -
Date
Jun 3 - Aug 5 -
Day
Monday -
Time
6:30PM-9:30PM -
Sessions
10 -
Faculty
Sultan, Samuel -
Location
Instructor Led
-
-
-
Section
2 -
Semester
Spring 2024 -
Date
Jan 29 - Apr 1 -
Day
Monday -
Time
6:30PM-9:30PM -
Sessions
10 -
Faculty
Sultan, Samuel -
Location
Instructor Led
Tuition $960 -