Introduction to SQL Programming Basics

Master the Fundamentals of SQL Programming

This 3-day intensive course is meticulously designed for training providers who want to equip their learners with a comprehensive understanding of SQL programming. The course dives into essential SQL concepts and techniques using Oracle Database 19c, making it an excellent resource for foundational SQL training.

Participants will explore topics such as:

• SQL Basics: Understanding database structures, retrieving data with SELECT statements, and leveraging single-row functions.
• Data Manipulation and Transformation: Using SQL commands like INSERT, UPDATE, and DELETE for effective data management.
• Advanced Query Techniques: Mastering joins, subqueries, set operators, and aggregation for complex data analysis.
• Database Management: Gaining practical skills in using DDL for creating and managing schema objects.

Each day is packed with engaging, hands-on labs, best practices, and scenarios that mirror real-world use cases, ensuring students leave with actionable skills. The courseware is crafted for easy integration into training programs, offering clarity, modularity, and relevance for a diverse audience.

Transform your training offerings with this industry-focused SQL programming curriculum—engineered to meet the demands of modern learners and professionals.

Day 1: Fundamentals of SQL and Data Retrieval

• Introduction to SQL and Relational Databases
  • Overview of Oracle Database 19c
  • Key SQL concepts and tools (SQL Developer, SQL*Plus)
• Retrieving Data Using SELECT Statements
  • Writing basic SELECT queries
  • Using column aliases and concatenation
  • Handling NULL values
• Restricting and Sorting Data
  • Using WHERE clauses with comparison and logical operators
  • Sorting data with ORDER BY
  • Utilizing substitution variables for dynamic queries
• Hands-On Practice: Basic query writing and data sorting in HR schema.

Day 2: Advanced Data Retrieval and Manipulation

• SQL Functions for Data Transformation
  • Single-row functions: character, number, and date functions
  • Conversion functions and conditional expressions (CASE, DECODE)
• Aggregating Data with Group Functions
  • Using COUNT, AVG, MAX, MIN, SUM, and GROUP BY clauses
  • Filtering grouped data with HAVING clauses
• Combining and Joining Data
  • INNER JOIN, OUTER JOIN, and CROSS JOIN
  • Subqueries and correlated subqueries
  • Set operators: UNION, INTERSECT, MINUS
• Hands-On Practice: Writing complex queries with joins, subqueries, and aggregations.

Day 3: Data Manipulation and Schema Management

• Data Manipulation Language (DML)
  • INSERT, UPDATE, DELETE statements
  • Managing transactions with COMMIT, ROLLBACK, and SAVEPOINT
• Data Definition Language (DDL)
  • Creating and altering tables
  • Applying constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK)
  • Dropping tables and managing schema objects
• Introduction to Cloud SQL
  • Overview of Oracle Exadata Express Cloud Service
  • Connecting to cloud databases
• Final Practice and Review
  • End-to-end query scenarios covering all topics
  • Q&A and final troubleshooting session.