• Category: os and database
• Product Type: Online Course

Section 1: Oracle 9i Introduction 1 ER Modeling 2 Data Storage on Different Media 3 RDBMS and SQL 4 Select Statement with Column Alias and Arithmetic operators 5 Concatenation Operator, Literal, Eliminating Duplicate rows 6 SQL iSQLplus and Displaying Table Structure 7 Basic SQL Select Statements-Pr actical Examples 8 Writing Basic SQL Select Statements 9 Where Clause and Comparison Conditions 10  Comparison Conditions 11 Logical and Order by Clause 12 Restricting and Sorting Data-Practical Examples 01 13 Restricting and Sorting Data-Practical Examples 02 14 Basic SQL Select Statements 15 Basic SQL Select Statements Continue 16 Character Function 17 Case Manipulation Function 18 Number, Arithmatic and Date Functions 19 Arithmetic with Dates 20 Conversion and RR YY Functions 21 CHAR Function with Dates 22 Nesting and General Functions 23 COALESCE Function 24 Practical Assignments 25 Practical exercise 26 Conversion Function 27 Practical Demonstration 28 Additional Examples 29 Additional Examples of Salary   Section 2: Displaying and Aggregating Data, Subqueries 30 Cartesian Product, EquiJoin 31 Non Equi, Outer and Self Joins 32 SQL 1999 Complaint Joins 33 Creating Three-Way Joins with the ON Clause 34 Displaying Data from Multiple Tables 1 35 Displaying Data from Multiple Tables 2 36 Displaying Data from Multiple Tables 3 37 Create Query 01 38 Create Query 02 39 Group Functions Syntax 40 MIN and MAX Functions 41 Groups of Data and Having Clause 42 IIIegal Querise Using Group Function 43 Aggregating Data Using Group Functions-Practical Examples 44 Aggregating Data Using Group Functions-Additional Examples 01 45 Aggregating Data Using Group Functions-Additional Examples 02 46 Subqueries 47 The HAVING Clause with Subqueries 48 Subqueries-Practical Examples-1 49 Subqueries-Practical Examples-2 50 Subqueries-Additional Examples 1 51 Subqueries-Additional Examples 2   Section 3: Producing Readable Output, Manipulating Data 52 Substitution Variables 53 Verify,Column,Break,Ttitle,Btitle commands 54 Producing Readable Output with iSQL-Practical Examples 55 Producing Readable Output with iSQL- Examples 56 Objectives and Insert Statement 57 Update, Delete and Merge 58 The UPDATE Statement Syntax 59 Database Transaction 60 ROLLBACK Statements 61 Manipulating Data-Session 8 Practical 1 62 Manipulating Data-Session 8 Practical 2 63 Manipulating Data-Session 8 Practical 3 64 Manipulating Data-Additional Examples 01 65 Manipulating Data-Additional Examples 02 66 Database Objects, Create Table 67 Tables in the Oracle Database 68 Alter Table , Drop Table 69 The SET UNUSED Option 70 Creating and Managing Tables-Practical Examples 01 71 Creating and Managing Tables-Practical Examples 02 72 Creating and Managing Tables-Additional Examples 01 73 Creating and Managing Tables-Additional Examples 02 74 Constraints, Type of Constraints and Defining Constraints 75 The UNIQUE Constraint 76 Adding, Disabling , Enabling Viewing Constraints 77 Adding, Disabling , Enabling Viewing Constraints- summary 78 Including Constraints-Practical Examples 79 Including Constraints-Additional Examples   Section 4: Views, Database Objects, User Access 80 Creating, Modifying and Queering Views 81 Complex Views, Denying DML, Inline Views and Top n Analysis 82 Complex Views, Denying DML, Inline Views and Top n Analysis part summary 83 Creating Views-Practical Examples 84 Creating Views-Additional Examples 85 Creating Sequence, Modifying 86 NEXTVAL and CURRVAL Pseudo columns 87 Indexes and Synonyms 88 Other Database Objects-Practical Examples 89 Other Database Objects-Additional Examples 90 Controlling User Access 91 Granting System Privileges 92 Practice and Additional Practice Part-1 93 Practice and Additional Practice Part-2 94 SQL Workshop Examples 01 95 SQL Workshop Examples 02 96 SQL Workshop Examples 03 97 SQL Workshop Examples 04 98 SQL Workshop Examples 05 99 SQL Workshop Examples 06 100 SQL Workshop Examples 07 101 SQL Workshop Examples 08 102 Set Operators, Union, Union all, Intersect and Minus 103 Oracle Server and Set Operator 104 Oracle Server and Set Operator summary 105 Using SET Operators-Practical Examples 106 Using SET Operators-Additional Examples   Section 5: Date time functions, Advances DML Operations 107 Tz_offset, Current_date, Current_time  stamp, Local time stamp 108 Extract and Other timestamp data types 109 Extract and Other timestamp data types summary 110 Oracle9i Date time Functions-Practical Examples 01 111 Oracle9i Date time Functions-Practical Examples 02 112 Oracle9i Date time Functions-Additional Practice 113 Group, Having, Group by, Rollup and Cube 114 Grouping Functions, Grouping Set 115 Grouping Functions, Grouping Set, Composite columns and Concatenated grouping summary 116 Enhancements to the GROUP BY Clause 01 117 Enhancements to the GROUP BY Clause 02 118 Enhancements to the GROUP BY Clause-Additional Examples 119 Multiple-Column Sub queries 120 Column Comparisons 121 Correlated Sub queries 122 Correlated UPDATE 123 summary 124 Advanced Sub queries-Practical Examples 01 125 Advanced Sub queries-Practical Examples 02 126 Advanced Sub queries-Additional Example 01 127 Advanced Sub queries-Additional Example 02 128 Hierarchical Queries 129 Walking the Tree From the Bottom Up 130 Hierarchical Queries_summary 131 Hierarchical Retrieval-Practical Examples 132 Hierarchical Retrieval-Additional Examples 133 Review of the UPDATE Statement 134 Ranking Rows With the Level 135 Pivoting Insert, External Tables 136 Creating an External Table 137 create table summary ... Read More