Oracle - The Complete SQL Guide (includes SQL Certification)
4.2 (5 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,009 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle - The Complete SQL Guide (includes SQL Certification) to your Wishlist.

Add to Wishlist

Oracle - The Complete SQL Guide (includes SQL Certification)

Master Oracle SQL: from Beginner to an "Oracle Certified SQL Developer" Ninja for a great and exciting Career ahead...
New
4.2 (5 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,009 students enrolled
Created by Abhijeet Soni
Last updated 9/2017
English
Current price: $12 Original price: $200 Discount: 94% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I Learn?
  • Be a SQL Ninja by understanding how the Oracle Database works through the usage of 100 Lectures with 10+ Hours Content (In Progress).
  • Develop the understanding of relational Database terminology.
  • Learn and master the concepts of SQL (Structured Query Language), Table creation, Data Retrieval Language (DQL/ DRL) which includes real time scenarios based on the usage of operators, functions, clauses and many more...
  • Gaining the deep understanding of Integrity Constraints, Pseudo columns, Joins and Queries to quickly become a Database developer.
  • Controlling user access and Database security using requisite SQL commands.
  • Dealing with other database objects (VIEWS, INDEXES, SEQUENCES, SYNONYMS) using the SQL commands.
  • Understanding the OLAP features and achieving a high degree of data concurrency through LOCKS.
  • Understanding the Data Manipulation Language, Transaction Control Language and Data Definition Language.
  • Project has been created to pursue a test driven approach by make use of Oracle Database Integration with Spring and Hibernate frameworks.
  • Pass the Oracle SQL Certification Examination through deep dive of the above discussed concepts.
View Curriculum
Requirements
  • No earlier programming experience is required to master the discussed content.
  • Person with basic computer knowledge is good enough to understand.
  • Use Chrome/ Oracle XE/ SQL Developer for practice.
Description

Welcome to my new course, 'Oracle - The Complete SQL Guide (includes SQL Certification)'.

This course starts from scratch, you neither need to know any pre-requisite database knowledge nor any programming expertise. 

From the environment Setup to Development, this course covers almost each and every concept required to become an expert SQL certified developer

Having a deep-dive of the concepts in this course, you'll learn all about:

  • Setup Development Environment Setup
  • Relational database fundamentals
  • Fundamentals of Database
  • Table creation and insertion of data
  • Data Retrieval Languages (DQL/ DRL)
  • Single Rows Function
  • Multiple Rows Function
  • Integrity Constraints
  • Pseudo Columns
  • Displaying Data from Multiple Tables i.e. JOINS
  • Query types
  • SET Operators usage
  • Controlling User Access and Database Security
  • Oracle Database Administration
  • Database objects (Views, Indexes, Sequence, Synonyms)
  • OLAP Features in Oracle
  • Table Locks
  • Data Manipulation Language (DML)
  • Transaction Control Language (TCL)
  • Data Definition Language (DDL)
  • Test driven approach by Integrating Oracle Database with Spring and Hibernate
  • Course Roundup and many more...

This course will assist:

  • in becoming an proficient 'Oracle SQL Developer' and 
  • to pass 'Oracle SQL Certification' examination.

Why SQL?

SQL the language is a structured query language designed for managing data in relational database management systems (RDBMS). Relational database management systems are often called SQL databases since they use the SQL language. SQL features provided are:

  • Rely on relational tables
  • Utilize defined data schema
  • Reduce redundancy through normalization
  • Support JOIN functionality
  • Engineered for data integrity
  • Traditionally scale up, not out
  • Rely on a simple, standardized query language
  • Near universal in adoption

Why Oracle?

Oracle database (Oracle DB) is a relational database management system (RDBMS) from the Oracle Corporation.The system is built around a relational database framework in which data objects may be directly accessed by users (or an application front end) through structured query language (SQL). Database features provided by Oracle are:

  • Scalability and Performance Features
  • Manageability Features
  • Database Backup and Recovery Features
  • High Availability Features
  • Business Intelligence Features
  • Content Management Features
  • Security Features
  • Data Integrity and Triggers
  • Information Integration Features
Who is the target audience?
  • Newcomer as well as experienced who would like to become SQL developer or interested in learning SQL for getting proficiency in relational database operations.
  • Practicing professional or simple an inspired individual interacting with the Oracle Database operations.
  • Course covers most of the topics required for the Oracle SQL Certification exam.
Compare to Other Oracle SQL Courses
Curriculum For This Course
77 Lectures
06:20:02
+
Setup - SQL Development Environment (In Progress...)
1 Lecture 04:32
+
Oracle Database – The Basics
6 Lectures 15:52
Entity Relationship Model
03:13

Relational Database Terminology
01:47

Structured Query Language
02:25

Database Objects
00:49

Table in Oracle
01:27

Data Types in Oracle
06:11
+
Table Creation and Insertion of Data
7 Lectures 22:21
Table Creation
02:39

Inserting Data in Table
04:17

Inserting Data in required columns
02:23

Inserting NULL values into Table
02:17

Multiple Inserts
03:22

Inserting special values into Table
02:31

Conditional Inserts
04:52
+
Data Retrieval Languages (DQL/ DRL)
15 Lectures 01:26:09
Select Statement
04:53

Comments within SQL
01:45

Arithmetic Operators
04:11

Defining a Column/ Table Alias
05:59

Concatenation Operator
02:32

Literals in Oracle
01:59

Eliminate Duplicate Rows
03:00

FROM Clause
04:35

WHERE Clause - Filter of Records
04:00

Order By Clause
05:09

PIVOT Clause
05:51

Relational or Comparison Operators
03:33

Operators: IN(), BETWEEN, IS NULL, IS NOT NULL
14:31

Operators: LIKE, REGEXP_LIKE, EXISTS
13:50

Logical Operators: AND, OR, NOT
10:21
+
Single Row Function
5 Lectures 51:29
Single Row Functions
01:47

Character Functions
15:13

Number Functions
10:22

Date Functions
12:21

Conversion Functions
11:46
+
Multiple Rows Function
7 Lectures 35:39
Aggregating or Group Functions
01:25

AVG(), SUM(), MIN(), MAX() Functions
06:40

STDDEV(), VARIANCE(),COUNT() Functions
05:16

Group By Clause
05:12

Having Clause
06:28

GREATEST(), LEAST(), USER, UID Functions
05:19

USERENV(), VSIZE(), SOUNDEX() Functions
05:19
+
Integrity Constraints
12 Lectures 01:07:54
Level of Constraints
01:09

NOT NULL Constraint
04:10

UNIQUE Constraint
09:22

PRIMARY KEY Constraint
10:19

FOREIGN KEY or REFERENTIAL INTEGRITY Constraint
08:45

CHECK Constraint
08:16

DEFAULT Option
02:36

Adding Constraint to a Table
08:29

DROPPING Constraints
05:05

DISABLING Constraint
03:02

ENABLE Constraint
03:05

VIEWING Constraints
03:36
+
Displaying Data from Multiple Tables i.e. JOINS
6 Lectures 33:56
JOINS and their Categories
01:23

Equi Join or Inner Join
09:22

Non-Equi Join
05:35



+
SET Operators usage
4 Lectures 16:48
UNION Operator
04:11

UNION ALL Operator
04:41

INTERSECT Operator
04:10

MINUS Operator
03:46
+
Working with Sequence
5 Lectures 14:20
Sequence: What & Why
00:27

Sequence: Syntax
02:25

Sequence: Creation
04:45

Sequence: Modification
02:55

Sequence: Removal & View
03:48
2 More Sections
About the Instructor
Abhijeet Soni
4.2 Average rating
4 Reviews
1,009 Students
1 Course
Software Developer and Instructor

Hi, my name is Abhijeet Soni. I've spent the last few years as a developer with a passion surrounded with programming and teaching. Having a Master's degree and I've been doing programming and building websites since 2010. It was in IT industry only where I first discovered my passion for programming, teaching and helping others by sharing the acquired knowledge to make the team more efficient.

As a self-taught professional and constantly searches new skills to learn. I’ve since focused my time and energy on bringing my teaching experience to an online environment i.e. Udemy. 

Join me on this with a concept ‘KAIZEN’ !!!