|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-sql-step-by-step-approach/
课程评论：没有评论
**Oracle SQL - Step by Step SQL** 本课程旨在帮助您在七周内成为一名能够盈利的SQL开发人员。从零开始，您将学习SQL的基础知识，包括数据库概念以及如何使用SQL与数据库进行交互。 **课程方法论：** 课程采用“商业需求 -> 疑问 -> SQL语句”的方法，帮助您理解SQL查询的构建过程。例如： * **商业需求：** 经理要求提供一份按天和城市汇总1月份销售量的报告。 * **思考过程：** * **Give?** SELECT (选择) * **What columns?** DAY, CITY (哪些列：日，城市) * **Summary?** SUM(VOLUME) (汇总：SUM(数量)) * **Preposition?** FROM (从) Which table contains sales orders data? SALES (哪个表包含销售订单数据？SALES) * **Filter?** WHERE SALES_DATE BETWEEN '01-JAN-2015' and '31-JAN-2015' (过滤：WHERE销售日期在‘2015-01-01’和‘2015-01-31’之间) * **Grouping?** GROUP BY DAY, CITY (分组：按日、城市分组) * **最终SQL语句：** ```sql SELECT day, city, SUM(volume) FROM sales WHERE sales_date BETWEEN '01-JAN-2015' AND '31-JAN-2015' GROUP BY day, city; ``` **课程内容：** * 关系型数据库概念 * 使用SQL命令检索数据 (SELECT) * 使用SQL命令根据业务需求筛选数据 (WHERE) * 使用SQL命令创建和修改表结构 (CREATE, ALTER) * 使用SQL JOIN连接来自多个表的数据 * 使用SQL GROUP BY和SQL聚合函数对数据进行分组和计算汇总 * 使用SQL关键字 (UNION, UNION ALL, INTERSECT, MINUS) 组合来自两个或多个表的数据 * 使用SQL命令在表上强制执行约束 (CREATE, ALTER) * 使用SQL命令创建视图 (CREATE VIEW) * 使用SQL命令创建其他数据库对象 (SYNONYMS, SEQUENCES) * 使用SQL命令控制用户访问权限 (GRANT, REVOKE) * 使用SQL命令改进性能 (CREATE INDEX) * 项目作业，总结所学SQL概念 * 以及更多有趣的内容。 **使用的软件：** * Oracle Database 11g * SQL Developer **更新记录：** * **2022年4月6日：** 新增练习。 * **2016年4月1日：** 讲座新增字幕。
Update 04/06/2022: Added new exercisesUpdate 01/04/2016: Closed Captions/Sub Titles are added to the Lectures. Learn to become a fee-earning SQL developer in just seven weeks. This fast, easy and effective course will take you from zero sql writing skills to being able to make money as a SQL developer. This one-stop-shot-style SQL course will teach you everything you need to know about SQL, from learning various database concepts to writing SQL to interact with the database. Throughout this SQL course I will be using the below methodology to make you think and help in forming the SQL statement. Business Need: Manager asks you to give you a report containing total sales volume for January month by day and city Questions in your mind to build your SQL query Give? SELECT What columns? DAY, CITY Summary? SUM(VOLUME) Preposition? FROM Which table contains sales orders data? SALES Filter? WHERE SALES_DATE BETWEEN '01-JAN-2015' and '31-JAN-2015' Grouping? GROUP BY DAY, CITY Combine the above answers to form the below SQL SELECT day, city, SUM(volume) FROM sales WHERE sales_date BETWEEN '01-JAN-2015' AND '31-JAN-2015' GROUP BY day, city; In this course participants will learn Relational databases ConceptsRetrieving Data from Database using SQL Commands (Select)Filtering Data based on business requirements using SQL Command (Where)Creating Tables and modifying its structure using SQL commands (Create, Alter)Joining Data from various Tables using SQL JoinsGrouping Data and calculating summaries using SQL GROUP BY and SQL Aggregate functionsCombining data from 2 or more tables using SQL keywords (UNION, UNION ALL, INTERSECT, MINUS)Enforcing Constraints on Tables using SQL commands (Create. Alter)Creating views using SQL command (Create View)Creating other database objects (SYNONYMS, SEQUENCES) using the SQL commandsControlling the access to the users using SQL commands (GRANT, REVOKE)Improving performance using SQL command (create Index )Project Work at the summarize the SQL concepts we learnt.and many more interesting things.. Softwares used Oracle Database 11gSQL Developer
