Oracle Course Overview
Oracle is one of the biggest database technology assets in the world. NareshIT provides enough knowledge on Oracle by highly experienced and real-time professionals and also various prestigious and worthy Oracle Certification courses in India at different metro locations for students, freshers, employees and professionals who want to lead the IT industry. You can register for Oracle Training and opt from a wide range of Oracle Training Courses at Naresh i Technologies in India. Oracle Training Course Prerequisites Computer Fundamentals, Windows Operating System Basic knowledge of database can be much more useful Oracle Training Course Objectives Create Database tables. Manage Database objects. Access and manipulate data in the Database using SQL statements. Control user access to data. Data Managing Working with Databases Oracle Training Course Duration Normal Track: 60 Working days, daily 1.30 Hours Fast Track: 45 Working days, daily 2.00 Hour
Oracle Training Content Introduction to DBMS Approach to Data Management Introduction to prerequisites File and Filesystem Disadvantages of file Review of Database Management Terminology Database Models Hierarchal Model Network Model Relational Model Introduction to RDBMS Feature of RDBMS Advantages of RDBMS over FMS ad DBMS The 12 rules (E.F Codd’s Rules –RDBMS) Need for Database Design Support of Normalization Process for Data
Management Client-Server Technology Oracle Corporation Products Oracle Versions About SQL&SQL*PLUS Sub Language Commands Data Definition Language (DDL) Data Retrieval Language (DRL) Data Manipulation Language (DML) Transaction Control Language (TCL) Database Security and Privileges (DCL) Introduction to SQL Database Object Oracle Pre Defined Datatypes DDL Commands Create, Alter (add, modify, rename, drop)Columns, Rename, truncate, drop DML-Insert, update, delete DQL-SELECT Statements using WHEREclause Comparison and Conditional Operators
HTML
CSS
Java
Arithmetic and Logical Operators Set Operators (UNION, UNION ALL, INTERSECT, MINUS) Special Operators – IN (NOT IN), BETWEEN (NOT BETWEEN), LIKE (NOT LIKE), IS NULL (IS NOT NULL) Working with DML, DRL Commands Operators Support Built-in Functions Arithmetic Functions, Character Functions, Date Functions, Conversion Functions Aggregate Functions, OLAP Functions & General Functions Grouping the Result of a Query Using Group by and Having Clause of DRL Statement Using Order by clause Working with Integrity Constraints Importance of Data Integrity
Support of Integrity Constraints for Relating Table in RDBMS NOT NULL constraint UNIQUE constraint PRIMARY KEY constraint FOREIGN KEY constraint CHECK constraint Working with different types of Integrity Constraints REF constraint Understanding ON DELETE clause in referential integrity constraint Working with a composite constraint Applying DEFAULT option to columns Working with multiple constraints upon a column Adding constraints to a table Dropping of constraints Enabling / Disable constraints Querying for constraints information Querying Multiple Tables (Joins) Equi Join/Inner Join/Simple Join
Cartesian Join Non-Equi Join Outer Joins Self Join Working with Sub Queries Understanding the practical approach to Sub Queries/Nested Select/Sub Select/Inner Select/Outer Select What is the purpose of a Sub Query? Sub Query Principle and Usage Type of Sub Queries Single Row Multiple Row Multiple Column Applying Group Functions in Sub Queries The impact of Having Clause in Sub Queries IN, ANY/SOME, ALL Operators in Sub Queries PAIRWISE and NON PAIRWISE Comparison in Sub Queries Be … Aware of NULL’s Correlated Sub Queries Handling Data Retrieval with EXISTS and NOT EXISTS Operator
