Introduction to Databases

所在平台: Coursera

课程主页: https://www.coursera.org/learn/introduction-to-databases

课程评论：没有评论

第一个写评论        关注课程

课程简介

课程名称：数据库入门 课程概述：本课程将带您了解数据库的基本概念，并探索它们的现代应用方式。您将学会区分不同类型的数据库管理系统，并通过使用结构化查询语言（SQL）命令进行基本的数据库创建和数据选择练习。 通过本课程的学习，您将能够： - 展示对数据库工作原理及其基本概念的理解 - 识别并解释数据库中使用的不同核心技术和管理系统 - 识别和解读基本的SQL语句和命令 - 使用SQL语句和命令操作数据库中的记录 - 概述SQL的替代方案 - 规划和执行一个简单的数据库开发项目 您将获得使用以下工具和软件的经验： - MySQL软件 - 基本SQL语法和命令 - 数据库管理系统 - NoSQL - MongoDB - 数据库记录 课程大纲： 1. **数据库入门**：介绍课程内容及可能的数据库工程师职业角色，讨论学习目标，了解数据库和数据的基本知识，学习标准查询语言（SQL）的基本结构及不同类型的键。 2. **创建、读取、更新和删除（CRUD）操作**：探索CRUD操作，了解SQL数据类型，学习如何创建和读取数据库中的数据，并学习如何更新和删除数据库中的数据。 3. **SQL运算符及数据的排序和过滤**：学习SQL运算符，了解如何使用SQL进行数据排序和过滤，掌握相关的SQL语句如Order By、Where和Select Distinct。 4. **数据库设计**：了解数据库设计的基本概念，学习如何设计数据库模式，探索关系型数据库设计及表之间的关系。 5. **评分评估**：回顾所学内容，识别自己的强项及需要重新学习的主题。 通过这个课程，您将全面掌握数据库的基本知识及技能，为今后的学习和职业发展奠定坚实基础。

课程大纲

Name:Introduction to Databases

Description:In this module, you’ll receive an introduction to the course and explore possible career roles that you could follow as a database engineer. You’ll also review some tips on how to take this course successfully and discuss what it is that you hope to learn. As part of your introduction, you’ll learn about the basics of databases and data and how they work. You’ll then receive an introduction to SQL, or Standard Query Language, the coding syntax used to interact with databases. Finally, you’ll explore the basic structure of databases and discover the different types of keys they use.

Name:Create, Read, Update and Delete (CRUD) Operations

Description:In this module, you’ll explore CRUD, or Create, Read Update and Delete operations. You’ll begin with an exploration of SQL data types and learn how to differentiate between numeric data, string data and default values. You’ll also embark upon several exercises in which you’ll learn how to utilize these different data types within your database projects. You’ll then move on to learn how to Create and Read data within a database. You’ll discover how to create databases and tables and populate them with data using SQL statements. Lastly, you’ll explore the SQL statements used for updating and deleting data in a database. And to demonstrate your ability with CRUD operations, you’ll complete exercises that will task you with creating and managing data.

Name:SQL Operators and sorting and filtering data

Description:In this module, you’ll explore SQL operators and learn how to sort and filter data. You’ll begin this module with a lesson on SQL operators. As part of this first lesson, you’ll explore the syntax and process steps used to deploy SQL arithmetic and comparison operators within a database. Next, you’ll discover how to sort and filter data using clauses. The clauses that you’ll learn about include the Order By clause, Where clause and Select Distinct clause. In each lesson item, you’ll receive an overview of how each clause is used to sort and filter data in a database. You’ll also view demonstrations of these clauses and then receive an opportunity to try them for yourself.

Name:Database design

Description:In this module, you’ll learn about database design. In the first lesson, you’ll receive an overview of how to design a database schema. As part of this overview, you’ll learn about basic database design concepts like schema and find out about different types of schemas. The next lesson focuses on relational database design. In this lesson, you’ll explore how to establish relationships between tables in a database using keys. You’ll also learn about the different types of keys that are used in relational database design, such as primary keys and foreign keys.

Name:Graded assessment

Description:In this module, you’ll have an opportunity to recap what you learned and identify your strengths as well as target topics that you would like to revisit in this course.

课程评论(0条)