|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/structured-data-handling-using-sql-for-accountants/
课程评论：没有评论
课程名称：Oracle数据库管理系统 课程概述：欢迎来到《数据库精通：从基础到高级技术》的课程。在这门全面的课程中，我们将带您深入了解数据库的世界，帮助您掌握有效处理各种数据库管理系统中数据所需的基本知识和实用技能。课程分为九个部分，共四十二节讲座，从数据库管理的基础知识到处理复杂数据查询和自动化业务逻辑的高级技术应有尽有。 第一部分“探索数据库”介绍了数据库的基本概念以及处理数据时需要进行的核心活动，包括不同的数据存储类型、关系数据库管理系统的类型以及数据库语言SQL。 在第二部分“限制数据集”中，您将学习如何过滤数据和限制查询结果，以获取所需的精确资料。 第三部分“转换和分组数据”探讨了字符和数值函数，以及强大的Group By子句和HAVING用于数据汇总。 第四部分“INNER JOIN（匹配数据处理）”介绍了各种连接类型，包括自然连接、使用和ON子句的连接、附加条件以及自连接，以便在数据库中关联多个实体。 在第五部分“OUTER JOIN（未匹配数据处理）”中，您将了解外部连接的实现以及交叉连接以处理未匹配的数据。 第六部分“回答商业问题（子查询）”涵盖了使用子查询回答复杂商业问题，包括单行和多行子查询。 第七部分“自动化业务逻辑（PL/SQL）”深入探讨PL/SQL概念，包括创建匿名块、带有或不带参数的过程以及函数以自动化业务逻辑。 第八部分“逐行处理数据（PL/SQL游标）”介绍了如何使用游标迭代查询结果，实现条件以及编写函数以计算税费。 最后，第九部分“扩展实验部分”将帮助您通过实践实验巩固所学知识，包括连接Oracle服务器的基本与高级使用、过滤数据和通配符比较。 无论您是希望建立数据库管理坚实基础的初学者，还是希望提升技能的经验丰富的专业人士，《数据库精通：从基础到高级技术》都是您掌握数据库世界的终极指南。
Embark on a journey through the realm of databases with our comprehensive course, "Mastering Databases: From Fundamentals to Advanced Techniques." This course is designed to equip you with the essential knowledge and practical skills needed to effectively work with data in various database management systems.Spanning nine sections and forty-two lectures, this course covers everything from the basics of database management to advanced techniques for handling complex data queries and automating business logic.In Section 1, "Discovering Databases," you'll start with an introduction to databases and learn about essential activities when working with data, including different data storage types, types of relational database management systems, and database languages such as SQL.Moving on to Section 2, "Restricting Data Sets," you'll delve into filtering data and restricting query results to obtain the precise information you need.Section 3, "Transforming and Grouping Data," explores character and numeric functions, as well as the powerful Group By Clause and HAVING for data aggregation.Section 4, "INNER JOIN (Matched Data Handling)," introduces you to various types of joins, including natural joins, join with using and on clauses, additional conditions, and self joins for relating multiple entities in your database.In Section 5, "OUTER JOIN (Unmatched Data Handling)," you'll learn about outer joins, their implementation, and cross joins for handling unmatched data.Section 6, "Answering Business Questions (Sub-Queries)," covers sub-queries for answering complex business questions, including single row and multiple rows sub-queries.In Section 7, "Automate Business Logic (PL/SQL)," you'll delve into PL/SQL concepts, including creating anonymous blocks, procedures with and without arguments, and functions to automate business logic.Section 8, "Handle Data By Row (PL/SQL Cursor)," introduces you to cursors for iterating through query results, implementing conditions, and coding functions to calculate taxes.Finally, in Section 9, "Extended Lab Section," you'll put your knowledge into practice with hands-on labs covering connecting to Oracle Server, basic and advanced use of select statements, filtering data, and wildcard comparisons.Whether you're a beginner looking to establish a solid foundation in database management or an experienced professional seeking to enhance your skills, "Mastering Databases: From Fundamentals to Advanced Techniques" is your ultimate guide to mastering the world of databases.
