SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1

Master yourself in SQL, do practical projects with MySQL, PHP and Python

4.63 (3025 reviews)
Udemy
platform
English
language
Databases
category
SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1
292,198
students
3 hours
content
Jan 2018
last update
$49.99
regular price

What you will learn

Do basic and complex queries using SQL

PHP project with SQL

Python project with SQL

Master yourself in MySQL

Basics and Advanced Understanding of PHP

Why take this course?

=== Our students' reviews regarding this course ===

"it's good that the course focuses more on the application part rather than just giving some bookish theories or concepts which anyone can read for the plenty of textbooks." -- Deepanshu Kumar

"Very clear and straight forward." -- Chakri Muthyala

"really very explanatory and easy to understand" -- Sekh

"simply the best" -- Frederick Ekow

"Very Informative Course. Thank You" -- Subrata Debnath

"So far so good. The installation has a detailed guide every step of the way. This should be a benchmark for any other tutorials during the installation process of the software." -- Emilio Comiling

"Well based step-by-step information that is clearly understandable" -- Volodymyr Gorbachov

The programming language PHP is one of the most popular scripting languages. It is free, open-source, and server-side (the code is executed on the server). And MySQL is another one of the most popular Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). The combination of PHP and MySQL gives amazing and cool options to create amazing websites, APIs, web portals, and more.

By completing this course, you will be able to read and write basic and complex SQL queries using MySQL. This course gives you hands-on and practical experience on the world's most popular RDBMS databases like MySQL. These skills are also applicable to any other RDMBS  databases (Like Oracle, MS SQL Server, SQLite, etc). You will do several practical projects with MySQL, PHP & Python. 

Learning both SQL is one of the fastest ways to improve your career. Hope this course will be used as a helping hand for your prospective career. Please dig on free preview videos for more information.  

Content

Introduction to Course

Introduction

Introduction to MySQL and Installation

What is MySQL?
XAMPP Installation
MySQL Workbench Installation

MySQL Basics

Data types in MySQL Part - 1
Data types in MySQL Part - 2
Creating Database & Table through PHPMyAdmin
Creating Database & Table through MySQL Workbench
Understanding Primary Key, Database Users & their Permissions
Importing & Exporting Databases
Introduction to MySQL Queries and SELECT Clause
Practical session on Insert + Update + Delete

MySQL Advanced

Mastering Table Storage Engines
Mastering Table Joining: Part 1
Mastering Table Joining: Part 2
Working with Math and Strings: Part 1
Working with Math and Strings: Part 2
Working with Group By: Part 1
Working with Group By: Part 2
Mastering Sub-queries: Part 1
Mastering Sub-queries: Part 2
Transactions and sequences

Mastering PHP

PHP Basics
PHP Advanced: Part 1
PHP Advanced: Part 2
PHP Advanced: Part 3
PHP Advanced: Part 4
PHP Advanced: Part 5

PHP + MySQL : Practical Project

PHP + MySQL: Basic Project # Part 1
PHP + MySQL: Basic Project # Part 2

Python Basics + Databased Programming with MySQL

Introduction to Python Variables
Python Datatypes
Creating MySQL Database through Python
Loading data into tables
Displaying data in HTML Tables
Database programming using Python Classes

Screenshots

SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1 - Screenshot_01SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1 - Screenshot_02SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1 - Screenshot_03SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1 - Screenshot_04

Our review

--- **Overview of the Course:** The course has received a global rating of *4.63*, with all recent reviews being positive. It serves as a good crash course for those looking to understand the basics of MySQL, PHP, and Python, and how these technologies work together to form a finished product. The course is designed for individuals who have some prior knowledge in these areas, as it moves at a brisk pace and assumes a certain level of understanding from the learner. **Pros:** - **Comprehensive Coverage:** The course offers a nice crash course and covers the functionalities of SQL extensively. - **Dual Tools:** It works with both Phpadmin as well as MySql Workbench, with a preference for MySql Workbench. - **Real-World Application:** It provides practical understanding through its content, encouraging application to real-life scenarios. - **Ease of Understanding:** The lectures are explained concisely and practically, making the content easier to grasp. - **Cultural Reach:** Some content is available in Spanish, which is a plus for non-English speaking learners. - **Versatility:** Suitable for students with no background in PHP and SQL, offering a good introduction. - **General Positive Feedback:** The majority of the reviews are positive, highlighting the course's effectiveness in teaching MySQL, PHP, and Python. **Cons:** - **Pacing Issues:** Some users felt the course progressed too quickly, which might make it difficult for beginners to fully understand some topics without additional resources or practice. - **Software Versions:** The course does not use the latest versions of MySQL Workbench and XAMPP, which could render some teachings outdated. - **Resource Availability:** Some reviewers mentioned that datasets used in the lessons are not provided immediately, necessitating manual creation of sample datasets to follow along. - **Lack of Detailed Explanations:** A few users pointed out that some steps were missing, and more detailed explanations would enhance the learning experience. - **Confusing Transitions:** There is a noted inconsistency in the operating systems used between sections of the course, which can be confusing for learners. - **No Downloadable Scripts:** Some learners expected to have access to downloadable scripts as mentioned in the reviews, which was not the case. - **Immediate Application:** While the course is good for revision, it might not be ideal for beginners who are new to coding or programming concepts. **Recommendations for Improvement:** - **Update Software Versions:** Ensure that the software versions used in the course are up-to-date to provide learners with the most current practices. - **Provide Downloadable Datasets and Scripts:** Offer datasets and scripts as downloadable resources to facilitate immediate application by learners. - **Slower Pacing for Beginners:** Adjust the pacing of the course to accommodate beginners, ensuring that all topics are thoroughly explained. - **Comprehensive Review of Keys and Indexes:** Incorporate more detailed explanations about database keys and indexes within the video content. - **Additional Projects for Practical Application:** Include additional projects or case studies to provide a clearer understanding of the concepts taught in the course. **Final Verdict:** The course is well-received overall, with some areas that could be improved for a more comprehensive and beginner-friendly learning experience. It is recommended for intermediate learners who have some background knowledge and are looking to expand their skills in MySQL, PHP, and Python, as well as for advanced programmers seeking a refresher course.

Coupons

DateDiscountStatus
8/28/2019100% OFF
expired
9/13/2019100% OFF
expired
2/26/2020100% OFF
expired
3/9/2020100% OFF
expired
4/4/2020100% OFF
expired
4/26/2020100% OFF
expired
5/12/2020100% OFF
expired
5/30/2020100% OFF
expired
6/25/2020100% OFF
expired
7/5/2020100% OFF
expired
7/19/2020100% OFF
expired
7/31/2020100% OFF
expired
8/21/2020100% OFF
expired
8/30/2020100% OFF
expired
9/22/2020100% OFF
expired
10/2/2020100% OFF
expired
10/26/2020100% OFF
expired
11/9/2020100% OFF
expired
11/27/2020100% OFF
expired
12/7/2020100% OFF
expired
1/5/2021100% OFF
expired
1/23/2021100% OFF
expired
2/8/2021100% OFF
expired
3/12/2021100% OFF
expired
3/23/202195% OFF
expired
4/12/2021100% OFF
expired
5/12/2021100% OFF
expired
6/12/2021100% OFF
expired
7/12/2021100% OFF
expired
8/12/2021100% OFF
expired
9/12/2021100% OFF
expired
10/12/2021100% OFF
expired
11/12/2021100% OFF
expired
12/12/2021100% OFF
expired
1/12/2022100% OFF
expired
3/7/2022100% OFF
expired
3/21/2022100% OFF
expired
4/11/2022100% OFF
expired
4/25/2022100% OFF
expired
5/12/2022100% OFF
expired
5/22/2022100% OFF
expired
6/12/2022100% OFF
expired
7/13/2022100% OFF
expired
8/12/2022100% OFF
expired
9/12/2022100% OFF
expired
10/12/2022100% OFF
expired
11/12/2022100% OFF
expired
12/12/2022100% OFF
expired
1/13/2023100% OFF
expired
3/12/2023100% OFF
expired
4/12/2023100% OFF
expired
5/12/2023100% OFF
expired
6/12/2023100% OFF
expired
7/12/2023100% OFF
expired
8/12/2023100% OFF
expired
9/12/2023100% OFF
expired
10/12/2023100% OFF
expired
11/13/2023100% OFF
expired
12/13/2023100% OFF
expired
1/12/2024100% OFF
expired
2/13/2024100% OFF
expired
3/12/2024100% OFF
expired
4/13/2024100% OFF
expired

Charts

Price

SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1 - Price chart

Rating

SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1 - Ratings chart

Enrollment distribution

SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1 - Distribution chart

Related Topics

1508458
udemy ID
1/13/2018
course created date
8/8/2019
course indexed date
Bot
course submited by