SQL Programming Language
Structured Query Language (SQL) is the language used to manipulate data in relational databases. After studying relational database theory, learn to use SQL to select, update, insert, and delete data from database tables, and get hands-on experience with both Oracle and MySQL. Learn how to select data from multiple tables using joins and unions, understand how to create sub-queries to develop more complex retrieval capabilities, and use DDL to create your own database and populate tables. You also learn about database design, table relationships, and normalization techniques. The course prepares you to work with any relational database such as Oracle, DB2, SQL, Server, or MySQL.
40 hours / Prerequisite: Database Design and Development