This course is designed for SQL beginners to review SQL statements, including creating tables, adding columns, and modifying tables. We'll look at using alter statements and learners will practice using DDL and DML statements completing exercises.
Overview
Syllabus
- SQL Review
- In this module, first, we will discuss what you will learn in this practice course. Then, we'll review types of SQL statements and take a look at developing a Data Model. We'll also walk through how to install SQL Plus and Oracle SQL Developer so you can follow along with some of our activities.
- Data Definition Language (DDL) and Data Manipulation Language (DML)
- In this module, we will review creating tables and adding columns to them as well as some best practices. We will also review using alter statements to modify our database. Lastly, we'll look at DML statements.
- Practice Writing SQL Code
- In this module, we'll put you to the test. You'll be able to create tables and modify them to test what you've learned to this point. Use SQLPlus if you installed it on you own machine, or go to https://livesql.oracle.com/ if you need an online way to test your code.
Taught by
Rafiq Wayani
