Webfire Themes Weebly Templates
    Mapple Jaipur
    info@mapple.ac.in
        mapple.edusoft@gmail.com
    Call us :  8233-25-2525
                          8233-54-5555
    • Home
    • Profile
      • Meet the Team
      • Partner with us
      • Webmail
      • Career >
        • Code of Conduct
    • Services
    • Training
      • Online Registration
      • IT Training >
        • Oracle Training >
          • Oracle 11g Database (DBA) >
            • 11g: Introduction to SQL
            • 11g: Administration Workshop 1
            • 11g: Administration Workshop 2
          • Oracle 10g Database (DBA) >
            • 10g: Introduction to SQL
            • 10g: Administration Workshop 1
            • 10g: Administration Workshop 2
          • Oracle 9i Database (DBA) >
            • 9i: Introduction to SQL
            • 9i: Administration Fundamentals 1
            • 9i: Administration Fundamentals 2
            • 9i: Performance Tuning
        • Big Data >
          • Introduction to Big Data
          • Big Data Essentials
        • Java Training >
          • Java Fundamentals SE6 (OCJA)
          • Java Fundamentals SE7 (OCJA)
          • Java Fundamentals SE8 (OCJA)
          • Java SE6 (OCJP)
          • Java SE7 (OCJP)
          • Java SE8 (OCJP)
          • Java SE 7 New Features
          • Java SE 8 New Features
          • Java EE6 Developing App (OCWCD)
          • Java EE6 Servlets & JSP (OCWCD)
          • Java EE6 EJB TECHNOLOGY (OCBCD)
        • PHP With MySQL >
          • PHP Training & MySQL
          • MySQL for Developers
        • Ethical Hacking
        • SEO Training
      • SSC Training >
        • SSC SYLLABUS TIER-I >
          • QUANTITATIVE APTITUDE
          • GENERAL MENTAL ABILITY
          • ENGLISH
          • COMPUTER AWARENESS
          • GENERAL KNOWLEDGE
    • Certification
    • Online Test
      • Admin
    • Alliances
    • Placement
    • Contact Us
      • Bank Details

    Oracle Database 9i: Introduction to SQL

    What 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.

    Why Oracle 9i training from Mapple Edusoft :
    • Official Course-ware from Oracle University.
    • Authorized Structured Oracle Training in Jaipur.
    • Highly Qualified Java Industry Experts as Trainer.
    • Hands on experience on Oracle Software.
    • Course Completion Certificate From Oracle University.
    • Discount Vouchers for International Exams.
    • 10 Full-length Online Mock Tests (Real-life Oracle® Exam) per Module.

    Prerequisites :
    • Familiarity with Data Processing Concepts and Techniques
    • Ability to use a graphical user interface (GUI)

    Course Topics :
    Introduction
    • Describing the Life Cycle Development Phases
    • 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
    Writing a Basic SQL Statement
    • Describing the SQL Select Capabilities
    • Executing a Basic Select Statement with the Mandatory Clauses
    • Differentiating Between SQL and iSQL*Plus Commands
    Restricting and Sorting Data
    • Limiting the Rows Retrieved by a Query
    • Sorting the Rows Retrieved by a Query
    Single Row Functions
    • Describing Various Types of Functions Available in SQL
    • 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
    Displaying Data from Multiple Tables
    • Writing SELECT Statements to Access Data from More Than One Table
    • Describing the Cartesian Product
    • Describing and Using the Different Types of Joins
    • Writing Joins Using the Tips Provided
    Aggregating Data by Using Group Functions
    • Identifying the Different Group Functions Available
    • Explaining the Use of Group Functions
    • Grouping Data by Using the GROUP BY Clause
    Writing Subqueries
    • Describing the Types of Problems That Subqueries Can Solve
    • 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
    Producing Readable Output with iSQL*Plus
    • Producing Queries That Require an Input Variable
    • Customizing the iSQL*Plus Environment
    • Producing More Readable Output
    • Creating and Executing Script Files
    Manipulating Data
    • Describing Each Data Manipulation Language (DML) Command
    • 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 and Managing Tables
    • Describing the Main Database Objects
    • Creating Tables
    • Describing the Oracle Data Types 
    • Altering Table Definitions
    • Dropping, Renaming, and Truncating Tables
    Including Constraints
    • Describing Constraints
    • Creating and Maintaining Constraints
    Creating Views
    • Describing Views and Their Uses
    • 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
    Other Database Objects
    • Creating, Maintaining, and Using Sequences
    • Creating and Maintaining Indexes
    • Creating Private and Public Synonyms
    Controlling User Access
    • Understanding the Concepts of Users, Roles, and Privileges
    • Granting and Revoking Object Privileges
    • Creating Roles and Granting Privileges to Roles
    • Creating Synonyms for Ease of Table Access
    SQL Workshop
    • Applying Techniques Learned in This Course
    • Preparing for Future Oracle Courses
    Using Set Operators
    • Describing the Set Operators
    • 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
    Oracle 9i Datetime Functions
    • Using DATETIME Functions
    • Using the NVL2 Function to Handle NULL Values
    Enhancements to the GROUP BY Clause
    • Using ROLLUP as an Extension to the GROUP BY Clause to Produce Subtotal 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 
    Advanced Subqueries
    • Multiple-Column Subqueries
    • 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
    Hierarchical Retrieval
    • Discussing the Benefits of the Hierarchical Query
    • 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
    Oracle9i Extensions to DML and DDL Statements
    • Discussing Multitable Inserts
    • Creating and Using External Tables
    • Naming the Index & Using the CREATE INDEX Command at the Time of Creating Primary Key  Constraint



    Certificate From Oracle University :
    Oracle Training in Jaipur - DBA, Developer - OCA -OCP
    Oracle Training in Jaipur - DBA, Developer - OCA -OCP
    Authorized Oracle 9i Training in Jaipur @ Mapple Edusoft

    OUR SERVICES : 

    IT Training & Skill Development
    International Certification
    Earn & Learn
    Software & Website Development
    Business Support Services
    Infrastructure leasing
    Franchise

    Company :

    About Us
    Contact Us
    Terms and Conditions
    Privacy Policy
    Disclaimer of Warranty

    Alliances :

    Oracle - Java - WDP
    EC - Council
    MeritTrac Services Pvt. Ltd
    Aspiring Minds
    Hughes Communication India Ltd.

    Contact US

    • Mapple Edusoft Private Limited
      78, 3rd Avenue, Goms Defence Colony,
      Vaishali Nagar, Jaipur - 302021
      Rajasthan
    • +91-8233-54-5555
      +91-8233-25-5555
    • info@mappleedusoft.com
    • www.mappleedusoft.com

    Back to top