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.
 
Continuing Education Units (CEU) : 2

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