O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle: Introduction to Oracle SQL and PL/SQL

Video Description

Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and Oracle Enterprise Manager. This tutorial will explain how to maintain the Logical Database, and the difference between the Logical Database and the Physical database. You will be guided, in great detail, in the following areas: retrieving, changing, adding, and deleting data from the Database. From there, you will learn about Logical Database objects, Security, Select Statements, and much more. Introduction to Oracle SQL and PL/SQL will cover areas for the Oracle Certification course (1Z0-007). To get started, click one of the movie topics below.

Table of Contents

  1. Welcome
    1. Welcome 00:02:27
    2. Useful Web Sites 00:04:55
    3. What is Oracle Software? 00:03:10
    4. The History of Databases 00:06:06
    5. The History of Oracle 00:05:07
    6. About this Course 00:05:10
  2. The Relational Database Model
    1. The Relational Database Model 00:04:57
    2. The Concerts Schema 00:02:57
    3. Normalization pt. 1 00:07:38
    4. Normalization pt. 2 00:04:06
    5. Denormalization pt. 1 00:05:23
    6. Denormalization pt. 2 00:06:10
  3. Oracle SQL and PL/SQL Tools
    1. What are the Oracle SQL and PL/SQL Tools? 00:02:43
    2. SQL Plus 00:05:09
    3. Formatting Output 00:05:34
    4. SQL Plus Worksheet 00:04:00
    5. iSQL Plus 00:02:35
    6. Oracle Enterprise Manager pt. 1 00:04:46
    7. Oracle Enterprise Manager pt. 2 00:01:11
  4. The Architecture of Oracle
    1. The Oracle Database and Oracle Instance pt. 1 00:04:11
    2. The Oracle Database and Oracle Instance pt. 2 00:01:54
    3. Control Files, Logging, Archiving and Recoverability 00:02:50
  5. Creating Database Objects
    1. Oracle Simple Datatypes pt. 1 00:04:11
    2. Oracle Simple Datatypes pt. 2 00:05:00
    3. Oracle Complex and Object Datatypes 00:03:23
    4. Types of Tables 00:05:11
    5. Methods of Table Creation 00:06:03
    6. Create Table Syntax 00:02:01
    7. Example Table Creations pt. 1 00:05:09
    8. Example Table Creations pt. 2 00:04:59
    9. Altering and Dropping Tables pt. 1 00:04:53
    10. Altering and Dropping Tables pt. 2 00:02:23
    11. What are Constraints? 00:05:41
    12. Creating, Changing and Dropping Constraints 00:06:21
    13. Types of Indexes pt. 1 00:07:37
    14. Types of Indexes pt. 2 00:04:10
    15. Creating, Altering and Dropping Indexes 00:05:37
    16. Sequence Counters 00:05:02
    17. Synonyms 00:01:03
    18. Views pt. 1 00:02:08
    19. Views pt. 2 00:01:47
    20. Metadata Views and Error Messages 00:06:02
  6. Users and Security
    1. Schemas, Users, Privileges and Roles pt. 1 00:04:38
    2. Schemas, Users, Privileges and Roles pt. 2 00:04:49
    3. Schemas, Users, Privileges and Roles pt. 3 00:07:39
    4. Types of Users 00:04:07
    5. Creating Users pt. 1 00:05:52
    6. Creating Users pt. 2 00:07:08
    7. Altering and Dropping Users 00:02:10
    8. Security 00:03:35
    9. System Privileges 00:04:26
    10. Object Privileges 00:00:58
    11. Granting and Revoking Privileges pt. 1 00:06:22
    12. Granting and Revoking Privileges pt. 2 00:02:13
    13. Grouping Privileges Using Roles pt. 1 00:06:59
    14. Grouping Privileges Using Roles pt. 2 00:02:17
    15. Setting Roles 00:01:35
  7. Retrieving Data from the Database
    1. The SELECT Statement pt. 1 00:03:14
    2. The SELECT Statement pt. 2 00:07:08
    3. The SELECT Statement pt. 3 00:03:19
    4. Types of SELECT Statement pt. 1 00:06:53
    5. Types of SELECT Statement pt. 2 00:01:45
    6. The DUAL Table pt. 1 00:03:00
    7. The DUAL Table pt. 2 00:03:15
    8. What is a NULL? 00:06:25
    9. Pseudo-Columns pt. 1 00:04:20
    10. Pseudo-Columns pt. 2 00:02:59
    11. More About SQL Plus Formatting pt. 1 00:04:16
    12. More About SQL Plus Formatting pt. 2 00:05:26
    13. More About SQL Plus Formatting pt. 3 00:06:10
  8. Oracle Built In Functions
    1. Types of Functions pt. 1 00:04:33
    2. Types of Functions pt. 2 00:04:38
    3. String Functions pt. 1 00:04:58
    4. String Functions pt. 2 00:07:43
    5. String Functions pt. 3 00:05:40
    6. Number Functions 00:05:52
    7. Date Functions pt. 1 00:04:11
    8. Date Functions pt. 2 00:04:24
    9. Other Functions pt. 1 00:02:56
    10. Other Functions pt. 2 00:05:54
    11. Datatype Conversion Functions pt. 1 00:05:22
    12. Datatype Conversion Functions pt. 2 00:02:08
    13. Custom Functions Using PL/SQL 00:00:46
  9. Filtering SELECT Statements
    1. The WHERE Clause 00:01:43
    2. Conditional Comparisons 00:01:21
    3. Using the WHERE Clause 00:01:27
    4. Using Logical Operators pt. 1 00:05:06
    5. Using Logical Operators pt. 2 00:01:37
    6. Using Conditional Comparisons pt. 1 00:05:30
    7. Using Conditional Comparisons pt. 2 00:06:02
  10. Sorting SELECT Statements
    1. The ORDER BY Clause 00:03:50
    2. Sorting Methods pt. 1 00:03:23
    3. Sorting Methods pt. 2 00:06:36
    4. Sorting Methods pt. 3 00:03:33
  11. Joining Multiple Tables
    1. What is a Join? 00:06:56
    2. Two Join Syntax Formats 00:04:14
    3. Types of Joins pt. 1 00:02:33
    4. Types of Joins pt. 2 00:05:55
    5. Types of Joins pt. 3 00:02:56
    6. Cross Join or Cartesian Product 00:04:04
    7. Natural or Inner Join pt. 1 00:05:34
    8. Change the Concerts Schema pt. 1 00:03:36
    9. Change the Concerts Schema pt. 2 00:04:45
    10. Outer Join pt. 1 00:03:49
    11. Outer Join pt. 2 00:06:33
    12. Self Join 00:01:25
    13. Equi-Joins, Anti-Joins and Range-Joins 00:03:08
    14. Mutable and Complex Joins 00:03:24
  12. Summarizing with GROUP BY
    1. What does GROUP BY Do? 00:05:24
    2. The GROUP BY Clause 00:03:36
    3. Types of Grouping Functions pt. 1 00:03:34
    4. Types of Grouping Functions pt. 2 00:04:50
    5. Special Behavior pt. 1 00:04:46
    6. Special Behavior pt. 2 00:04:45
    7. Summary Functions 00:04:49
    8. Statistical Functions 00:02:30
    9. Other Functions 00:04:01
    10. Filtering GROUP BY with the HAVING Clause 00:03:17
    11. Extending the GROUP BY Clause pt. 1 00:04:52
    12. Extending the GROUP BY Clause pt. 2 00:03:56
  13. Subqueries and Other Advanced Queries
    1. What is a Subquery? 00:01:20
    2. Types of Subqueries 00:06:57
    3. Comparison Conditions Revisited pt. 1 00:05:35
    4. Comparison Conditions Revisited pt. 2 00:04:51
    5. Comparison Conditions Revisited pt. 3 00:03:13
    6. Regular vs. Correlated Subqueries 00:01:15
    7. Nested Subqueries and Replacing Joins 00:06:27
    8. Where Can Subqueries be Used? 00:04:38
    9. Hierarchical Queries 00:04:52
    10. Set Operators and Composite Queries 00:04:15
  14. Oracle Data Manipulation Language (DML)
    1. What is DML? 00:03:39
    2. Adding Data with INSERT 00:04:46
    3. Multiple Table INSERT pt. 1 00:02:20
    4. Multiple Table INSERT pt. 2 00:07:04
    5. Changing Data with UPDATE pt. 1 00:04:33
    6. Changing Data with UPDATE pt. 2 00:05:51
    7. Remove Data with DELETE or TRUNCATE pt. 1 00:04:20
    8. Remove Data with DELETE or TRUNCATE pt. 2 00:04:22
    9. Merging Tables with MERGE pt. 1 00:06:50
    10. Merging Tables with MERGE pt. 2 00:00:57
    11. Transactional Control 00:03:56
    12. Locking and Visibility of Data Changes 00:04:57
    13. COMMIT vs ROLLBACK 00:04:27
  15. PL/SQL (Programming Language SQL)
    1. What is PL/SQL? 00:03:52
    2. Anonymous Procedures 00:02:56
    3. Modular Structure 00:04:28
    4. Named Procedures 00:07:05
    5. Functions 00:03:24
    6. Packages 00:07:10
    7. Triggers pt. 1 00:07:03
    8. Triggers pt. 2 00:05:07
    9. Variables and Types in PL/SQL pt. 1 00:05:12
    10. Variables and Types in PL/SQL pt. 2 00:05:06
    11. Objects and Object Datatypes 00:03:50
    12. More About Objects pt. 1 00:06:16
    13. More About Objects pt. 2 00:07:38
    14. Programming Control Structures 00:05:56
    15. Simple Database Access in PL/SQL 00:06:14
    16. Cursors and Implicit Cursors pt. 1 00:02:11
    17. Cursors and Implicit Cursors pt. 2 00:07:03
    18. Explicit Cursors pt. 1 00:03:21
    19. Explicit Cursors pt. 2 00:06:43
    20. Dynamic SQL 00:05:03
    21. Provided (DBMS_) Packages 00:01:59
  16. Credits
    1. About the Author 00:02:01