If you want to learn how to use the structured query language (SQL) to create, query, and manipulate data in relational databases then this learning path is for you. This collection of courses and labs will explain the fundamentals concepts of SQL before extending your practical knowledge of the topic. We then go further into SQL functions before working through a practical scenario where we solve a business issue with SQL.

This learning path starts with an Introduction to SQL - the structured query language. You'll learn what SQL is, how you use it, and why it exists as a way to work with data. We then look at how to read and write data from databases using SQL before practicing some basic commands in a lab environment.

In Working with SQL we learn how to use SQL to alter and delete tables and how to use primary and foreign keys. We examine common joins between tables in a relational database. We then delve into inner, outer, left, and right joins before learning to manipulate data using the INSERT, UPDATE, and DELETE functions.

In the SQL Masterclass we go beyond the basics to empower you with the skills, how-to knowledge, and hands-on expertise to work through and solve complex business issues with SQL. We go deep and hands-on with transactions, subqueries, inline views, summarized queries, the EXISTS predicate, and set operations.

We then practice solving a real-world data scenario in Using SQL to Import and Validate Data from CSV Files.

Outline

• Introduction to SQL
• SQL Language
• Run Your First SQL Queries
• Working with SQL
• Work with Joins in SQL
• SQL Master Class
• Using SQL to Import and Validate Data from CSV Files
• Knowledge Check: Working with SQL
  

Intended Audience

This learning path provides an ideal start for anyone wanting to get started with database management and data science.

Prerequisites

To get the most out of this learning path, you should have a basic understanding of compute concepts.

Feedback

Please contact us at support@cloudacademy.com if you need help or guidance with this content. We welcome all questions, comments, and feedback.