|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/intro-to-databases-back-end-development
课程评论：没有评论
课程名称：后端开发的数据库入门 课程概述：后端开发人员编写用户与数据库互动的应用程序。用户通过这些应用程序执行存储、搜索、提取和操作数据等常见任务。因此，所有后端开发人员都必须具备强大的数据库知识和经验。本课程将介绍数据库的基本概念，以及如何利用数据库存储和管理数据的不同方法。 课程大纲： 1. **数据库介绍**：学习课程概述，探讨数据库工程师的职业角色，成功完成课程的小贴士，以及希望学习的内容。了解数据库和数据的基本知识，以及数据库的工作原理。介绍SQL（标准查询语言）和数据库的基本结构及其使用的不同类型的键。 2. **创建、读取、更新和删除（CRUD）操作**：探索CRUD操作的基本概念，学习SQL数据类型，区分数值数据、字符串数据和默认值。通过练习掌握在数据库项目中利用这些数据类型，并学习如何在数据库中创建和读取数据，更新和删除数据的SQL语句，以及完成管理数据的练习。 3. **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.
Back-end developers write applications that end-users use to interact with databases. Some common tasks that end-users carry out using these applications include storing, searching, extracting and manipulating data. Therefore, it’s essential that all back-end developers possess strong knowledge and experience with how databases work. In this course, you’ll receive an introduction to databases and explore the different ways in which they can be used to store and manage data. You’ll also learn t
