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
Introduction
- Introduction to RDBMS and SQL
- How to use the exercise files
Fetch Data from Tables
- Basic select statements
- Operators
- Data types
Filtering Data
- Comparison conditions
- Logical conditions
- Order of precedence
- Sorting data
Single Row Functions
- Types of functions and number functions
- Character functions
- Date functions
- Data type conversion functions
- Conditional expressions
Multiple Row Functions Group Functions
- Types of group functions
- Creating groups and nested groups
- Filtering group results
Joins and Subqueries
- Types of joins
- Uses of subqueries
- Types of subqueries
Conclusion
- Next steps