|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-sql-with-mysql-ms-sql-server-2-courses-in-1/
课程评论：没有评论
课程名称：初学者的MySQL与Microsoft SQL Server SQL学习 课程概述：在大多数商业数据存储于关系数据库的背景下，学习SQL对任何希望成为SQL开发人员、数据库管理员、数据分析师或数据科学家的人来说都是至关重要的。SQL是创建和操作关系数据库及其存储数据的主要工具，因此掌握SQL对于维护这些数据库是必要的。课程开始时，您将学习数据建模，包括如何创建概念、逻辑和物理实体关系图（ERD）。接下来，您将学习如何安装MySQL和Microsoft SQL Server，并熟悉它们的工作环境。您将从零开始学习这两种数据库管理系统的SQL内容，包括数据定义语言（DDL）、数据操纵语言（DML）和数据转换语言（DTL）。该课程从SQL的基础知识入手，教授如何创建和管理数据库。您将学习如何创建和修改表、视图及其他数据库对象，如何在表中插入、更新和删除数据。此外，您还将学习如何使用SELECT语句从表中检索数据，并利用MySQL和Microsoft SQL Server的相关功能，例如聚合函数、转换函数和日期函数等。最后，您将学习不同类型的SQL连接，以从多个表中检索数据。
As most of the business data stored in relational databases, learning SQL is essential for anyone wants to be a SQL developer, database administrator, data analyst or data scientist. Since SQL is the main tool used to create and manipulate relational databases and their stored data, mastering SQL is necessary to maintain them. You will learn in the beginning of this course, data modeling including how to create conceptual, logical, and physical ERD's (Entity Relationship Diagram). After that you will learn how to install MySQL and Microsoft SQL Server and be acquainted in their work environments. You will learn SQL from scratch in both two database management systems. You will learn DDL, DML, and DTL SQL. This course starts with the basics of SQL like creating and managing a database. You will learn how to create and modify tables, views and other database objects. You will learn how to insert, update and delete data in tables. Also, you will learn retrieving data from tables using SELECT statement in both MySQL and Microsoft SQL Server. You will learn using the most important functions in SELECT quires, such as: aggregate, conversion, and date functions. Furthermore, you will learn different types of SQL joins to retrieve data from multiple tables.
