|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/the-ultimate-mysql-bootcamp-go-from-sql-beginner-to-expert/
课程评论：没有评论
课程名称：《终极MySQL训练营：从SQL初学者到专家》 课程概述：本课程经过全新改版，包含超过325个全新录制的视频，使用MySQL 8.x，并包括窗口函数、视图和SQL模式等新主题。如果你想了解如何从数据中获取洞察，但对数据库感到畏惧，不知从何开始，那么这个课程正适合你。该课程以温和而全面的方式介绍MySQL，帮助你掌握这一当今商业领域中极为重要的技能。不论你是在销售或市场工作，还是运营自己的公司，亦或是想要开发自己的应用程序，精通MySQL对于通过数据解答复杂的商业问题至关重要。 《终极MySQL训练营》将为你打下坚实的数据库基础，内容不仅信息丰富且充满吸引力。你将在课程中学习到： - SQL语法的基本和高级技巧 - 使用销售和用户数据生成报告 - 运用聚合函数分析数据 - 利用MySQL逻辑运算符和字符串函数运行复杂查询 - 编写所有常见的SQL连接 - 处理包含成千上万条记录的大型数据集 - 设计和实现复杂的数据库模式 - 学会在存储日期和时间时避免常见陷阱 - 克隆一个照片分享社交网络的数据库结构 - 使用MySQL 8.x的窗口函数（如RANK、LEAD、LAG、NTILE等） - 创建MySQL数据库视图和虚拟表 课程中还充满了练习、挑战、项目以及实践机会，让你将所学应用于现实世界的挑战，如寻找网站的活跃用户、计算最佳学生、识别网站上的机器人，或确定哪些标签能产生最有效的曝光。课程中你也能见到我的宠物猫Blue，她非常可爱！ 学习MySQL的原因：SQL在最近的雇主调查中一直被评选为最受欢迎的技能，是提升收入和职业发展的绝佳方式。许多现今的公司都在使用MySQL，包括Twitter、Uber、Airbnb、Dropbox、Github、Kickstarter、Udemy、Slack等。对于SQL和MySQL的区别有疑问吗？MySQL是最流行的开源SQL数据库，因此是你学习旅程的理想起点。我们会深入讨论SQL与MySQL的不同，但在本课程中，你学到的95%的MySQL知识同样适用于其他数据库，如Postgres、Oracle和Microsoft SQL Server。 课程亮点：本课程不只是让你观看我编程20小时，你将获得大量实际动手编写代码的机会（甚至在课程的前七分钟内）。我的教学经验深根于课堂，与线下面对面课程相结合，提供了在线学习的便利。在完成本课程后，你将能够与任何SQL数据库互动和查询，轻松生成报告，通过数据解决公司绩效问题，并将MySQL整合到完整的应用程序中。 让我们开始吧！今天就报名，开始学习SQL！
This course was just completely redone and rebuilt from the ground up, with over 325 brand new videos recorded. The course now uses MySQL 8.x and covers new topics including: Window Functions, Views, and SQL modes.If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today. Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that's both informative and engaging. Yes, that's right, it's possible to make an engaging course on databases. In this course, you will:Learn the ins and outs of SQL syntaxGenerate reports using sales and user dataAnalyze data using Aggregate FunctionsRun complex queries using MySQL logical operators and string functionsWrite all the common SQL joinsWork with large datasets containing thousands of entriesDesign and implement complex database schemasLearn to navigate the treacherous world of storing dates and timesClone the database structure of a photo sharing social networkWork with MySQL 8.x Window Functions: RANK, LEAD, LAG, NTILE, etc.Create MySQL database views and virtual tablesThis course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you're learning. Apply what you're learning to real-world challenges such as finding a website's power users, calculating your top students, identifying bots on a site, or determining which hashtags generate the most traction on a site. Along the way, you'll also get to meet my pet cat, Blue! (She's really cute.)Why Learn MySQLConsistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open source SQL database out there, so it's a great choice to begin your learning journey. We'll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.Why This Course Is Different This isn't going to be a course where you watch me code for 20 hours; it's a course with ample opportunity for you to get your hands dirty writing code (even within the first 7 minutes of the course).My teaching experience is rooted in the classroom. I've spent years teaching programming, web development, and databases to my in-person bootcamp students. This course combines the best of my offline courses with the convenience of learning online, in a setting that's best for you. Upon completing this course, you'll be able to interact with and query any SQL database out there. You'll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.So let's do this! Enroll today and start learning SQL!
