Oracle SQL : Become a Certified SQL Developer From Scratch!
4.5 (437 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.
4,899 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL : Become a Certified SQL Developer From Scratch! to your Wishlist.

Add to Wishlist

Oracle SQL : Become a Certified SQL Developer From Scratch!

Learn SQL with a "Professional Certification Course", Hundreds of Examples with True and False Usages, English Subtitle!
Bestselling
4.5 (437 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.
4,899 students enrolled
Created by Omer Dagasan
Last updated 5/2017
English
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 11.5 hours on-demand video
  • 5 Articles
  • 6 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Over 100+ Lectures, 12,5+ Hours Content
  • Write SQL queries easily
  • Very well organised into 16 sections
  • Can create solutions on any sql problems
  • Understanding database terminology
  • Reading data using a SELECT statement
  • Grouping, filtering and restricting data
  • Inserting, updating and deleting data
  • Oracle SQL Functions
  • Oracle Data Types
  • Joins, set operators, subqueries
  • Creating, Modifying and Dropping tables
  • Lifetime support from the author
  • Weekly Assessments / Quizzes
View Curriculum
Requirements
  • Oracle Database Software
  • Oracle SQL Developer
Description

Course Updates:

  • 4-Feb-2017 -> (NEW!) Quizzes were added at the end of each section!

An easy course does not mean to understand easily, it means just think to understand. This course is not just easily explained, but also explained in detail, and many examples. If you get this course, please try to write and run all the examples with me. If you follow what I said in this course, "You will be an SQL Developer just in 7 weeks."

  • You can ask any questions about this course from discussion board.
  • Your questions will be answered immediately.

=============================================================

Are you a student to learn SQL for your lessons?

Do you want to get a better job?

Are you bored in watching a lot of stuff but could not learn anything?

Do you think you know SQL, but can not write code?

Are you looking for a really professional course?

Then this is the course you are looking for.

In this course, all the subjects are explained with a professional order.

If you are new in sql, you can learn easily with all the details. If you already know sql and want to improve it, this course explains all the details of including subjects.

After finishing this course, you will learn what you need to learn at all. If you don't see anything in this course, that means you really don't need to know it for now.

Coding can be learned with coding. A course which has no example is not a course at all. And there are hundreds and hundreds of codes in this course.

And something more.. Are you not good in English? No problem.

All of our videos are supported with "English Subtitle".

So come on, what are you waiting for..

Get this course, and go get a better job..


Benefits of Taking This SQL Course

Knowing SQL can get you a better job or improve the one you have and it provides to earn you $80k+ in the IT Industry. It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, that's why it's so popular and backed by Oracle.

This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts how to write SQL codes easily and thinking analytically against the problem in your company.

Student Reviews Prove This Course's Worth

Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.

Many students had also taken other SQL courses in the past, only to find that this SQL course was their favorite. They enjoyed the structure of the content and the high quality audio/video.

Check out all of the great reviews in the review section ... a lot of happy students :-)


No Risk – Money-Back Guarantee

Finally, there is no risk. You can preview 10% of the course for free. Once you purchase the course, if for some reason you are not happy with the course, Udemy offers a 30-day money back guarantee.

So you have nothing to lose, sign up for this course and learn how to write SQL code easily from scratch to master level!

Who is the target audience?
  • University or college students
  • Graduates or workers
  • Beginners on SQL
  • Intermediates on SQL
  • Anyone who wants to improve SQL
  • Software developers (java/.net/python) interacting with the Oracle Database
Curriculum For This Course
Expand All 105 Lectures Collapse All 105 Lectures 12:22:27
+
Course Guideline
1 Lecture 00:00

This is a quick guideline that you should read before starting the Oracle SQL Become an SQL Developer Course.

Course Guideline
1 page
+
Introduction and Software Preparation
11 Lectures 01:15:42

Having The Database with Oracle VirtualBox Lecture:

Download virtual image link (Copy & Paste into your browser):

https://drive.google.com/uc?id=0B7rEng2gKzHUSS1PTng2aXlYOWs&export=download 

----------------------------------------------------------------------------------------------------------------------

Oracle Virtual Box

https://drive.google.com/uc?id=0B7rEng2gKzHUU1pSaEU5WWVub3c&export=download

Preview 16:29

An error occured and it is deleted. It will be online today..

Preview 08:43

In this article, we are going to learn how to unlock hr user.

Lesson Keywords: #hr #user #sql #sqltraining

HR User Problems & Solutions
01:43

HR Schema Create Codes
25:30

Covers how to download and configure right SQL Developer and how to connect to database.

Preview 08:06

Introduces what is relational database management systems and how it used in oracle..

Describing Relational Database Management Systems (RDBMS)
02:18

In all the course, we are going to use HR schema pre-created by Oracle, so a basic description of this schema (for example : tables, relations in it..)

Describe the Schema used in this course (HR)
02:42

Entitiy relationship is the main perspective or new kind of databases. This lesson explains what is ER logic and how used in Oracle..

Entity Relationship Logic in Oracle Database
02:49

Introduces which SQL statements we are going to use in this course. (Oracle's specific SQL details are in next lessons.)

SQL Statement used in this course
01:25

This lecture introduces shows how much we appriciate your thoughts.

Don't Forget to Leave a Rating!
00:14

SQL Developer is the most used tool for coding with Oracle SQL. This course gives some details how we are going to use Oracle SQL Developer.

Oracle SQL Developer Basics
05:43

You can evaluate your sql knowledge and skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 1 : Quiz
10 questions
+
Retrieving Data
9 Lectures 01:00:12

In this lesson, we're going to talk about Oracle Data Types which are;

  1. CHAR
  2. VARCHAR2
  3. NUMBER
  4. DATE
  5. LONG
  6. RAW
  7. LONG RAW
  8. BLOB
  9. CLOB
  10. BFILE
  11. ROWID.
Oracle Data Types
03:53

This lesson includes Oracle DESC or DESCRIBE Command.

DESCRIBE Command
03:41

This lesson covers Oracle SQL Statement Basics.

SQL Statement Basics
10:03

This lesson covers Oracle SELECT Statements.

Using SELECT Statement
04:37

This lesson covers Oracle Column Aliases.

Using Column Aliases
07:51

This lesson covers Oracle Quote (q) Operator.

Quote (Q) Operator
07:14

This lesson covers Oracle Distinct(DISTINCT) Operator.

DISTINCT Operator
05:17

This lesson covers Concatenation ( || ) Operator.

Concatenation Operators
07:28

This lesson covers Oracle SQL Arithmetic Operations like;

  • Add
  • Substract
  • Multiply
  • Divide

and covers NULL values.

Arithmetic Expressions and NULL Values
10:08

You can test your sql skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 2 : Quiz
4 questions
+
Restricting Data
9 Lectures 45:35

In this lesson we're going to learn WHERE Clause in Oracle Database.

Using WHERE Clause
02:50

In this lesson we're going to learn Comparison Operators( <, >, < = , >=, <>) in Oracle Database.

Comparison Operators
05:40

In this lesson we're going to learn BETWEEN ... AND Operator in Oracle Database.

BETWEEN … AND Operator
04:10

In this lesson we're going to learn IN Operator in Oracle Database.

IN Operator
06:10

In this lesson we're going to learn LIKE Operator in Oracle Database.

LIKE Operator
07:19

In this lesson we're going to learn IS NULL Operator in Oracle Database.

IS NULL Operator
02:36

In this lesson we're going to learn Logical Operators

  1. AND Operator
  2. OR Operator
  3. NOT Operator

in Oracle Database.


Logical Operators (AND, OR, NOT)
11:17

In this lesson, we're going to learn Rules of Precedence in Oracle Database.

Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.

Operator, Operation

+, - identity, negation

*, / multiplication, division

+, -, || addition, subtraction, concatenation

=, !=, <, >, <=, >=, IS NULL, LIKE, BETWEEN, IN comparison

NOT exponentiation, logical negation

AND conjunction

OR disjunction

Rules of Precedence
05:33

Oracle SQL Quiz about Section 2 : Retrieving Data with using SQL.
Preview 12 pages

You can test your sql skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".


Section 3 : Quiz
10 questions
+
Sorting Data
3 Lectures 18:19

In this lesson we're going to learn ORDER BY Clause in Oracle Database.

ORDER BY Clause
05:00

In this lesson we're going to learn ASC (Ascending) and DESC(Descending) Operators in Oracle Database.

ASC and DESC Operators
08:07

In this lesson we're going to learn NULLS FIRST and NULLS LAST Operators in Oracle Database.

NULLS FIRST and NULLS LAST Operators
05:12

You can evaluate your sql knowledge and skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 4 : Quiz
5 questions
+
Single-Row Functions
7 Lectures 01:26:18

In this lesson we're going to learn Single-Row Functions in Oracle Database.

Single Row Functions
09:28

In this lesson we're going to learn Character Functions Part 1 in Oracle Database.

This lesson includes;

1.Case conversion functions
  1. LOWER function
  2. UPPER function
  3. INITCAP function
2.Character Manipulation functions
  1. SUBSTR function
  2. LENGTH function
  3. CONCAT function
  4. INSTR function
  5. TRIM function
  6. REPLACE function
  7. LPAD function
  8. RPAD function
Character Functions (Part 1)
16:51

In this lesson we're going to learn Character Functions Part 2 in Oracle Database.

This lesson includes;

1.Case conversion functions

  1. LOWER function
  2. UPPER function
  3. INITCAP function

2.Character Manipulation functions

  1. SUBSTR function
  2. LENGTH function
  3. CONCAT function
  4. INSTR function
  5. TRIM function
  6. REPLACE function
  7. LPAD function
  8. RPAD function
Character Functions (Part 2)
15:21

In this lesson we're going to learn Number(Numeric) Functions in Oracle Database.

Number Functions
09:00

In this lesson we're going to learn Nesting Functions in Oracle Database.

Nesting Functions
07:59

In this lesson we're going to learn Date Functions in Oracle Database.
Date Functions
07:48

In this lesson we're going to learn Date Operations in Oracle Database.

Date Operations
19:51

You can evaluate your sql knowledge and skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 5 : Quiz
5 questions
+
Conversion Functions
4 Lectures 45:32

In this lesson we're going to learn Conversion Functions in Oracle Database.

It contains;

  1. Implicit Data Type Conversion
  2. Explicit Data Type Conversion

  1. TO_CHAR Function
  2. TO_DATE Function
  3. TO_NUMBER Funtion

Conversion Functions
07:06

In this lesson we're going to learn

  1. TO_CHAR Function in Oracle
  2. TO_DATE Function in Oracle
  3. TO_NUMBER Function in Oracle.
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)
13:37

In this lesson we're going to learn

  1. TO_CHAR Function in Oracle
  2. TO_DATE Function in Oracle
  3. TO_NUMBER Function in Oracle.
TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)
12:29

In this lesson we're going to learn

  1. NVL Function in Oracle
  2. NVL2 Function in Oracle
  3. NULLIF Function in Oracle
  4. COALESCE Function in Oracle.
NVL, NVL2, NULLIF, COALESCE Functions
12:20

You can evaluate your sql knowledge and skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 6 : Quiz
6 questions
+
Conditional Expressions
1 Lecture 17:38

In this lesson we will mention about these topics below;

  1. IF...THEN...ELSE Expressions in Oracle Database.
  2. CASE Expression in Oracle Database.
  3. DECODE Expressions in Oracle Database.
Conditional Expressions (CASE-DECODE)
17:38

You can evaluate your sql knowledge and skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 7 : Quiz
5 questions
+
Group Functions
7 Lectures 28:55

In this lesson we are going to learn Oracle Group Functions

Group Functions
04:28

In this lesson we are going to learn AVG Function in Oracle Database.

AVG Function
04:36

In this lesson we are going to learn COUNT Function in Oracle Database.

COUNT Function
05:06

In this lesson we are going to learn MAX Function in Oracle Database.

MAX Function
04:04

In this lesson we are going to learn MIN Function in Oracle Database.

MIN Function
04:33

In this lesson we are going to learn SUM Function in Oracle Database.

SUM Function
03:09

In this lesson we will look at overview of Oracle Group Functions.

Overview Of Group Functions
02:59

You can evaluate your sql knowledge and skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 8 : Quiz
5 questions
+
Grouping Data
3 Lectures 29:39

This lesson explains what is GROUP BY Clause and how used in Oracle.

GROUP BY Clause
18:10

This lesson explains what is HAVING Clause and how used in Oracle.

HAVING Clause
07:27

This lesson explains what are Nesting Group Functions and how we used in Oracle Database.

Nesting Group Functions
04:02

You can evaluate your sql knowledge and skills with our quizzes. 

Keywords: "SQL", "sql programming", "quiz", "sql quiz".

Section 9 : Quiz
5 questions
7 More Sections
About the Instructor
Omer Dagasan
4.4 Average rating
613 Reviews
8,347 Students
4 Courses
Oracle Architect & Software Engineer

I have been working for more than 10 years on software development on many programming languages (like JAVA, C#, PHP, etc) and about 10 years on SQL- PL/SQL programming. And software project manager for more than 5 years.. For now, I am working on a database which has more than 15M active user as a project manager, and teaching SQL-PL/SQL courses...