by | Released August 2014 | ISBN: 9781771372794

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. Show and hide more Publisher resources Download Example Code

1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
Show and hide more