|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/practice-advanced-sql-with-mysql/
课程评论：没有评论
课程名称：使用 MySQL 5.7+ 练习高级 SQL 查询 概述：本课程专为已掌握基础知识的学习者设计，旨在帮助您提升到一个新水平。无论您是 BI 分析师、IT 专家、QA 分析师、自动化测试员、数据库管理员、或有志于成为数据科学家的人士，您都会学到如何使用分析函数、利用表分区、编写用户定义函数和程序、使用游标等高级 SQL 技巧。此外，课程特别关注最受欢迎的开源数据库 MySQL。我们将共同编写代码和 SQL 查询，课程包括两个测试数据库、70 多节讲座、4 小时以上的视频以及丰富的实例和实践，让您通过编写代码来学习高级 SQL 技巧。 优惠承诺：如果您在学习后认为没有学到任何东西，可以在 30 天内向 Udemy 申请全额退款。 课程亮点： - 我会分享我多年在编写高级 SQL 代码方面的最佳实践。 - 课程内容丰富，某些视频因内容量大而分为多个部分，以便于学习。 -您将通过实例和实践掌握 MySQL 的高级 SQL 概念。 - 附件中提供了课程中使用的所有 SQL 代码的 .md 文件。 - 本课程不涵盖数据库安装及 SQL 工具的基础知识，专注于 MySQL。 学习建议：建议您在一天内集中精力学习，关闭手机，全情投入。 课程内容包含前后阶段的测验，以便您在课程开始时检查自己的 SQL 知识水平，课程结束后再进行一次测验来评估进步情况。 课程适合群体：任何已经掌握 SQL 基础的人，尤其是 BI 开发者、自动化测试员、数据分析师及数据库管理员都将受益匪浅。 课程反馈：许多学员对课程给予了高度评价，称赞课程内容丰富，能有效提升 SQL 技能。 享受 SQL 和 MySQL 的学习乐趣！
I designed this course especially for those who already know the basics and wonder how to get to the next level. Maybe you're a BI analyst, IT specialist, QA analyst, automation tester, DB admin, aspiring data scientist or just passionate to learn SQL. You'll learn how to use analytic functions, how to take advantage of table partitioning, how to write user-defined functions, procedures with cursors and even how to write beautiful code. All of that with the focus on the most popular open-source database: MySQL. In this course, we'll write the code & MySQL queries together. I prepared 2 test databases, 70+ lectures, 4+ hours of video and lots of examples and practices so that you can learn advanced SQL techniques by writing the code. You'll not learn just by watching me and eating pop-corn. You need to write the queries, and I'll help you! I believe that's the only way for you to adopt this new knowledge. At the end of this course you will not just know these advanced techniques, but also know how to use them in practice. Anyways, you have nothing to lose. Try this course and if you can honestly say that you learned nothing, just email Udemy, and they will give you a 100% refund within 30 days. Recent reviews"The course was great. Now, I write beautiful queries, using coding style conventions and best practices." -MauroVideo Last course update: March 2017Video quality: Very high (1080p HD, 1920x1080)Length: Over 5 hours Course Highlights We'll go through my personal best practices in writing advanced SQL code which I adopted in the last years. Thus some of the videos are long and content-heavy. I had to divide some of them into three parts because of Udemy's limit of 20 mins/video. If you are a BI developer, automation tester, data analyst, or a DB admin, I'm sure you'll appreciate the hands-on examples and practices. They will help you understand the concepts and learn them by writing the advanced SQL code for MySQL. If you have a tech background, you'll like the attached.md files with all the SQL code used in the course. Please note Basics such as how to instal a database and SQL tools is not covered in the course.This course focuses on MySQL, not PostgreSQL (a new course focused on PostgreSQL coming soon!). Did you know? Did you know that even SQL code can be beautiful? The more advanced SQL code I wrote for MySQL or PostgreSQL, the more I focused on writing beautiful code. It's especially important if you work with several colleagues on the same codebase.I recorded all the video content (5+ hours of final footage) in one day, from early morning to late night? I believe you need to get into the zone to produce great content, be creative or to learn efficiently. Thus I recommend the same to you: purchase this course, dedicate 1 full day to it, turn off your smartphone and learn, learn, learn.There's a quiz before and after the course. Take it to check your level of knowledge at the beginning of the course to assess your level of SQL & MySQL knowledge. Then take it after the course. If you learn nothing, ask for refund. (Although I'm certain this doesn't happen!)As a CTO, I'm responsible for HotelQuickly's product, engineering, technical infrastructure and databases - we use MySQL & PostgreSQL. Prior to joining HotelQuickly I spent 4 years working as a data warehouse consultant, developing and optimising data marts running on Oracle. Featured Testimonials (see them all on the bottom of this page) "Let's be clear: If you used only basics of the sql, you will definitely learn lots of new stuff here. This is definitely not the introductory course to MySQL and author will not waste your time by explaining basics to you. Author is very knowledgeable about the topic and you will surely learn, at least how to write well structured queries, and you can apply those immediately in your work. In first 3 chapters you will have a lot of explanations and practices to keep you busy." -Dusan Kostic (see full below)"SELECT * FROM `the_most_fascinating`.`course` :-) I really like it!!! Thank you a lot Michal for you very professional work!!" -Andrey Ivashkin"This is great course on MYSQL, I learned more here, than any other course I have taken so far." -David Abraham"Lots of stuff you can learn from this course. There are still more to MySQL than just creating databases. I would recommend anyone to take this course after they know the basics." -Raymond John Escobar Enjoy & have fun with SQL & MySQL!:-)
