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!
4.6 (255 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.
3,132 students enrolled Bestselling in SQL
$19
$200
90% off
Take This Course
  • Lectures 102
  • Length 12.5 hours
  • Skill Level All Levels
  • Languages English
  • 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 7/2015 English

Course Description


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!

What are the requirements?

  • Oracle Database Software
  • Oracle SQL Developer

What am I going to get from this course?

  • Write SQL codes easily
  • Can create solutions on any sql problems in their jobs..
  • Very well organised into 16 sections
  • Understand 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
  • Support from the author

What 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

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

1 page

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

46 pages

Here, there are create and insert code scripts of hr schema for you to analyze or to create if you don't have hr schema.

Section 1: Introduction and Software Preparation
08:43

In this lesson we're going to learn how to download and install Oracle Database 12c Installation step by step.

We're going to use Oracle Database 12c of Oracle Database version.


08:06

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

02:18

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

02:42

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

02:49

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

01:25

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

05:43

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.

Section 2: Retrieving Data
03:53

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.
03:41

This lesson includes Oracle DESC or DESCRIBE Command.

10:03

This lesson covers Oracle SQL Statement Basics.

04:37

This lesson covers Oracle SELECT Statements.

07:51

This lesson covers Oracle Column Aliases.

07:14

This lesson covers Oracle Quote (q) Operator.

05:17

This lesson covers Oracle Distinct(DISTINCT) Operator.

07:28

This lesson covers Concatenation ( || ) Operator.

10:08

This lesson covers Oracle SQL Arithmetic Operations like;

  • Add
  • Substract
  • Multiply
  • Divide

and covers NULL values.

12 pages
Oracle SQL Quiz about Section 2 : Retrieving Data with using SQL.
Section 3: Restricting Data
02:50

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

05:40

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

04:10

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

06:10

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

07:19

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

02:36

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

11:17

In this lesson we're going to learn Logical Operators

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

in Oracle Database.


05:33

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

Section 4: Sorting Data
05:00

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

08:07

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

05:12

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

Section 5: Single-Row Functions
09:28

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

16:51

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
15:21

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
09:00

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

07:59

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

19:51

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

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

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

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.
12:29

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.
12:20

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.
Section 7: Conditional Expressions
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.
Section 8: Group Functions
04:28

In this lesson we are going to learn Oracle Group Functions

04:36

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

05:06

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

04:04

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

04:33

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

03:09

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

02:59

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

Section 9: Grouping Data
18:10

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

07:27

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

04:02

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

Section 10: Joining Multiple Tables
03:10

This lesson explains joining multiple tables in Oracle and introduces types of joins.

07:29

In this lesson we are going to learn Natural Join in Oracle Database.

04:42

This lesson explains how used join with USING Clause in Oracle Database.

06:47

This lesson explains handling ambigious column names in Oracle Database.

05:29

This lesson explains how used join with ON clause in Oracle Database.

05:48

In this lesson we're going to learn multiple join operations in Oracle Database.

02:33

In this lesson we're going to learn resticting joins in Oracle Database.

03:33

In this lesson we are going to learn how used joining unequal tables in Oracle Database.

05:11

In this lesson we're going to learn self join in Oracle Database.

04:04

In this lesson we're going to learn OUTER JOINS in Oracle Database and we are gonna show type of outer joins;

  1. LEFT OUTER JOIN
  2. RIGHT OUTER JOIN
  3. FULL OUTER JOIN
04:01

In this lesson we're going to learn LEFT OUTER JOIN in Oracle Database.

06:45

In this lesson we're going to learn RIGHT OUTER JOIN in Oracle Database.

02:26

In this lesson we're going to learn FULL OUTER JOIN in Oracle Database.

05:30

In this lesson we're going to learn CROSS JOIN or CARTESIAN PRODUCT in Oracle Database.

Section 11: Using Subqueries
06:48

This lesson helps the participants to write subqueries in Oracle Database.

10:21

This lesson covers single row subqueries in Oracle Database.

11:47

This lesson covers multiple row subqueries in Oracle Database.

07:03

This lesson covers multiple column subqueries in Oracle Database.

Section 12: Using SET Operators
12:22

This lesson helps the participants to using SET operators in Oracle Database.

09:59

This lesson covers UNION and UNION ALL Operators in Oracle.

01:51

This lesson covers INTERSECT Operator in Oracle Database.

02:32

This lesson covers MINUS Operator in Oracle Database.

02:29

This lesson helps the participants to learn how to match unmatched queries in Oracle Database.

04:58

In this lesson participants learn how to use ORDER BY with SET Operators.

Section 13: Data Manipulation Language (DML) Statements
02:45

This lesson introduces what is Data Manipulation Language (DML) and how to used in Oracle Database.

11:34

In this lesson we are going to learn insert statement and how to used in Oracle Database.

12:11

In this lesson we are going to learn INSERT statement and how to used in Oracle Database.

07:50

In this lesson we are going to learn Update Statement and how to used in Oracle Database.

04:31

In this lesson we are going to learn delete statement and how to used in Oracle Database.

03:28

This lesson introduces what is Transaction Control Statements (TCL) and how to used in Oracle Database.

07:07

In this lesson we are going to learn COMMIT and ROLLBACK Statements and how to used in Oracle Database.

08:37

In this lesson we are going to learn SAVEPOINT Statement and how to used in Oracle Database.

08:21

In this lesson we are going to learn FOR UPDATE statement and how to used in Oracle Database.

Section 14: Data Definition Language (DDL) Statements
02:49

This lesson introduces what is Data Definiton Language (DDL) Statements and how to used in Oracle Database.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Omer Dagasan, 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...

Ready to start learning?
Take This Course