1. Home
  2. Training Library
  3. Learn SQL - Introduction

Learn SQL - Introduction

Contents

keyboard_tab
Introduction

The course is part of this learning path

SQL - Newbie to Ninja LP - Introduction
Overview
Difficulty
Beginner
Duration
3m
Students
2131
Ratings
4.9/5
starstarstarstarstar-half
Description

SQL - Learning path Introduction 

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
Avatar
Andrew Larkin
Head of Content
Students
125946
Courses
98
Learning Paths
104

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.