SQL Review-Introduction To SQL Practice Course
SQL Practice Course Intro
()
Entity Relationship Diagram
()
Types of SQL Statements
ERD: Developing a Data Model
SQL Review-Installing SQL Plus
Install Oracle Tutorial
Installing Oracle
()
Installing Oracle SQL Developer
Installing Oracle SQL Developer
()
Data Definition Language (DDL) and Data Manipulation Language (DML)-Building A Database Table Structure
Using The Create Table Statement
()
Extending The Create Table Statement
()
Creating Database Tables In Oracle
Using SQLPlus with an Editor
()
Using the Alter Table Statement
()
Closer Look at the Alter Table statement
Data Definition Language (DDL) and Data Manipulation Language (DML)-Using DML Statements
Practice DML Statements in SQLPlus
()
Comprehensive Knowledge about DML Statements
Practice Writing SQL Code-Practice SQL Code
Exercise 1: Create and Populate Tables
Exercise 2: Modify, Drop, and Update Tables