Oracle Database 19c: SQL Workshop


Request for price


Length: 5.0 day (40 hours)

 

This comprehensive course provides a deep dive into the powerful SQL language and its application within the Oracle Database 19c environment. Participants will learn essential SQL concepts and techniques to effectively query, manipulate, and analyze data

  • Database Administrators
  • SQL Programmers
  • Data Analysts
  • Business Intelligence Professionals
  • Data Scientists
  • IT Managers
  • Software Developers
  • Database Designers and Modelers
  • Technical Consultants
  • System Analysts and Architects
  • Anyone seeking to enhance their SQL skills and knowledge of Oracle Database 19c
  • Basic understanding of database concepts
  • Familiarity with SQL fundamentals
  • Access to an Oracle Database 19c environment (either on-premises or cloud-based)

Start with the customer – find out what they want and give it to them.

Course objectivesCourse outlines

Course objectives

After completing this course, students will be able to:

    • Write complex SQL queries to retrieve specific data from the database
    • Manipulate and update data within tables
    • Create and manage database objects like tables, indexes, and views
    • Optimize SQL queries for improved performance
    • Utilize advanced SQL features and functions
    • Secure and control access to database data

Course outlines

  • Module 1: Introduction to SQL
    • Overview of SQL and its role in database management
    • SQL syntax and basic data types
    • Connecting to an Oracle Database using SQL*Plus or SQL Developer
  • Module 2: Data Retrieval with SQL
    • SELECT statement: basic syntax and retrieving data from tables
    • Filtering data with WHERE clause
    • Sorting data with ORDER BY clause
    • Using arithmetic and logical operators
    • Working with single-row functions (e.g., UPPER, LOWER, ROUND, TO_CHAR)
  • Module 3: Data Manipulation with SQL
    • INSERT, UPDATE, and DELETE statements
    • Modifying data with DML commands
    • Understanding COMMIT and ROLLBACK transactions
  • Module 4: Grouping and Aggregating Data
    • GROUP BY and HAVING clauses
    • Using aggregate functions (e.g., COUNT, SUM, AVG, MIN, MAX)
    • Creating complex queries with multiple levels of grouping
  • Module 5: Joining Tables
    • Different types of joins (INNER JOIN, OUTER JOIN, SELF JOIN)
    • Combining data from multiple tables
    • Using JOIN conditions to filter data
  • Module 6: Subqueries and Set Operations
    • Using subqueries to filter and aggregate data
    • Employing set operations (UNION, INTERSECT, MINUS) to combine result sets
  • Module 7: Advanced SQL Features
    • Working with hierarchical queries (CONNECT BY clause)
    • Using regular expressions for pattern matching
    • Creating and managing database views
    • Understanding PL/SQL for procedural programming
  • Module 8: Performance Tuning
    • Analyzing query performance with EXPLAIN PLAN
    • Indexing strategies for optimizing query execution
    • Using hints to guide the optimizer

​

Download outlines