By the end of this course, you will be able to describe what SQL (Structured Query Language) is, write SQL queries, answer questions by accessing and querying a database, and create and manipulate tables in databases. Ideally, you are familiar with spreadsheets, but that is not a requirement since I will go over a high-level overview of databases and spreadsheets.
SQL is a programming language that has been around since the 70s and is designed to manage data in relational databases. With SQL, you can read, write, and manipulate data with many functions available to help you query data from a database. For example, you can aggregate data much like you can using Excel pivot tables utilizing sums, counts, min, max, etc. Don’t worry if any of this doesn’t make sense right now; we will cover these topics in future videos.
This entry-level SQL for Data Practitioners training prepares data practitioners to use SQL to perform advanced queries, build stable databases, and optimize your data lakes and warehouses.
When data is stored away inside massive data warehouses or inside databases just waiting to be put to use, getting it out and into the places where you can use it requires speaking the right language. That language is SQL – Structured Query Language – and when you know how to write it, databases work better, search queries are more useful and data is responsive.
No matter what you use the data for, knowing how to write and understand SQL is a foundational step in using it better.
Once you're done with this SQL skills training, you'll know how to use SQL to perform advanced queries, build stable databases, and optimize your data lakes and warehouses.
For supervisors, this SQL training can be used to onboard new data practitioners, curated into individual or team training plans, or as a SQL reference resource.
SQL for Data Practitioners: What You Need to Know
This SQL for Data Practitioners training covers SQL topics including:
- Querying and manipulating relational databases
- Defining connections between data fields and determining how they can be expressed
- Working with data directly through SQL commands and queries
- Creating, modifying and repairing databases, data lakes and data warehouses
- Telling stories and visualizing data
Who Should Take SQL for Data Practitioners Training?
This SQL for Data Practitioners training is considered foundational-level training SQL which means it was designed for data practitioners. This SQL skills course is valuable for new IT professionals with at least a year of experience with relational database management and experienced data practitioners looking to validate their data skills.
New or aspiring data practitioners. Learning SQL early in your career is like learning to change your oil as soon as you get your driver’s license. You might prefer to have your programs and interfaces handle your data pulls and queries automatically, but this SQL for data practitioners course shows you how to do it yourself. That way you can open up the hood and do it perfectly according to your unique needs.
Experienced data practitioners.If you’ve been working as a data professional for several years already, you’ll want to learn SQL so that you don’t accidentally silo yourself professionally. Your teams and co-workers may not trust you with the big projects if you don’t know how to get your hands dirty with hand-written SQL queries, fix that with this SQL course.