Learning SQL Programming

Focused View

Scott Simpson

56:24

259 View

01 - Introduction

04 - What is a database.mp4

01:52

05 - What is SQL.mp4

06:14

02 - Ask for Data from a Database

01 - Ask for data with SELECT.mp4

04:41

05 - Organize responses with ORDER BY.mp4

03:02

06 - Find information about the data.mp4

03:47

03 - Ask for Data from Two or More Tables

01 - Ask for data across two or more tables.mp4

06:50

04 - Challenge Practice with JOINs.mp4

00:29

04 - Data Types, Math, and Helpful Features

01 - Data types in SQL.mp4

04:22

03 - Compound Select.mp4

02:57

05 - Creating aliases with AS.mp4

02:17

05 - Add or Modify Data

01 - Add data to a table.mp4

04:34

02 - Modify data in a table.mp4

04:48

03 - Removing data from a table.mp4

03:10

04 - Challenge Practice working with data.mp4

00:36

05 - Solution Practice working with data.mp4

02:22

06 - Conclusion

01 - Overcoming common SQL mistakes.mp4

03:29

02 - Next steps.mp4

00:54

Exercise Files

Ex_Files_Learning_SQL_Prog.zip

Description

More from LinkedIn Learning's top experts

Programming Languages Newsletter

Structured Query Language (SQL) is a common tool for retrieving data from relational databases such as SQL Server, MySQL, MariaDB, and PostgreSQL. This course provides an introduction to this core programming language. Learn how to request data from a database, limit and sort the responses, aggregate data from multiple tables with joins, and edit and delete data. Instructor Scott Simpson also shows how to perform simple math operations and transform data into different formats.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Scott Simpson

Instructor's Courses

I write and record video courses on Linux, Open Source, and IT topics. As an educational content producer and author with a strong technology background, I enjoy using my experience to teach others and to advance my own learning with technical projects. I strive to speak to beginner, intermediate, and advanced audiences in an engaging and informative way.

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.