Oracle SQL

Course Structure

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

We at Rolla Academy want to empower the students. This will eventually make them great assets for the organization they are working in or the ones they aim to work in the future. Our courses are student centric and so are our timings. We understand that the professionals have a busy schedule and thus we alter us according to them. Students are free to choose the timings for their classes. To attend the classes at your convenience, book your batch now.