What you'll Learn

Home » Application Development » Oracle SQL Fundamentals​

Oracle SQL Fundamentals

Oracle SQL Fundamentals​ course is intended for those who wish to learn database and query concepts. This course gives Oracle introduction for beginners to write queries, sub queries, multiple-queries, controlling privileges, creating indexes and constraints, and altering existing schema objects.

Duration :  20 Hrs

Oracle SQL Fundamentals​
Home » Application Development » Oracle SQL Fundamentals​

Oracle SQL Fundamentals Course Content

  • Introduction about Database
    • Oracle Database features
    • Describe relational and Object relational database design
    • Oracle internet platform
    • System Development Life Cycle [SDLC]
    • Relational Database Management System [RDBMS]
  • Retrieving Data Using the SQL SELECT Statement
    • List the capabilities of SQL SELECT statements
    • Execute a basic SELECT statement
  • Restricting and Sorting Data
    • Limit the rows that are retrieved by a query
    • Sort the rows that are retrieved by a query
    • Use ampersand substitution to restrict and sort output at runtime
  • Using Single-Row Functions to Customize Output
    • Describe various types of functions available in SQL
    • Use character, number, and date functions in SELECT statements
  • Using Conversion Functions and Conditional Expressions
    • Describe various types of conversion functions that are available in SQL
    • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    • Apply conditional expressions in a SELECT statement
  • Reporting Aggregated Data Using the Group Functions
    • Identify the available group functions
    • Describe the use of group functions
    • Group data by using the GROUP BY clause
    • Include or exclude grouped rows by using the HAVING clause
  • Displaying Data from Multiple Tables
    • Write SELECT statements to access data from more than one table using equijoins and no equijoins
    • Join a table to itself by using a self-join
    • View data that generally does not meet a join condition by using outer joins
    • Generate a Cartesian product of all rows from two or more tables
  • Using Subqueries to Solve Queries
    • Define subqueries
    • Describe the types of problems that the subqueries can solve
    • List the types of subqueries
    • Write single-row and multiple-row subqueries
  • Using the Set Operators
    • Describe set operators
    • Use a set operator to combine multiple queries into a single query
    • Control the order of rows returned
  • Manipulating Data
    • Describe each data manipulation language (DML) statement
    • Insert rows into a table
    • Update rows in a table
    • Delete rows from a table
    • Control transactions
  • Using DDL Statements to Create and Manage Tables
    • Categorize the main database objects
    • Review the table structure
    • List the data types that are available for columns
    • Create a simple table
    • Explain how constraints are created at the time of table creation
    • Describe how schema objects work
  • Creating Other Schema Objects
    • Create simple and complex views
    • Create, maintain, and use sequences
    • Create and maintain indexes
    • Create private and public synonyms
Enquiry - Course Pages

Need more details?

Please submit below inquiry form


You may also interested in