Video description
In this Oracle SQL training course, expert author Steve Perry teaches you everything you need to know about this graphical user interface. This course is designed for the absolute beginner, meaning no prior knowledge of Oracle SQL is required.
You will start by learning about a basic SQL select statement, including how to retrieve data from a table, use mathematical and text expressions, and sort the results using column names. Steve will then show you how to restrict data, join tables, and summarize data. This video tutorial will also cover data subsets, restricting data, using subqueries, and data modeling. Other topics that are covered include creating tables and manipulating data, single-row functions, creating and using views, database management, and legacy SQL techniques.
Once you have completed this computer based training course, you will be able to use Oracle SQL as your main productivity tool for development. Working files are included, allowing you to follow along with the author throughout the lessons.
Table of contents
-
Introduction To Oracle SQL
- Introduction And About The Author 00:02:58
- What Is SQL? 00:05:31
- Relational Databases Explained - Part 1 00:06:51
- Relational Databases Explained - Part 2 00:06:22
- How To Query Data From A Database 00:06:52
- The Difference Between SQL And PL/SQL 00:03:58
- Setting Up An Oracle Apex Account 00:09:53
- Running SQL Using Oracle Apex 00:06:50
- Assignment 1 00:00:44
- Assignment 1 - Solution 00:01:30
-
Basic SQL Select Statement
- Retrieving All Data From A Table 00:05:31
- Retrieving Some Data From A Table 00:02:02
- Restricting The Retrieval Of Rows From A Table 00:05:29
- Using Mathematical And Text Expressions 00:06:09
- Sorting The Results Using Column Names 00:05:42
- Assignment 2 00:02:27
- Assignment 2 - Solution 00:06:37
-
Restricting Data - The Basics
- What Is A Primary Key? 00:06:13
- Comparison Operators 00:04:49
- Logical Operators 00:07:36
- Dealing With Null Values 00:08:14
- Sorting The Results Using Column Position 00:03:53
- Assignment 3 00:01:28
- Assignment 3 - Solution 00:06:19
-
Joining Tables - The Basics
- What Is A Foreign Key? 00:04:24
- Inner Joins With The Using Clause 00:06:49
- Joins With The On Clause 00:05:31
- Joins And The Order Of Processing 00:04:35
- Assignment 4 00:01:02
- Assignment 4 - Solution 00:04:49
-
Summarizing Data
- Aggregate Functions 00:06:45
- The Count Functions 00:05:10
- The Min And Max Functions 00:04:28
- The Avg And Sum Functions 00:02:38
- Concatenating Data 00:04:27
- Aggregates - Order Of Processing 00:03:33
- Assignment 5 00:00:51
- Assignment 5 - Solution 00:01:29
-
Joining Multiple Tables
- Many-To-Many Relationships - Part 1 00:07:16
- Many-To-Many Relationships - Part 2 00:04:22
- Join Multiple Tables With The Using Clause 00:07:31
- Join Multiple Tables With The On Clause 00:06:57
- Eliminating Duplicate Rows From The Results 00:05:32
- Sorting The Results Using Column Aliases 00:01:45
- Assignment 6 00:01:09
- Assignment 6 - Solution 00:03:36
-
Data Subsets
- Using The Group By Clause 00:07:50
- Using The Having Clause 00:04:43
- Having With Compound Conditions 00:03:18
- Assignment 7 00:01:03
- Assignment 7 - Solution 00:04:18
-
Restricting Data - Advanced Concepts
- Using The In Operator 00:04:04
- Using The Between Operator 00:06:30
- Using The Like Operator For Pattern Matching 00:09:32
- Outer Joins 00:11:48
- Assignment 8 00:00:58
- Assignment 8 - Solution 00:03:38
-
Using Subqueries - The Basics
- How Do Subqueries Work? 00:06:47
- Subqueries With The In Operator 00:09:25
- Subqueries Using A Comparison Operator 00:07:21
- Subqueries Vs. Joins 00:04:12
- Using A Subquery Vs. A Self-Join 00:04:23
- Assignment 9 00:01:05
- Assignment 9 - Solution 00:04:33
-
Data Modeling - The Basics
- How Data Is Organized In A Relational Database 00:04:13
- The Entity-Relationship Approach 00:08:26
- Normalization Guidelines - Part 1 00:07:14
- Normalization Guidelines - Part 2 00:07:06
- Assignment 10 00:01:47
- Assignment 10 - Solution 00:02:52
-
Creating Tables And Manipulating Data
- Creating Tables - Part 1 00:06:48
- Creating Tables - Part 2 00:09:06
- Specifying Keys 00:04:33
- The Check Constraint 00:06:50
- Creating Indexes 00:06:58
- Modifying And Removing Tables 00:05:58
- More Constraints 00:04:26
- Adding Data To A Table 00:06:59
- Changing Data In A Table - Part 1 00:04:50
- Changing Data In A Table - Part 2 00:03:12
- Removing Data From A Table 00:03:23
- Assignment 11 00:01:17
- Assignment 11 - Solution 00:01:15
-
Single-Row Functions
- String Functions - Part 1 00:08:02
- String Functions - Part 2 00:04:15
- Number Functions 00:05:50
- Date Functions 00:07:53
- Limiting Rows And The Dual Table 00:06:07
- Assignment 12 00:01:56
- Assignment 12 - Solution 00:02:27
-
Creating And Using Views
- Creating And Using Views 00:09:18
- Set Operators 00:09:23
- Assignment 13 00:00:52
- Assignment 13 - Solution 00:01:50
-
Database Management
- Transaction Management 00:02:58
- Concurrency Control 00:04:00
- Security Considerations 00:06:32
- Stored Procedures And Triggers 00:04:37
- Database Integrity 00:03:23
- Assignment 14 00:00:57
- Assignment 14 - Solution 00:01:57
-
Legacy SQL Techniques
- Implicit Joins 00:05:46
- Subqueries With Modifiers 00:05:13
- Subqueries Using The Exists Clause 00:07:08
- Assignment 15 00:01:21
- Assignment 15 - Solution 00:03:34
-
Conclusion
- Difference Between Oracle And Other SQLs 00:04:45
- SQL In A Programming Language 00:05:41
- Embedded SQL 00:04:42
- What Is Next? 00:01:14
Product information
- Title: Learning SQL For Oracle
- Author(s):
- Release date: August 2014
- Publisher(s): Infinite Skills
- ISBN: 9781771372794
You might also like
video
SQL Fundamentals LiveLessons
Start building powerful SQL queries right now! 8 Hours of Expert Video Instruction This one-of-a-kind video …
video
Learning Oracle PL/SQL
In this Learning Oracle PL/SQL training course, expert author Darryl Hurley will teach you how to …
video
SQL Fundamentals
People today spend more and more time online, working, shopping, socializing, streaming entertainment, and doing many …
book
OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)
A fully updated, integrated self-study system for the Oracle Database SQL Exam This thoroughly revised Oracle …