image
Introduction to SQL
SQL - Newbie to Ninja LP - Introduction
Difficulty
Beginner
Duration
1h 6m
Students
8705
Ratings
4/5
starstarstarstarstar-border
Description

In this Course, we will provide a brief overview and history of the SQL standard. We will then learn how to read and write data using structures created with the language SQL. By the end of this Course, you should be able to recognise and explain the structured query language and be able to read and write SQL commands. This Course is suited to anyone familiar with computing who is interested in learning how to read and manipulate data stored in a relational database.

Prerequisites

It will help if you have a basic understanding of computing services to get the most from this practical Course. 

Feedback 

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
 

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

 

 

Transcript

Hello, and welcome to this learn SQL, Newbie to Ninja learning path. My name is Andy Larkin and I'll be your tutor for this course. So, if you want to learn how to use the Structured Query Language to create, query and manipulate data in relational databases, then this learning path is for you. This collection of courses and hands-on labs teaches you the basics before we advance in skills and how-to knowledge and hands-on expertise to work through and solve complex business issues using SQL. You can start this learning path with little or no knowledge of SQL and emerge a confident SQL practitioner. 

So, this learning path provides an ideal start point for anyone wanting to get started with database management, data science, solution architecture, or writing applications that need to interface with databases or datasets. The learning path provides a lab environment for practical learning, so, it will help if you have a basic understanding of compute concepts so you get the most from this learning path. 

So, this learning path starts with an introduction to the Structured Query Language. What SQL is, how we use it and why it exists as a form of data manipulation. We then learn how to read and write data using structures created with the language SQL, before practising some basic select commands in a lab environment. We then do working with SQL, where we learn how SQL can be used to alter and delete tables, and how we can use primary and foreign keys to organise information. 

We examine common joins between tables in relational databases. We then delve into inner, outer, left and right joins before learning to manipulate data using the INSERT, UPDATE and DELETE functions. We have a series of labs to help us get our heads around those concepts. Do not worry, they may sound complicated now, but the labs will help you get hands-on experience with using these functions. Then, we progress into our SQL masterclass where 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. 

So, we're gonna go deep and hands-on with transactions, subqueries, inline views, summarised queries, the exists predicate and set operations. Then, we're gonna get really, really practical. We're gonna solve a real-world data scenario using SQL to import and validate data from CSV files that have been captured from ATM machines. Very real, very practical, very useful. 

So, by the end of this learning path, you will be able to recognise and explain the Structured Query Language and you'll be able to read and write SQL commands. Now, we welcome all questions, comments and feedback, so please feel free to reach out to us at support@cloudacademy.com if you have any questions or you want to provide any feedback on the content. All right, so if you're ready, let's get started.

About the Author
Students
175669
Courses
72
Learning Paths
178

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