Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Course Introduction|
A brief introduction to what you will learn in this course.
The basics of SQLPreview
Key concepts about Relational Models
Database modeling overview: setting business requirements with a simple case scenario
How to create a simple Relational Model
Introducing the Human Resources and Order Entries sample schemas
Using Oracle SQL Developer and getting familiar with both schemas
|Section 2: Retrieving Data|
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
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
|Section 3: Restricting and Sorting Data|
How to subset retrieved data using the WHERE clause
Analysing the WHERE clause components
Creating query conditions using character and date values
Using comparison and logical operators
How to manipulate operator precedence in query expressions
Section 3 - Restricting and Sorting data
|Section 4: Customizing Output Data|
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
How Oracle performs implicit datatype conversion
Introducing explicit conversion functions
Different types of explicit conversion: character,numeric and date
Implementing the if-then-else logic in SQL statements
Using the Decode conversion functions
Creating Case expressions
Section 4 - Customizing Output Data
|Section 5: Aggregating Data|
How you can use aggregate functions to retrieve summarized data
Introducing Aggregate functions you can use to summarize data
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
|Section 6: Retrieving Data from Multiple tables|
How to retrieve data from multiple tables
Table joins guidelines
The unwanted Cartesian Product
Using the equality operator in join conditions to perform equijoins
Using the BETWEEN operator in join conditions to perform non-equijoins
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
|Section 7: Using Subqueries|
Addressing complex problems using subqueries
How to create a relationship between the subquery and the main query
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
Comparing multiple attributes from the main query with the subquery using multiple-column subqueries
How to combine multiple queries using SET operators
Analysing the UNION,UNION ALL, MINUS and INTERSECT operators
Section 7 - Using Subqueries
|Section 8: Manipulating Data|
How to manipulate data held in the Oracle Database using Data Manipulation Language statements
Adding, changing and removing data from a table
Introducing fundamental concepts about database transactions
The ACID transaction properties - Overview
How to control a database transaction
|Section 9: Manipulating Database Objects|
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
Key concepts about Constraints
Methods for creating a table Constraint: column level vs table level
Using different types of Constraints
What is a View and why to create Views
Benefits of using Views
Simple Views vs Complex Views
Creating,modifying and removing Views
How to create number generators using Sequences
Managing the properties of a Sequence
How to create,modify and remove a Sequence
What is an Index
Key benefits of using an Index
Index creation guidelines
Creating,modifying and removing Indexes
|Section 10: Using the Data Dictionary|
A brief introduction to the Oracle Data Dictionary
Understanding the main Data Dictionary components
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|
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
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.