|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/structured-query-language-sql-level-up-masterclass-2022/
课程评论：没有评论
**课程名称：MySQL 从基础到高级：进阶大师课程** **课程概述：** 本课程全面介绍关系型数据库语言——结构化查询语言（SQL）。课程内容涵盖：实体-关系建模、关系模型、SQL语言的数据检索、数据操作和数据定义语句。所有互动阅读题均使用“实时”SQL进行，作业则通过学生自行安装的MySQL数据库完成。课程中，学生将开发一个真实的数据库项目。 **先修要求：** 本课程面向希望达到SQL基础到高级水平的数据库开发者或学生。需要具备基本的计算机操作能力。 **课程价值：** 本课程为计算机科学和信息学专业学生在数据库或数据科学领域打下坚实基础。对于计划从事软件工程和开发的学生来说，掌握SQL也是一项重要技能。此外，本课程也服务于非CS专业学生，特别是那些在社会科学、商业、生物及物理科学等领域工作或计划从事相关领域的学生，他们需要处理或计划处理关系型数据库和数据科学。 **课程目标：** * 掌握中高级SQL。 * 能够编写数据检索查询并评估结果集。 * 能够编写SQL语句来编辑现有数据。 * 能够编写SQL语句来创建数据库对象。 * 理解关系型数据库的结构和设计。 * 理解数据库安全和数据完整性维护的重要性及主要问题。
Course Description: This course provides a comprehensive introduction to the language of relational databases: Structured Query Language (SQL). Topics covered include: Entity-Relationship modeling, the Relational Model, the SQL language: data retrieval statements, data manipulation and data definition statements. All interactive reading problems involve the use of "live" SQL. Homework will be done using databases running in MySQL which students install on their machines. Students develop a real-world database project using MySQL during the course.Prerequisites: This course is designed database developers or students who desire a basic to advance level of proficiency with the Structured Query Language (SQL). Prerequisite: Basic computer literacy including.Justification: This course will provide a solid preparation in SQL in the Computer Science and Informatics majors who plan to take database or data science courses. A knowledge of this material is also an important skill for anyone planning to do software engineering and development. It is also a service course for students outside of the CS major who work with or plan to work with relational databases and data science such as students studying social science, business, biological and physical sciences, among others.Course Objectives:Learn structured query language (SQL) to an intermediate/advanced level.Be able to write data retrieval queries and evaluate the result set.Be able to write SQL statements that edit existing data.Be able to write SQL statements that create database objects.Understand the structure and design of relational databases.Understand the importance and major issues of database security and the maintenance of data integrity.
