|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/introduction-to-database-queries/
课程评论：没有评论
课程名称：数据库查询入门 课程概述：本课程旨在教授使用关系数据库管理系统所需的所有知识，适用于web、云和嵌入式应用程序。无论是在信息技术、软件工程、网络安全还是计算机科学领域，数据库开发和管理技能都是必不可少的。本课程将采用开源关系数据库MySQL，MySQL及其开源分支MariaDB被广泛应用于数百万个网络应用中，以持久化应用数据及处理查询。学生将在实验室中获得宝贵的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 1st course of 3 in the program and focuses on learning to query a database. We will drill into tools, single-table queries, multiple-table queries, and queries that modify data in the database.
