|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-and-sql-from-beginner-to-advanced/
课程评论：没有评论
课程名称：MySQL、SQL 和存储过程从初学者到高级 课程概述：本课程旨在将您从SQL和MySQL的初学者提升到高级水平。无论您是只具备基本计算机知识的完全初学者，还是希望深入了解事务、用户权限、触发器和存储过程等高级功能的专业人员，这门课程都能满足您的需求。在IT行业中，数据库技能的需求非常旺盛；无论是网站还是多人游戏，几乎都需要某种形式的数据库。MySQL是一个免费的工业级关系数据库，在全球范围内被广泛使用。实际上，本课程涉及到的MySQL社区服务器是全球最受欢迎的开源数据库，服务于数百万个网站。 从基础开始掌握MySQL的高级功能：在本课程中，您将首先学习如何使用SQL与MySQL创建、查询和添加数据到数据库。随着课程的深入，我们将探讨MySQL的高级功能，这些功能对于充分利用MySQL至关重要，包括事务、索引、隔离级别、视图、触发器和存储过程。您将学习如何使用SQL创建强大且高效的数据库，如何阅读和创建增强实体-关系（EER）图，理解并实现"多对多"和"一对多"等表关系，更甚至如何使用免费的MySQL Workbench客户端工具进行可视化数据库设计。课程结束时，您将对MySQL的强大功能有深入的理解，超越大多数专业软件开发人员，并具备的SQL知识将帮助您掌握任何关系数据库。您将能够创建和查询自己的数据库，并利用事务、存储过程、约束、索引、视图等功能，确保您的数据库高效且安全。
This course will take you from beginner in SQL and MySQL to an advanced level. Whether you're a complete beginner with only basic computer knowledge, or a professional who already uses MySQL but wants to understand advanced features like transactions, user permissions, triggers and stored procedures, this course can help you. Database skills are highly in demand in the I.T. industry; everything from websites to multiplayer games are likely to make use of some kind of database. MySQL is a free, industrial-strength relational database, very widely used all over the world. In fact, the MySQL Community Server (which this course covers to an advanced level) is the world's most popular open-source database, used by millions of websites.Master Advanced MySQL Features, Starting from the Ground Up In this course you'll begin by learning the basics of creating, querying and adding data to databases using SQL with MySQL. As the course progresses, we'll move on to advanced features, vital for getting the most out of MySQL, including transactions, indexes, isolation levels, views, triggers and stored procedures. You'll learn how to create powerful and efficient databases using SQL, how to read and create EER diagrams, how to understand and implement table relationships like "many to many" and "one to many", and even how to design databases visually using the free MySQL Workbench client tool. By the end of the course you'll understand MySQL's powerful features to a greater level than probably most professional software developers, and you'll have an understanding of SQL that will help you get to grips with any relational database. You'll be able to create and query your own databases and use transactions, stored procedures, constraints, indices, views and other features to ensure your database is efficient and secure.
