
Introduction to Oracle 11g
by Gavin Powell
Start the free chapterThis 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.
Course content
Introduction5 lessons
Oracle Installation & Configuration11 lessons
- Using Amazon Web Services0:511 credit or ad
- Downloading Oracle Software3:211 credit or ad
- Preparing a Linux Server pt. 15:461 credit or ad
- Preparing a Linux Server pt. 26:321 credit or ad
- Install Oracle on Linux pt. 15:281 credit or ad
- Install Oracle on Linux pt. 25:411 credit or ad
- Install Oracle on Windows3:271 credit or ad
- Install Oracle Client Software2:261 credit or ad
- Creating an Oracle Database6:201 credit or ad
- Download & Install Oracle Docs4:411 credit or ad
- Finding Things in Oracle Docs5:561 credit or ad
Tools & Configuration6 lessons
The Relational Database8 lessons
- Metadata vs. Data5:131 credit or ad
- Introducing Tables & Things5:361 credit or ad
- Sample Models Used in this Course1:551 credit or ad
- Relational Database Model6:441 credit or ad
- Types of Databases (OLTP & DW)5:361 credit or ad
- Normalization & Normal Forms pt. 14:051 credit or ad
- Normalization & Normal Forms pt. 24:121 credit or ad
- Custom vs. Off the Shelf2:281 credit or ad
The Architecture of Oracle11 lessons
- Commits & Rollbacks4:261 credit or ad
- Multi-User Transactions2:591 credit or ad
- General Oracle Architecture4:121 credit or ad
- Datafiles & Tablespaces pt. 13:301 credit or ad
- Datafiles & Tablespaces pt. 25:011 credit or ad
- Processes & Memory6:521 credit or ad
- Backup & Recovery5:381 credit or ad
- Failover with Standby5:091 credit or ad
- High Availability with RAC6:061 credit or ad
- Adding ASM to Oracle RAC1:451 credit or ad
- Replication3:351 credit or ad
Working with Tables20 lessons
- Generating Tables from a Data Model6:381 credit or ad
- Types of Tables4:591 credit or ad
- Methods of Table Creation2:501 credit or ad
- Simple Datatypes4:541 credit or ad
- Basic CREATE TABLE Syntax6:271 credit or ad
- Some Advanced CREATE TABLE Syntax5:301 credit or ad
- Inline Constraints6:381 credit or ad
- Out of Line Constraints3:241 credit or ad
- Naming Constraints & More Syntax4:451 credit or ad
- Primary & Foreign Key Indexing3:521 credit or ad
- Organizing My Data Model3:241 credit or ad
- Unique Constraints / Non-FK Inversions6:341 credit or ad
- Check Constraints & Default Values6:221 credit or ad
- Global Temporary / Tablespaces / Logging5:191 credit or ad
- Parallel Processing pt. 14:041 credit or ad
- Parallel Processing pt. 24:351 credit or ad
- Partitions / Externals / Compression3:331 credit or ad
- Basic Dropping & Altering Tables3:551 credit or ad
- Metadata Views pt. 16:291 credit or ad
- Metadata Views pt. 25:551 credit or ad
The SELECT Statement15 lessons
- Basic SELECT Statement Syntax6:411 credit or ad
- Updating Model & Importing Data5:551 credit or ad
- The SELECT & FROM Clauses3:361 credit or ad
- One / Many / All Columns3:501 credit or ad
- Rename SELECT Columns4:001 credit or ad
- Schema References4:361 credit or ad
- Aliases6:221 credit or ad
- Expressions6:101 credit or ad
- Precedence & Operators pt. 16:071 credit or ad
- Precedence & Operators pt. 24:201 credit or ad
- The DUAL Table / Pseudocolumns / SYSDATE4:551 credit or ad
- Using Functions6:411 credit or ad
- The DISTINCT Clause6:261 credit or ad
- Using NULLs in Oracle SQL5:501 credit or ad
- UNION / INTERSECT / MINUS / Count Function6:531 credit or ad
Restricting & Filtering Data16 lessons
- WHERE Clause Syntax5:011 credit or ad
- WHERE Clause Comparison Conditions3:031 credit or ad
- Equality & Inequality5:291 credit or ad
- IS [ NOT ] NULL5:371 credit or ad
- Range & BETWEEN pt. 16:241 credit or ad
- Range & BETWEEN pt. 25:521 credit or ad
- LIKE Pattern Match6:541 credit or ad
- ANY & SOME & ALL6:421 credit or ad
- Logical / Compound Operators pt. 14:521 credit or ad
- Logical / Compound Operators pt. 25:061 credit or ad
- Logical / Compound Operators pt. 34:201 credit or ad
- IN List Comparisons6:431 credit or ad
- Making Queries Run Faster pt. 16:171 credit or ad
- Making Queries Run Faster pt. 213:041 credit or ad
- Making Queries Run Faster pt. 33:551 credit or ad
- Making Queries Run Faster pt. 45:031 credit or ad
Sorting Data6 lessons
Single Row Functions9 lessons
- Types of Functions5:391 credit or ad
- Single Rows Functions in Manuals6:151 credit or ad
- Using String Functions pt. 13:181 credit or ad
- Using String Functions pt. 25:171 credit or ad
- Using String Functions pt. 34:541 credit or ad
- Using Number Functions6:111 credit or ad
- Using Date & Time Functions6:201 credit or ad
- Using Conversion Functions6:581 credit or ad
- Miscellaneous Functions6:551 credit or ad
Joining Tables14 lessons
- What is a Join?3:511 credit or ad
- Join Clause Syntax4:111 credit or ad
- Types of Joins3:471 credit or ad
- Cross Joins5:231 credit or ad
- Inner Joins pt. 15:091 credit or ad
- Inner Joins pt. 24:441 credit or ad
- Natural Joins5:351 credit or ad
- Types of Outer Joins5:241 credit or ad
- Left Outer Join3:401 credit or ad
- Right Outer Join4:161 credit or ad
- Full Outer Join6:431 credit or ad
- Self Join3:441 credit or ad
- Using Outer & Self Joins5:451 credit or ad
- ANSI & Oracle Prop. Syntax2:141 credit or ad
Aggregating Using GROUP BY16 lessons
- GROUP BY Clause Syntax3:221 credit or ad
- What GROUP BY Does1:461 credit or ad
- Grouping Functions4:031 credit or ad
- Summary Functions pt. 14:471 credit or ad
- Summary Functions pt. 24:111 credit or ad
- Statistical Functions5:411 credit or ad
- Ranking Functions5:021 credit or ad
- Analytic Functions4:161 credit or ad
- Group Functions & Null Values2:471 credit or ad
- Basic GROUP BY Clauses3:141 credit or ad
- Filter Grouped Results with HAVING3:551 credit or ad
- More Changes to the Shows Model6:401 credit or ad
- The ROLLUP Clause6:441 credit or ad
- The CUBE Clause4:291 credit or ad
- The GROUPING SETS Clause2:311 credit or ad
- Pivot Queries4:191 credit or ad