Quick Start Guide to SQL
1h 18mBeginner2022-02-16
Authors

Deepa Maddala
Experienced Consultant and PL/SQL Developer in Information Technology
Course details
Are you looking to take a deeper dive into the fundamentals of structured query language (SQL)? This short, beginner-friendly course is just the place to start. Join instructor Deepa Maddala as she walks you through the basics of SQL and how to make it work seamlessly with large Oracle datasets.
Learn about relational database management systems, SQL, and how it works. Explore strategies that you can put to use fetching data from tables, filtering data, and manipulating data with single-row and multiple-row functions, as well as joins and subqueries. By the end of this course, you’ll not only have a deeper understanding of the basic concepts of SQL—you’ll also be ready to get started working on real-time business scenarios.
Learn about relational database management systems, SQL, and how it works. Explore strategies that you can put to use fetching data from tables, filtering data, and manipulating data with single-row and multiple-row functions, as well as joins and subqueries. By the end of this course, you’ll not only have a deeper understanding of the basic concepts of SQL—you’ll also be ready to get started working on real-time business scenarios.
Skills covered
Oracle DatabaseSQLDatabase AdministrationDatabase DevelopmentOracleDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Introduction to RDBMS and SQL
- 02 - How to use the exercise files
1. Fetch Data from Tables
- 03 - Basic select statements
- 04 - Operators
- 05 - Data types
2. Filtering Data
- 06 - Comparison conditions
- 07 - Logical conditions
- 08 - Order of precedence
- 09 - Sorting data
3. Single Row Functions
- 10 - Types of functions and number functions
- 11 - Character functions
- 12 - Date functions
- 13 - Data type conversion functions
- 14 - Conditional expressions
4. Multiple Row Functions Group Functions
- 15 - Types of group functions
- 16 - Creating groups and nested groups
- 17 - Filtering group results
5. Joins and Subqueries
- 18 - Types of joins
- 19 - Uses of subqueries
- 20 - Types of subqueries
Conclusion
- 21 - Next steps
Related courses
- Oracle Autonomous Database Professional Workshop
- Oracle Database 12c: Administration
- Oracle Autonomous Database Professional Workshop (January 2025)
- Oracle Cloud Infrastructure Foundations Associate (January 2025)
- Oracle HeatWave MySQL Foundations
- Complete Guide to Oracle Database 23ai: From Beginner to Advanced
- Learning Oracle Database 19c
- Oracle Base Database Services Professional Workshop