Introduction to Oracle 11g

Auteur : Gavin Powell
Durée 11h5
Date 2012-04-28

Acheter cette formation en téléchargement pour 79,00 €
Abonnez vous à l'ensemble des formations en VOD pour 30 € TTC /an

⊞ à propos de ce cours

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.

Formation téléchargeable
FORMATION TÉLÉCHARGÉABLE 		Formation téléchargeable
VISIONNAGE ILLIMITÉ

⊞ Fiche Technique

Formateur : Gavin Powell
Langue : Anglais
Durée : 11h5
Nombre de séquences vidéo : 139 		SKU : 34312
Réf :
ISBN : 978-1-61866-042-8
Date de publication : 2012-04-28
Compatibilité : Apple Mac OS X (PPC & Intel) | Windows XP, Vista, 7, 8
Formations compatibles iPad en VOD et via l'application TutoShop sur l'AppStore.

Descriptif :

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.

⊞ Auteur

Gavin Powell

Author Gavin Powell spent 25 years as an IT professional in positions such as Oracle DBA, performance tuner, data architect, and developer. In the last 10 years he has branched out into technical writing (many titles in print) in between contract and consulting jobs. He also enjoys music, songwriting, performing, singing, playing too many instruments, home recording/producing, and studying music at Berklee.

Plan de formation

  • The Relational Database

    • (05:13)
      Metadata vs. Data
    • (05:36)
      Introducing Tables & Things
    • (01:55)
      Sample Models Used in this Course
    • (06:44)
      Relational Database Model
    • (05:36)
      Types of Databases (OLTP & DW)
    • (04:05)
      Normalization & Normal Forms pt. 1
    • (04:12)
      Normalization & Normal Forms pt. 2
    • (02:28)
      Custom vs. Off the Shelf

  • The Architecture of Oracle

    • (04:26)
      Commits & Rollbacks
    • (02:59)
      Multi-User Transactions
    • (04:12)
      General Oracle Architecture
    • (03:30)
      Datafiles & Tablespaces pt. 1
    • (05:01)
      Datafiles & Tablespaces pt. 2
    • (06:52)
      Processes & Memory
    • (05:38)
      Backup & Recovery
    • (05:09)
      Failover with Standby
    • (06:06)
      High Availability with RAC
    • (01:45)
      Adding ASM to Oracle RAC
    • (03:35)
      Replication

  • Working with Tables

    • (06:38)
      Generating Tables from a Data Model
    • (04:59)
      Types of Tables
    • (02:50)
      Methods of Table Creation
    • (04:54)
      Simple Datatypes
    • (06:27)
      Basic CREATE TABLE Syntax
    • (05:30)
      Some Advanced CREATE TABLE Syntax
    • (06:38)
      Inline Constraints
    • (03:24)
      Out of Line Constraints
    • (04:45)
      Naming Constraints & More Syntax
    • (03:52)
      Primary & Foreign Key Indexing
    • (03:24)
      Organizing My Data Model
    • (06:34)
      Unique Constraints / Non-FK Inversions
    • (06:22)
      Check Constraints & Default Values
    • (05:19)
      Global Temporary / Tablespaces / Logging
    • (04:04)
      Parallel Processing pt. 1
    • (04:35)
      Parallel Processing pt. 2
    • (03:33)
      Partitions / Externals / Compression
    • (03:55)
      Basic Dropping & Altering Tables
    • (06:29)
      Metadata Views pt. 1
    • (05:55)
      Metadata Views pt. 2

  • The SELECT Statement

    • (06:41)
      Basic SELECT Statement Syntax
    • (05:55)
      Updating Model & Importing Data
    • (03:36)
      The SELECT & FROM Clauses
    • (03:50)
      One / Many / All Columns
    • (04:00)
      Rename SELECT Columns
    • (04:36)
      Schema References
    • (06:22)
      Aliases
    • (06:10)
      Expressions
    • (06:07)
      Precedence & Operators pt. 1
    • (04:20)
      Precedence & Operators pt. 2
    • (04:55)
      The DUAL Table / Pseudocolumns / SYSDATE
    • (06:41)
      Using Functions
    • (06:26)
      The DISTINCT Clause
    • (05:50)
      Using NULLs in Oracle SQL
    • (06:53)
      UNION / INTERSECT / MINUS / Count Function

  • Restricting & Filtering Data

    • (05:01)
      WHERE Clause Syntax
    • (03:03)
      WHERE Clause Comparison Conditions
    • (05:29)
      Equality & Inequality
    • (05:37)
      IS [ NOT ] NULL
    • (06:24)
      Range & BETWEEN pt. 1
    • (05:52)
      Range & BETWEEN pt. 2
    • (06:54)
      LIKE Pattern Match
    • (06:42)
      ANY & SOME & ALL
    • (04:52)
      Logical / Compound Operators pt. 1
    • (05:06)
      Logical / Compound Operators pt. 2
    • (04:20)
      Logical / Compound Operators pt. 3
    • (06:43)
      IN List Comparisons
    • (06:17)
      Making Queries Run Faster pt. 1
    • (13:04)
      Making Queries Run Faster pt. 2
    • (03:55)
      Making Queries Run Faster pt. 3
    • (05:03)
      Making Queries Run Faster pt. 4

  • Sorting Data

    • (04:16)
      ORDER BY Clause Syntax
    • (04:16)
      Sorting by Column
    • (03:56)
      Sorting by Position
    • (06:26)
      Ascending & Descending Sorts
    • (02:37)
      NULLS First & NULLS Last
    • (02:45)
      Sorting by Expression

  • Single Row Functions

    • (05:39)
      Types of Functions
    • (06:15)
      Single Rows Functions in Manuals
    • (03:18)
      Using String Functions pt. 1
    • (05:17)
      Using String Functions pt. 2
    • (04:54)
      Using String Functions pt. 3
    • (06:11)
      Using Number Functions
    • (06:20)
      Using Date & Time Functions
    • (06:58)
      Using Conversion Functions
    • (06:55)
      Miscellaneous Functions

  • Joining Tables

    • (03:51)
      What is a Join?
    • (04:11)
      Join Clause Syntax
    • (03:47)
      Types of Joins
    • (05:23)
      Cross Joins
    • (05:09)
      Inner Joins pt. 1
    • (04:44)
      Inner Joins pt. 2
    • (05:35)
      Natural Joins
    • (05:24)
      Types of Outer Joins
    • (03:40)
      Left Outer Join
    • (04:16)
      Right Outer Join
    • (06:43)
      Full Outer Join
    • (03:44)
      Self Join
    • (05:45)
      Using Outer & Self Joins
    • (02:14)
      ANSI & Oracle Prop. Syntax

  • Aggregating Using GROUP BY

    • (03:22)
      GROUP BY Clause Syntax
    • (01:46)
      What GROUP BY Does
    • (04:03)
      Grouping Functions
    • (04:47)
      Summary Functions pt. 1
    • (04:11)
      Summary Functions pt. 2
    • (05:41)
      Statistical Functions
    • (05:02)
      Ranking Functions
    • (04:16)
      Analytic Functions
    • (02:47)
      Group Functions & Null Values
    • (03:14)
      Basic GROUP BY Clauses
    • (03:55)
      Filter Grouped Results with HAVING
    • (06:40)
      More Changes to the Shows Model
    • (06:44)
      The ROLLUP Clause
    • (04:29)
      The CUBE Clause
    • (02:31)
      The GROUPING SETS Clause
    • (04:19)
      Pivot Queries

  • Conclusion

    • (02:27)
      Course Wrap Up

  • Credits

    • (01:07)
      About the Author