Learning SQL Programming
1h 49mBeginner2023-12-20
Authors
Scott Simpson
Creating Technology Courses as a Senior Staff Author at LinkedIn
Course details
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.
Learning objectives
Name the predicate of the following statement: SELECT EyeColor, Age FROM Student WHERE FirstName = 'Tim' ORDER BY LastName ASC;
Explain what to use to enforce the order in which an expression must be evaluated if the WHERE clause contains multiple expressions to evaluate.
Identify the best option to join two tables in a database to be able to display data from both.
List a data type that is not numeric.
Determine the result of running the following statement on a table containing columns col_1 and col_2:
INSERT INTO Box (col_1, col_2) VALUES ('A', 'B'), ('A', 'B'), ('A', 'B'), ('A', 'B');
Determine the best approach of deleting Jon Ramirez (ID 3452) from a Student table.
Learning objectives
Name the predicate of the following statement: SELECT EyeColor, Age FROM Student WHERE FirstName = 'Tim' ORDER BY LastName ASC;
Explain what to use to enforce the order in which an expression must be evaluated if the WHERE clause contains multiple expressions to evaluate.
Identify the best option to join two tables in a database to be able to display data from both.
List a data type that is not numeric.
Determine the result of running the following statement on a table containing columns col_1 and col_2:
INSERT INTO Box (col_1, col_2) VALUES ('A', 'B'), ('A', 'B'), ('A', 'B'), ('A', 'B');
Determine the best approach of deleting Jon Ramirez (ID 3452) from a Student table.
Skills covered
SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisLearningProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Learning SQL programming
- 02 - Exercise files
- 03 - Exploring DB Browser for SQLite
- 04 - CoderPad tour
- 05 - What is a database
- 06 - What is SQL
1. Ask for Data from a Database
- 07 - Ask for data with SELECT
- 08 - Narrow down a query with WHERE
- 09 - Adding more criteria to a statement
- 10 - Broadening and limiting responses
- 11 - Organize responses with ORDER BY
- 12 - Find information about the data
- 13 - Solution - Retrieve data from the database
2. Ask for Data from Two or More Tables
- 14 - Ask for data across two or more tables
- 15 - Understand JOIN types
- 16 - Grouping results
- 17 - Solution - Practice with JOINs
3. Data Types, Math, and Helpful Features
- 18 - Data types in SQL
- 19 - Math in SQL
- 20 - Compound Select
- 21 - Transforming data
- 22 - Creating aliases with AS
- 23 - Solution - State score metrics
4. Add or Modify Data
- 24 - Add data to a table
- 25 - Modify data in a table
- 26 - Removing data from a table
- 27 - Solution - Identifying the correct record
Conclusion
- 28 - Overcoming common SQL mistakes
- 29 - Next steps