|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dtgroup_database/
课程评论：没有评论
课程名称：数据库、数据建模与SQL导论 课程概述：本课程旨在为所有参与软件开发的人士提供基础知识，特别针对那些对数据建模与结构化查询语言（SQL）概念不太熟悉的学员。DT集团认为，应用程序开发不仅仅是编写代码。一个应用程序开发团队的每个成员如果能够理解其他角色，将能够更有效地执行各自的职责。本课程将引导学员探索数据建模的基本概念，涵盖以下主题： - 理解结构化数据与非结构化数据的区别 - 学习如何基于一个已知概念（以学生为例）构建数据模型以存储相关数据 - 了解数据建模中的常见错误及其解决方法 - 学习如何使用行业标准格式（实体关系图，ERD）表示数据模型 - 学习如何使用结构化查询语言（SQL）在数据库中构建数据模型 - 学习如何使用SQL与数据模型进行交互，包括常用的SQL命令（插入、更新、删除、选择） - 理解表之间的不同类型关系（联接）以及如何在SQL中使用这些关系 无论您在软件开发生命周期（SLDC）中的角色是什么，更深入地理解数据建模和数据交互将显著提高您的工作质量和交付的软件。希望您享受这门课程！注意：本课程将使用PostgreSQL数据库，并学习特定于该数据库的SQL命令。虽然这些概念适用于其他数据库（如MySQL、Oracle等），但语法可能会有所不同。这是一门实践课程，您将需要在自己的系统上安装并与数据库进行交互。请确保您的计算机上至少有2GB的可用空间，并能安装软件。
This class is designed for anyone involved in software development, with a focus on those new to the concepts of Data Modeling and Structured Query Language (SQL). At DT Group, we believe application development is about more then just code. The more all members of an application development team understand the other roles, the more effect each member of the team will become. In this class, we will walk through concepts of data modeling. This includes the following topics:Understand the difference between Structured and Unstructured Data Learn how to take a know concept ( we will use a Student) to build a Data Model to store relevant data Understand common mistakes in data modeling and how to correct themLearn how to represent this data model in an industry standard format (Entity Relationship Diagram, or ERD)Learn how to build the data model in the database using Structured Query Language (SQL) Learn how to interact with your data model using SQL, including the most common SQL commands (Insert, Update, Delete, Select) Understand the different types of relationships between tables (Joins) and how to use these in SQLRegardless of your role within the SLDC, a deeper understanding of data modeling and data interactions will dramatically improve the quality of your work and the software delivered. I hope you enjoy! NOTE:In this class, we will be using a PostgreSQL database and learning SQL commands formatted specific for this type of database. The concepts are applicable to many other databases (MySQL, Oracle, and others), but the syntax will be slightly different. This is a hands on class, where you will install and interact with a database on your own system. Please make sure you have at least 2 GB of free space on your computer and the ability to install software.
