Curriculum
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 Arithmatic operators
5 Concatination Operator,Literal, Eliminating Duplicate rows
6 SQL iSQLplus and Displaying Table Structure
7 Basic SQL Select Statements-Practical 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 Contraints
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 Quering 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 Pseudocolumns
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, Unionall, 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: Datetime functions, Advances DML Operations
107 Tz_offset,Current_date,Current_timestamp,Localtimestamp
108 Extract and Other timestamp data types
109 Extract and Other timestamp data types summary
110 Oracle9i Datetime Functions-Practical Examples 01
111 Oracle9i Datetime Functions-Practical Examples 02
112 Oracle9i Datetime Functions-Additional Practice
113 Group, Having, Group by, Rollup and Cube
114 Grouping Functions, Grouping Set
115 Grouping Functions, Grouping Set, Composit 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 Subqueries
120 Column Comparisons
121 Correlated Subqueries
122 Correlated UPDATE
123 summary
124 Advanced Subqueries-Practical Examples 01
125 Advanced Subqueries-Practical Examples 02
126 Advanced Subqueries-Additional Example 01
127 Advanced Subqueries-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
