Oracle SQL

Oracle SQL Courseware (ORA100)

OracleDataSQL

This Oracle SQL course is designed for beginners who want to learn the fundamentals of SQL using Oracle Database. The course covers topics such as relational database basics, creating tables, basic selects, Oracle SQL functions, aggregate functions, joins, subqueries, set operators, conditional processing with CASE, Data Manipulation Language (DML), and creating views. Through practical exercises and real-world examples, students will gain a strong foundation in SQL and learn how to create, manipulate, and retrieve data from Oracle databases efficiently and effectively.

Publisher: Webucator

Benefits

  1. Foundational Knowledge: The course provides a comprehensive introduction to Oracle SQL, ensuring students have a solid understanding of SQL fundamentals and Oracle database management.
  2. Hands-on Learning: Practical exercises and real-world examples help students develop their skills and confidence in working with Oracle SQL.
  3. Efficient Data Management: Students will learn how to create, manipulate, and retrieve data from Oracle databases efficiently and effectively, improving their productivity and problem-solving abilities.
  4. Scalable Learning: The course serves as a strong foundation for learning Oracle PL/SQL or for becoming a DBA.

PowerPoint Presentation

This course includes a PowerPoint presentation that maps to the manual and to the labs:

Full Lab Environment Add-On

Enhance and simplify your classes by providing an unparalleled learning platform that requires no setup. Your trainers and students can dive straight into a fully-prepared lab environment with just a click. This seamless integration means no time wasted on installations or configurations, allowing trainers and students to focus solely on the task at hand. The lab comes pre-loaded with all the necessary tools and resources, ensuring a smooth, hassle-free learning experience.

Skillable Lab

Outline

  1. Relational Database Basics
    1. Brief History of SQL
    2. Relational Databases
    3. Popular Databases
    4. Schemas and Users
  2. Creating Tables
    1. Data Types
    2. Creating Tables
    3. Creating Tables (Exercise)
    4. Adding Constraints
    5. Altering the departments_copy Table (Exercise)
    6. UNIQUE Constraints
    7. Adding and Dropping Columns
    8. Dropping Tables
  3. Basic Selects
    1. Comments
    2. Whitespace and Semi-colons
    3. Case Sensitivity
    4. SELECTing All Columns in All Rows
    5. Exploring the Tables (Exercise)
    6. SELECTing Specific Columns
    7. SELECTing Specific Columns (Exercise)
    8. Sorting Records
    9. Sorting Results (Exercise)
    10. The WHERE Clause and Logical Operator Symbols
    11. Using the WHERE Clause to Check for Equality or Inequality (Exercise)
    12. Checking for Greater Than or Less Than
    13. Using the WHERE Clause to Check for Greater or Less Than (Exercise)
    14. Checking for Null and Not Null
    15. Checking for NULL (Exercise)
    16. WHERE and ORDER BY
    17. Using WHERE and ORDER BY Together (Exercise)
    18. Checking Multiple Conditions with Boolean Operators
    19. Writing SELECTs with Multiple Conditions (Exercise)
    20. The WHERE Clause and Logical Operator Keywords
    21. More SELECTs with WHERE (Exercise)
    22. Limiting Rows
    23. Working with FETCH (Exercise)
  4. Oracle SQL Functions
    1. The DUAL Table and Column Aliases
    2. Calculated Fields
    3. Calculating Commissions (Exercise)
    4. ROW_NUMBER()
    5. Numeric Functions
    6. Using MOD() (Exercise)
    7. Character Functions Returning Character Values
    8. Concatenation (Exercise)
    9. More Character Functions Returning Character Values
    10. Character Functions Returning Number Values
    11. Datetime Functions
    12. Dates (Exercise)
    13. SQL*Plus column Command
    14. NULL-Related Functions
    15. NULL Functions (Exercise)
    16. Other Functions
  5. Aggregate Functions
    1. Introduction to Aggregate Functions
    2. Working with Aggregate Functions (Exercise)
    3. Grouping Data
    4. Grouping Results (Exercise)
    5. Selecting Distinct Records
    6. ROLLUP() and CUBE()
  6. Joins
    1. Inner Joins
    2. Inner Joins (Exercise)
    3. Outer Joins
    4. Outer Joins (Exercise)
  7. Subqueries
    1. Subquery Basics
    2. Subqueries (Exercise)
    3. Subqueries in the SELECT Clause
    4. Subqueries in SELECTs (Exercise)
  8. Set Operators
    1. Set Operators
    2. UNION
    3. UNION ALL
    4. INTERSECT
    5. MINUS
    6. Working with Set Operators (Exercise)
    7. Set Operators and Aliases
  9. Conditional Processing with CASE
    1. Selected Case
    2. Searched Case
    3. Working with CASE (Exercise)
  10. Data Manipulation Language
    1. Transactions and Sessions
    2. INSERT
    3. Inserting Records (Exercise)
    4. UPDATE
    5. DELETE
    6. Updating and Deleting Records (Exercise)
    7. Updating and Deleting Multiple Records
  11. Creating Views
    1. Creating Views
    2. Benefits of Views
    3. Creating a View (Exercise)
    4. Inline Views

Required Prerequisites

None

License

Length: 4 days | $160.00 per copy
Labs: Add-on available | $50.97 per lab
View Lab Details

LicenseRequest More InformationDownload Sample CopyRequest Trainer Evaluation Copy
What is Included?
  • Student Manual
  • Student Class Files
  • PowerPoint Presentation
  • Labs (optional add-on)
    Courseware Tracks

    This course is included in the following tracks: