This course is designed to help you continue learning about Oracle SQL and database management. We will look more closely at the Create, Alter, and Update commands, explore database relationships, and demonstrate how to use database views and SQL functions. It is recommended that you complete the first three courses of this specialization prior to this one.
Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.
Course 4 of 4 in the Oracle SQL Databases Specialization.
Syllabus
WEEK 1
Review SQL
In this module, we'll take a look at the three SQL Command Categories, and review the insert, update, and delete commands as well as the select statement.
Create And Alter Commands
In this module, we are going to take a closer look at the create, alter, and update commands, as well as demonstrate many ways they can be used.
WEEK 2
Database Relationships
In this module, we are going to explore the relationships between tables and how they are linked using primary and foreign keys.
Views and Functions
In this module, we'll explore database views, their benefits, and how they are used. We'll also take a look at SQL functions.
