Notifications can be turned off anytime from settings.
Item(s) Added To cart
Qty.
Something went wrong. Please refresh the page and try again.
Something went wrong. Please refresh the page and try again.
Exchange offer not applicable. New product price is lower than exchange product price
Please check the updated No Cost EMI details on the payment page
Exchange offer is not applicable with this product
Exchange Offer cannot be clubbed with Bajaj Finserv for this product
Product price & seller has been updated as per Bajaj Finserv EMI option
Please apply exchange offer again
Your item has been added to Shortlist.
View AllYour Item has been added to Shopping List
View AllSorry! Introduction & Intermediate Oracle 11g Video Course By Easy Learning (DVD) is sold out.
You will be notified when this product will be in stock
Total Course Duration : 21.10 Hrs Learn Everything, Anywhere, Anytime
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)
India's Largest Online Education Marketplace
The images represent actual product though color of the image and product may slightly differ.
Register now to get updates on promotions and
coupons. Or Download App