Working with SQL
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.
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 firstname.lastname@example.org.
Okay, if you're ready, let's get started.
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.