Oracle SQL Practice Course

BY
LearnQuest via Coursera

Lavel

Intermediate

Mode

Online

Duration

3 Weeks

Fees

Free

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based
Learning efforts 2 Hours Per Week

Course and certificate fees

Type of course

Free

certificate availability

Yes

certificate providing authority

Coursera

certificate fees

₹2,436

The syllabus

Week 1: SQL Review

Videos
  • SQL Practice Course Intro
  • Entity Relationship Diagram
  • Installing Oracle
  • Installing Oracle SQL Developer
Readings
  • Types of SQL Statements
  • ERD: Developing a Data Model 
  • Install Oracle Tutorial
  • Installing Oracle SQL Developer
Practice exercise
  • Module 1 Quiz  

Week 1: Data Definition Language (DDL) and Data Manipulation Language (DML)

Videos
  • Using The Create Table Statement
  • Extending The Create Table Statement
  • Using SQLPlus with an Editor
  • Using the Alter Table Statement
  • Practice DML Statements in SQLPlus
Readings
  • Creating Database Tables In Oracle
  • Closer Look at the Alter Table statement
  • Comprehensive Knowledge about DML Statements
Practice exercise
  • Module 2 Quiz

Week 2: Practice Writing SQL Code

Readings
  • Exercise 1: Create and Populate Tables
  • Exercise 2: Modify, Drop, and Update Tables

Articles

Popular Articles

Latest Articles

Similar Courses

Amazon DynamoDB Building NoSQL Database Driven App...

Amazon Web Services via Edx

4 Weeks Online
Intermediate
Free

Relational Database Administration

IBM via Coursera

Online
Intermediate

Building Batch Data Pipelines on GCP

Google via Coursera

6 Weeks Online
Intermediate

Enterprise Database Migration

Google via Coursera

3 Weeks Online
Intermediate

Advanced Database Queries

NYU via Edx

5 Weeks Online
Intermediate
Free

Database Systems Concepts and Design

Georgia Tech via Udacity

16 Weeks Online
Intermediate
Free

Database Management Essentials

CU Denver via Coursera

12 Weeks Online
Intermediate

Courses of your Interest

Salesforce Administrator and App Builder

Salesforce Administrator and App Builder

SkillUp Online via Simplilearn

16 Hours Online
Intermediate
Free
Introduction to Medical Software

Introduction to Medical Software

Yale University, New Haven via Coursera

3 Weeks Online
Intermediate
Free

Google Cloud Architect Program

Google Cloud via SkillUp Online

11 Weeks Online
Intermediate
₹ 54,999

Google Cloud Architect Program

Google via SkillUp Online

11 Weeks Online
Intermediate
₹ 54,999
Information Security Design and Development

Information Security Design and Development

Coventry University, Coventry via Futurelearn

10 Weeks Online
Intermediate
Ethics Laws and Implementing an AI Solution on Mic...

Ethics Laws and Implementing an AI Solution on Mic...

CloudSwyft Global Systems, Inc via Futurelearn

14 Weeks Online
Intermediate
Network Security and Defence

Network Security and Defence

Coventry University, Coventry via Futurelearn

10 Weeks Online
Intermediate

Cyber Security Foundations Start Building Your Car...

EC-Council via Futurelearn

15 Weeks Online
Intermediate
Applied Data Analysis

Applied Data Analysis

CloudSwyft Global Systems, Inc via Futurelearn

14 Weeks Online
Intermediate
₹ 900

More Courses by LearnQuest

Artificial Intelligence Ethics in Action

LearnQuest via Coursera

Online
Intermediate

Data Processing with Azure

LearnQuest via Coursera

3 Weeks Online
Intermediate
Free

Test Driven Development Overview

LearnQuest via Coursera

3 Weeks Online
Intermediate

Integrating Test Driven Development into your Work...

LearnQuest via Coursera

3 Weeks Online
Intermediate

Writing Java Application Code

LearnQuest via Coursera

3 Hours Online
Intermediate

Java Class Library

LearnQuest via Coursera

3 Weeks Online
Intermediate

Object-Oriented Hierarchies in Java

LearnQuest via Coursera

3 Weeks Online
Intermediate

Fundamentals of Kubernetes Deployment

LearnQuest via Coursera

3 Weeks Online
Intermediate
Free

Introduction to iOS App Development with Swift 5

LearnQuest via Coursera

3 Weeks Online
Intermediate

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books