1. Home
  2. Training Library
  3. Big Data
  4. Courses
  5. Working with SQL

Working with SQL

Developed with
QA

Contents

keyboard_tab
Working with SQL
1
Working with SQL - Introduction
PREVIEW1m 8s
2
Changing Data
PREVIEW5m 53s
3
Working with Nulls
9m 28s
4
SQL Joins
PREVIEW13m 37s
5
Other Joins in SQL
PREVIEW8m 51s

The course is part of these learning paths

Working With SQL — Beyond the Basics
3
3
2
Learn SQL - From Newbie to Ninja
5
4
4
Working with SQL - Introduction
Overview
Difficulty
Intermediate
Duration
39m
Students
2652
Ratings
4/5
starstarstarstarstar-border
Description

In this course, we first 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.

This course is built from content created and delivered by Ian Wallington of QA.

Transcript

Hello, and welcome to this working with the Structured Query Language course. 

Now, this course follows on from our Introduction to the Structured Query Language course, so it's suited to anyone familiar with Structured Query Language, who is interested in the practical applications of SQL to solve business problems. 

So, in this course, we firstly learn how to use SQL to create, alter, and delete tables. And, how to use primary and foreign keys. We then examine creating and managing common Joins between tables in a relational database. We then delve deeper into Inner, Outer, Left, and Right Joins before learning how to manipulate data using the INSERT, UPDATE, and DELETE functions. 

So, by the end of this course, you should be able to apply the Structured Query Language to manage and manipulate data in a relational database. 

As a prerequisite, we recommend completing our Introduction to the Structured Query Language course first. And remember, we welcome all comments, questions, and feedback. So, if you need any help with this course, please reach out to us at support@cloudacademy.com. 

Okay, if you're ready, let's get started.

About the Author
Avatar
Andrew Larkin
Head of Content
Students
158054
Courses
73
Learning Paths
164

Andrew is fanatical about helping business teams gain the maximum ROI possible from adopting, using, and optimizing Public Cloud Services. Having built  70+ Cloud Academy courses, Andrew has helped over 50,000 students master cloud computing by sharing the skills and experiences he gained during 20+  years leading digital teams in code and consulting. Before joining Cloud Academy, Andrew worked for AWS and for AWS technology partners Ooyala and Adobe.

Covered Topics

SQLDatabases