Working With SQL — Beyond the Basics

Developed with QA
QA
This content is developed in partnership with QA
DifficultyIntermediate
AVG Duration4h
Students172
Ratings
5/5
starstarstarstarstar
Content
course 3 labchallenge 1 exam 3 lab 1

Description

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 extend your practical knowledge of the topic. We go further into SQL functions before working through a practical scenario where we solve a business issue with SQL.

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

  • 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 progress 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.



Certificate

Your certificate for this learning path
lock

Training Content

1
course
Course - Intermediate - 39m
Working with SQL
In this course, you'll learn how to apply the structured query language to manage and manipulate data in a relational database.
2
lab
Hands-on Lab - Intermediate - 1h
Work with Joins in SQL
In this lab, you will practice using joins. Joins are a SQL tool that allow you to view, edit and store data from multiple tables using a single query.
3
exam
Exam - 25m
Knowledge Check: Working with SQL
Knowledge Check: Working with SQL
4
course
Course - Advanced - 43m
SQL Master Class
We go deep into transactions, subqueries, inline views, summarized queries, the exists predicate and set operations.
5
exam
Exam - 25m
Knowledge Check: SQL Master Class
Knowledge Check: SQL Master Class
6
course
Course - Intermediate - 46m
Using SQL to Import and Validate Data from CSV Files
In this course, you'll learn about the use cases, procedures, and automation processes of SQL.
7
exam
Exam - 15m
Knowledge Check: Using SQL to Import and Validate Data
Knowledge Check: Using SQL to Import and Validate Data
8
labchallenge
Hands-on Lab Challenge - Beginner - 1h
Intro to SQL Challenge
This lab challenge provides you with a SQL environment. You must perform several SQL tasks to complete the challenge.
About the Author
Students113137
Courses98
Learning paths96

Head of Content

Andrew is an AWS certified professional who is passionate about helping others learn how to use and gain benefit from AWS technologies. Andrew has worked for AWS and for AWS technology partners Ooyala and Adobe.  His favorite Amazon leadership principle is "Customer Obsession" as everything AWS starts with the customer. Passions around work are cycling and surfing, and having a laugh about the lessons learnt trying to launch two daughters and a few start ups. 

Covered Topics