Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Learn Oracle SQL

Name: Learn Oracle SQL
Rating: 4.1 (222 reviews)

Your first step to become an Oracle SQL Developer

Created bySam Dhanasekaran

Last updated 10/2017

English

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

14 sections • 81 lectures • 2h 41m total length

Introduction5:10
This lecture introduces this course to its students

Installing Oracle 12c in Windows 1012:11
How to download Oracle 12c software from Oracle's Website and install it in you Windows PC or a Windows Laptop.
Using SQL Developer2: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.
Troubleshooting Connection Issues3:26
If you are not able to connect a Oracle Database using Oracle SQL Developer tool, then use this lecture for troubleshooting.

Client Server Architecture2:22
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.
Different types of Clients4:02
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.

Quick Overview of Oracle RDBMS Architecture5:18
Gives a simplified, high level overview of Oracle RDBMS System
Connecting to an Oracle Database2:25
This lecture explains about connecting to an Oracle Database.
Demo - Connecting as SYSDBA2:06
Hands-on lab: Connect as SYSDBA
DEMO - Stopping an Oracle Database1:20
This hands-on lecture explains about Stopping an Oracle Database.
DEMO - Starting an Oracle Database3:18
Explains about starting an Oracle Database.
What is a Table?1:59
This lecture explains about a Table.
Data Types2:01
This lecture explains about Data Types

Basics of a SELECT Statement2:38
The lecture explains the basics of a SELECT statement
DESCRIBE Command - DESC1:43
Explains about DESCRIBE command which is used to get the Column level information of a Table.
SELECT COUNT - Find the total number of Rows0:46
This lecture explains about how to find the total row count of a Table.
DBA_TABLESPACES1:01
Explains about DBA_TABLESPACES
Selecting Particular Columns1:46
Learn about Selecting the columns that we want instead of all the columns from a Table.
WHERE Clause - Basics2:22
Explains the basics of a WHERE clause.

Classification of SQL Commands2:53
Provides information about SQL Classifications as well as the Commands included in each classification
DML - Data Manipulation Language1:07
Explains about Data Manipulation Language
DDL - Data Definition Language1:08
Explains about Data Definition Language
DCL - Data Control Language0:23
Explains about Data Control Language
TCL - Transaction Control Language0:18
Explains about Transaction Control Language

Basics of DML1:35
Explains the basics of DML statements
DML - SELECT STATEMENT0:36
Explains about SELECT statement
DML - INSERT STATEMENT1:39
Explains about INSERT statement
LAB - DML - INSERT Fails. Why?0:20
The INSERT has failed. Why?
DBA Info - METADATA1:11
What is METADATA? - This course explains about it.
DBA Info - DATA DICTIONARY0:34
Explains about Oracle Database's DATA DICTIONARY
DBA Info - DEFAULT PERMANENT TABLESPACE3:11
Explains about Default Permanent Tablespace
DML - Fixing the Failed INSERT0:28
Fixing the INSERT
Demonstration of the commands to fix the INSERT3:31
Demonstrating the fix commands for the failed INSERT statement.
DML - UPDATE STATEMENT2:08
Explains about UPDATE statement
Demo of an UPDATE STATEMENT1:27
Demo about UPDATE statement
DML - DELETE STATEMENT1:08
Explains about DELETE statement
Demo - DELETE STATEMENT1:09
Demo about DELETE statement
DML - MERGE STATEMENT0:14
About MERGE statement

TCL - Basics1:17
Explains about TCL
Definition of a Transaction0:26
Explains about TCL
What is a Transaction?3:56
Explains about a Transaction
Demo of a Transaction2:06
Demo of a Transaction
DBA Info - Internal handling of Transaction through REDO3:41
Part 1 of 2: How does Oracle handle a transaction? This lesson explains about REDO Concept.
DBA Info - Internal handling of Transaction through UNDO3:07
Part 2 of 2: How a transaction is being handled? This lesson explains about the use of UNDO.
TCL - COMMIT STATEMENT1:56
Explains about COMMIT and some of its options as suitable for this beginners course
TCL - COMMIT Demo2:54
Demonstration of COMMIT commands
TCL - ROLLBACK STATEMENT1:38
Explains the ROLLBACK statement
TCL - SAVEPOINT STATEMENT1:59
This lesson explains about SAVEPOINTS. SAVEPOINTS are used saving part of your changes by doing partial rollback instead of full rollback.
TCL - SAVEPOINT Demo2:14
Demonstration of SAVEPOINTS.

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

Learn Oracle SQL

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 5min

Installation3 lectures • 18min

Infrastructure Architecture2 lectures • 6min

Oracle RDBMS Architecture7 lectures • 18min

SELECT - Basic SELECT Statement6 lectures • 10min

DBA Info - Oracle Database User Architecture4 lectures • 9min

Classification of SQL Commands5 lectures • 6min

Creating a Schema2 lectures • 4min

DML - Data Manipulation Language14 lectures • 19min

TCL - Transaction Control Language11 lectures • 25min

Requirements

Description

Who this course is for: