- Introduction to the course
- Why SQL?
- Table Design (Part 1 of 2)
- Table Design (Part 2 of 2)
- Schema Building Exercise
- Home
- LearnQuest
- Courses
- Oracle SQL Exam Prep
Beginner
Online
2 Weeks
Free
Quick facts
particular | details | |
---|---|---|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Type of course
certificate availability
certificate providing authority
certificate fees
The syllabus
Week 1: SQL and Table Design
Videos
Readings
- Activity: Creating a Schema
- Reading: Schemas
Practice Exercise
- Module 1 Quiz
Week 1: SQL Database Terms
Videos
- Database Terms (Part 1 of 6)
- Database Terms (Part 2 of 6)
- Database Terms (Part 3 of 6)
- Database Terms (Part 4 of 6)
- Database Terms (Part 5 of 6)
- Database Terms (Part 6 of 6)
Readings
- SQL Database Terms
- More Database Terms to Know
Practice Exercise
- Module 2 Quiz
Week 2: Key Constraints and the USING Clause
Videos
- Primary Key Constraint (Part 1 of 2)
- Primary Key Constraint (Part 2 of 2)
- Foreign Key Constraint
- Foreign Key Constraint and the Using Clause
Readings
- Primary Key Constraints
- Foreign Keys and the USING Clause
Practice Exercise
- Module 3 Quiz
Week 2: Functions, Subqueries, Pseudocolumns, and Views
Videos
- Using SQL Functions within Queries
- Subqueries
- More on Subqueries and Pseudocolumns
- Views
- Materialized Views
Readings
- Subqueries Further Explained
- View versus Materialized View
Practice Exercise
- Module 4 Quiz
Week 2: Practice Certification Quiz
Practice Exercise
- Practice SQL Certification Exam
Articles
Popular Articles
Latest Articles
Similar Courses
My SQL Basics
Great Learning
Introduction to Structured Query Language
Davidson College, Davidson via Edx
Courses of your interest
An Introduction To Coding Theory
IIT Kanpur via Swayam
C++ Foundation
PW Skills
Data Science Foundations to Core Bootcamp
Springboard
User Experience Design And Research
UM–Ann Arbor via Futurelearn
Data Analysis with Excel for Complete Beginners
CloudSwyft Global Systems, Inc via Futurelearn
Artificial intelligence Design and Engineering wit...
CloudSwyft Global Systems, Inc via Futurelearn
Data Science Fundamentals on Microsoft Azure
CloudSwyft Global Systems, Inc via Futurelearn
Artificial Intelligence Projects
Great Learning
More Courses by LearnQuest
LCFA Exam Preparation
LearnQuest via Coursera
LCFA Practice
LearnQuest via Coursera
CompTIA Exam Prep
LearnQuest via Coursera
Scrum Master Certification Practice
LearnQuest via Coursera
CompTIA Practice
LearnQuest via Coursera
Scrum Master Certification Exam Preparation
LearnQuest via Coursera
Cloud Computing Basics
LearnQuest via Coursera
Mastering Final Cut Pro
LearnQuest via Coursera
Artificial Intelligence Algorithms Models and Limi...
LearnQuest via Coursera
Introduction to Object-Oriented Programming with J...
LearnQuest via Coursera