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

Introduction to Oracle 11g

Video Description

This VTC course introduces some of the basics of Oracle Database including: installing Oracle on Windows and Linux, Oracle tools, some database modeling, underlying architecture (the files), creating and dropping tables, selecting data, filtering data, sorting data, built-in functions, joining tables, and aggregating with the GROUP BY clause. The course content is not focused on Oracle Certification but it will give you a good start towards coding SQL and will also get you started with basic installation and configuration. To begin learning today, simply click on the movie links.

Table of Contents

  1. Introduction
    1. Welcome to Oracle Database 00:00:42
    2. Useful Web Sites 00:04:24
    3. Choosing Your Profession 00:04:42
    4. About This Course 00:03:53
    5. Certification 00:04:57
  2. Oracle Installation & Configuration
    1. Using Amazon Web Services 00:00:51
    2. Downloading Oracle Software 00:03:21
    3. Preparing a Linux Server pt. 1 00:05:46
    4. Preparing a Linux Server pt. 2 00:06:32
    5. Install Oracle on Linux pt. 1 00:05:28
    6. Install Oracle on Linux pt. 2 00:05:41
    7. Install Oracle on Windows 00:03:27
    8. Install Oracle Client Software 00:02:26
    9. Creating an Oracle Database 00:06:20
    10. Download & Install Oracle Docs 00:04:41
    11. Finding Things in Oracle Docs 00:05:56
  3. Tools & Configuration
    1. Deinstalling & Reinstalling Oracle 00:05:40
    2. Rerunning netca / ntemgr / dbca 00:06:37
    3. Oracle Enterprise Manager (OEM) 00:04:11
    4. Using SQL*Plus 00:06:39
    5. Download & Install SQL Developer 00:04:51
    6. Using SQL Developer 00:06:04
  4. The Relational Database
    1. Metadata vs. Data 00:05:13
    2. Introducing Tables & Things 00:05:36
    3. Sample Models Used in This Course 00:01:55
    4. Relational Database Model 00:06:44
    5. Types of Databases (OLTP & DW) 00:05:36
    6. Normalization & Normal Forms pt. 1 00:04:05
    7. Normalization & Normal Forms pt. 2 00:04:12
    8. Custom vs. Off the Shelf 00:02:28
  5. The Architecture of Oracle
    1. Commits & Rollbacks 00:04:26
    2. Multi-User Transactions 00:02:59
    3. General Oracle Architecture 00:04:12
    4. Datafiles & Tablespaces pt. 1 00:03:30
    5. Datafiles & Tablespaces pt. 2 00:05:01
    6. Processes & Memory 00:06:52
    7. Backup & Recovery 00:05:38
    8. Failover with Standby 00:05:09
    9. High Availability with RAC 00:06:06
    10. Adding ASM to Oracle RAC 00:01:45
    11. Replication 00:03:35
  6. Working with Tables
    1. Generating Tables from a Data Model 00:06:38
    2. Types of Tables 00:04:59
    3. Methods of Table Creation 00:02:50
    4. Simple Datatypes 00:04:54
    5. Basic CREATE TABLE Syntax 00:06:27
    6. Some Advanced CREATE TABLE Syntax 00:05:30
    7. Inline Constraints 00:06:38
    8. Out of Line Constraints 00:03:24
    9. Naming Constraints & More Syntax 00:04:45
    10. Primary & Foreign Key Indexing 00:03:52
    11. Organizing My Data Model 00:03:24
    12. Unique Constraints / Non-FK Inversions 00:06:34
    13. Check Constraints & Default Values 00:06:22
    14. Global Temporary / Tablespaces / Logging 00:05:19
    15. Parallel Processing pt. 1 00:04:04
    16. Parallel Processing pt. 2 00:04:35
    17. Partitions / Externals / Compression 00:03:33
    18. Basic Dropping & Altering Tables 00:03:55
    19. Metadata Views pt. 1 00:06:29
    20. Metadata Views pt. 2 00:05:55
  7. The SELECT Statement
    1. Basic SELECT Statement Syntax 00:06:41
    2. Updating Model & Importing Data 00:05:55
    3. The SELECT & FROM Clauses 00:03:36
    4. One / Many / All Columns 00:03:50
    5. Rename SELECT Columns 00:04:00
    6. Schema References 00:04:36
    7. Aliases 00:06:22
    8. Expressions 00:06:10
    9. Precedence & Operators pt. 1 00:06:07
    10. Precedence & Operators pt. 2 00:04:20
    11. The DUAL Table / Pseudocolumns / SYSDATE 00:04:55
    12. Using Functions 00:06:41
    13. The DISTINCT Clause 00:06:26
    14. Using NULLs in Oracle SQL 00:05:50
    15. UNION / INTERSECT / MINUS / Count Function 00:06:53
  8. Restricting & Filtering Data
    1. WHERE Clause Syntax 00:05:01
    2. WHERE Clause Comparison Conditions 00:03:03
    3. Equality & Inequality 00:05:29
    4. IS [ NOT ] NULL 00:05:37
    5. Range & BETWEEN pt. 1 00:06:24
    6. Range & BETWEEN pt. 2 00:05:52
    7. LIKE Pattern Match 00:06:54
    8. ANY & SOME & ALL 00:06:42
    9. Logical / Compound Operators pt. 1 00:04:52
    10. Logical / Compound Operators pt. 2 00:05:06
    11. Logical / Compound Operators pt. 3 00:04:20
    12. IN List Comparisons 00:06:43
    13. Making Queries Run Faster pt. 1 00:06:17
    14. Making Queries Run Faster pt. 2 00:06:47
    15. Making Queries Run Faster pt. 3 00:03:55
    16. Making Queries Run Faster pt. 4 00:05:03
  9. Sorting Data
    1. ORDER BY Clause Syntax 00:04:16
    2. Sorting by Column 00:05:54
    3. Sorting by Position 00:03:56
    4. Ascending & Descending Sorts 00:06:26
    5. NULLS First & NULLS Last 00:02:37
    6. Sorting by Expression 00:02:45
  10. Single Row Functions
    1. Types of Functions 00:05:39
    2. Single Rows Functions in Manuals 00:06:15
    3. Using String Functions pt. 1 00:03:18
    4. Using String Functions pt. 2 00:05:17
    5. Using String Functions pt. 3 00:04:54
    6. Using Number Functions 00:06:11
    7. Using Date & Time Functions 00:06:20
    8. Using Conversion Functions 00:06:58
    9. Miscellaneous Functions 00:06:55
  11. Joining Tables
    1. What is a Join? 00:03:51
    2. Join Clause Syntax 00:04:11
    3. Types of Joins 00:03:47
    4. Cross Joins 00:05:23
    5. Inner Joins pt. 1 00:05:09
    6. Inner Joins pt. 2 00:04:44
    7. Natural Joins 00:05:35
    8. Types of Outer Joins 00:05:24
    9. Left Outer Join 00:03:40
    10. Right Outer Join 00:04:16
    11. Full Outer Join 00:06:43
    12. Self Join 00:03:44
    13. Using Outer & Self Joins 00:05:45
    14. ANSI & Oracle Prop. Syntax 00:02:14
  12. Aggregating Using GROUP BY
    1. GROUP BY Clause Syntax 00:03:22
    2. What GROUP BY Does 00:01:46
    3. Grouping Functions 00:04:03
    4. Summary Functions pt. 1 00:04:47
    5. Summary Functions pt. 2 00:04:11
    6. Statistical Functions 00:05:41
    7. Ranking Functions 00:05:02
    8. Analytic Functions 00:04:16
    9. Group Functions & Null Values 00:02:47
    10. Basic GROUP BY Clauses 00:03:14
    11. Filter Grouped Results with HAVING 00:03:55
    12. More Changes to the Shows Model 00:06:40
    13. The ROLLUP Clause 00:06:44
    14. The CUBE Clause 00:04:29
    15. The GROUPING SETS Clause 00:02:31
    16. Pivot Queries 00:04:19
  13. Conclusion
    1. Course Wrap Up 00:02:27
  14. Credits
    1. About the Author 00:01:07