Understand SQL: Explore the Power and Versatility of the SQL Database Language

27mBeginner2022-09-26

Authors

Christina Stathopoulos

Data Whisperer, Analytics Specialist, Public Speaker, and Educator

Course details

No matter how many new programming languages and database structures keep popping up, SQL remains arguably the most widely used database language in the world. And with the field of data science rapidly on the rise, the demand for skilled programming professionals continues to grow with it. In this course, instructor Christina Stathopoulos helps you build out your understanding of SQL, its history and context, and why it’s so important for anyone working with data.

Get ready for a stepping-stone introduction to SQL before you start writing code of your own, developing your awareness of the language itself and priming your skill set for hands-on learning. By the end of this course, you’ll know about the benefits and resilience of SQL in an ever-changing tech world, along with a handful of some of the most commonly used tools and command families that allow you to define, manipulate, control and query your data.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Let's talk about data with SQL
02 - What is SQL

1. Emergence and History

03 - Emergence of SQL
04 - A brief history of SQL

2. Benefits and Resilience in the Ever-Changing Tech World

05 - Users of SQL
06 - Benefits and resilience of SQL
07 - Common applications for SQL execution

3. SQL Commands and Execution

08 - SQL command families
09 - Define, Manipulate, Control, Query
10 - Common tools for SQL execution

Conclusion

11 - Next steps with SQL