Hands-On Introduction: SQL
1h 21mIntermediate2022-11-09
Authors
Deepa Maddala
Experienced Consultant and PL/SQL Developer in Information Technology
Course details
Join instructor Deepa Maddala as she uses hands-on lessons to teach you the tools, techniques, and know-how that you need to start using SQL from day one. Deepa guides you through using the Select statement to fetch and filter data, creating and adding to tables and data, modifying existing tables, and what to use in different scenarios. She includes simple examples with each topic she covers.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Introduction to SQL
- 02 - Using GitHub Codespaces with this course
1. The Select Statement
- 03 - Fetch data
- 04 - Filtering data
- 05 - Types of functions, part 1
- 06 - Types of functions, part 2
- 07 - Using multiple tables
2. New Tables and Data
- 08 - Create new tables
- 09 - Change table structure
- 10 - Add new rows to a table
- 11 - Delete rows in a table
- 12 - Commit and rollback
3. Modifying Existing Tables
- 13 - Modify rows and columns in tables
- 14 - Merge rows in a table
- 15 - Drop or truncate a table
- 16 - Rename a table
Conclusion
- 17 - Next steps
Related courses
- SQL Practice: Managing Tables with CREATE, ALTER, and DROP
- Understand SQL: Explore the Power and Versatility of the SQL Database Language
- Introduction to Modern Data Engineering with Snowflake
- Learning Amazon Athena
- Hands-On Introduction: ASP.NET Razor Pages
- Hands-On Introduction: Go
- Hands-On Introduction: Java
- Hands-On Introduction: JavaScript
Related learn paths
- SQL Hands-On Practice
- Data Engineering Hands-On Practice
- Data Engineering Foundations Professional Certificate by Astronomer
- Develop Your NoSQL Skills
- Explore App Development with the MERN Stack
- Advance Your Data Skills in Apache Spark
- Advance Your MS SQL Server Skills
- Introduction to Fundamental Skills for Data Work: Data Analysis and Interpretation