|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-dba-for-beginners/
课程评论：没有评论
课程名称：MySQL数据库管理：初级SQL数据库设计 概述：如果您希望发展实用的、符合实际的数据分析和商业智能技能，学习数据库管理（DBA）和分析的基础知识，那么您来对地方了。该课程承诺将提供与众不同的体验。我们将从基础开始，教授您完成工作的工具，并教您如何将技能应用于实际项目，真正像数据库管理员一样思考。您将扮演Maven Consulting的数据库管理顾问，帮助企业创建、维护和优化数据库。在课程中，您将直接与各种公司的业主合作，帮助他们管理新兴和扩展企业中的数据。您将运用所学技能完成实际的数据库管理项目。 课程大纲： 1. SQL简介与MySQL设置 - 教授如何下载并安装访问MySQL所需的工具，包括MySQL社区服务器和MySQL Workbench。 2. 创建、修改和删除模式与表 - 学习如何通过SQL代码和Workbench UI工具创建模式和表，并了解如何修改和删除。 3. 插入、更新和删除记录 - 学习如何在表中插入数据，以及如何更新和删除记录。 4. 数据库设计 - 探讨最佳实践，学习表之间的关系，并使用EER图表编辑器创建数据库模型。 5. 中期项目 - 对客户的数据库进行规范化。 6. 高级概念 - 学习创建索引、施加约束以及创建存储过程和触发器。 7. 服务器和用户管理 - 学习监控服务器并管理用户权限的工具。 8. 期末项目 - 从零开始设计和构建整个数据库。 重要说明：本课程不涵盖数据探索和数据库分析，重点在于使用MySQL和MySQL Workbench构建、修改和维护SQL/MySQL数据库。 课程提供： - 7小时高质量视频 - 可下载的MySQL电子书和备忘单 - 测验和作业 - 中期和期末SQL项目 - 30天退款保证 如果您正在寻找一份实用的手册，以掌握使用SQL/MySQL的数据库管理技能，本课程非常适合您！
If you're looking to develop practical, real-world data analytics & business intelligence skills and learn the foundations of database administration (DBA) and analysis, you've come to the right place.This course is unlike anything you've seen before, guaranteed. We'll start from the ground up, teaching you the tools to get the job done, and most importantly how to you apply your skills to real projects and learn how to truly think like a Database Administrator.You'll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases. Throughout the course, you'll be working directly with the owners of various companies to help them manage data in their new and scaling enterprises. You will use the skills you learn to complete actual projects that database administration professionals work on every day.COURSE OUTLINE:SQL Intro & MySQL SetupFor students who haven't completed one of our other SQL courses, we'll demonstrate exactly how to download and install the tools that we'll need to access MySQL, including MySQL Community Server & MySQL Workbench. We'll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we'll analyze throughout the course.Creating, Altering, and Deleting Schemas & Tables In this section we'll learn how to create schemas and tables using SQL code and with the Workbench UI tools. Then, we will learn how to alter tables by adding and removing columns. Finally, we will walk through dropping schemas and tables (be careful with this one).Inserting, Updating, and Deleting RecordsAfter we get up to speed creating and altering tables, we will learn how to populate those tables with records of data, and update and delete records as needed. Database DesignNow that we have covered the basic mechanics, we will learn how tables relate to one another optimally, and discuss best practices for database design. We will explore the EER Diagram Editor, and you will have some opportunities to create your own database models. ***MID-COURSE PROJECT: Normalize this database for your client! Advanced ConceptsIn this section, we will get into concepts like adding an index to a column, imposing constraints, and creating stored procedures and triggers. This is powerful stuff! Server & User ManagementIn our last section before the Final Project, we will learn how to monitor servers to make sure they are running, and how to restart them when needed. You will also get your hands on user management tools to assign roles and manage permissions, just like a real DBA. ***FINAL COURSE PROJECT: Design and build an entire database from scratch! IMPORTANT NOTE: This course does NOT cover data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses).______________________________Enroll today and get LIFETIME access to:7 hours of high-quality videoDownloadable MySQL ebook and cheat sheetsQuizzes and homework assignmentsMid-course and Final SQL projects30-day money-back guaranteeIf you're looking for a hands-on, practical guide to mastering database administration skills using SQL/MySQL, this is the course for you!Happy administering!-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)__________Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses!See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:"I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning - I wanted to keep charging on to the next lesson!"- Ann S."This is an excellent advanced course! I've taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work!"- Dan S."John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"- Steven M.
