|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-database-queries/
课程评论：没有评论
课程名称：高级数据库查询 课程概述：该课程旨在教授学生使用关系数据库管理系统的各种技能，适用于Web、云计算及嵌入式应用程序。数据库开发和管理技能是信息技术、软件工程、网络安全及计算机科学等众多职位所需的重要能力。课程采用开源关系数据库MySQL进行教学，MySQL及其开源分支MariaDB在数百万个Web应用中用于持续应用数据和查询处理。学生将在实验中获得宝贵的SQL查询编程实践经验。除了实践SQL实验外，学生还将全面了解关系数据库，从设计鲁棒且高效的数据库开始。此外，学生将学习如何利用SQL构建数据库、填充数据并通过广泛的实践进行查询。本课程为自学型，将为学生提供本科学级别的数据库编程和管理入门知识，帮助他们为更高级的计算机科学、信息技术或网络安全课程做好准备。 课程目标：完成本课程后，学生应能够： - 使用关系代数查询检索数据； - 应用SQL查询创建、读取、更新和删除数据库中的数据； - 描述实体完整性约束和引用完整性约束的概念（包括外键的定义）； - 解释关系的各种范式（1NF、2NF、3NF、BCNF和4NF）； - 将规范化应用于关系，以创建一组BCNF关系并对关系模式进行反规范化； - 描述两个或多个属性之间的功能依赖关系，这些属性为关系的子集； - 理解多值依赖并能够在关系模式中识别示例； - 草拟概念数据模型（包括ER图）以描述数据库结构； - 使用SQL根据概念和关系模型创建关系数据库模式； - 使用商业关系数据库管理系统（DBMS）应用存储过程、函数和触发器； - 描述并发控制及其在数据库隔离级别中的影响。 这是该课程系列的第二门课程，重点关注更高级的数据库查询，内容包括聚合、子查询、数据类型、函数及数据库设计。
This program will teach you everything you need to know to use a relational database management system in the Web, the Cloud, and embedded applications. Database development and administration skills are required in most Information Technology, Software Engineering, Cybersecurity, and Computer Science jobs. The courses utilize the open-source relational database MySQL. MySQL and its open-source fork, MariaDB, are used in millions of web apps to persist the application data and provide query processing. Students gain valuable hands-on experience programming SQL queries in the labs. In addition to the applied SQL labs, you will also gain an understanding of relational databases in general, learning how to design your database so it's robust and efficient. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data, and query that data through extensive hands-on practices.This self-paced program provides an undergraduate-level introduction to database programming and administration that will help prepare students for advanced undergraduate computer science, information technology, or cybersecurity coursework.Course ObjectivesBy the end of this program, students should be able to:Apply queries in relational algebra to retrieve data.Apply queries in SQL to create, read, update, and delete data in a database.Apply the concepts of entity integrity constraint and referential integrity constraint (including the definition of the concept of a foreign key).Describe the normal forms (1NF, 2NF, 3NF, BCNF, and 4NF) of a relation.Apply normalization to a relation to create a set of BCNF relations and denormalize a relational schema.Describe functional dependency between two or more attributes that are a subset of a relation.Understand multi-valued dependency and identify examples in relational schemas.Sketch conceptual data models (including ER) to describe a database structure.Apply SQL to create a relational database schema based on conceptual and relational models.Apply stored procedures, functions, and triggers using a commercial relational DBMS.Describe concurrency control and how it is affected by isolation levels in the database.This is the 2nd course of 3 in the program and focuses on more advanced querying of the database. We will drill into aggregation, subqueries, data types, function and database design.
