Gianna Finz
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.