Introduction to SQL

The vast majority of applications that use data, are backed by a good relational database system. This course will help to establish a base to those who want to begin learning Structured Query Language (SQL).
Course info
Rating
(3035)
Level
Beginner
Updated
Dec 20, 2017
Duration
3h 2m
Table of contents
Course Overview
Introduction
Understanding Basic SQL Syntax
Querying Data with the SELECT Statement
Filtering Results with the WHERE Clause
Shaping Results with ORDER BY and GROUP BY
Matching Different Data Tables with JOINs
Adding, Changing, and Removing Data
Creating Database Tables
Description
Course info
Rating
(3035)
Level
Beginner
Updated
Dec 20, 2017
Duration
3h 2m
Description

Structured Query Language (SQL) is a special purpose language for interacting with relational databases. In this course, Introduction to SQL (Update), you will learn the basics of Structured Query Language. First, you will learn how to query data and shape results. Next, you will focus on creating and modifying data in your tables. Finally, you will touch on how actually modify the tables themselves. By the end of this course, you'll understand the basics of how to create and use a relational database.

About the author
About the author

Although Jon spent the first few years of his professional life as an attorney, he quickly found chasing bits more interesting than chasing ambulances. Since 2011, Jon has been concentrating on the mobile world. Working mainly in iOS, Jon has helped numerous companies create and transform mobile teams into teams that can create, build, test, and deploy mobile applications with ease.

More from the author
Introduction to SQL (Update)
Beginner
3h 3m
Nov 13, 2017
More courses by Jon Flanders
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Jon Flanders and welcome to my course, Introduction to SQL. I'm a developer with over 20 years of experience using relational databases and despite the fact that topics like big data and NoSQL databases get all the press these days, the vast majority of applications that use data which by the way, are the vast majority of applications, are backed by a good old-fashioned relational database system that is programmed using Structured Query Language also known as SQL. This course will provide you with the basics that you need to know to get started using SQL. No prior SQL experience is required. Some of the major topics that we will cover include querying data using the select statement, shaping your results using the where clause, creating and modifying data in your tables as well as creating and modifying those tables themselves. By the end of this course, you'll know the basics of how to create and use a relational database. Before beginning the course, you really only need to be familiar with the basic concepts of computer programming. I hope you'll join me here at Pluralsight to learn SQL with the Introduction to SQL course.