Course Description

In this course on Oracle SQL Training, you will learn about Producing Readable Output with iSQL*Plus, Manipulating Data, Creating and Managing Tables, Including Constraints etc. The course starts from scratch and hence a beginner can also take and enjoy this course.

In this Training Bundle you will learn about 3 Major Concepts in about 300+ lectures

• Oracle SQL Training
• Oracle PLSQL Training
• Oracle Database Administration 1

Target Audience for Oracle 9i Course Bundle:

• Application Developers
• Database Administrators
• Developer
• Forms Developer
• Portal Developer
• System Analysts
• Technical Consultant

Curriculum

Section 1: Oracle SQL Training

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

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

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

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

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

Section 2: Online Oracle PLSQL Courses Training

138            Introduction

139            What is PLSQL

140            Advantages of PLSQL

141            Calling PLSQL‚ PLSQL Block Structure

142            Anonymous Blocks

143            Anonymous Blocks Execution

144            PLSQL Functions

145            Declaration with Initialization

146            Anonymous Blocks – User Inputs

147            Anonymous Blocks – Tempp Table

148            Anonymous Blocks – Datatype

149            Anonymous Blocks – Nesting of Structures

150         IF THEN ELSE Statement

151         IF THEN ELSEIF Statement

152         Loops In PLSQL Part 1

153         Loops In PLSQL Part 2

154         Loops In PLSQL Part 3

155         Loops In PLSQL Part 4

156         Loops In PLSQL Part 5

157         Loops In PLSQL Part 6

158         Loops In PLSQL Part 7

159         Loops In PLSQL Part 8

160         Loops In PLSQL Part 9

161         Sub Blocks In PLSQL Part 1

162         Sub Blocks In PLSQL Part 2

163         Sub Blocks In PLSQL Part 3

164            Cursors Part 1

165            Cursors Part 2

166            Cursors Part 3

167            Cursors Part 4

168            Cursors Part 5

169            Cursors Part 6

170            Cursors Part 7

171            Cursors Part 8

172            Cursors Part 9

173            Cursor Part 10

174            Cursor Part 11

175            Cursor Part 12

176            Cursor Part 13

177            Exceptions Part 1

178            Exceptions Part 2

179            Exceptions Part 3

180            Exceptions Part 4

181            Exceptions Part 5

182            Exceptions Part 6

183           Exceptions Part 7

184            Exceptions Part 8

185            Exceptions Part 9

186            Exceptions Part 10

187            Exceptions Part 11

188            Stored Procedures Part 1

189            Stored Procedures Part 2

190            Stored Procedures Part 3

191            Stored Procedures Part 4

192            Stored Procedures Part 5

193            Stored Procedures Part 6

194            Stored Functions Part 1

195            Stored Functions Part 2

196            Stored Functions Part 3

197            Stored Functions Part 4

198            Managing Subprograms Part 1

199            Managing Subprograms Part 2

200            Managing Subprograms Part 3

201            Managing Subprograms Part 4

202            Managing Subprograms Part 5

203            Packages Part 1

204            Packages Part 2

205            Packages Part 3

206            Packages Part 4

207            Packages Part 5

208            Packages Part 6

209            Packages Part 7

210            Packages Part 8

211            Managing LOBs Part 1

212            Managing LOBs Part 2

213            Managing LOBs Part 3

214            Triggers Part 1

215            Triggers Part 2

216            Triggers Part 3

217            Triggers Part 4

218            Triggers Part 5

219            Triggers Part 6

220            Triggers Part 7

221            Triggers Part 8

222            Triggers Part 9

223            Triggers Part 10

224            Triggers Part 11

225            Advance Triggers Concepts Part 1

226            Advance Triggers Concepts Part 2

Section 3: Oracle Database Administration 1

227             Introduction

228             Oracle Server, Instance and Database

229             SGA, Shared Pool, Library Cache

230             Redo Log Buffer, Large Pool and Java Pool

231             Program Global Area

232             Database Writer (DBWn),Log Writer (LGWR)System Monitor (SMON)

233             Checkpoint, Archiver

234             Processing SQL Statements

235             Checkpoint, Archiver and Logical Structure Summary

236             Getting Started with the Oracle Server

237             ?Database Administrator Users,SQLPlus

238             Oracle Enterprise Manager and Console

239             Managing an Oracle Instance

240             SPFILE spfileSID.ora

241             Starting up database, Alter database

242             Shutting Down Database

243             Managing and Organizing a Database

244             Using Password File Authentication & Creating a Database

245             Create Database Using DCA And Manually

246             Creating a Database using OMF, Troubleshooting and After Database Creation

247             Creating a Database 01

248             Creating a Database 02

249             Data Dictionary

250             Dynamic Performance Tables

241             Practical Examples session 5

252             Maintaining the Control File

253             Maintaining the Control File Count

254             Practical Examples Session 6

255             Maintaining Redo Log Files

256             Dropping Online Redo Log Files

257             Managing Online Redo Log Files

258             Practical Examples Session 7

259             Types of Tablespaces

260             Locally Managed Tablespaces

261             Undo, Temporary and Read Only Tablespace

262             Default Temporary Tablespace

263             Tablespace offline, Storage Settings and Resizing Tablespace

264             Resizing, Dropping and Obtaining Tablespace information

265             Managing Tablespaces and Datafiles-Practical 01

266             Managing Tablespaces and Datafiles-Practical 02

267             Types of Segments

268             Storage Clause Precedence

269             Non Standard Block Size, Database Block Contents

270             Manual Data block Management and Practical Examples

271             Managing Undo Data

272             Types of Undo Segments

273             Automatic Undo Management Altering an UNDO Tablespace

274             Automatic Undo Management Sizing an UNDO Tablespace

275             Practical Example Session 10

276             Storing User Data

277             Oracle Built-in Data Types

278            ROWID Format,Structure of a Row

279             Creating a Table

280             Truncating , Dropping Table

281             Dropping a Table

282             Practical Example Session 11

283             Btree Index

284             Bitmap Indexes

285             Creating Btree and Bitmap Index

286             Changing Storage Parameters for Indexes

287             Changing Storage Parameters for Indexes Count

288             Practical Examples Session 12

289             Types of Constraints , Constraints States

290             Types of Constraints , Constraints States Count

291             Defining Constraints

292             Enabling Constraints

293             Practical Examples Session 13

294             Profiles and Password Management

295             Profiles and Password Management Count

296             Alter, Drop Profile

297             Resource Plan Directives

298             Practical Examples Session 14

299             Users and Security

300             Creating a New User: Operating System Authentication

301             Practical Examples Session 15

302             Granting and Revoking System Privileges

Here is a sample for the course completion certificate which you will recieve after complete the course. This certificate is widely accepted across industries and will boost your chances to grab the job opportunities.

Mail us at: [email protected] with below details to receive your certificate:

• Name
• Course Name
• Date of Completion
• Address