DBA

DBA Fundamentals

Session: 1

  • Oracle Database Introduction & Basics of Tables
  • Setting up the Oracle SQL Development Environment (Mac and Windows)
  • Important: Prepare the Data in the Database

Session 2:

  • Single Table Queries (Exercise & Solutions in the lectures)
    • Oracle Exams and Certification Information
    • Retrieving Data using the SELECT Clause
    • Using the WHERE Clause in a Query
    • Combining WHERE, AND & OR with Operators
    • Query Filtering Continued BETWEEN, IN and NULL
    • Query Filtering Conditions & Operator Precedence
    • Ordering, Concatenating & Aliasing Query Results
  • Assignment 1: Practice with single table queries
  • Practice Test 1: Single Table Queries

Session 3:

  • Single Row Functions (Exercises and Solutions in the lectures)
    • Single Row Functions (SRF) & Using the Dual Table
    • Using Functions in WHERE and Character Based SRFs
    • Numeric and Date Data type SRFs
    • Conversion SRFs & Date Functions
    • Concluding SRFs & NULL /NULLIF Functions
  • Assignment 2: Practice with Single Row Function
  • Practice Test 2: Single Table Queries

Session 4:

  • Grouping Functions (Exercises and Solutions in the lectures)
    • Grouping Functions MIN, MAX, AVG, COUNT etc
    • GROUP BY Clause & HAVING Clause
    • More Practice with the GROUP Clauss
  • Practice with Group Function
  • Group Function Queries