|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/relational-database
课程评论：没有评论
课程名称：关系数据库系统 概述：欢迎参加关系数据库系统的专业课程。本课程将持续六周，配有视频和各种文档，帮助您以简单的方式学习多种类型的信息系统和数据库，以解决企业的不同问题和需求。 目标：学习者能够根据业务需求设计、测试和实施分析性、事务性或NoSQL数据库系统，通过使用SQL和Hadoop生态系统编写可靠、可扩展和易维护的应用程序和资源。 编程语言：第一课将使用MYSQL语言。 软件下载： - MySQL - Workbench 如果您使用的是Mac / IOS操作系统，需要使用虚拟机（如VirtualBox、Vmware）。 课程大纲： 1. **信息系统** 描述：第一模块将学习人员、硬件、软件、网络、技术和程序如何协同工作，以自动化企业日常运营所需的事务处理过程。 2. **实体关系理论与概念设计** 描述：本模块专注于概念设计。学习者将能够根据业务需求创建实体关系图。 3. **关系数据库理论与逻辑设计** 描述：本模块专注于逻辑设计。学习者将能够从实体关系图创建关系模型。 4. **结构化查询语言数据操作语言** 描述：本模块关注物理设计。学习者将能够使用结构化查询语言创建具有数据定义语言的数据库对象。 5. **结构化查询语言及高级SQL编程** 描述：本模块关注SQL编程中的数据操作语言，以填充和查询关系数据库对象。 6. **事务与查询优化** 描述：本模块专注于根据信息系统类型进行查询优化。 本课程旨在为学习者提供全面的关系数据库系统知识，使其能够在实际业务中有效应用。
Name:Information Systems
Description:In the first module named information systems, we will learn how people, hardware, software, networks, techniques and procedures work together to automate transactional processes that companies need for their daily operations. Let's start!
Name:Entity Relationship Theory and Conceptual Design
Description:The present module is focused on Conceptual Design. The learner will be able to create an Entity Relationship Diagram through the Conceptual Design from business requirements.
Name:Relational Database Theory and Logical Design
Description:The present module is focused on Logical Design. The learner will be able to create an Relational Model from the entity-relationship diagram
Name:Structured Query Language Data Manipulation Language
Description:The present module is focused on Physical Design. The learner will be able to create database objects with data definition language from the Structured Query Language.
Name:Structured Query Language and Advanced SQL Programming
Description:The present module is focused on Data Manipulation Language on SQL programming to feed and query relational database objects.
Name:Transactions and query optimization
Description:The present module is focused on query optimization according to type of information systems.
Welcome to the specialization course Relational Database Systems. This course will be completed on six weeks, it will be supported with videos and various documents that will allow you to learn in a very simple way how several types of information systems and databases are available to solve different problems and needs of the companies. Objective: A learner will be able to design, test, and implement analytical, transactional or NoSQL database systems according to business requirements by programming reliable, scalable and maintainable applications and resources using SQL and Hadoop ecosystem. Programming languages: For course 1 you will use the MYSQL language. Software to download: MySQL Workbench In case you have a Mac / IOS operating system you will need to use a virtual Machine (VirtualBox, Vmware).
