Practice advanced SQL queries with MySQL 5.7+

Build on your current knowledge and get to a next level in SQL. Learn by writing - lots of examples are waiting for you.
4.18 (588 reviews)
Udemy
platform
English
language
Databases
category
instructor
Practice advanced SQL queries with MySQL 5.7+
5 363
students
5 hours
content
Dec 2017
last update
$49.99
regular price

What you will learn

write user defined functions

write stored procedures

simulate some of the analytic (window) functions

work with cursors

use the right indexes and partitions

write advanced & beautiful queries

Course Gallery

Practice advanced SQL queries with MySQL 5.7+ – Screenshot 1
Screenshot 1Practice advanced SQL queries with MySQL 5.7+
Practice advanced SQL queries with MySQL 5.7+ – Screenshot 2
Screenshot 2Practice advanced SQL queries with MySQL 5.7+
Practice advanced SQL queries with MySQL 5.7+ – Screenshot 3
Screenshot 3Practice advanced SQL queries with MySQL 5.7+
Practice advanced SQL queries with MySQL 5.7+ – Screenshot 4
Screenshot 4Practice advanced SQL queries with MySQL 5.7+

Charts

Students
Price
Rating & Reviews
Enrollment Distribution

Comidoc Review

Our Verdict

This advanced SQL queries course is well-suited for those who want to delve deeper into the topic and seek a hands-on learning experience. The instructor demonstrates expertise and provides helpful insights on best practices, but be aware that a few presentation pain points might hinder your learning. Overall, it offers valuable lessons but some may encounter setup difficulties on Windows machines or find issues with incomplete exercises. Nonetheless, it is still an excellent resource to strengthen your SQL skills.

What We Liked

  • Covers advanced SQL topics like writing user-defined functions, cursors, and indexes
  • Lots of examples provided for hands-on practice and learning
  • Instructor is knowledgeable and presents the material in a clear manner
  • Valuable tips on best practices to write well-structured queries

Potential Drawbacks

  • Course could be improved with better presentation of materials, such as eliminating redundant PDFs, providing complete code exercises solutions, and ensuring all important information is visible in videos
  • Limited coverage of some advanced topics, with some being left out of videos and relegated to \
  • sections
  • Issues with setting up sample databases on Windows systems, as author did not provide specific instructions or alternatives for MySQL GUI tools usage on Windows
  • Certain limitations in course content and exercises make it less accessible for those who are newcomers to the SQL and MySQL environment
Related Topics
835946
udemy ID
30/04/2016
course created date
21/11/2019
course indexed date
Bot
course submited by
Practice advanced SQL queries with MySQL 5.7+ - | Comidoc