Oracle SQL Proficiency

This course is part of Oracle SQL Databases Specialization

Instructor: Rafiq Wayani

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

4 assignments

Taught in English

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

Learn more about Coursera for Business

Build your subject-matter expertise

This course is part of the Oracle SQL Databases Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

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.

What's included

6 videos4 readings1 assignment

6 videosTotal 20 minutes

SQL Command Categories3 minutesPreview module
Select Statement3 minutes
Insert Command4 minutes
Update Command2 minutes
Delete Command4 minutes
DDL Statements Demonstration3 minutes

4 readingsTotal 60 minutes

Writing Select Statements15 minutes
Insert Statement15 minutes
Update Statement15 minutes
Power behind the DELETE Statement15 minutes

1 assignmentTotal 30 minutes

Module 1 Quiz30 minutes

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.

What's included

6 videos2 readings1 assignment

6 videosTotal 26 minutes

Create & Alter DDL Demo Part 1 of 24 minutesPreview module
Create & Alter DDL Demo Part 2 of 23 minutes
Alter DDL Command Explained Part 1 of 23 minutes
Alter DDL Command Explained Part 2 of 23 minutes
Alter DDL Command Demonstration4 minutes
Update DML Command Demonstration5 minutes

2 readingsTotal 30 minutes

Create DDL Statement15 minutes
Alter Table Statement15 minutes

1 assignmentTotal 30 minutes

Module 2 Quiz30 minutes

In this module, we are going to explore the relationships between tables and how they are linked using primary and foreign keys.

What's included

3 videos1 reading1 assignment

In this module, we'll explore database views, their benefits, and how they are used. We'll also take a look at SQL functions.

What's included

5 videos2 readings1 assignment

Instructor

Instructor ratings

4.6 (36 ratings)

Rafiq Wayani

LearnQuest

6 Courses37,122 learners

Offered by

LearnQuest

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.5

130 reviews

5 stars
68.93%
4 stars
23.48%
3 stars
3.03%
2 stars
1.51%
1 star
3.03%

Showing 3 of 130

Reviewed on Nov 25, 2021

One of the best courses among all the other three. This is very helpful in learning and implementing SQL queries, and performing CRUD operations on a database.

Reviewed on Aug 19, 2023

Very impressive course. I am learning a lot from here. Thanks

Reviewed on Feb 26, 2023

This course is perfect for beginners and intermediate individuals to learn about databases.

View more reviews