SLR Infotech

Setup Menus in Admin Panel

SLR Infotech - Largest Industrial Training Company Since 20 Years

Authorised Oracle 12C DBA Training



    Introduction to SQL training helps you write subqueries, combine multiple queries into a single
    query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises.
    Learn To:

        • Understand the basic concepts of relational databases ensure refined code by developers.
        • Create reports of sorted and restricted data.
        • Run data manipulation statements (DML).
        • Control database access to specific objects.
        • Manage schema objects.
        • Manage objects with data dictionary views.
        • Retrieve row and column data from tables.
        • Control privileges at the object and system level.
        • Create indexes and constraints; alter existing schema objects.
        • Create and query external tables.

        Benefits to You:
        Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.


        • Course Objectives, Course Agenda and Appendixes Used in this Course
        • Overview of Oracle Database 12c and Related Products
        • Overview of relational database management concepts and terminologies
        • Introduction to SQL and its development environments
        • What is Oracle SQL Developer?
        • Starting SQL*Plus from Oracle SQL Developer
        • The Human Resource (HR) Schema
        • Tables used in the Course
        • Retrieving Data using the SQL SELECT Statement
        • Capabilities of the SELECT statement
        • Arithmetic expressions and NULL values in the SELECT statement
        • Column aliases
        • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
        • Use of the DESCRIBE command
        • Restricting and Sorting Data
        • Limiting the Rows
        • Rules of precedence for operators in an expression
          Substitution Variables
        • Using the DEFINE and VERIFY command
        • Using Single-Row Functions to Customize Output
        • Describe the differences between single row and multiple row functions
        • Manipulate strings with character function in the SELECT and WHERE clauses
        • Manipulate numbers with the ROUND, TRUNC and MOD functions
        • Perform arithmetic with date data
        • Manipulate dates with the date functions
        • Using Conversion Functions and Conditional Expressions
        • Describe implicit and explicit data type conversion
        • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
        • Nest multiple functions
        • Apply the NVL, NULLIF, and COALESCE functions to data
        • Use conditional IF THEN ELSE logic in a SELECT statement
        • Reporting Aggregated Data Using the Group Functions
        • Group Functions
        • Creating Groups of Data
        • Restricting Group Results
        • Displaying Data from Multiple Tables Using Joins
        • Introduction to JOINS
        • Types of Joins
        • Natural join
        • Self-join
        • Non equijoins
        • OUTER join
        • Using Subqueries to Solve Queries
        • Introduction to Subqueries
        • Single Row Subqueries
        • Multiple Row Subqueries
        • Using the SET Operators
        • Set Operators
        • UNION and UNION ALL operator
        • INTERSECT operator
        • MINUS operator
        • Matching the SELECT statements
        • Using ORDER BY clause in set operations
        • Managing Tables using DML statements
        • Data Manipulation Language
        • Database Transactions
        • Introduction to Data Definition Language
        • Data Definition Language
        • Introduction to Data Dictionary Views
        • Introduction to Data Dictionary
        • Describe the Data Dictionary Structure
        • Using the Data Dictionary views
        • Querying the Data Dictionary Views
        • Creating Sequences, Synonyms, Indexes
        • Overview of sequences
        • Overview of synonyms
        • Overview of indexes
        • Creating Views
        • Overview of views
        • Managing Schema Objects
        • Managing constraints
        • Creating and using temporary tables
        • Creating and using external tables
        • Retrieving Data by Using Subqueries
        • Retrieving Data by Using a Subquery as Source
        • Working with Multiple-Column subqueries
        • Using Scalar subqueries in SQL
        • Correlated Subqueries
        • Working with the WITH clause
        • Manipulating Data by Using Subqueries
        • Using Subqueries to Manipulate Data
        • Inserting by Using a Subquery as a Target
        • Using the WITH CHECK OPTION Keyword on DML Statements
        • Using Correlated Subqueries to Update and Delete rows
        • Controlling User Access
        • System privileges


    SLR Infotech Pvt Ltd
    Address: SCO134-136, Second Floor, Sector-34 A, Chandigarh,
    Call at: 9876543050, 9876543005  |  Whatsapp on: 9876543050
    Timings: Open 8am – 8pm
    Weekdays: Mon-Sat

    Course Reviews


    • 1 stars0
    • 2 stars0
    • 3 stars0
    • 4 stars0
    • 5 stars0

    No Reviews found for this course.

    • 1 week, 3 days

    Why SLR Infotech ?

    • Certificate from ISO Certified Company.
    • Demo classes before joining.
    • Flexible timings from 8.00AM-8.00 PM.
    • 100% Practical Classes.
    • Small batch size and 2 hours class daily.
    • Expert & Certified Faculty.
    • Live Projects With Financial Assistance.
    • Leaders in Education Since 20 Years.
    • Trained Over 2 Lakh Students.
    • Industrial Training Certificate From Software Development Company.
    • Professional help after training and placement.


    About SLR Infotech

    SLR Infotech Pvt. Ltd. is one of the leading Training and Consultancy Company who provides complete internet solutions including php development, internet marketing, search engine optimization and content development.

    Follow Us

    All rights reserved.