Monthly Subscription Starting at AED 99 + VAT

Oracle SQL Practice Course
  • Level Professional
  • Duration 7 hours
  • Course by LearnQuest
  • Offered by

About

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.

Modules

Introduction To SQL Practice Course

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • SQL Practice Course Intro
  • Entity Relationship Diagram

2 Readings

  • Types of SQL Statements
  • ERD: Developing a Data Model

Installing SQL Plus

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • Installing Oracle
  • Installing Oracle SQL Developer

2 Readings

  • Install Oracle Tutorial
  • Installing Oracle SQL Developer

Module 1 Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Module 1 Quiz

Building A Database Table Structure

    • 4 Videos
    • 2 Readings
Show info about module content

4 Videos

  • Using The Create Table Statement
  • Extending The Create Table Statement
  • Using SQLPlus with an Editor
  • Using the Alter Table Statement

2 Readings

  • Creating Database Tables In Oracle
  • Closer Look at the Alter Table statement

Using DML Statements

    • 1 Videos
    • 1 Readings
Show info about module content

1 Videos

  • Practice DML Statements in SQLPlus

1 Readings

  • Comprehensive Knowledge about DML Statements

Module 2 Review

    • 1 Assignment
Show info about module content

1 Assignment

  • Module 2 Quiz

Practice SQL Code

    • 2 Readings
    • 2 Discussion
Show info about module content

2 Discussions

  • Discussion Prompt: DDL Statements
  • Discussion Prompt: DML Statements

2 Readings

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

Auto Summary

Discover the Oracle SQL Practice Course, an essential learning experience for aspiring SQL professionals and beginners in the IT and Computer Science domain. This professionally curated course by Coursera offers a thorough review of SQL statements, focusing on foundational skills such as creating tables, adding columns, and modifying tables using alter statements. Engage in hands-on practice with Data Definition Language (DDL) and Data Manipulation Language (DML) statements through comprehensive exercises designed to solidify your understanding. With a total duration of 420 minutes, this course provides a substantial yet manageable commitment to advancing your SQL proficiency. Flexible subscription options, including Starter and Professional plans, cater to different learning needs and budgets. Ideal for beginners looking to build a strong SQL foundation, this course will equip you with the practical skills needed to excel in database management and manipulation. Enroll today to start your journey toward becoming an SQL expert.

Rafiq Wayani
Instructor

Rafiq Wayani