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