What is Data? Collect some example of data for three kind business and organize it, What is Database?, Understanding DBMS and RDBMS, Top Database Service Provider Companies, About Oracle, Evolution of Oracle, About SQL*Plus, Data types in Oracle, Operators in Oracle, Database Properties
Sample Assignments and WorkoutsFetch the record using select statement, Fetch the particular column using select, select with where clause, select with having clause, select with group by clause, select with order by clause, select with using clause, Eliminate duplicate column data, Fetch data from two tables, Data filtering and sorting with in single table
Sample Assignments and WorkoutsCreating a table, Creating table from another table, Dropping a table using DROP command, Altering the column of a table, Modifying the column datatype in a table, Renaming the column of a table, Renaming an entire table, Creating views, About Global and Local Template Table
Sample Assignments and WorkoutsInsert data into a table, copy data from one table to another table, Copy a structure of a table, Different types of inserting row to an existing table, Updating records, Deleting a particular record from a table, Delete all the records from a table, Delete records under particular condition, Delete a table, Difference between Delete and Truncate command
Sample Assignments and WorkoutsCreate a column level constraints, Create a row level constraints, Add constraints to an existing table, Types of integrity constraints, Not null, Unique key, Primary key, Referential integrity, Check integrity, Enable and disable constraints
Sample Assignments and WorkoutsSingle row functions using dummy table, Types of single row functions, String functions, Date functions, Mathematical functions, Conversion functions, Special functions, Working with multi row functions
Sample Assignments and WorkoutsWorking with aggregate function: Count(), Sum(), Max(), Min(), Avg(), Working with group by and having clause, Difference between WHERE and HAVING clause
Sample Assignments and WorkoutsUnderstanding joins and its uses, Types of joins, Equi join, Non – equi join, Self join, Outer join, Left & Right outer join, Full outer join, Cross join, Anti Join, Semi Join
Sample Assignments and WorkoutsHow to use set operators in a single table content? Working with set operator types, UNION, UNION ALL, INTERSECT, MINUS, Working with pseudo columns
Sample Assignments and WorkoutsImportance of sub queries, Using different types of sub queries, Nested queries, Multi column sub queries
Sample Assignments and WorkoutsData query language using TCL, Data control language commands, Use of commit and rollback, Use of savepoint and set transaction, Use of system privileges to an user, Invoke and revoke object privilege, Create users and roles
Sample Assignments and WorkoutsCreating and working with Views, Working with Synonyms, Creating Index and clusters, Working with in materialized view, Understanding sequences and its types
Sample Assignments and WorkoutsIntroduction to PL/SQL, Advantages of PL/SQL, Data types in PL/SQL, Program structure of PL/SQL, Embedding SQL statements, Conditional Control: IF Statements, Conditional Control: CASE Statements, Iterative Control: Basic Loops, Iterative Control: WHILE and FOR Loops, Iterative Control: Nested Loops
Sample Assignments and WorkoutsWhat is cursor? Create a cursor, Create explicit cursor, Creation of *for loop* cursor, Understand cursor parameters, Uses of update clause, What is ref cursors? Uses of implicit cursors
Sample Assignments and WorkoutsWhat is an Exception? Describing Exception types, Handling system defined exceptions, Handling user defined exceptions
Sample Assignments and WorkoutsCreating procedures in PL/SQL, Working with procedure parameters, IN parameter, OUT parameter, INOUT parameter, How to create procedures with cursors, Procedures with return values
Sample Assignments and WorkoutsImportance of function, How to create functions, Difference between procedures and functions, inline functions
Sample Assignments and WorkoutsWhat is a Package? Uses of packages, About package specification and package body, Initialize and instantiated package, What are all the package state?
Sample Assignments and WorkoutsCreate triggers, Benefits of trigger, Trigger a trigger, Before trigger, After trigger, Drop trigger, Disable and enable trigger
Sample Assignments and WorkoutsWhat is collection? Uses of arrays, Using nested tables, Listing types of collection methods
Sample Assignments and WorkoutsAbout DBA Concepts and Varies Job Role regarding DBA
Project Work