Oracle 9i: Introduction to SQLWhat you will learn:
This class is applicable to Oracle 9i and Oracle 10g & 8i users. This course offers students an extensive introduction to data server technology.The class covers the concepts of both relational and object relational databases and the powerful SQL programming language. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. Students learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. Students will learn how to write (SQL and SQL*Plus)script files using the iSQL*Plus tool & how to generate report-like output.Demonstrations and hands-on practice reinforce the fundamental concepts. |
Students who can benefit from this course:
Technical Support Professionals
Database Administrators System Analysts Applications Developer Prerequisites: Familiarity with data processing concepts and techniques Ability to use a graphical user interface (GUI) Course Objectives:
Course Topics:
Defining a Relational Database Discussing the Theoretical, Conceptual, and Physical Aspects of a Relational Database Describing How a Relational Database Management System is used to Manage a Relational Database Describing tOracle Implementation of Both RDBMS & Object Relational Database Management System. Describing How SQL Is Used in the Oracle Product Set
Executing a Basic Select Statement with the Mandatory Clauses Differentiating Between SQL and iSQL*Plus Commands
Sorting the Rows Retrieved by a Query
Using a Variety of Character, Number, and Date Functions in SELECT Statements Explaining What the Conversion Functions Are and How They Are Used Using Control Statements
Describing the Cartesian Product Describing and Using the Different Types of Joins Writing Joins Using the Tips Provided
Explaining the Use of Group Functions Grouping Data by Using the GROUP BY Clause
Describing Subqueries Listing the Types of Subqueries Writing Single-Row and Multi-Row Subqueries Describing and Explaining the Behavior of Subqueries When NULL Values Are Retrieved
Customizing the iSQL*Plus Environment Producing More Readable Output Creating and Executing Script Files
Inserting Rows into a Table Updating Rows in a Table Deleting Rows from a Table Merging Rows into a Table Controlling Transactions Describing Transaction Processing Describing Read Consistency and Implicit and Explicit Locking
Creating Tables Describing the Oracle Data Types Altering Table Definitions Dropping, Renaming, and Truncating Tables
Creating and Maintaining Constraints
Creating a View Retrieving Data by Means of a View Inserting, Updating, and Deleting Data Through Views Dropping Views Altering the Definition of a View Inline Views Top 'N' Analysis
Creating and Maintaining Indexes Creating Private and Public Synonyms
Granting and Revoking Object Privileges Creating Roles and Granting Privileges to Roles Creating Synonyms for Ease of Table Access
Preparing for Future Oracle Courses
Obeying the Set Operators Rules and Guidelines Using a Set Operator to Combine Multiple Queries into a Single Subquery Controlling the Order of Rows Returned
Using the NVL2 Function to Handle NULL Values
Using CUBE as an Extension to the GROUP BY Clause to Produce Cross-Tabulation Values Using the GROUPING Function to Identify the Row Values Created by ROLLUP or CUBE Operators Using GROUPING SETS to Produce a Single Result Set That Is Equivalent to a UNION ALL Approach Using the WITH Clause
Writing a Subquery in the FROM Clause Writing and describing Correlated Subquery Using EXISTS and NOT EXISTS Operators Updating and Deleting Rows Using Correlated Subqueries Using Scalar Subqueries in SQL
Ordering the Rows Retrieved by a Query in a Hierarchical Manner Formatting Hierarchical Data so That It Is Easy to Read Excluding Branches from the Tree Structure
Creating and Using External Tables Naming the Index & Using the CREATE INDEX Command at the Time of Creating Primary Key Constraint |
Mapple Edusoft offers 45 Days Training / 6 Weeks Training / Android Training / Android Training in Jaipur / Asp.Net Training in Jaipur / Asp.Net with C# Training in Jaipur / B.Tech Training / BE Training / Best Institute Oracle Jaipur / Best Oracle Institute / Best Oracle Institute in Jaipur / C Training in Jaipur / C# Training in Jaipur / C++ Training in Jaipur / Embedded Systems Training in Jaipur / Four Weeks Training / Industrial Training / Institute for Oracle in Jaipur / IT Training / IT Training Institute / Java Training / Java Training in Jaipur / Major Project / MCA Training / MCA Training in Jaipur / Minor Project / Oracle Certification / Oracle Certification Center in Jaipur / Oracle Certification Course / Oracle Certification Course in Jaipur / Oracle Certification in Jaipur / Oracle Certification Jaipur / Oracle Classes in Jaipur / Oracle Coaching / Oracle Coaching Classes / Oracle Coaching Classes in Jaipur / Oracle Coaching in Jaipur / Oracle Coaching Jaipur / Oracle Course / Oracle Course in Jaipur / Oracle Course Jaipur / Oracle in Jaipur / Oracle Jaipur / Oracle Jaipur Institute / Oracle Training / Oracle Training Center / Oracle Training Center in Jaipur / Oracle Training in Jaipur / Oracle Training Institute / Oracle Training Institute in Jaipur / Oracle Training Institute Jaipur / Oracle Training Institutes / Oracle Training Institutes in Jaipur / Oracle Training Jaipur / PHP Training / PHP Training in Jaipur / Robotics Training in Jaipur / SEO Training in Jaipur / Six Weeks Training / Software Training / Software Training Institute / Summer Training / Summer Training for B.E / Summer Training for B.Tech Students / Summer Training for MCA / Summer Training in Jaipur / VLSI Training in Jaipur / .Net Training in Jaipur / 4 Weeks Training