Introduction to SQL

Focused View

Jon Flanders

3:01:41

45 View

1. Course Overview

1. Course Overview.mp4

01:30

2. Introduction

1. Introduction.mp4

04:21

2. The Relational Model.mp4

06:57

3. Summary.mp4

00:17

3. Understanding Basic SQL Syntax

1. Introduction.mp4

03:16

2. Basic SQL Commands - SELECT.mp4

01:01

3. Basic SQL Commands - INSERT.mp4

01:58

4. Basic SQL Commands - UPDATE.mp4

01:37

5. Basic SQL Commands - DELETE.mp4

01:42

6. Course Housekeeping.mp4

02:56

7. Summary.mp4

00:28

4. Querying Data with the SELECT Statement

01. Introduction.mp4

03:56

02. Demo - SELECT.mp4

01:42

03. The SELECT List.mp4

02:16

04. SELECT List Wildcard (-).mp4

01:56

05. The FROM Clause.mp4

04:39

06. Demo - FROM Clause.mp4

03:43

07. How to Constrain the Result Set.mp4

00:50

08. DISTINCT and NOT DISTINCT.mp4

03:11

09. Demo - Distinct.mp4

02:23

10. Summary.mp4

00:24

5. Filtering Results with the WHERE Clause

01. The WHERE Clause.mp4

03:45

02. Demo - WHERE Clause.mp4

00:57

03. Boolean Operators.mp4

01:51

04. The AND Keyword.mp4

01:37

05. Demo - AND.mp4

01:41

06. The OR Keyword.mp4

01:23

07. Demo - OR.mp4

02:01

08. Other Boolean Operators.mp4

00:27

09. BETWEEN.mp4

02:21

10. Demo - BETWEEN.mp4

02:07

11. LIKE.mp4

01:56

12. Demo - LIKE.mp4

02:36

13. IN.mp4

01:26

14. Demo - IN.mp4

02:11

15. IS.mp4

01:50

16. IS NOT.mp4

01:27

17. Demo - IS AND IS NOT.mp4

05:59

18. Summary.mp4

00:36

6. Shaping Results with ORDER BY and GROUP BY

01. Introduction.mp4

00:46

02. ORDER BY.mp4

01:48

03. Demo - ORDER BY.mp4

01:22

04. Set Functions.mp4

03:36

05. Demo - Set Functions.mp4

05:08

06. Set Function And Qualifiers.mp4

01:53

07. Demo - Set Function And Qualifiers.mp4

01:28

08. GROUP BY.mp4

02:46

09. Demo - GROUP BY.mp4

02:14

10. HAVING.mp4

02:23

11. Demo - HAVING.mp4

03:05

12. Summary.mp4

00:34

7. Matching Different Data Tables with JOINs

01. Introduction.mp4

01:07

02. CROSS JOIN.mp4

01:09

03. Demo - CROSS JOIN.mp4

01:43

04. INNER JOIN.mp4

02:18

05. Demo - INNER JOIN.mp4

01:45

06. OUTER JOINs.mp4

00:59

07. LEFT OUTER JOIN.mp4

01:16

08. Demo - LEFT OUTER JOIN.mp4

00:58

09. RIGHT OUTER JOIN.mp4

01:03

10. Demo - RIGHT OUTER JOIN.mp4

01:55

11. FULL OUTER JOIN.mp4

01:14

12. Demo - FULL OUTER JOIN.mp4

01:30

13. SELF JOIN.mp4

01:26

14. Summary.mp4

00:28

8. Adding, Changing, and Removing Data

01. Introduction.mp4

01:35

02. INSERT.mp4

02:05

03. Demo - INSERT.mp4

05:02

04. BULK INSERT.mp4

02:10

05. Demo - BULK INSERT.mp4

01:06

06. UPDATE.mp4

01:34

07. Demo - UPDATE.mp4

03:02

08. DELETE.mp4

01:46

09. Demo - DELETE.mp4

01:51

10. Summary.mp4

00:16

9. Creating Database Tables

01. Introduction.mp4

01:11

02. CREATE DATABASE.mp4

02:15

03. Demo - CREATE DATABASE.mp4

01:06

04. CREATE TABLE.mp4

03:08

05. Demo - CREATE TABLE.mp4

02:43

06. NULL Values.mp4

03:33

07. PRIMARY KEY.mp4

01:36

08. CONSTRAINT.mp4

02:06

09. ALTER TABLE.mp4

02:28

10. DROP TABLE.mp4

01:16

11. Demo - CREATE TABLE.mp4

05:41

12. Summary.mp4

01:03

Description

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).

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

MySQL

Database Programming

Microsoft SQL

Jon Flanders

Instructor's Courses

Although Jon spent the first few years of his professional life as an attorney, he quickly found chasing bits more interesting than chasing ambulances. He first worked at the University of Minnesota, building a financial reporting Web site using ASP and SQL Server, specializing in automatic integration between multiple data stores. Since joining the training industry in 1999, Jon has devoted his time to working on various projects while migrating from the world of ASP and COM to the world of .NET, ASP.NET, and Web Services, and now into the world of mobile devices. During this part of Jon’s career he wrote RESTFul.NET for O’Reilly, Essential ASPfor Addison-Wesley, and co-authored Mastering Visual Studio.NETfor O’Reilly. 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. Augmented Reality is another one of Jon’s current passions, along with Beacons and IoT. Jon is excited for the next phase of mobile development and exploring how technology can not only entertain us, but help create a connected world where smart devices start to perform tasks that are difficult and time-consuming.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.