• MKCL
  • MKCL
  • BCA
  • BCA_TM
  • slider html5
  • design
21st Anniversary1 MKCL2 BCA3 BCA_TM4 BIS5 design6
slider html5 Paraminfo

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

Duration: 2 Months

Learning Objectives SQL
  • 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
PLSQL
  • 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