Mastering Oracle Database 12c SQL by example

Plug into the next gen cloud databases! Take your learning to the next level and become a top skilled SQL developer.
3.2 (6 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.
178 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 33
  • Length 6 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 1/2014 English

Course Description

In the "Mastering Oracle Database 12c SQL by example" course, students learn how to use SQL's best practices to query and manipulate data held in Oracle relational databases.

What distinguishes this course from others SQL courses?

This course is a media-rich learning experience! It will take your learning to the next level with lectures that will provide you an effective learning method, consisting of:

A brief and summarized theoretical component that will save your time reading the exhaustive Oracle SQL documentation presenting you just the fundamental and essential learning topics.

A Virtual Class Module that will plug you into a class environment, where you can learn by example, with plenty of demonstrations that will show you how to implement SQL's best practices using the Oracle Database

Practice is the key of success! You can practice the several hands-on exercises available at the end of each lecture including lecture quizzes at any time and anywhere you want.


Why should you take this course?

If you are new to SQL, this course will be a fast and effective way for you to learn this language and become a skilled SQL developer.For the intermediate, the advanced topics provide new implementation approaches, including the newest SQL 12c features, that I'm sure will be a plus for your daily challenges using SQL and improve the way you perform your Oracle Database related tasks.

Since my goal is to provide every Udemy student with an exceptional learning experience, when you enroll this course expect my online support to clarify any doubt or question you may have throughout the course.

What are the requirements?

  • Familiarity with data processing concepts and techniques

What am I going to get from this course?

  • Identify the main structural components of the Oracle Database 12c
  • Write SELECT statements to retrieve data from tables
  • Customize output data with Single-Row functions
  • Summarize data using Aggregate functions
  • Restrict and sort data retrieved from tables
  • Identify the different types of subqueries
  • Implement the if-then-else logic using conditional expressions
  • Retrieve data from multiple tables using different join methods
  • Manipulate data held in the Oracle Database 12c using DML statements
  • Manage schema objects
  • Manage objects with data dictionary views
  • Identify the Oracle SQL 12c newest features

What is the target audience?

  • Business Analysts
  • Database and Application Developers
  • Business Intelligence Developers
  • College Students
  • Beginner and Intermediate levels

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: Course Introduction
03:45

A brief introduction to what you will learn in this course.

Course Objectives

Course Agenda

The basics of SQL
Preview
01:30
02:17

Key concepts about Relational Models

Database modeling overview: setting business requirements with a simple case scenario

How to create a simple Relational Model

04:43

Introducing the Human Resources and Order Entries sample schemas

Using Oracle SQL Developer and getting familiar with both schemas

Section 2: Retrieving Data
10:59

The main characteristics of the SELECT statement

How to retrieve data from a single table: specifying the attributes you want to display

Handling unknown data

10:32

Introducing SQL operators

How to use the concatenation operator to customize output

Using aliases to set alternative output names for table attributes

Section 2 Quiz - Retrieving Data
5 questions
Section 3: Restricting and Sorting Data
07:14

How to subset retrieved data using the WHERE clause

Analysing the WHERE clause components

Creating query conditions using character and date values

15:08

Using comparison and logical operators

How to manipulate operator precedence in query expressions

Sorting Data
06:22
Section 3 - Restricting and Sorting data
6 questions
Section 4: Customizing Output Data
02:13

Identifying the different types of SQL functions you

Introducing and analyzing the behaviour of the different types of Single-Row functions

Character, Numeric and Datetime functions
19:34
13:09

How Oracle performs implicit datatype conversion

Introducing explicit conversion functions

Different types of explicit conversion: character,numeric and date

08:27

Implementing the if-then-else logic in SQL statements

Using the Decode conversion functions

Creating Case expressions

Section 4 - Customizing Output Data
7 questions
Section 5: Aggregating Data
08:51

How you can use aggregate functions to retrieve summarized data

Introducing Aggregate functions you can use to summarize data

12:44

How to create groups of summarized data using the GROUP BY clause

Using the HAVING clause to restrict groups of summarized data

How to handle null values when aggregating data

Section 5 - Aggregating Data
6 questions
Section 6: Retrieving Data from Multiple tables
05:13

How to retrieve data from multiple tables

Table joins guidelines

The unwanted Cartesian Product

08:11

Using the equality operator in join conditions to perform equijoins

Using the BETWEEN operator in join conditions to perform non-equijoins

12:08

How to retrieve data from multiple tables even if some rows don't match the join condition

How to join a table with itself

Section 6 - Retrieving data from multiple tables
4 questions
Section 7: Using Subqueries
12:31

Addressing complex problems using subqueries

How to create a relationship between the subquery and the main query

13:39

Returning values to the main query using a single-row and multiple-row subqueries

Using the IN,ANY and ALL operators to include/exclude values returned by the subquery in the main query condition

09:23

Comparing multiple attributes from the main query with the subquery using multiple-column subqueries

10:15

How to combine multiple queries using SET operators

Analysing the UNION,UNION ALL, MINUS and INTERSECT operators

Section 7 - Using Subqueries
6 questions
Section 8: Manipulating Data
22:20

How to manipulate data held in the Oracle Database using Data Manipulation Language statements

Adding, changing and removing data from a table

11:43

Introducing fundamental concepts about database transactions

The ACID transaction properties - Overview

How to control a database transaction

Section 9: Manipulating Database Objects
10:10

How to create a new table specifying attributes or using a subquery

Modifying table structure: adding,modifying and removing table attributes

How to remove a table

21:30

Key concepts about Constraints

Methods for creating a table Constraint: column level vs table level

Using different types of Constraints

20:26

What is a View and why to create Views

Benefits of using Views

Simple Views vs Complex Views

Creating,modifying and removing Views

07:10

How to create number generators using Sequences

Managing the properties of a Sequence

How to create,modify and remove a Sequence

10:55

What is an Index

Key benefits of using an Index

Index creation guidelines

Creating,modifying and removing Indexes

Section 10: Using the Data Dictionary
01:50

A brief introduction to the Oracle Data Dictionary

Understanding the main Data Dictionary components

15:46

Guidelines when using the Data Dictionary

Data Dictionary Views: how to use them to retrieve Database objects information

Section 11: Oracle Database 12c - SQL New Features
26:53

Describe Oracle Database 12c SQL new features

Use sequences in column default values

Create Identity columns

Create invisible columns

Truncate tables cascading foreign key constraints

Row limiting for TOP-N result queries

Course Summary
01:38

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Prof. Rui Cunha, Oracle Developers Academy CEO & University Lecturer

Rui is a database enthusiast that has been working with Oracle Database products for almost 15 years, either as an University Lecturer, Oracle Trainer and IT Consultant.

He has been training Oracle Database products such as SQL and PL/SLQ since 2002, helping thousands of students to succeed and reach their objectives.

With a vast experience as an IT Consultant, Rui has also been participating in several international Datawarehousing projects for some key market players.

Rui is now Oracle Developers Academy CEO and founder, a learning community for Oracle Database developers to learn and improve their skills using Oracle database products such as SQL and PL/SQL.

Rui's courses deliver at least 80% of practice contents,with plenty of demonstrations,hands-on exercices and quizzes. He strongly believes that practice is the key of success!

When enrolling any of his courses, Rui's main goal is to provide you with an exceptional learning experience.So expect his support to clarify any doubt or question you may have throughout any course.

Ready to start learning?
Take This Course