Oracle SQL Practice Course

Instructor: LearnQuest Network

Access provided by L&T Corp - ATLNext

3,519 already enrolled

3 modules

Gain insight into a topic and learn the fundamentals.

31 reviews

Intermediate level

Some related experience required

7 hours to complete

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

31 reviews

Intermediate level

Some related experience required

7 hours to complete

Flexible schedule

Learn at your own pace

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

2 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 3 modules in this course

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.

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.

What's included

4 videos4 readings1 assignment

4 videos Total 15 minutes

SQL Practice Course Intro 2 minutes
Entity Relationship Diagram 5 minutes
Installing Oracle 5 minutes
Installing Oracle SQL Developer 4 minutes

4 readings Total 90 minutes

Types of SQL Statements 20 minutes
ERD: Developing a Data Model 30 minutes
Install Oracle Tutorial 30 minutes
Installing Oracle SQL Developer 10 minutes

1 assignment Total 30 minutes

Module 1 Quiz 30 minutes

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.

What's included

5 videos3 readings1 assignment

5 videos Total 28 minutes

Using The Create Table Statement 5 minutes
Extending The Create Table Statement 4 minutes
Using SQLPlus with an Editor 5 minutes
Using the Alter Table Statement 6 minutes
Practice DML Statements in SQLPlus 8 minutes

3 readings Total 60 minutes

Creating Database Tables In Oracle 20 minutes
Closer Look at the Alter Table statement 20 minutes
Comprehensive Knowledge about DML Statements 20 minutes

1 assignment Total 30 minutes

Module 2 Quiz 30 minutes

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.