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
- SQL for Testers
- Learning Azure SQL Querying
- Quick Start Guide to Scala
- Build Your Own Professional Training: Quick Start Guide
- Advanced Guide to ChatGPT, Embeddings, and Other Large Language Models (LLMs)
- Enterprise AI Development with GitHub Models and Azure
- Unreal Engine 4: Realtime Motion Graphics
- Cinema 4D and After Effects: Logo Animation and Compositing
Related learn paths
- Explore a Career in Database Development
- Optimizing Enterprise Security and Productivity Using Microsoft 365
- Become a Corporate Financial Planning Analyst
- Introduction to Fundamental Skills for Data Work: Data Analysis and Interpretation
- CFI Financial Analysis and Modeling Professional Certificate
- Become a MEAN Javascript Developer
- The Top Skills IT Professionals Have Right Now
- Become a Back-End Web Developer