Learning SQL Programming (2017)

Learning SQL Programming (2017)

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:

  • 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 SQL Programming (2017)
  • 时长:1小时27分
  • 字幕:英语

课程目录

  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

评论