Oracle Classes and Computer Training course in Kalyan-Param Computer Education.

Oracle certifications are tangible, industry-recognized credentials that can help you succeed in your IT career and provide measurable benefits to your employer. Oracle certifications are a reliable validation of training and experience that can accelerate your professional development, improve your productivity, and enhance your credibility. This course provides an exhaustive coverage of SQL, PL/SQL & Forms.

Oracle

• Introduction to DatabasesCODD'S Rules
• Data types and Creating Tables
• Oracle Data Manipulation Language (INSERT, UPDATE, DELETE, INSERT ALL, MERGE)
• Oracle Data Definition Language (CREATE, ALTER, DROP, TRUNCATE, RENAME)
• Oracle SQL SELECT Statement
• UNION, INTERSECT, MINUS Operators and Sorting Query Result
• Oracle SQL Functions (Character Functions, Math Functions, Aggregate Functions)
• Oracle Join Queries, (Inner Join, Outer Join, Self Join)
• GROUP BY Queries, SUB Queries, CUBE, ROLLUP Functions, WITH, CASE Operators
• Oracle Integrity Constraints (PRIMARY KEY, NOT NULL, CHECK, FOREIGN KEY, UNIQUE)
• Oracle Transaction Control Language (COMMIT, ROLLBACK,SAVEPOINT)
• Data Control Language (GRANT, REVOKE)
• Oracle Date Operators, Functions
• Managing Oracle Views
• Managing Oracle Sequences and Synonyms
• Managing Indexes and Clusters
• Oracle Table Partitioning and Creating Partitioned Tables
• Oracle Objects and Object Types

• Introduction to PL/SQL, Advantages of PL/SQL, PL/SQL Variables
• PL/SQL Constants
• PL/SQL Records
• PL/SQL Conditional Statements
• PL/SQL Iterative Statements
• PL/SQL Cursors
• PL/SQL Explicit Cursors
• PL/SQL Procedures
• PL/SQL Functions
• Parameters-Procedure, Function
• PL/SQL Exception Handling
• PL/SQL Triggers
• PLSQL-Packages

^Up