
Oracle: Introduction to Oracle SQL and PL/SQL
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.
Course content
Welcome6 lessons
The Relational Database Model6 lessons
Oracle SQL and PL/SQL Tools7 lessons
The Architecture of Oracle3 lessons
Creating Database Objects20 lessons
- Oracle Simple Datatypes pt. 14:101 credit or ad
- Oracle Simple Datatypes pt. 25:001 credit or ad
- Oracle Complex and Object Datatypes3:221 credit or ad
- Types of Tables5:101 credit or ad
- Methods of Table Creation6:031 credit or ad
- Create Table Syntax2:001 credit or ad
- Example Table Creations pt. 15:091 credit or ad
- Example Table Creations pt. 24:591 credit or ad
- Altering and Dropping Tables pt. 14:531 credit or ad
- Altering and Dropping Tables pt. 22:231 credit or ad
- What are Constraints?5:401 credit or ad
- Creating, Changing and Dropping Constraints6:211 credit or ad
- Types of Indexes pt. 17:371 credit or ad
- Types of Indexes pt. 24:101 credit or ad
- Creating, Altering and Dropping Indexes5:361 credit or ad
- Sequence Counters5:021 credit or ad
- Synonyms1:021 credit or ad
- Views pt. 12:081 credit or ad
- Views pt. 21:471 credit or ad
- Metadata Views and Error Messages6:021 credit or ad
Users and Security15 lessons
- Schemas, Users, Privileges and Roles pt. 14:371 credit or ad
- Schemas, Users, Privileges and Roles pt. 24:491 credit or ad
- Schemas, Users, Privileges and Roles pt. 37:381 credit or ad
- Types of Users4:061 credit or ad
- Creating Users pt. 15:521 credit or ad
- Creating Users pt. 27:081 credit or ad
- Altering and Dropping Users2:091 credit or ad
- Security3:351 credit or ad
- System Privileges4:261 credit or ad
- Object Privileges0:581 credit or ad
- Granting and Revoking Privileges pt. 16:221 credit or ad
- Granting and Revoking Privileges pt. 22:131 credit or ad
- Grouping Privileges Using Roles pt. 16:591 credit or ad
- Grouping Privileges Using Roles pt. 22:161 credit or ad
- Setting Roles1:351 credit or ad
Retrieving Data from the Database13 lessons
- The SELECT Statement pt. 13:141 credit or ad
- The SELECT Statement pt. 27:081 credit or ad
- The SELECT Statement pt. 33:181 credit or ad
- Types of SELECT Statement pt. 16:531 credit or ad
- Types of SELECT Statement pt. 21:451 credit or ad
- The DUAL Table pt. 12:591 credit or ad
- The DUAL Table pt. 23:151 credit or ad
- What is a NULL?6:251 credit or ad
- Pseudo-Columns pt. 14:191 credit or ad
- Pseudo-Columns pt. 22:581 credit or ad
- More About SQL Plus Formatting pt. 14:151 credit or ad
- More About SQL Plus Formatting pt. 25:251 credit or ad
- More About SQL Plus Formatting pt. 36:101 credit or ad
Oracle Built In Functions13 lessons
- Types of Functions pt. 14:321 credit or ad
- Types of Functions pt. 24:371 credit or ad
- String Functions pt. 14:581 credit or ad
- String Functions pt. 27:421 credit or ad
- String Functions pt. 35:401 credit or ad
- Number Functions5:511 credit or ad
- Date Functions pt. 14:111 credit or ad
- Date Functions pt. 24:241 credit or ad
- Other Functions pt. 12:551 credit or ad
- Other Functions pt. 25:531 credit or ad
- Datatype Conversion Functions pt. 15:211 credit or ad
- Datatype Conversion Functions pt. 22:071 credit or ad
- Custom Functions Using PL/SQL0:461 credit or ad
Filtering SELECT Statements7 lessons
- The WHERE Clause1:421 credit or ad
- Conditional Comparisons1:201 credit or ad
- Using the WHERE Clause1:261 credit or ad
- Using Logical Operators pt. 15:061 credit or ad
- Using Logical Operators pt. 21:371 credit or ad
- Using Conditional Comparisons pt. 15:301 credit or ad
- Using Conditional Comparisons pt. 26:011 credit or ad
Sorting SELECT Statements4 lessons
Joining Multiple Tables14 lessons
- What is a Join?6:551 credit or ad
- Two Join Syntax Formats4:131 credit or ad
- Types of Joins pt. 12:321 credit or ad
- Types of Joins pt. 25:551 credit or ad
- Types of Joins pt. 32:551 credit or ad
- Cross Join or Cartesian Product4:041 credit or ad
- Natural or Inner Join pt. 15:341 credit or ad
- Change the Concerts Schema pt. 13:351 credit or ad
- Change the Concerts Schema pt. 24:451 credit or ad
- Outer Join pt. 13:491 credit or ad
- Outer Join pt. 26:331 credit or ad
- Self Join1:251 credit or ad
- Equi-Joins, Anti-Joins and Range-Joins3:071 credit or ad
- Mutable and Complex Joins3:241 credit or ad
Summarizing with GROUP BY12 lessons
- What does GROUP BY Do?5:251 credit or ad
- The GROUP BY Clause3:361 credit or ad
- Types of Grouping Functions pt. 13:341 credit or ad
- Types of Grouping Functions pt. 24:491 credit or ad
- Special Behavior pt. 14:461 credit or ad
- Special Behavior pt. 24:451 credit or ad
- Summary Functions4:491 credit or ad
- Statistical Functions2:301 credit or ad
- Other Functions4:001 credit or ad
- Filtering GROUP BY with the HAVING Clause3:171 credit or ad
- Extending the GROUP BY Clause pt. 14:521 credit or ad
- Extending the GROUP BY Clause pt. 23:561 credit or ad
Subqueries and Other Advanced Queries10 lessons
- What is a Subquery?1:201 credit or ad
- Types of Subqueries6:571 credit or ad
- Comparison Conditions Revisited pt. 15:341 credit or ad
- Comparison Conditions Revisited pt. 24:511 credit or ad
- Comparison Conditions Revisited pt. 33:131 credit or ad
- Regular vs. Correlated Subqueries1:151 credit or ad
- Nested Subqueries and Replacing Joins6:271 credit or ad
- Where Can Subqueries be Used?4:381 credit or ad
- Hierarchical Queries4:511 credit or ad
- Set Operators and Composite Queries4:141 credit or ad
Oracle Data Manipulation Language (DML)13 lessons
- What is DML?3:391 credit or ad
- Adding Data with INSERT4:451 credit or ad
- Multiple Table INSERT pt. 12:201 credit or ad
- Multiple Table INSERT pt. 27:031 credit or ad
- Changing Data with UPDATE pt. 14:321 credit or ad
- Changing Data with UPDATE pt. 25:511 credit or ad
- Remove Data with DELETE or TRUNCATE pt. 14:191 credit or ad
- Remove Data with DELETE or TRUNCATE pt. 24:231 credit or ad
- Merging Tables with MERGE pt. 16:501 credit or ad
- Merging Tables with MERGE pt. 20:571 credit or ad
- Transactional Control3:551 credit or ad
- Locking and Visibility of Data Changes4:571 credit or ad
- COMMIT vs ROLLBACK4:271 credit or ad
PL/SQL (Programming Language SQL)21 lessons
- What is PL/SQL?3:511 credit or ad
- Anonymous Procedures2:561 credit or ad
- Modular Structure4:271 credit or ad
- Named Procedures7:051 credit or ad
- Functions3:231 credit or ad
- Packages7:101 credit or ad
- Triggers pt. 17:021 credit or ad
- Triggers pt. 25:061 credit or ad
- Variables and Types in PL/SQL pt. 15:121 credit or ad
- Variables and Types in PL/SQL pt. 25:061 credit or ad
- Objects and Object Datatypes3:491 credit or ad
- More About Objects pt. 16:161 credit or ad
- More About Objects pt. 27:381 credit or ad
- Programming Control Structures5:551 credit or ad
- Simple Database Access in PL/SQL6:131 credit or ad
- Cursors and Implicit Cursors pt. 12:111 credit or ad
- Cursors and Implicit Cursors pt. 27:031 credit or ad
- Explicit Cursors pt. 13:201 credit or ad
- Explicit Cursors pt. 26:431 credit or ad
- Dynamic SQL5:021 credit or ad
- Provided (DBMS_) Packages1:581 credit or ad