|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-database-administration/
课程评论：没有评论
课程名称：高级数据库管理 课程概述：本课程将教授您在Web、云和嵌入式应用程序中使用关系数据库管理系统所需的所有知识。数据库开发和管理技能在大多数信息技术、软件工程、网络安全和计算机科学岗位中都是必需的。课程采用开源关系数据库MySQL，MySQL及其开源分支MariaDB被广泛应用于数百万个Web应用程序中，负责持久化应用数据和提供查询处理。学生将在实验室中获得有价值的SQL查询编程实践。此外，除了应用SQL实验外，您还将了解关系型数据库的一般知识，学习如何设计一个稳健高效的数据库。您将借助SQL的学习，学会构建数据库、填充数据并通过广泛的实践查询数据。该自学课程为本科级别的数据库编程和管理提供了介绍，帮助学生为更高级的计算机科学、信息技术或网络安全课程做好准备。 课程目标：完成本课程后，学生应能够： - 应用关系代数查询以检索数据； - 使用SQL进行数据库的数据创建、读取、更新和删除； - 理解实体完整性约束和参照完整性约束的概念（包括外键的定义）； - 描述关系的范式（1NF、2NF、3NF、BCNF和4NF）； - 对关系应用规范化，以创建一组BCNF关系并去规范化关系模式； - 描述两个或多个属性之间的函数依赖，且它们是关系的子集； - 理解多值依赖，并在关系模式中识别示例； - 绘制概念数据模型（包括ER图）以描述数据库结构； - 应用SQL基于概念和关系模型创建关系数据库模式； - 使用商业关系数据库管理系统应用存储过程、函数和触发器； - 描述并发控制及其如何受数据库的隔离级别影响。 这是该项目的第三门课程，重点讲解更高级的数据库管理知识，深入探索数据库中的存储对象，如索引、视图、存储过程和函数。
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 3rd course of 3 in the program and focuses on more advanced database administration. We will drill into stored objects in the database such as indexes, views, stored procedures, and functions.
