Instructor-led training

Oracle SQL Training in Del Rio, Texas

Data training from Hartmann Software Group, delivered onsite in Del Rio, Texas or live online.

Request a Training Proposal View Course Outline

What you'll learn

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.

Prerequisites

None

Course Outline

Relational Database Basics
1. Brief History of SQL
2. Relational Databases
3. Popular Databases
4. Schemas and Users
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
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)
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
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()
Joins
1. Inner Joins
2. Inner Joins (Exercise)
3. Outer Joins
4. Outer Joins (Exercise)
Subqueries
1. Subquery Basics
2. Subqueries (Exercise)
3. Subqueries in the SELECT Clause
4. Subqueries in SELECTs (Exercise)
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
Conditional Processing with CASE
1. Selected Case
2. Searched Case
3. Working with CASE (Exercise)
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
Creating Views
1. Creating Views
2. Benefits of Views
3. Creating a View (Exercise)
4. Inline Views

Training locations

Oracle SQL training across the U.S. and beyond.

We provide Oracle SQL training onsite and live online for organizations throughout the United States and internationally.

View all Oracle SQL training locations

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176