4.13 out of 5
4.13
2089 reviews on Udemy

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

Master yourself in SQL, do practical projects with MySQL, PHP and Python
Instructor:
Creative Online School
191,323 students enrolled
English [Auto]
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

=== 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.  

Introduction to Course

1
Introduction

Introduction to MySQL and Installation

1
What is MySQL?
2
XAMPP Installation
3
MySQL Workbench Installation

MySQL Basics

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

MySQL Advanced

1
Mastering Table Storage Engines
2
Mastering Table Joining: Part 1
3
Mastering Table Joining: Part 2
4
Working with Math and Strings: Part 1
5
Working with Math and Strings: Part 2
6
Working with Group By: Part 1
7
Working with Group By: Part 2
8
Mastering Sub-queries: Part 1
9
Mastering Sub-queries: Part 2
10
Transactions and sequences

Mastering PHP

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

PHP + MySQL : Practical Project

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

Python Basics + Databased Programming with MySQL

1
Introduction to Python Variables
2
Python Datatypes
3
Creating MySQL Database through Python
4
Loading data into tables
5
Displaying data in HTML Tables
6
Database programming using Python Classes
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.1
4.1 out of 5
2089 Ratings

Detailed Rating

Stars 5
755
Stars 4
736
Stars 3
453
Stars 2
94
Stars 1
49
1ed3d6cc1e9a9bfbaf99fc017486801b
Course available for 2 days
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Don't Miss Any Course Join Our Telegram Channel Join Channel
+ +