Learn Oracle SQL
3.9 (206 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,674 students enrolled

Learn Oracle SQL

Your first step to become an Oracle SQL Developer
3.9 (206 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
8,674 students enrolled
Created by Sam Dhanasekaran
Last updated 10/2017
English
Current price: $12.99 Original price: $19.99 Discount: 35% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 8 articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Write SQL Queries to interact with Oracle Databases
  • Become a Database Developer
  • Develop codes using Oracle SQL
  • Understand the basics of Oracle RDBMS Architecture
  • Progress towards Oracle SQL Certification
  • Understand about Oracle 12c Database
Course content
Expand all 81 lectures 02:41:41
+ Introduction
1 lecture 05:10

This lecture introduces this course to its students

Preview 05:10
+ Installation
3 lectures 17:48

How to download Oracle 12c software from Oracle's Website and install it in you Windows PC or a Windows Laptop.

Preview 12:11

This lecture explains about how to connect to a Oracle Database using SQL Developer. Oracle SQL Developer is a tool provided for Oracle, to interact with Oracle Databases. Oracle SQL Developer tool can be used to develop programs for Oracle Database.

Using SQL Developer
02:11

If you are not able to connect a Oracle Database using Oracle SQL Developer tool, then use this lecture for troubleshooting.

Troubleshooting Connection Issues
03:26
+ Infrastructure Architecture
2 lectures 06:24

The lecture explains about Client Server Architecture. Client Server architecture is a two system architecture where one system serves as a Server or a provider while the other acts as the client or consumer.

Client Server Architecture
02:22

This lecture explains about the various types of clients used to access Oracle Database along with the type of database driver needed such as, ODBC, JDBC, OCI etc.

Different types of Clients
04:02
+ Oracle RDBMS Architecture
7 lectures 18:27

Gives a simplified, high level overview of Oracle RDBMS System

Quick Overview of Oracle RDBMS Architecture
05:18

This lecture explains about connecting to an Oracle Database.

Connecting to an Oracle Database
02:25

Hands-on lab: Connect as SYSDBA

Demo - Connecting as SYSDBA
02:06

This hands-on lecture explains about Stopping an Oracle Database.

DEMO - Stopping an Oracle Database
01:20

Explains about starting an Oracle Database.

DEMO - Starting an Oracle Database
03:18

This lecture explains about a Table.

What is a Table?
01:59

This lecture explains about Data Types

Data Types
02:01
+ SELECT - Basic SELECT Statement
6 lectures 10:16

The lecture explains the basics of a SELECT statement

Basics of a SELECT Statement
02:38

Explains about DESCRIBE command which is used to get the Column level information of a Table.

DESCRIBE Command - DESC
01:43

This lecture explains about how to find the total row count of a Table.

SELECT COUNT - Find the total number of Rows
00:46

Explains about DBA_TABLESPACES

DBA_TABLESPACES
01:01

Learn about Selecting the columns that we want instead of all the columns from a Table.

Selecting Particular Columns
01:46

Explains the basics of a WHERE clause.

WHERE Clause - Basics
02:22
+ DBA Info - Oracle Database User Architecture
4 lectures 08:40

Gain knowledge about how Oracle Users and Schemas work.

Oracle Database User Architecture
05:58

Compares Oracle Schema and Oracle User

Schema Vs User
00:45

Explains the fundamental principles of how objects are stored within a database.

How objects are stored?
01:03

Explains the fundamental principles of accessing objects within a database.

Accessing the Objects
00:54
+ Classification of SQL Commands
5 lectures 05:50

Provides information about SQL Classifications as well as the Commands included in each classification

Classification of SQL Commands
02:53

Explains about Data Manipulation Language

DML - Data Manipulation Language
01:07

Explains about Data Definition Language

DDL - Data Definition Language
01:08

Explains about Data Control Language

DCL - Data Control Language
00:23

Explains about Transaction Control Language

TCL - Transaction Control Language
00:18
+ Creating a Schema
2 lectures 03:52

The students will learn about how to create a user.

Create a User
02:30

Explains about how to create a Table.

Create a Table
01:22
+ DML - Data Manipulation Language
14 lectures 19:12

Explains the basics of DML statements

Basics of DML
01:35

Explains about SELECT statement

DML - SELECT STATEMENT
00:36

Explains about INSERT statement

DML - INSERT STATEMENT
01:39

The INSERT has failed. Why?

LAB - DML - INSERT Fails. Why?
00:20

What is METADATA? - This course explains about it.

DBA Info - METADATA
01:11

Explains about Oracle Database's DATA DICTIONARY

DBA Info - DATA DICTIONARY
00:34

Explains about Default Permanent Tablespace

DBA Info - DEFAULT PERMANENT TABLESPACE
03:11

Fixing the INSERT

DML - Fixing the Failed INSERT
00:28

Demonstrating the fix commands for the failed INSERT statement.

Demonstration of the commands to fix the INSERT
03:31

Explains about UPDATE statement

DML - UPDATE STATEMENT
02:08

Demo about UPDATE statement

Demo of an UPDATE STATEMENT
01:27

Explains about DELETE statement

DML - DELETE STATEMENT
01:08

Demo about DELETE statement

Demo - DELETE STATEMENT
01:09

About MERGE statement

DML - MERGE STATEMENT
00:14
+ TCL - Transaction Control Language
11 lectures 25:14

Explains about TCL

TCL - Basics
01:17

Explains about TCL

Definition of a Transaction
00:26

Explains about a Transaction

What is a Transaction?
03:56

Demo of a Transaction

Demo of a Transaction
02:06

Part 1 of 2: How does Oracle handle a transaction? This lesson explains about REDO Concept.

DBA Info - Internal handling of Transaction through REDO
03:41

Part 2 of 2: How a transaction is being handled? This lesson explains about the use of UNDO.

DBA Info - Internal handling of Transaction through UNDO
03:07

Explains about COMMIT and some of its options as suitable for this beginners course

TCL - COMMIT STATEMENT
01:56

Demonstration of COMMIT commands

TCL - COMMIT Demo
02:54

Explains the ROLLBACK statement

TCL - ROLLBACK STATEMENT
01:38

This lesson explains about SAVEPOINTS. SAVEPOINTS are used saving part of your changes by doing partial rollback instead of full rollback.

TCL - SAVEPOINT STATEMENT
01:59

Demonstration of SAVEPOINTS.

TCL - SAVEPOINT Demo
02:14
Requirements
  • Basic knowledge in using Computers
  • Strong motivation to learn
Description

About This Course:

Welcome to the course, Learn Oracle SQL.

This course introduces Oracle SQL to its students. Anyone who is interested in getting into Oracle SQL Development may use this course to learn Oracle SQL.

This is a free course with considerable amount of video lectures to not only introduce Oracle SQL to you, but also to take you much deeper into Database Development.

The idea is to introduce SQL to you with less hassle. So you may just want to watch the videos, get yourself familiar with the SQL language and advance to another Oracle SQL course created by the same author.

That course is: The Complete Oracle SQL Course For Beginners

About SQL:

SQL is used to interact with Database Systems. As per ANSI (American National Standards Institute), SQL is the standard language for Relational Database Management Systems.

SQL has been the prominent language to interact with various Database Systems for many decades. While many languages that existed two decades ago are extinct now, SQL has always maintained its supremacy in the RDBMS world. Over the time, it has only advanced with new features and standards. And it seems to stay that way for years to come.

About the Instructor:
The instructor of this course, Mr.Sam Dhanasekaran, has more than 20 years of IT experience. It predominantly includes Database Support, IT Support and Recruiting.


Who this course is for:
  • Anyone who wants to learn Oracle SQL Development
  • This SQL course is for beginners who would like to learn about SQL syntax and get into SQL Development. No prior programming knowledge is needed.
  • College Students can take this course to understand SQL and Oracle Database Fundamentals