Onlince Oracle Sql/pl Sql Classes-Fresh Batch Begins On 08/27Th

[satyatrainer]

[size=3][font=courier new,courier,monospace]Hello all,

This is Satya and I have total software experience of 4 years including 1.5 years as a corporate trainer in a reputed MNC. I am right now dealing online trainings for SQL/PLSQL (Oracle). [/font][/size]

[size=3][font=courier new,courier,monospace]I am starting a fresh batch for SQL/PLSQL course from [color=#0000cd][b]08/27/2012[/b].[/color] The class would be daily at [color=#0000cd][b]6 AM IST[/b][/color] for 1 hour to 1 hour and 15 mins of duration. [/font][/size]

[size=3][font=courier new,courier,monospace]You can surely join the demo class I would conduct on [color=#0000cd][b]08/25/2012 at 6 AM IST[/b][/color] to get more details into the course. Interested people please contact me on [b][color=#0000cd][email protected][/color][/b] to know details about demo class and course.[/font][/size]

[size=3][font=courier new,courier,monospace][b]Note:[/b] [color=#0000cd][b]The recording of the classes along with a detailed material will be provided at free of cost. I will also provide with some exercises after some significant topics to make learners have hands on practice.[/b][/color][/font][/size]

[size=3][font=courier new,courier,monospace][size=4][b]Course Content:[/b][/size][/font][/size]

[size=3][font=courier new,courier,monospace][b]SQL[/b][/font][/size][list]
[*][size=3][font=courier new,courier,monospace]Database Introduction[/font][/size]
[*][size=3][font=courier new,courier,monospace]DBMS[/font][/size]
[*][size=3][font=courier new,courier,monospace]Oracle Introduction[/font][/size]
[*][size=3][font=courier new,courier,monospace]SQL Introduction[/font][/size]
[*][size=3][font=courier new,courier,monospace]SELECT Command[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]Various types of SELECT queries.[/font][/size]
[*][size=3][font=courier new,courier,monospace]Arithmetic expressions, Column aliases, Literals, Concatenated columns[/font][/size]
[*][size=3][font=courier new,courier,monospace]Null values, NVL function[/font][/size]
[*][size=3][font=courier new,courier,monospace]Relational Operators[/font][/size]
[*][size=3][font=courier new,courier,monospace]Logical Operators[/font][/size]
[*][size=3][font=courier new,courier,monospace]SQL Operators[/font][/size]
[*][size=3][font=courier new,courier,monospace]Where clause, Distinct Clause, Order by clause[/font][/size]
[*][size=3][font=courier new,courier,monospace]Substitution Variables[/font][/size]
[*][size=3][font=courier new,courier,monospace]Single row functions[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]String Functions[/font][/size]
[*][size=3][font=courier new,courier,monospace]Arithmetic Functions[/font][/size]
[*][size=3][font=courier new,courier,monospace]DATE functions[/font][/size]
[*][size=3][font=courier new,courier,monospace]Conversion Functions[/font][/size]
[*][size=3][font=courier new,courier,monospace]Miscellaneous Functions[/font][/size]
[*][size=3][font=courier new,courier,monospace]User environment Functions[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]SET Operators[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]UNION[/font][/size]
[*][size=3][font=courier new,courier,monospace]UNION ALL[/font][/size]
[*][size=3][font=courier new,courier,monospace]INTERSECT[/font][/size]
[*][size=3][font=courier new,courier,monospace]MINUS[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]Multi row/Group functions[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]AVG, Count, Max, Min, Sum[/font][/size]
[*][size=3][font=courier new,courier,monospace]Group by clause, Having clause[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]Sub queries[/font][/size]
[*][size=3][font=courier new,courier,monospace]JOINS[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]CROSS JOIN[/font][/size]
[*][size=3][font=courier new,courier,monospace]INNER JOIN[/font][/size]
[*][size=3][font=courier new,courier,monospace]OUTER JOIN[/font][/size]
[*][size=3][font=courier new,courier,monospace]SELF JOIN[/font][/size]
[/list]
[/list][*][size=3][font=courier new,courier,monospace]DDL commands[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]CREATE[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]Data types[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]Character data types.[/font][/size]
[*][size=3][font=courier new,courier,monospace]Number Data types.[/font][/size]
[*][size=3][font=courier new,courier,monospace]Long Raw data types.[/font][/size]
[*][size=3][font=courier new,courier,monospace]Date and Time Data types.[/font][/size]
[*][size=3][font=courier new,courier,monospace]Large Object Data types.[/font][/size]
[/list]
[/list]
[/list]
[/list][list]
[*][size=3][font=courier new,courier,monospace]ALTER[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]ADD, MODIFY, DROP, CASCADE, ENABLE/DISABLE, SET UNUSED[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]DROP[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]Recycle bin concept and FLAHBACK, PURGE commands.[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]Integrity Constraints[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]Domain Integrity Constraints[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]NOT NULL, CHECK[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]Entity Integrity Constraints[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]UNIQUE, PRIMARY KEY[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]Referential Integrity Constraints[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]FOREIGN KEY[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]Column level Integrity Constraints vs Table level Integrity Constraints[/font][/size]
[*][size=3][font=courier new,courier,monospace]DEFAULT option[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]ON DELETE clause[/font][/size]
[/list][list]
[*][size=3][font=courier new,courier,monospace]DML commands[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]INSERT[/font][/size]
[*][size=3][font=courier new,courier,monospace]UPDATE[/font][/size]
[*][size=3][font=courier new,courier,monospace]DELETE[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]TRUNCATE command[/font][/size]
[*][size=3][font=courier new,courier,monospace]RENAME command[/font][/size]
[*][size=3][font=courier new,courier,monospace]TCL commands[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]COMMIT[/font][/size]
[*][size=3][font=courier new,courier,monospace]ROLLBACK[/font][/size]
[*][size=3][font=courier new,courier,monospace]SAVEPOINT[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]DCL commands[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]GRANT[/font][/size]
[*][size=3][font=courier new,courier,monospace]REVOKE[/font][/size]
[*][size=3][font=courier new,courier,monospace]ROLES[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]Other Database Objects[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]VIEWS[/font][/size]
[*][size=3][font=courier new,courier,monospace]INDEXES[/font][/size]
[*][size=3][font=courier new,courier,monospace]SEQUENCES[/font][/size]
[*][size=3][font=courier new,courier,monospace]SYNONYMS[/font][/size]
[*][size=3][font=courier new,courier,monospace]CLUSTERS[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]Data dictionary Views[/font][/size]
[*][size=3][font=courier new,courier,monospace]SQL * PLUS Commands[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]Eg: Set autocommit on, we will see all the other useful commands like this.[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]Report Generating Commands[/font][/size]
[list]
[*][size=3][font=courier new,courier,monospace]TITLE commands[/font][/size]
[*][size=3][font=courier new,courier,monospace]BREAK[/font][/size]
[*][size=3][font=courier new,courier,monospace]COLUMN[/font][/size]
[*][size=3][font=courier new,courier,monospace]COMPUTE[/font][/size]
[/list][*][size=3][font=courier new,courier,monospace]CLEAR command[/font][/size]
[/list]
[size=3][font=courier new,courier,monospace][b]PL/SQL[/b][/font][/size][list]
[*][size=3][font=courier new,courier,monospace]Introduction to PL/SQL[/font][/size]
[*][size=3][font=courier new,courier,monospace]Advantages of PL/SQL[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Block structure[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Variables[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Constants[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Conditional Statements[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Iterative Statements[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Records[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Implicit Cursors[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Explicit Cursors[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Procedures[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Functions[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Packages[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Exception Handling[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Triggers[/font][/size]
[*][size=3][font=courier new,courier,monospace]PL/SQL Arrays[/font][/size]
[/list]
[size=3][font=courier new,courier,monospace]The PLSQL would involve dealing a deep drive of all above topics I outlined above.[/font][/size]

[size=3][font=courier new,courier,monospace]The recording of the classes along with a detailed material will be provided at free of cost. I will also provide with some exercises after some significant topics to make learners have hands on practice.

Thank you for viewing my post and please contact me on [email protected].

Regards,
Satya[/font][/size]