The ‘MySQL, SQL and Stored Procedures from Beginner to Advanced’ course is a complete guide to MySQL queries, database design, transactions and stored procedures. In this course you’ll begin by learning the basics of creating, querying and adding data to databases using SQL with MySQL.
This course will take you from beginner in SQL and MySQL to an advanced level. The course is usually available for INR 2,799 on Udemy but you can click on the link and get the ‘MySQL, SQL and Stored Procedures from Beginner to Advanced’ for INR 499.
Who all can opt for this course?
- Anyone who is interested to learn MySQL.
Course Highlights
| Key Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 499 ( |
| Duration | 18 Hours |
| Rating | 4.4/5 |
| Student Enrollment | 22,995 students |
| Instructor | John Purcell https://www.linkedin.com/in/johnpurcell |
| Topics Covered | MySQL Operators, MySQL Data Types, MySQL Functions |
| Course Level | Beginner |
| Total Student Reviews | 3,355 |
Learning Outcomes
- Database creation, querying, and updating.
- Utilize stored procedures, triggers, and views.
- Learn about database isolation levels and transactions.
- Know the security and users of the database.
Course Content
| S.No. | Module (Duration) | Topics |
|---|---|---|
| 1. | Introduction (07 minutes) | Introducing MySQL |
| 2. | Getting Started (01 hour 26 minutes) | Installing MySQL and the Workbench |
| Using the Command Line | ||
| Creating Tables | ||
| Multiple Columns, int and Data Types | ||
| Null Values and Not Null | ||
| Mysql Storage Engines and Configuration | ||
| SQL Modes | ||
| Deleting All the Data in a Table | ||
| Primary Keys | ||
| Auto Increment | ||
| Narrowing Down Select Statements | ||
| 3. | Importing and Exporting Data (17 minutes) | Exporting and Importing Data |
| Exporting Using the Command Line | ||
| Importing Using the Command Line | ||
| 4. | MySQL Operators (56 minutes) | Some Test Data |
| Comparison Operators | ||
| Logical Operators | ||
| 018 Exclusive Or | ||
| Exercises Part 1 | ||
| Solutions Part 1 | ||
| 5. | Update, Order and Limit (14 minutes) | Beginning Update Statements |
| Order By | ||
| Limiting Results | ||
| 6. | MySQL Data Types (01 hour 38 minutes) | Mysql Types |
| Text Types | ||
| Floating Point Types and Ints | ||
| The Bit Type | ||
| Bool | ||
| Blobs | ||
| Time, Date and Year | ||
| Timestamp and Datetime | ||
| Enumerations | ||
| Brackets and Conditions Revisited | ||
| Exercises 2 | ||
| Solutions 2 | ||
| 7. | Aggregate Functions and Grouping (01 hour 00 minutes) | The distinct keyword |
| Counting Distinct Values | ||
| Aggregate Functions | ||
| Arithmetic in MySQL | ||
| The Health Survey Dataset | ||
| Group By | ||
| Having- Restricting Groups By Aggregate Functions | ||
| Exercises 3 | ||
| Solutions 3 | ||
| 8. | Foreign Keys and Multiple Tables (02 hours 15 minutes) | Naming Columns and Tables |
| Foreign Keys | ||
| ER Diagrams | ||
| Joins and Cartesian Products | ||
| Inner Joins | ||
| Left and Right Outer Joins | ||
| Joins on Multiple Tables | ||
| Querying Chains of Tables | ||
| One to Many and One to One | ||
| Many to Many | ||
| Joining Tables to Themselves | ||
| Restrict Foreign Keys | ||
| Cascade Foreign Keys | ||
| Exercises 4 | ||
| Solutions 4 | ||
| 9. | Combining Queries (25 minutes) | Union and Union All |
| Subqueries with “in” | ||
| Inline Views | ||
| 10. | Altering Schemas (22 minutes) | Adding Columns |
| Adding Foreign Keys | ||
| Adding Indexes | ||
| Indexes on Multiple Columns | ||
| 11. | Users and Privileges (17 minutes) | Creating Users |
| Granting Privileges | ||
| 12. | Views (26 minutes) | Creating a Simple View |
| View Algorithms | ||
| With Check Option | ||
| 13. | Locks and Transactions (02 hours 18 minutes) | Exclusive Table Locks |
| Shared Table Locks | ||
| Using Variables | ||
| Setting Variables with Selects | ||
| A Select-Update Example | ||
| Fixing Select-Updates with Table Locks | ||
| ACID | ||
| A Simple Transaction | ||
| Start Transaction | ||
| InnoDB Row Locking and Isolation | ||
| ACID Isolation Levels | ||
| Serializable and Row vs Table Locking | ||
| Demonstrating the Other Isolation Levels | ||
| Rolling Back to Savepoints | ||
| The Account Transfer Problem | ||
| Select for Update | ||
| Lock in Share Mode | ||
| 14. | MySQL Functions (01 hour 16 minutes) | String Functions |
| Dates, Intervals and Queries | ||
| Date Diff and Dayname | ||
| Str_To_Date and Date_Format | ||
| Control Flow Functions | ||
| Casting | ||
| Functions Exercises | ||
| Functions Solution | ||
| 15. | Stored Procedures (03 hours 24 minutes) | Introducing Stored Procedures |
| Changing the Delimiter | ||
| Hello World | ||
| Editing Stored Procedures 2 | ||
| Setting the Definer | ||
| Procedure Permission | ||
| Passing Parameters | ||
| Multiple Parameters | ||
| Select Into Variables | ||
| Out Parameters | ||
| Inout Parameters | ||
| The If Statement | ||
| Local Variables | ||
| Implementing Account Withdrawal | ||
| Transactional Withdrawal | ||
| Errors and Warnings | ||
| Handling Errors | ||
| While Loops | ||
| Labelled Loops | ||
| Generating Random Data | ||
| A Data Generating Procedure | ||
| Cursors | ||
| Fetching Cursor Data in a Loop | ||
| The Case Expression | ||
| Variable Scope and Multiple Cursors | ||
| Exercises 6 | ||
| Solutions 6 | ||
| 16. | Triggers (45 minutes) | Introducing Triggers |
| Validating with Triggers | ||
| Triggers and Transactions | ||
| Triggers Exercise | ||
| Triggers Solution | ||
| 17. | User-Defined Functions (16 minutes) | Functions vs Procedures |
| User-Defined Functions | ||
| 18. | Visual Design (40 minutes) | Designing Databases Visually |
| Connecting with Java | ||
| Retrieving Data with Java | ||
| 19. | Final Exercise (05 minutes) | Final Exercise |
| Conclusion |
Resources Required
- Both the free MySQL Workbench and the free MySQL Server Community Edition must be downloaded and installed.
Featured Review
Sim Zhi Hao Ridzuan (5/5) : Excellent course for a person like myself who has zero knowledge on SQL. Everything from start to end was explained clearly as well as the ‘why-do-this’ was anything but short of it. I wanted to say I felt this course could be shorter as I have experience in programming but after revising it, I’d say every section is needed. Overall good learning experience. Recommended for people who want to learn purely on SQL language and syntax, although he did introduce Java at the end as one of many programming language that are used with SQL.
Pros
- Chabrio François (5/5) : Excellent cours sur Mysql !!! Si vous êtes un(e) compl(et)(ète) débutant(e) dans ce domaine, vous serez entre de bonnes mains pour maîtriser tous les fondamentaux de ce programme.
- Doris Ivanov (3/5) : I would be best to start with downloads and file formats that can be imported in SQL.
- Shawn Russell (5/5) : This was one of the best resources to learn specifically how to handle Stored Procedures/Functions for a beginner.
- Tim Koerner (5/5) : John’s Udemy classes are probably the best that I have seen.
Cons
- M . (1/5) : – Q&A portion is dead! do not expect to get any help from this course at all.
- Aditya Pratap Singh (1/5) : The instructor simply skips the content and It’s difficult to pick what he is doing.
- Frank (2/5) : Hmm setting this up on your personal laptop or PC can be difficult and/or troublesome.
- Diane M Guidebeck (1/5) : I was expecting a beginner and learn as I advance, seems to bounce around and learning very little.
About the Author
The instructor of this course is John Purcell who is a Software Development Trainer. With 4.5 Instructor Rating and 189,358 Reviews on Udemy, John Purcell offers 19 Courses and has taught 2,603,190 Students so far.
- John Purcell chose to work full-time as a private software trainer after spending more than 14 years as a software developer and contractor for a variety of businesses, including CSC, Proquest, SPSS, and AT&T in the UK and Netherlands.
- John Purcell presently reside in Italy after four years in the lovely city of Budapest, Hungary, and a year in Berlin.
Comparison Table
| Parameters | MySQL, SQL and Stored Procedures from Beginner to Advanced | The Complete MySQL Developer Course | SQL Tutorial: Learn SQL with MySQL Database -Beginner2Expert |
|---|---|---|---|
| Offers | INR 499 ( | INR 455 ( | INR 455 ( |
| Duration | 18.5 hours | 10.5 hours | 11 hours |
| Rating | 4.4/5 | 4.4/5 | 4.6/5 |
| Student Enrollments | 22,995 | 21,831 | 9,736 |
| Instructors | John Purcell | Rob Percival | Pradnyankur Nikam |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this