The Complete Oracle SQL Course For Beginners
4.7 (97 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,047 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Complete Oracle SQL Course For Beginners to your Wishlist.

Add to Wishlist

The Complete Oracle SQL Course For Beginners

Learn Oracle SQL: From Beginner to An Oracle Certified Associate - Helpful for Oracle Exam 1Z0-071
4.7 (97 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,047 students enrolled
Created by Sam Dhanasekaran
Last updated 12/2016
English
English, ...
  • English
  • English
Price: $125
30-Day Money-Back Guarantee
Includes:
  • 7 hours on-demand video
  • 54 Articles
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Do database development
  • Develop codes using Oracle SQL
  • Understand the fundamentals of SQL (Structured Query Language)
  • Understand the basics of Oracle RDBMS Architecture
  • Learn the basics of Oracle RDBMS Architecture
  • Can gain considerable SQL knowledge to apply for a beginner level, SQL Developer or Database Developer Job
  • Understand about Oracle 12c Database
  • Take steps towards becoming an Oracle SQL Developer
  • Take steps towards becoming an Oracle DBA
  • Progress towards Oracle SQL Certification
View Curriculum
Requirements
  • Basic computer skills
  • Strong motivation to learn
  • Download and install Oracle 12c in Windows 10 as explained in one of the lectures
  • Use Oracle SQL Developer in Windows 10 as explained in the lectures
Description

Quick Info:

  • Course Launched on: 19-May-2016
  • Last update review: 03/30/2017
  • More than 220 Lectures
  • Very Comprehensive with extra lectures on Database Administration
  • May help in obtaining Oracle Database 12c SQL Certification.
  • With FULL Subtitles for all the video lessons

About This Course:

Welcome to the course, The Complete Oracle SQL Course For Beginners.

This course introduces SQL, which is an acronym for 'Structured Query Language', to its students. This is based on Oracle's SQL implementation for Oracle Databases. The lessons are based on Oracle 12c Database and SQL Developer Tools running in Windows 10.

This course may help you in taking a step towards..

  • in becoming an 'Oracle SQL Developer'
  • in achieving 'Oracle SQL Certification'

About the Name of this Course:

When I started out to create this course, I wanted to create a Beginner Level Oracle SQL course. So I named it as 'SQL Development for Beginners'.

However as I progressed, I decided to make it much more comprehensive and cover most of the topics in the curriculum of Oracle SQL exam 1Z0-071. And so I renamed it to, 'Oracle SQL: Oracle Database 12c SQL Certified Associate'.

So, this course starts with Beginner Level lessons and progresses into next levels.

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 Oracle Database:

Oracle Database is one of the prominent Database Systems in the RDBMS (Relational Database Management Systems) segment. Some of the other prominent Database Systems are

  • Microsoft SQL Server
  • MySQL
  • Sybase ASE.
They also use SQL to interact with their Database Systems. While there are subtle differences between each of their SQL implementations, a SQL as a whole, is generally very standard. So a person with SQL knowledge in one platform such as Oracle, may find it easier to learn and code for other Database Systems such as Microsoft SQL or MySQL. 
The point is, once you learn SQL, then your reach into the job market is very wide.

About the Curriculum:
  • The curriculum has been carefully designed to introduce the Oracle RDBMS environment first.
  • Then it moves on to various types of SQL Statements such as DDL, DML and TCL.
  • And next, it goes to the depths of various SQL Statements, Conditions, Sorting, Functions, Grouping etc..
  • It also gives Database Administration tips, as needed.
  • It is also covers most of the topics from the Oracle SQL Certification Exam 1Z0-071

Oracle Certification:
  • Oracle awards certain certifications that are recognized globally
  • One such certification is Oracle Database 12c SQL Certified Associate
  • The exam for that certification is (currently as of May 2016), 1Z0-071.
  • The topics in this course covers most of the topics for that exam.

Oracle Certification - Declarations
  •  While this course covers most of the topics for that exam, this course is not a sole material for that exam. Additional materials such as Oracle's recommended Books may be needed.
  • This course is NOT an official course from Oracle Corporation.
  • This course has been developed individually by its author.

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.

About Previews:
More lessons have been opened for public previews than the required amount. Please take your time to go through all of them. This will give you an idea about the instructor's presentation style, technical knowledge etc.

Subtitles/Closed Captions:
All the video based lectures contain subtitles or closed-captions. You would be able to enable them if needed.
Who is the target audience?
  • 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.
  • This is probably not for you if you are looking for advanced and complex queries
  • This course covers most of the topics for the Oracle SQL Certification exam, 1Z0-071. So this course can also be helpful, along with Oracle's recommended study materials, if you are planning to get Oracle's SQL Certification such as “Oracle Database 12c SQL Certified Associate”
  • College Students can take this course to understand SQL and Oracle Database Fundamentals
Students Who Viewed This Course Also Viewed
Curriculum For This Course
222 Lectures
07:25:50
+
Introduction
1 Lecture 02:42

Welcome to Oracle SQL development course for Beginners. This video introduces this course to the students by briefly explaining about SQL. It also explains that this course will teach you SQL Development with faster performance being an important goal.

Preview 02:42
+
PART I - SQL DEVELOPMENT FOR BEGINNERS
1 Lecture 00:33

PART I begins here.

Preview 00:33
+
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

Questions about Oracle Installation

Self Test - Oracle Installation
3 questions

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.

Preview 02:11

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

Preview 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.

Preview 04:02
+
Oracle RDBMS Architecture
1 Lecture 05:18

Gives a simplified, high level overview of Oracle RDBMS System

Preview 05:18
+
Connecting to an Oracle Database
3 Lectures 04:39

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

LAB - Hands on with connecting as SYSDBA

LAB - Connecting as SYSDBA
00:08
+
Stopping and Starting an Oracle Database
4 Lectures 05:20

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

DEMO - Stopping an Oracle Database
01:20

LAB - Hands on with Stopping an Oracle Database

LAB - Stopping an Oracle Database
00:14

Explains about starting an Oracle Database.

DEMO - Starting an Oracle Database
03:18

Hands on with Starting an Oracle Database

LAB - Starting an Oracle Database
00:27
+
Table
2 Lectures 04:01

This lecture explains about a Table.

What is a Table?
02:00

This lecture explains about Data Types

Data Types
02:01
+
SELECT - Basic SELECT Statement
5 Lectures 05:12

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

LAB work on DESCRIBE Command

LAB - DESCRIBE or DESC Command
00:01

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

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

LAB for SELECT COUNT syntax

LAB - SELECT COUNT
00:04
+
DBA Info - DBA_TABLESPACES
2 Lectures 01:11

Explains about DBA_TABLESPACES

DBA_TABLESPACES
01:01

SELECT and understand the data from DBA_TABLESPACES

LAB - DBA_TABLESPACES
00:10
35 More Sections
About the Instructor
Sam Dhanasekaran
4.4 Average rating
584 Reviews
5,512 Students
5 Courses
Experienced IT Support and Database Specialist

Around 20 years of IT and Database Support experience.


* Expert in Systems Administration, Database Administration, Systems Integration, IT Operations Mgmt, Business Management, IT Consulting and Business Development.

* Hobbies include Social Networking, Music Composition, Reading and Writing.

Specialties:IT Support, Client Support, Client Management, Database Support. Infrastructure Management, Project Management, Business Development, IT Solutions Management, Team Management and Customer Care.