Learning SQL Programming

Learning SQL Programming
Learning SQL Programming
English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 27m | 183 MB

SQL (Structured Query Language) 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 server, 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.

Topics include:

  • What is SQL?
  • Asking for data with SELECT
  • Limiting database responses
  • Organizing responses
  • Asking for data from two or more tables
  • Understanding join types and data types
  • Transforming data
  • Performing math
  • Adding and modifying data in a table
Table of Contents

1 Welcome
2 Use the exercise files
3 Explore DB Browser
4 What is a database_
5 What is SQL_
6 Ask for data with SELECT
7 Narrow down a query with WHERE
8 Add more criteria to a statement
9 Limit responses
10 Organize responses with ORDER BY
11 Find information about the data
12 Ask for data across two or more tables
13 Understand JOIN types
14 Combine results
15 Data types in SQL
16 Math in SQL
17 Compound Select
18 Transform data
19 Use aliases to shorten field names
20 Add data to a table
21 Modify data in a table
22 Remove data from a table
23 Overcome common SQL mistakes
24 Next steps