Published 1/2025
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Oracle SQL Crash Course: Learn by Doing with the HR Schema
What you’ll learn
Fundamentals of SQL: You will understand the key concepts of SQL.
Explain the purpose and use of essential SQL commands (SELECT, FROM, WHERE, ORDER BY, GROUP BY, HAVING).
Construct queries to retrieve specific data from a database.
Formulate queries to filter data using different operators (comparison, logical, special).
Utilize aggregate functions (e.g., COUNT, SUM, AVG) to analyze data.
Employ JOIN clauses to combine data from multiple tables.
Create subqueries to refine data retrieval.
Requirements
SQL Developer installed with access to the HR schema.
Description
Overview
Section 1: Software and data
Lecture 1 SQL Developer and HR Scheme
Section 2: Basic SQL Commands
Lecture 2 SELECT – Retrieving data
Lecture 3 WHERE – Filtering data using the WHERE clause
Lecture 4 ORDER BY – Data sorting
Lecture 5 Limiting the number of rows – FETCH FIRST, ROWNUM and OFFSET clauses
Lecture 6 Practical examples of using SELECT, WHERE, and ORDER BY statements
Section 3: Data Aggregation
Lecture 7 Introduction to Data Aggregation
Lecture 8 Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
Lecture 9 GROUP BY
Lecture 10 HAVING
Programmers who want to learn SQL to work with Oracle databases.,Data analysts who need SQL to analyze and report data.,Students of computer science and related fields.,Anyone who wants to learn the basics of SQL and its practical applications.
