|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-full-course-in-1-hour-from-basics-to-advanced-topics/
课程评论：没有评论
课程名称：SQL与PostgreSQL快速入门：从零开始的完整SQL课程 课程概述： 本课程旨在向学员介绍SQL的多项重要主题，以便掌握使用SQL的必要技能。课程内容包括： 1. 数据库连接与数据可视化：学习如何将数据库连接至Tableau和Power BI。 2. Amazon数据库部署：了解如何部署免费的数据库服务。 3. SQL工具探索：掌握pgAdmin、VS Code、DBeaver和psql等工具的使用。 4. 基本SQL命令：学习ORDER BY（升序/降序）、OFFSET、LIMIT、LIKE、iLIKE、UNION（ALL）、COALESCE、日期和时间函数（如NOW()和INTERVAL）等基本命令。 5. 子查询与聚合函数：掌握如何编写子查询，以及使用SUM、ROUND、AVG、MAX、MIN和COUNT等聚合函数。 6. WHERE与HAVING子句：了解何时使用这些子句，以及DO UPDATE和DO NOTHING的用法。 7. 查询优化：学习在处理大表时如何优化查询以提升性能。 8. 数据库约束与视图：学习如何使用CHECK约束、视图、存储过程、事务、窗口函数、通用表表达式和触发器等高级功能。 9. 表之间的关系：探索表之间的一对一、一对多和多对多关系。 10. 连接操作：掌握各种JOIN操作（内连接、左连接、右连接、全外连接和交叉连接）。 11. SQL规范化：了解第一、第二和第三范式及其应用。 12. SQL注入：通过实践示例学习REST API与授权应用中的SQL注入及其可能导致的后果。 13. 实践测试：为面试准备的实际测试。 课程还将提供详细的讲解资料，帮助巩固学习，并为未来使用SQL提供参考资源。通过本课程，学员将在SQL的学习旅程中充满信心，能够运用SQL解决多种实际问题。
Throughout this course, we will delve into a variety of essential topics to equip you with the necessary skills to work with SQL:Connecting Database to Tableau / Power BI and data visualization;Deploy a free tier database with Amazon;Exploring the free tools to work with SQL (e.g., pgAdmin, VS Code, DBeaver, psql);Learn basic SQL commands (ORDER BY ASC / DESC, OFFSET / LIMIT, LIKE, iLIKE, UNION (ALL), COALESCE, DATE, NOW(), INTERVAL, AGE);Writing subqueries;Aggregate functions (SUM, ROUND, AVG, MAX, MIN, COUNT);Understand when to use WHERE and HAVING clauses / DO UPDATE / DO NOTHING;How to optimize queries and increase performance of queries when working with big tables;How to use (CHECK) CONSTRAINTS, VIEWS, STORED PROCEDURES, TRANSACTIONS, WINDOW FUNCTIONS, COMMON TABLE EXPRESSIONS, FULL-TEXT SEARCH, CASE EXPRESSIONS, TRIGGERS;Exploring relations between tables (ONE TO ONE, ONE TO MANY, MANY TO MANY);Writing JOINS (JOINS: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, CROSS JOIN);SQL (NON) NORMAL FORMS (first normal form, second normal form and third normal form);SQL INJECTIONS on practical examples: Rest API web / Authorization application injection with consequences of exploiting such injection.Pass practical tests to be prepared for an interview.Throughout the course, you will receive a detailed presentation with all the queries we discuss. This will help you consolidate your learning and provide you with a reference resource you can use later.I'm excited to guide you through this journey of SQL learning, and I hope that by the end of the course, you will feel confident in your ability to use SQL to solve a variety of problems.
