fbpx
Oracle Database 12C SQL Online Training Syllabus:

Key Highlights

Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional.

Job Opportunities

Who Can Study?

Learn To:

Suggested Prerequisite

Oracle Database 12C SQL Online Training Syllabus:

• Identify the connection between an ERD and a Relational
Database
• Explain the relationship between a database and SQL
• Describe the purpose of DDL
• Describe the purpose of  DML
• Build a SELECT statement to retrieve data from an Oracle
Database table

• Use the ORDER BY clause to sort SQL query results
• Limit the rows that are retrieved by a query
• Use ampersand substitution to restrict and sort output at
runtime
• Use SQL row limiting clause

• Use various types of functions available in SQL
• Use character, number, and date and analytical
(PERCENTILE_CONT, STDDEV, LAG, LEAD) functions
in SELECT statements

• Describe various types of conversion functions that are
available in SQL
• Use the TO_CHAR, TO_NUMBER, and TO_DATE
conversion functions
• Apply general functions and conditional expressions in a
SELECT statement

• Describe the use of group functions
• Group data by using the GROUP BY clause
• Include or exclude grouped rows by using the HAVING
clause

• Describe the different types of joins and their features
• Use SELECT statements to access data from more than one
table using equijoins and nonequijoins
• Join a table to itself by using a self-join
• View data that generally does not meet a join condition by
using outer joins

• Define subqueries
• Describe the types of problems subqueries can solve
• Describe the types of subqueries
• Query data using correlated subqueries
• Update and delete rows using correlated subqueries
• Use the EXISTS and NOT EXISTS operators
• Use the WITH clause
• Use single-row and multiple-row subqueries

• Describe set operators
• Use a set operator to combine multiple queries into a single
query
• Control the order of rows returned

• Truncate data
• Insert rows into a table
• Update rows in a table
• Delete rows from a table
• Control transactions

• Describe data types that are available for columns
• Create a simple table
• Create constraints for tables
• Drop columns and set column UNUSED
• Create and use external tables

• Query various data dictionary views

• Differentiate system privileges from object privileges
• Grant privileges on tables and on a user
• Distinguish between privileges and roles

• Describe how schema objects work
• Create simple and complex views with visible/invisible
columns
• Create, maintain and use sequences
• Create and maintain indexes including invisible indexes and
multiple indexes on the same columns
• Perform flashback operations

• Describe the features of multitable INSERTs
• Merge rows in a table

Detailed Syllabus

Best-in-class content by leading faculty and industry leaders in the form of videos, cases, and projects

DOWNLOAD SYLLABUS




    Attend a 30-minute FREE class with our Top Trainers

    Our Trainers are Industrial Experience super-experts who simplify complex
    concepts visually through real examples

    BOOK FREE 30 MIN DEMO CLASS




      Enquiry for Batch & Seat Availability




        smeclabs online skill development training

        Everything You Need is Here

        Our Certification & Accreditation
        NSDC IISC SMEC Certifications

        The SMEClabs Advantage

        Strong hand-holding with dedicated support to help you master Oracle Database.
        ©  2001-2021 SMEClabs.  All Rights Reserved.