|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-design/
课程评论：没有评论
课程名称：数据库设计 课程概述：无论您使用哪个数据库应用程序，本课程将覆盖所有关系数据库管理系统的设计概念。该课程旨在为希望下载课程或观看无广告视频的学习者提供支持，特别适合关系数据库设计的学习者。课程将介绍最受欢迎的数据库实例，包括 MySQL、Oracle、Microsoft SQL Server、PostgreSQL、SQLite、MariaDB 等。 我们将从基础开始，首先了解数据库是什么以及它与电子表格、网站、文件柜等的区别。课程中将介绍 SQL，包括数据定义语言和数据操作语言。经过四个重点视频的讲解，我们将深入学习实体和属性的概念，并将这些概念应用于表格和关系的结构设计。我们将详细讲解如何设计所有关系，视频中将使用黑板对概念进行解释，以帮助深入理解数据库设计。 在掌握所有数据库设计概念后，学习者将逐步进行从头到尾的数据库设计。课程不需要任何编程技能，也不会教授数据库编程。而是专注于如何最好地设计您的数据库。您可能会想，为何如此庞大的课程仅涉及数据库设计。实际上，数据库设计是数据库管理中极为重要的一部分，好的设计能带来最佳结果，并使数据库编程变得更加简单。 完成该课程后，您应该可以自信而熟练地应对几乎任何数据库设计项目。请注意，学习数据库设计需要时间和努力，确保在每个视频后做笔记并反思所学内容，做好记录将使这门课程的学习变得更加轻松。
Whichever database application you use does not matter! This course will cover design concepts for all relational database management systems. This course is designed for those who want to download this course or watch it ad free. This is a course for relational database design. Here are some examples of the most popular databases: MySQL Oracle Microsoft SQL Server PostgreSQL SQLite MiariaDB and MORE! We start off this course by taking our time to first look at what a database is and how it differs from a spreadsheet, website, filing cabinet, and so forth. We introduce SQL and talk about data definition language and data manipulation language. After about 4 solid videos of explaining databases and SQL, we dive into learning about entities and attributes. We apply all of these concepts to structure tables and relationships. We learn to design all of the relationships and I explain everything in depth. Most of the videos are on my chalkboard, explaining concepts. This is because it helps to fully understand database design before you dive into designing your own database. Once we go over all of the concepts of database design we will be designing databases from start to finish. No programming skills are required. This course does not program a database. This course will only be teaching how to best design your database. You may be wondering why such a large course is required for only designing a database. Well, designing a database is an extremely important part of database management. The best design will get us the best results and make programming our database really easy. After this course you should be able to tackle almost any database design project with confidence and skill. Keep in mind though that learning database design takes a lot of time and effort. Be sure to take notes and stop after each video to reflect on what you've learned. Keeping notes will make this video course a whole lot easier!
