Mastering Oracle Database 12c SQL by example
3.3 (7 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.
187 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering Oracle Database 12c SQL by example to your Wishlist.

Add to Wishlist

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.3 (7 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.
187 students enrolled
Created by Prof. Rui Cunha
Last updated 1/2014
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Familiarity with data processing concepts and techniques
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.

Who is the target audience?
  • Business Analysts
  • Database and Application Developers
  • Business Intelligence Developers
  • College Students
  • Beginner and Intermediate levels
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 33 Lectures Collapse All 33 Lectures 05:49:09
+
Course Introduction
4 Lectures 12:15

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

Course Objectives

Course Agenda

Preview 03:45


Key concepts about Relational Models

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

How to create a simple Relational Model

Preview 02:17

Introducing the Human Resources and Order Entries sample schemas

Using Oracle SQL Developer and getting familiar with both schemas

Preview 04:43
+
Retrieving Data
2 Lectures 21:31

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

The SELECT statement
10:59

Introducing SQL operators

How to use the concatenation operator to customize output

Using aliases to set alternative output names for table attributes

Customizing data output
10:32

Section 2 Quiz - Retrieving Data
5 questions
+
Restricting and Sorting Data
3 Lectures 28:44

How to subset retrieved data using the WHERE clause

Analysing the WHERE clause components

Creating query conditions using character and date values

Restricting Data
07:14

Using comparison and logical operators

How to manipulate operator precedence in query expressions

Comparison and Logical Operators
15:08

Sorting Data
06:22

Section 3 - Restricting and Sorting data
6 questions
+
Customizing Output Data
4 Lectures 43:23

Identifying the different types of SQL functions you

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

Single-Row Functions
02:13

Character, Numeric and Datetime functions
19:34

How Oracle performs implicit datatype conversion

Introducing explicit conversion functions

Different types of explicit conversion: character,numeric and date

Using Conversion functions
13:09

Implementing the if-then-else logic in SQL statements

Using the Decode conversion functions

Creating Case expressions

Creating Conditional Expressions
08:27

Section 4 - Customizing Output Data
7 questions
+
Aggregating Data
2 Lectures 21:35

How you can use aggregate functions to retrieve summarized data

Introducing Aggregate functions you can use to summarize data

Aggregate Functions
08:51

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

Manipulating groups of data
12:44

Section 5 - Aggregating Data
6 questions
+
Retrieving Data from Multiple tables
3 Lectures 25:32

How to retrieve data from multiple tables

Table joins guidelines

The unwanted Cartesian Product

Joining Tables - Overview -
05:13

Using the equality operator in join conditions to perform equijoins

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

Equijoins and Non-Equijoins
08:11

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

How to join a table with itself

Additional join methods
12:08

Section 6 - Retrieving data from multiple tables
4 questions
+
Using Subqueries
4 Lectures 45:48

Addressing complex problems using subqueries

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

Subqueries Overview
12:31

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

Single-Row and Multiple-Row Subqueries
13:39

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

Multiple-Column Subqueries
09:23

How to combine multiple queries using SET operators

Analysing the UNION,UNION ALL, MINUS and INTERSECT operators

Combining Multiple Queries
10:15

Section 7 - Using Subqueries
6 questions
+
Manipulating Data
2 Lectures 34:03

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

Adding, changing and removing data from a table

Data Manipulation Language (DML) Overview
22:20

Introducing fundamental concepts about database transactions

The ACID transaction properties - Overview

How to control a database transaction

Managing Transactions
11:43
+
Manipulating Database Objects
5 Lectures 01:10:11

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

Managing table structure
10:10

Key concepts about Constraints

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

Using different types of Constraints

Managing Constraints
21:30

What is a View and why to create Views

Benefits of using Views

Simple Views vs Complex Views

Creating,modifying and removing Views

Using Views
20:26

How to create number generators using Sequences

Managing the properties of a Sequence

How to create,modify and remove a Sequence

Manipulating Sequences
07:10

What is an Index

Key benefits of using an Index

Index creation guidelines

Creating,modifying and removing Indexes

Manipulating Indexes
10:55
+
Using the Data Dictionary
2 Lectures 17:36

A brief introduction to the Oracle Data Dictionary

Understanding the main Data Dictionary components

Data Dictionary Overview
01:50

Guidelines when using the Data Dictionary

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

How to use the Data Dictionary
15:46
1 More Section
About the Instructor
Prof. Rui Cunha
3.3 Average rating
7 Reviews
187 Students
1 Course
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.