|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-complete-mysql-for-developers/
课程评论：没有评论
课程名称：完整的 MySQL 初学者课程 概述：欢迎参加完整的 MySQL 开发者课程，本课程是成为 MySQL 大师的实用指南。该课程从零基础开始，逐步提升您的 SQL 数据库技能。您将学习如何一步步在本地机器上安装 MySQL，以及如何使用 MySQL Workbench（我们将用于操作 MySQL 数据库引擎的主要 GUI）。此外，您还将学习如何在市场上最热门的云服务提供商，如 AWS（亚马逊网络服务）和微软 Azure 上创建自己的云数据库。课程将介绍数据库即服务（DBaaS）和亚马逊关系数据库服务（RDS）等概念。 掌握 MySQL 和关系数据库的基本概念后，您将准备好开始与数据库引擎交互。课程内容包括： - 创建数据库和模式的步骤 - 使用 SQL 脚本和 Workbench 创建和删除表 - 理解 DML、DDL、模式、DBaaS 等重要术语 - 根据权限创建用户以访问数据库 - 创建不同的约束条件 - 创建主键、外键和复合键 - 批量导入和导出数据 - 使用 SELECT 语句检索数据 - 使用 WHERE 子句过滤数据 - 使用聚合函数（如 Sum、Min、Max 等） - 学习使用 GROUP BY 和 HAVING 结合聚合函数 - 使用 CASE 语句 - 掌握数据操作的基本语句（INSERT、UPDATE 和 DELETE） - 使用 BETWEEN、IN、DISTINCT、EXISTS 等关键字 - 理解如何创建子查询 - 设计复杂的数据库关系 - 轻松克隆数据库表 课程中，您将从头设计一个小型人力资源数据库，并将使用 Sakila 数据库（一个预先准备好的示例关系数据库）进行实践。您将学习如何在数据库服务器上安装 Sakila 数据库，并对人力资源数据库和 Sakila 数据库执行各种 SQL 查询和语句。课程提供超过 30 个真实世界的练习，帮助您实操并深入理解每个主要主题，讲师会逐步演示解决这些练习，同时也会给予您时间自己尝试。 所有 SQL 脚本均可随时下载，让您的简历因掌握 MySQL 而大幅提升。现在就注册并开始掌握 MySQL 吧！
Welcome to the Complete MySQL For Developers Course, The practical guide to become a MySQL masterThis course will start with you from zero level experience in SQL databases, starting to level up as we are going through the course.This course will guide you how to install MySQL on a local machine step by step and how to workwith MySQL Workbench (The main GUI that we will be using to work with MySQL Database engine) then you will learn how to create your own cloud databases on the most required cloud services providers in the market...AWS (Amazon Web Services) and Microsoft Azure.You will learn what is meant by concepts like DBaaS and Amazon Relational Database Service (RDS) After you learn the basic concepts of the MySQL and relational databases and how to install it on a machine and on the cloud, You will be ready to start interacting with the database engine, some of the topics this course will cover: How create a database and schema.How create and drop tables using both SQL script and easily with Workbench.Understand the famous terms DML, DDL, schemas, DBaaS and more.You will learn how to create users to access your database based on specific permissions you gave them.How to create different constraints.Create primary keys, foreign keys and composite keys. How to export and import a bulk of data in and out of your database.How to retrieve data from your database using select statement.How to filter data using where clause.How to use aggregate functions (Sum, Min, Max..etc).Learn how to use group by and having with aggregate functions.How to use case statement.Master data manipulation with the essentials statements (insert into, update and delete)How to use the keywords like between, in, distinct, exists and more.Understand how to create subqueries.How to design complex database relations.Cloning database tables easily.You will be designing a small human resources database from scratch, and we will also work with the Sakila database. Sakila is sample relational database ready for you to test and use it. You will learn how to install Sakila database onto your database server and we are going to perform different SQL queries and statements on both HumanResources and Sakila.With over 30 real world exercises to help you practice and learn more about almost each major topic in the course, I am going to solve all of the exercises with you while giving you some time to try to solve it on your own.All the SQL scripts I will be using in this course are available for you to download anytime.Give your CV a huge boost by mastering MySQL with the Complete MySQL for developers course, Enroll now and start mastering MySQL.
