Learn SQL - From Newbie to Ninja

Developed with QA
OverviewStepsAuthor
QA
This content is developed in partnership with QA
DifficultyBeginner
AVG Duration10h
Students1027
Ratings
4.5/5
starstarstarstarstar-half
Content
Course Created with Sketch. 5 1 Exams Created with Sketch. 4 Labs Created with Sketch. 3

Description

Introduction
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 Structured Query Language . 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. What SQL is, how you use it and why it exists as a way to work with data. We then learn 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 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, data science Prerequisites
This learning path provides a lab environment for practical learning. It will help to have a basic understanding of computing concepts to get the most from this learning path

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

Learning Path Steps

1courses

SQL - Newbie to Ninja - Learning Path Introduction

2courses

Learn how to read and write data using structures created with the language SQL

3exam-filled

Knowledge Check: Introduction to SQL

4labs

In this lab, you will practice the basics of SQL by connecting to a Microsoft SQL Server instance and then creating, managing and viewing data using a combination of user interface tools and SQL queries.

5courses

In this course, you'll learn how to apply the structured query language to manage and manipulate data in a relational database.

6exam-filled

Knowledge Check: Working with SQL

7labs

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.

8

This lab challenge provides you with a SQL environment. You must perform several SQL tasks to complete the challenge.

9courses

We go deep into transactions, subqueries, inline views, summarized queries, the exists predicate and set operations.

10exam-filled

Knowledge Check: SQL Master Class

11courses

In this course, you'll learn about the use cases, procedures, and automation processes of SQL.

12labs

In this lab, you will complete a series of exercises that cover all the important components of the language and allow you to practice your SQL.

13exam-filled

Knowledge Check: Using SQL to Import and Validate Data

About the Author

Students80429
Courses96
Learning paths52

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