Product Description
Total Course Duration : 21.10 Hrs
Video Lessons : 262 Tutorials
Introduction to Oracle 11g Course Duration:11.5 hrs / 139 tutorials
Welcome to Oracle Database(00:42)T Useful Web Sites(04:24)T Choosing Your Profession(04:42)T About this Course(03:53)T Certification(04:57)TOracle Installation & Configuration
Using Amazon Web Services(00:51)T Downloading Oracle Software(03:21)T Preparing a Linux Server pt. 1(05:46)T Preparing a Linux Server pt. 2(06:32)T Install Oracle on Linux pt. 1(05:28)T Install Oracle on Linux pt. 2(05:41)T Install Oracle on Windows(03:27)T Install Oracle Client Software(02:26)T Creating an Oracle Database(06:20)T Download & Install Oracle Docs(04:41)T Finding Things in Oracle Docs(05:56)TTools & Configuration
Deinstalling & Reinstalling Oracle(05:40)T Rerunning netca / ntemgr / dbca(06:37)T Oracle Enterprise Manager (OEM)(04:11)T Using SQL*Plus(06:39)T Download & Install SQL Developer(04:51)T Using SQL Developer(06:04)TThe Relational Database
Metadata vs. Data(05:13)T Introducing Tables & Things(05:36)T Sample Models Used in this Course(01:55)T Relational Database Model(06:44)T Types of Databases (OLTP & DW)(05:36)T Normalization & Normal Forms pt. 1(04:05)T Normalization & Normal Forms pt. 2(04:12)T Custom vs. Off the Shelf(02:28)TThe Architecture of Oracle
Commits & Rollbacks(04:26)T Multi-User Transactions(02:59)T General Oracle Architecture(04:12)T Datafiles & Tablespaces pt. 1(03:30)T Datafiles & Tablespaces pt. 2(05:01)T Processes & Memory(06:52)T Backup & Recovery(05:38)T Failover with Standby(05:09)T High Availability with RAC(06:06)T Adding ASM to Oracle RAC(01:45)T Replication(03:35)TWorking with Tables
Generating Tables from a Data Model(06:38)T Types of Tables(04:59)T Methods of Table Creation(02:50)T Simple Datatypes(04:54)T Basic CREATE TABLE Syntax(06:27)T Some Advanced CREATE TABLE Syntax(05:30)T Inline Constraints(06:38)T Out of Line Constraints(03:24)T Naming Constraints & More Syntax(04:45)T Primary & Foreign Key Indexing(03:52)T Organizing My Data Model(03:24)T Unique Constraints / Non-FK Inversions(06:34)T Check Constraints & Default Values(06:22)T Global Temporary / Tablespaces / Logging(05:19)T Parallel Processing pt. 1(04:04)T Parallel Processing pt. 2(04:35)T Partitions / Externals / Compression(03:33)T Basic Dropping & Altering Tables(03:55)T Metadata Views pt. 1(06:29)T Metadata Views pt. 2(05:55)TThe SELECT Statement
Basic SELECT Statement Syntax(06:41)T Updating Model & Importing Data(05:55)T The SELECT & FROM Clauses(03:36)T One / Many / All Columns(03:50)T Rename SELECT Columns(04:00)T Schema References(04:36)T Aliases(06:22)T Expressions(06:10)T Precedence & Operators pt. 1(06:07)T Precedence & Operators pt. 2(04:20)T The DUAL Table / Pseudocolumns / SYSDATE(04:55)T Using Functions(06:41)T The DISTINCT Clause(06:26)T Using NULLs in Oracle SQL(05:50)T UNION / INTERSECT / MINUS / Count Function(06:53)TRestricting & Filtering Data
WHERE Clause Syntax(05:01)T WHERE Clause Comparison Conditions(03:03)T Equality & Inequality(05:29)T IS [ NOT ] NULL(05:37)T Range & BETWEEN pt. 1(06:24)T Range & BETWEEN pt. 2(05:52)T LIKE Pattern Match(06:54)T ANY & SOME & ALL(06:42)T Logical / Compound Operators pt. 1(04:52)T Logical / Compound Operators pt. 2(05:06)T Logical / Compound Operators pt. 3(04:20)T IN List Comparisons(06:43)T Making Queries Run Faster pt. 1(06:17)T Making Queries Run Faster pt. 2(13:04)T Making Queries Run Faster pt. 3(03:55)T Making Queries Run Faster pt. 4(05:03)TSorting Data
ORDER BY Clause Syntax(04:16)T Sorting by Column(04:16)T Sorting by Position(03:56)T Ascending & Descending Sorts(06:26)T NULLS First & NULLS Last(02:37)T Sorting by Expression(02:45)TSingle Row Functions
Types of Functions(05:39)T Single Rows Functions in Manuals(06:15)T Using String Functions pt. 1(03:18)T Using String Functions pt. 2(05:17)T Using String Functions pt. 3(04:54)T Using Number Functions(06:11)T Using Date & Time Functions(06:20)T Using Conversion Functions(06:58)T Miscellaneous Functions(06:55)TJoining Tables
What is a Join?(03:51)T Join Clause Syntax(04:11)T Types of Joins(03:47)T Cross Joins(05:23)T Inner Joins pt. 1(05:09)T Inner Joins pt. 2(04:44)T Natural Joins(05:35)T Types of Outer Joins(05:24)T Left Outer Join(03:40)T Right Outer Join(04:16)T Full Outer Join(06:43)T Self Join(03:44)T Using Outer & Self Joins(05:45)T ANSI & Oracle Prop. Syntax(02:14)TAggregating Using GROUP BY
GROUP BY Clause Syntax(03:22)T What GROUP BY Does(01:46)T Grouping Functions(04:03)T Summary Functions pt. 1(04:47)T Summary Functions pt. 2(04:11)T Statistical Functions(05:41)T Ranking Functions(05:02)T Analytic Functions(04:16)T Group Functions & Null Values(02:47)T Basic GROUP BY Clauses(03:14)T Filter Grouped Results with HAVING(03:55)T More Changes to the Shows Model(06:40)T The ROLLUP Clause(06:44)T The CUBE Clause(04:29)T The GROUPING SETS Clause(02:31)T Pivot Queries(04:19)TConclusion
Course Wrap Up(02:27)TCredits
About the Author(01:07)
Intermediate Oracle 11g Course Duration:10.5 hrs / 123 tutorials
Welcome to Intermediate Oracle(01:13)T Prerequisites for This Course(02:34)T About This Course(02:55)TSubqueries
What is a Subquery?(04:29)T Subquery Syntax(05:21)T Types of Subqueries(06:22)T Where Can Subqueries Be Used?(05:40)T Comparison Conditions pt. 1(03:54)T Comparison Conditions pt. 2(05:40)T Regular vs. Correlated Subqueries(05:19)T Using the WITH Clause(05:45)T Nested Semi Joins(06:45)TSpecialized Queries
Composite Query Syntax(04:18)T Using Composite Queries pt. 1(06:02)T Using Composite Queries pt. 2(02:26)T Hierarchical Queries(03:41)T Hierarchical Query Syntax(03:48)T Hierarchical Family Trees pt. 1(06:09)T Hierarchical Family Trees pt. 2(06:21)T Flashback Query Syntax(02:54)T Flashback Query Pseudocolumns(02:02)T Using Flashback Queries pt. 1(04:47)T Using Flashback Queries pt. 2(03:01)TExpressions and Regular Expressions
What an Expression Is(06:07)T Types of Expressions(01:42)T Expression Types Demo pt. 1(05:45)T Expression Types Demo pt. 2(04:37)T Expression Types Demo pt. 3(06:46)T Meta Characters(06:30)T Regular Expression Functions(05:01)T Using Regular Expression Patterns(06:41)T Check Constraint Regular Expressions(03:00)T Oracle Expression Filter(02:47)TChanging Tables
The ALTER TABLE Command(02:30)T Table Properties pt. 1(06:52)T Table Properties pt. 2(06:22)T Columns pt. 1(04:00)T Columns pt. 2(05:31)T Columns pt. 3(05:07)T Columns pt. 4(03:56)T Constraints Options(02:39)T Constraint States(06:44)T Renaming and Dropping Constraints(04:48)TChanging Data
What the DML Commands Are(03:04)T INSERT Statement Syntax(05:37)T Using INSERT pt. 1(03:38)T Using INSERT pt. 2(04:46)T Using INSERT pt. 3(05:58)T UPDATE Statement Syntax(02:01)T Using UPDATE(04:56)T DELETE and TRUNCATE Syntax(06:05)T Using DELETE and TRUNCATE(06:29)T MERGE Statement Syntax(03:46)T Using MERGE(05:59)T Transactional Control(06:26)T Demonstrating Transaction Control(05:29)TUsers and Security
Oracle Security pt. 1(06:02)T Oracle Security pt. 2(05:06)T Types of Users(06:10)T Create User Syntax pt. 1(05:46)T Create User Syntax pt. 2(04:13)T Using CREATE USER pt. 1(04:16)T Using CREATE USER pt. 2(03:50)T Alter and Drop User Syntax(04:26)T Using ALTER and DROP USER(05:56)T Oracle Power Users(06:59)T Resources and Profiles(01:41)T Privileges pt. 1(06:02)T Privileges pt. 2(05:41)T Granting and Revoking Privileges(05:57)T Using GRANT pt. 1(04:00)T Using GRANT pt. 2(03:07)T Using REVOKE(05:16)T Group Privileges Using Roles(03:08)T Setting Roles(01:41)T Metadata Views pt. 1(04:49)T Metadata Views pt. 2(03:26)TSpecialized Database Objects
Sequence Syntax(05:08)T What and Where and How of Sequences(03:30)T Using Sequences(06:25)T Synonym Syntax(04:31)T Using Synonyms(06:16)T Database Links(05:39)T Views and Materialized Views(06:46)T Using Views(04:23)T Metadata Views pt. 1(05:00)T Metadata Views pt. 2(06:02)TWorking with Indexes
Types of Indexes(04:24)T Index Attributes(06:09)T BTree Indexes(05:51)T Function-Based Indexes(04:49)T Bitmap Indexes(05:45)T Exotic Indexing(04:37)T Creating Indexes pt. 1(05:55)T Creating Indexes pt. 2(03:08)T Changing and Dropping Indexes(06:53)T Working with Indexes pt. 1(06:49)T Working with Indexes pt. 2(06:05)T Metadata Views(06:20)TPL/SQL
What PL/SQL Is pt. 1(03:47)T What PL/SQL Is pt. 2(06:02)T Why PL/SQL Is Programming(06:36)T Blocks & Exception Traps pt. 1(05:22)T Blocks & Exception Traps pt. 2(04:06)T Named Procedures pt. 1(03:52)T Named Procedures pt. 2(07:09)T Functions(06:02)T Triggers pt. 1(04:48)T Triggers pt. 2(05:25)T Triggers pt. 3(04:51)T Packages(06:08)T Variables and Datatypes pt. 1(06:26)T Variables and Datatypes pt. 2(02:47)T Programming Control Structures(04:56)T Simple PL/SQL Database Access(05:41)T Explicit Cursors(06:26)T Implicit Cursors pt. 1(05:18)T Implicit Cursors pt. 2(06:53)T Dynamic SQL pt. 1(06:35)T Dynamic SQL pt. 2(05:18)T Wrapping Up PL/SQL(04:11)TConclusion
Course Wrap Up(04:51)TCredits
About the Author(01:19)