|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-and-database-management/
课程评论：没有评论
课程名称：MySQL数据库管理：掌握数据优化 课程概述： MySQL可以运行在各种硬件上，从普通设备到企业级服务器，其性能与任何数据库系统相媲美。MySQL结合了关系数据库的强大功能，同时易于设置和管理。本课程将为您提供所需的所有工具，帮助您轻松入门。本课程采用系统化、简明的方法，通过50个简短快速的学习单元，让您可以快速完成学习。课程非常适合希望在编程技能上增添新内容的初学者。同时，对于已经完成在线课程或训练营的新编码者而言，本课程也将为您在已有知识基础上构建提供极大的价值。 您将学习的内容包括： 1. 设置包管理器 2. 设置工作环境 3. SELECT 语句、关键字、表达式和函数 4. ORDER BY 升序和降序 5. WHERE 子句、LIKE 和 IN 子句 6. 数据的插入和更新 7. 创建和使用数据库 8. 使用表、索引和约束 9. 日期和时间类型及函数 10. 使用触发器和事务 11. 例程、函数和过程 12. PDO 总结： 通过本课程的学习，您将获得扎实的MySQL基础，使您能够自信地管理数据库，执行查询，并在实际场景中应用最佳实践。无论您是刚入门还是希望在现有知识上进行扩展，这门课程都将为您提供必要的实用技能，助您在数据库管理领域脱颖而出。
MySQL runs on anything from modest hardware all the way up to enterprise servers, and its performance rivals any database system put up against it. It offers the power of a relational database in a package that's easy to set up and administer, and this course will provide all the tools you need to get started.In this course, you'll learn methodically, systematically, and simply-in 50 short, quick lessons that will each take very less to complete.The course is ideal for the inexperienced programmer interested in adding these skills to their toolbox. New coders who′ve made it through an online course or boot camp will also find great value in how this course builds on what you already know.What you'll learn: 1. Setup a Package Manager2. Setup Working Environment3. Select, Keyword, Expressions and Functions4. ORDER BY ASC and DESC5. WHERE Clause, LIKE and IN Clauses6. Insert and update data7. Create and use database8. Use tables, indexes, constraints9. Date and time types and functions10. Use triggers and transactions11. Routines, Functions, Procedures12. PDOConclusion:By the end of this course, you'll have a solid foundation in MySQL, empowering you to confidently manage databases, perform queries, and apply best practices in real-world scenarios. Whether you're just starting out or building on your existing knowledge, this course will equip you with the practical skills necessary to excel in database management.
