Search This Blog

Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts

Sunday, December 4, 2016

Oracle Certified Associate Java SE 8 Programmer I (1Z0-808) Video Training DVD Rs 399/-



Duration : 18 hours
Skill Level :Beginner to Intermediate

Table of Contents

Module 1: Before You Begin
Lesson 1: Why would I take the Oracle Certified Associate Java Programmer Exam
Lesson 2: The path to certification
Lesson 3: Preparation strategies
Lesson 4: Test Taking Strategies
    4.1: How to take exam questions
    4.2: Prepare for exam questions, confidence, and other resources
Module 2: Java Basics
Lesson 1: Define the scope of variables
    1.1: The meaning of scope, blocks, and curly braces
    1.2: Special cases of scope
Lesson 2: Define the structure of a Java class
    2.1: Java class files: Contents and naming rules
    2.2: Java classes: The class, member variables, methods and constructors
Lesson 3: Create executable Java applications with a main method; run a Java program from the command line; including console output
    3.1: Create executable Java applications with a main method
    3.2: Running Java from the command line
    3.3: Managing the classpath
    3.4: Working with console output
Lesson 4: Import other Java packages to make them accessible in your code
    4.1: About packages and their purpose
    4.2: Statement order, wildcard imports, importing sub-packages, and handling duplicate class names
Lesson 5: Compare and contrast the features and components of Java such as: platform independence, object orientation, encapsulation, etc.
    5.1: Understanding Java’s execution model
    5.2: Understanding the value of threading and garbage collection
    5.3: Understanding the value of object orientation and encapsulation
Module 3: Working with Java Data Types
Lesson 1: Declare and initialize variables (including casting of primitive data types)
    1.1: Using the general form of simple declarations
    1.2: Using the general form of initialized declarations
    1.3: Understanding integer primitive types, literal forms
    1.4: Understanding floating point primitive types, literal forms
    1.5: Understanding logical and character primitive types, literal forms
    1.6: Casting primitive types
Lesson 2: Differentiate between object reference variables and primitive variables
    2.1: Using the == operator with primitives and references
    2.2: Understanding method argument passing
Lesson 3: Know how to read or write to object fields
    3.1: Selecting a field from a reference expression
    3.2: Using "this" to access fields
    3.3: Code examples
Lesson 4: Explain an Object's Lifecycle (creation, "dereference by reassignment" and garbage collection)
    4.1: Understanding allocation and referencing
    4.2: Collecting garbage
Lesson 5: Develop code that uses wrapper classes such as Boolean, Double, and Integer
    5.1: Understanding and identifying wrapper objects, understanding autoboxing
    5.2: Investigating the API of Integer
Module 4: Using Operators and Decision Constructs
Lesson 1: Use Java operators; including parentheses to override operator precedence
    1.1: Using operators, operands, and expressions
    1.2: Using arithmetic operators + - * / %
    1.3: Using the plus operator with Strings
    1.4: Promoting operands
    1.5: Using increment and decrement operators
    1.6: Using shift operators
    1.7: Using comparison operators
    1.8: Using logical operators
    1.9: Using short-circuit operators
    1.10: Using assignment operators
    1.11: Understanding assignment compatibility
    1.12: Understanding other elements of expressions
    1.13: Using parentheses and operator precedence
Lesson 2: Test equality between Strings and other objects using == and equals ()
    2.1: Understanding the meaning of == and the intended meaning of equals ()
    2.2: Determining if equals() is implemented, and implementing equals()
Lesson 3: Create if and if/else and ternary constructs
    3.1: Understanding the basic form of if and if/else
    3.2: Using braces with if/else. Effect of "else if"
    3.3: Understanding the if / else if / else structure
    3.4: Using the ternary operator
Lesson 4: Use a switch statement
    4.1: Using the general form of switch, case, break, and default
    4.2: Code examples for the general form of switch
    4.3: Understanding break
    4.4: Identifying switchable types
Module 5: Creating and Using Arrays 
Lesson 1: Declare, instantiate, initialize and use a one-dimensional array
    1.1: Understanding simple array declarations, and variables of array type
    1.2: Instantiating an array, array length
    1.3: Initializing arrays by iteration, array indexes
    1.4: Using a combined declaration and initialization of arrays
    1.5: Using immediate array creation not in a declaration
    1.6: Initializing arrays by copying
Lesson 2: Declare, instantiate, initialize and use multi-dimensional array
    2.1: Declaring multi-dimensional arrays
    2.2: Using immediate initialization of multi-dimensional arrays
    2.3: Using iterative initialization of multi-dimensional arrays
    2.4: Code examples for multi-dimensional arrays
Module 6: Using Loop Constructs
Lesson 1: Create and use while loops
    1.1: Creating and using while loops
    1.2: Code examples of the while loop
Lesson 2: Create and use for loops including the enhanced for loop
    2.1: Understanding the simple use of the for loop
    2.2: Understanding the initialization section of the for loop
    2.3: Understanding the test section of the for loop
    2.4: Understanding the increment section of the for loop
    2.5: Omitting sections of a for loop
    2.6: Code examples for basic for loops
    2.7: Understanding the simple use of the enhanced for loop
    2.8: Identifying the valid targets of the enhanced for loop
    2.9: Using the enhanced for loop with generic collections
    2.10: Code examples for enhanced for loops
Lesson 3: Create and use do/while loops
    3.1: Creating and using do/while loops
Lesson 4: Compare loop constructs
    4.1: Comparing while and do while loops
    4.2: Comparing while and simple for loops
    4.3: Comparing while and enhanced for loops working on Iterables
    4.4: Comparing while and enhanced for loops working on arrays
Lesson 5: Use break and continue
    5.1: Using break from a single loop
    5.2: Using continue in a single loop
    5.3: Using a labeled break from multiple loops
    5.4: Using a labeled continue from multiple loops
Module 7: Working with Methods and Encapsulation
Lesson 1: Create methods with arguments and return values including overloaded methods
    1.1: Creating Methods
    1.2: Code example for simple methods
    1.3: Understanding basic syntax of overloaded methods
    1.4: Understanding rules and guidance for using overloaded methods
    1.5: Code example for overloaded methods
    1.6: Investigating variable length argument lists
Lesson 2: Apply the static keyword to methods and fields
    2.1: Comparing class fields and object fields
    2.2: Using static on methods
    2.3: Code example
Lesson 3: Create and overload constructors; including impact on default constructors
    3.1: Creating and overloading constructors
    3.2: Differentiating between default and user defined constructors
Lesson 4: Apply access modifiers
    4.1: Using the access modifiers public and private
    4.2: Using default access and the protected modifier
Lesson 5: Apply encapsulation principles to a class
    5.1: Designing for encapsulation
    5.2: Implementing encapsulation
Lesson 6: Determine the effect upon object references and primitive values when they are passed into methods that change the values
    6.1: Changing values through method local variables
    6.2: Changing the value of method local variables
    6.3: Code example
Module 8: Working with Inheritance
Lesson 1: Describe inheritance and its benefits
    1.1: Understanding interface and implementation inheritance
    1.2: Basic coding of implementation inheritance
    1.3: Changing inherited behavior
    1.4: Code examples
    1.5: Philosophy and terminology of inheritance (Part 1)
    1.6: Philosophy and terminology of inheritance (Part 2)
Lesson 2: Develop code that demonstrates the use of polymorphism
    2.1: Understanding the concepts of polymorphism
    2.2: Code example
    2.3: Understanding the core terminology of polymorphism
    2.4: Understanding variable type and object type
    2.5: Determining object type
    2.6: Code examples
Lesson 3: Determine when casting is necessary
    3.1: Understanding the Liskov substitution principle and the "is a" relationship
    3.2: Recognizing impossible assignments
    3.3: Understanding casting with interface types in assignments
Lesson 4: Use super and this to access objects and constructors
    4.1: Understanding "this" for accessing object features
    4.2: Understanding "super" for accessing parent features
    4.3: Understanding "this()" for accessing overloaded constructors
    4.4: Understanding "super()" for accessing parent constructors
    4.5: Understanding the underlying principles of "this" and "super" for invoking other constructors
    4.6: Code examples
Lesson 5: Use abstract classes and interfaces
    5.1: Preventing instantiation
    5.2: Marking behaviors abstract
    5.3: Understanding the rules about abstract classes and methods
    5.4: Understanding and defining interfaces
    5.5: Implementing and using interfaces
    5.6: Code example for interfaces
    5.7: Understanding the rules about interfaces
    5.8: Understanding static and default methods
Module 9: Handling Exceptions
Lesson 1: Differentiate among checked exceptions, RuntimeExceptions and Errors
    1.1: Understanding exception types
Lesson 2: Create a try-catch block and determine how exceptions alter normal program flow
    2.1: Coding try and catch
    2.2: Passing an exception to our caller
    2.3: Using finally to clean up resources
    2.4: Using the try with resources mechanism
    2.5: Code example for try / catch / finally
    2.6: Code example for try with resources
Lesson 3: Describe the advantages of Exception handling
    3.1: Investigating the philosophy of the exception mechanism
Lesson 4: Create and invoke a method that throws an exception
    4.1: Handling exceptions thrown by called code
    4.2: Code example 
Lesson 5: Recognize common exception classes and categories (such as NullPointerException, ArithmenticException, ArrayIndexOutOfBoundsException, ClassCastException)
    5.1: Common Exception Classes
Module 10: Working with Selected Classes from the Java API
Lesson 1: Manipulate data using the StringBuilder class and its methods
    1.1: Understanding the common StringBuilder constructors
    1.2: Using methods that modify StringBuilders
    1.3 Using methods that read and search in StringBuilders, and using methods that interact with the internal storage of StringBuilders
Lesson 2: Creating and manipulating Strings
    2.1: Creating Strings
    2.2: Understanding common String methods: Immutability
    2.3: Using common String methods
    2.4: Using common String methods to perform comparisons
Lesson 3: Create and manipulate calendar data using...
    3.1: Creating Time and Date Objects
    3.2: Changing Times and Dates
    3.3: Using the DateTimeFormatter
    3.4: Comparing and Ordering Times and Dates, and Using the Period class
Lesson 4: Declare and use an ArrayList of a given type
    4.1: Understanding the purpose and benefits of ArrayList
    4.2: Declaring and initializing an ArrayList
    4.3: Using common methods of, and uses of, ArrayList
    4.4: Investigating documentation and code for ArrayList
    4.5: Understanding simple generics with the ArrayList
Lesson 5: Write a simple Lambda expression that consumes a Lambda Predicate expression
    5.1: Understanding the Predicate interface
    5.2: Creating Lambda expressions for Predicates
    5.3: Reviewing the rules for Lambda expressions
Summary


======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 
======================================================================

Term

Shipping Banner

Tuesday, February 16, 2016

Learn Oracle PL/SQL Video Training Tutorial DVD



Total Duration : 13h 30m


PART-1

Level - Beginner
Duration - 4h 28m

Course Introduction5m 53s
Anonymous Blocks19m 44s
PL/SQL Commonly Used Datatypes1h 4m
Loops33m 10s
Conditional Execution24m 32s
Cursors54m 12s
Exceptions29m 40s
Debugging36m 47s

PART-2

Level - Intermediate
Duration - 5h 10m

Overview8m 17s
Procedures39m 54s
Functions33m 11s
Parameters in Procedures & Functions49m 34s
Local Subprograms18m 26s
Package Specification28m 42s
Package Body48m 33s
Calling Functions from SQL31m 14s
Roles & Privileges With Subprograms52m 28s

PART-3

Level - Intermediate
Duration- -4h 1m

Introduction6m 30s
Transaction Management in PL/SQL50m 9s
Autonomous Transactions27m 36s
Native Dynamic SQL58m 47s
Dynamic SQL Using DBMS_SQL1h 1m
Debugging PL/SQL Code37m 22s

======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 
======================================================================

Term

Shipping Banner

Learn Oracle 11g , Real Application Clusters & Application Express Video Training DVD Rs 399/-





Total Duration 21.5 hours

245 Video Lessons


Course 01- Oracle 11g Video Training


Duration: 8 hours 

120 Video Lessons


01. Introduction
02. The Technology - OS, Middleware, And Hardware
03. The Technology - Database
04. Database Architecture
05. Storage
06. Database Structures
07. Oracle IDEs
08. Structured Query Language
09. PL/SQL
10. XML
11.Analysis Tasks With Oracle Data Modeler
12. Database Tasks
13.Data Import/Export
14. Database Security
15. Very Large Databases



Course 02-Oracle 11g Real Application Clusters Video Training

Duration: 8.15 hours

68 Video Lessons

01. Oracle Real Application Cluster Overview
02. RAC System Requirements
03. Establish User Equivalence
04. Install Grid Infrastructure Software
05. Identify Voting Disk And OCR
06. Install ASM And Configure Grid Infrastructure Software
07. Install The Database
08. Create Disk Groups
09. RAC Listener
10. Use SRVCTL
11. RAC Components
12. Backup RAC With RMAN
13. Tuning RAC
14. Identify The RAC Services
15. Configure Transaction Application Failover
16. RAC Diagnostics
17. RAC And Grid
18. Shared Devices
19. RAC And Tools
20. RAC Utilities
21. RAC Architecture


Course 03-Oracle Application Express Video Training

Duration: 5.25 hours 

61 Video Lessons

01. Apex - Installation And Administration
02. Apex Basics - Applications, Pages And Regions
03. Apex Regions - Forms, Reports, Charts And More
04. User Interface, Templates And Themes
05. Creating Mobile Applications
06. Apex Advanced Topics - Security, Performance And Team Development
07. Conclusion



======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 
======================================================================

Term


Shipping Banner

Wednesday, October 15, 2014

Introduction & Intermediate Oracle 11g Video Course DVD Rs 400/-


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)

======================================================================

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

=======================================================================


Payment mode : CASH ON DELIVERY , Pay on my account ,Buying via ebay or ShopClues


Shipping : By Courier through all over India


Shipping charge : Rs 50/- Flat Rate shipping anywhere in India


You can get with in two days

Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDVDs

Tuesday, July 8, 2014

Learn Oracle Database 12c Video Training Course DVD Rs 300/-







Duration: 11.25 hours - 104 tutorial videos

Table of Contents Course

01. Introduction
What You Should Expect From This Course
About The Author
What is Oracle?
0104 How To Access Your Working Files

02. The Oracle Technology Family
Hardware
Operating Systems
Virtualization
Middleware And Java

03. Oracle Database Technology
What Is A Database?
Oracle RDBMS
Oracle Database Server Editions
Oracle Database Server Versioning
Oracle Database Options
Software
Documentation
SQL Developer

04. Database Architecture
0401 The Oracle RDBMS - Instance And Database
0402 The Instance - Background Memory Processes
0403 The Instance - System Global Area
0404 The Instance - Program Global Area
0405 The Database - Core Datafiles
0406 The Redo Architecture
0407 Real Application Clusters
0408 Container Databases
0409 Pluggable Databases

05. Installing The Oracle Software
0501 Planning An Installation
0502 The Oracle Universal Installer
0503 Installing The Software - Part 1
0504 Installing The Software - Part 2

06. Creating An Oracle Database
0601 Planning Database Creation
0602 Running NETCA And DBCA
0603 Stepping Through Database Creation - Part 1
0604 Stepping Through Database Creation - Part 2
0605 Stepping Through Database Creation - Part 3
0606 Setting Up The SQL Developer

07. Structured Query Language (SQL)
0701 What Is SQL?
0702 Select
0703 Insert
0704 Update
0705 Deletes
0706 Joins
0707 Single Row Functions
0708 Data Aggregation
0709 Optimizer And Execution Plans
0710 Transactions And Concurrency

08. PL And SQL
0801 What Is PL And SQL?
0802 Anonymous Blocks
0803 Procedures
0804 Functions
0805 Packages
0806 Object Types

09. Oracle Storage Structures
0901 Blocks
0902 Extents
0903 Segments
0904 Datafiles
0905 Smallfile Tablespaces
0906 Bigfile Tablespaces
0907 Automatic Storage Management - ASM

10. Database Objects
1001 Tables
1002 Partitions
1003 Temporary Tables
1004 B-tree Indexes
1005 Bitmap Indexes
1006 Index Organized Tables
1007 Function Based Indexes
1008 Views
1009 Primary And Unique Keys
1010 Foreign Keys
1011 Check Constraints
1012 Synonyms
1013 Sequences

11. Database Security
1101 Principles Of Database Security
1102 Oracle Schema Based Approach
1103 Creating And Dropping Users
1104 System Privileges
1105 Object Privileges
1106 Roles
1107 Profiles
1108 Auditing

12. Database Administrative Tasks
1201 Instance Startup
1202 Instance Shutdown
1203 Parameter File
1204 Modifying Parameters
1205 The Data Dictionary
1206 Password File
1207 ADRCI
1208 Alert Log And Trace Files
1209 Memory Management
1210 Monitoring Sessions
1211 Monitoring Space Usage

13. Database Backup And Recovery
1301 Backup And Recovery Concepts
1302 RMAN Backups
1303 RMAN Incremental Backups
1304 RMAN Complete Recovery
1305 RMAN Incomplete Recovery
1306 RMAN Backup Maintenance

14. Data Migration
1401 SQL Loader
1402 External Tables
1403 Data Pump Export
1404 Data Pump Import

15. Oracle Networking
1501 Understanding Oracle Connections
1502 Networking Configuration Files
1503 Listener Control

16. Conclusion
1601 Wrap-Up And Review




_________________________________________________________________

This DVDs are only suitable for a PC/laptop/Mac; it WILL NOT play on a TV 

_________________________________________________________________


VLC Player, Flash Player and Other Video Tools Also Provided in this Course DVD






Any Advanced Graphic Design Software Tutorials, IT Software Tutorials, Multimedia  Software Tutorials, All Engineering purpose Software Tutorials & All Software Tutorials Available

For more details

Email : digitalcollections4u@gmail.com
https://www.facebook.com/TutorialsDvDs