Oracle SQL: Oracle Database 12c SQL Certified Associate

Complete SQL Guide: From Beginner to An Oracle Certified Associate - Helpful for Oracle Exam 1Z0-071
4.2 (57 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.
799 students enrolled
$19
$200
90% off
Take This Course
  • Lectures 222
  • Length 7.5 hours
  • Skill Level All Levels
  • Languages English, captions
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2016 English Closed captions available

Course Description

Quick Info:

  • Course Launched on: 19-May-2016
  • 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, 'Oracle SQL: Oracle Database 12c SQL Certified Associate'.

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.

What are the 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

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:42

Welcome to SQL development for Absolute 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.

Section 2: PART I - SQL DEVELOPMENT FOR BEGINNERS
Article

PART I begins here.

Section 3: Installation
12:11

Download Oracle 12c software from Oracle's Website and install it in a Windows 10 PC/Laptop.

3 questions

Questions about Oracle Installation

02:11

Connect to the Oracle Database using SQL Developer

03:26

In case you are unable to connect to the database, use this lecture for troubleshooting.

Section 4: Infrastructure Architecture
02:22

The lecture explains about Client Server Architecture

04: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.

Section 5: Oracle RDBMS Architecture
05:18

Gives a simplified, high level overview of Oracle RDBMS System

Section 6: Connecting to an Oracle Database
02:25

This lecture explains about connecting to an Oracle Database.

02:06

Hands-on lab: Connect as SYSDBA

Article

LAB - Hands on with connecting as SYSDBA

Section 7: Stopping and Starting an Oracle Database
01:20

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

Article

LAB - Hands on with Stopping an Oracle Database

03:18

Explains about starting an Oracle Database.

Article

Hands on with Starting an Oracle Database

Section 8: Table
02:00

This lecture explains about a Table.

02:01

This lecture explains about Data Types

Section 9: SELECT - Basic SELECT Statement
02:38

The lecture explains the basics of a SELECT statement

01:43

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

Article

LAB work on DESCRIBE Command

00:46

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

Article

LAB for SELECT COUNT syntax

Section 10: DBA Info - DBA_TABLESPACES
01:01

Explains about DBA_TABLESPACES

Article

SELECT and understand the data from DBA_TABLESPACES

Section 11: SELECT - Selecting Specific Data
01:46

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

Article

Lab about selecting a set of columns that we want instead of all the columns from a Table.

02:22

Explains the basics of a WHERE clause.

Article

Hands on with WHERE Clause

Section 12: DBA Info - Oracle Database User Architecture
05:58

Gain knowledge about how Oracle Users and Schemas work.

00:45

Compares Oracle Schema and Oracle User

01:03

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

00:54

Explains the fundamental principles of accessing objects within a database.

Section 13: Classification of SQL Commands
02:54

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

DML - Data Manipulation Language
Article
DDL - Data Definition Language
Article
Article

Explains about Data Control Language

Article

Explains about Transaction Control Language

Section 14: Creating a Schema
02:30

The students will learn about how to create a user.

Article

LAB Work: Hands-on with creating a user

01:22

Explains about how to create a Table.

Article

Lab: Hands-on with CREATE TABLE statement

Section 15: DML - Data Manipulation Language
01:35

Explains the basics of DML statements

00:36

Explains about SELECT statement

01:39

Explains about the structure of an INSERT statement.

Article

The INSERT has failed. Why?

01:11

What is METADAT? - This course explains about it.

00:34

Explains about Oracle Database's DATA DICTIONARY

DBA Info - DEFAULT PERMANENT TABLESPACE
Preview
03:12
00:28

The course explains about fixing the INSERT statement that failed earlier.

03:31

Demonstrating the fix commands for the failed INSERT statement.

Article

LAB - Hands on with the commands to fix the INSERT

02:08

Explains about UPDATE statement

01:27

Demonstrating the UPDATE statement

Article

LAB - Hands on with UPDATE statements

01:08

Explains about DELETE statements

01:09

Demonstrating a DELETE statement

Article

LAB - Hands on with a DELETE statement

Article

We will take a look at MERGE statement later

Section 16: TCL - Transaction Control Language
01:17

Basics of Transaction Control Language which is commonly referred as TCL.

Article

This lecture narrates the definition of a Transaction.

03:56

This lecture narrates an example scenario about Transactions.

02:06

This lesson show demo of three individual transactions. Two are single DML transactions and one transaction involves two DMLs.

Article

Lab: Hands-on with Transactions

03:41

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

03:07

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

01:56

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

02:54

Demostration of COMMIT commands

Article

LAB: Hands-on for COMMIT related commands

01:38

Explains the ROLLBACK statement

Article

LAB - Hands on for ROLLBACK statements

01:59

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

02:14

Demonstration of SAVEPOINTS.

Article

LAB - Hands on with SAVEPOINT's usage scenario.

Section 17: DCL - Data Control Language
00:38

Explains about GRANT statement

00:29

Explains about SYSTEM PRIVILEGES

00:35

Explains about Object Privileges

00:55

Explains about ROLE PRIVILEGES

00:22

Explains about REVOKE statements

05:40

Full demonstration of GRANT and REVOKE statements.

Article

LAB: Hands on with GRANT and REVOKE statements

01:09

By the way, who are my DBAs?

Article

Lab: Hands-on about finding the users who have been granted the DBA privilege. As well as list the system privileges granted to the DBA role.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sam Dhanasekaran, 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.

Ready to start learning?
Take This Course