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

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

3.95 (2762 reviews)
Udemy
platform
English
language
Databases
category
270,118
students
3 hours
content
Jan 2018
last update
$189.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

Description

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

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

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

Reviews

Harsh
June 3, 2022
in last python part is very quick and use linux os and upper part use windows os it's confusing for people but in case of php and mysql it's good.
Lei
April 19, 2022
this course would actually need you to have a bit of coding background on html and python otherwise you would find it's a bit difficult to catch up especially for the section 7
Benjamin
April 14, 2022
The fact that there isn't immediate access to the datasets being used in the lessons is very frustrating. Thar said, they do give a comprehensive review of the purpose behind important functions/queries.
Vicente
March 21, 2022
En general me gustó el curso. El unico tema es que creo que iba demasiado rapido en algunos temas y no se podia explicar del todo lo que hacian, pero nada que pausar el video y complementar con bibliografia u otro material sobre el tema no ayude para llenar esos "baches" que senti que habia en algunos temas.
Oskar
September 24, 2021
Una explicación consisa y practica del manejo de bases de datos relacionales; lo unico malo es que las bases de datos usadas en el curso no estan disponibles, pero con una base de datos que se descargue, uno puede practicar.
Shin
September 20, 2021
Good intro course for student with no background in PHP and SQL. would be better if lecture notes and source codes provided
Cesar
August 22, 2021
Excelente curso en donde aprendí toda la funcionalidad de SQL, sin embargo, me hubiera gustado como Bonus generar un caso-ejercicio especifico aplicado a la vida real
Ashwin
August 7, 2021
Course is explaining briefly about each topic and proceed in the easiest way to understand course content.
Ernesto
July 17, 2021
Muy bien explicadas las clases, si pudieran poner los subtitulo en español y en su momento poder descargar los vídeos
Andrew
July 6, 2021
Does not use latest version of software mySQL Workbench and XAMPP making the whole course redundant. wish I could get a refund
Nitesh
June 9, 2021
Some steps were missing such as how to use xampp, how to check the password of the database that you have created.
Toren
June 2, 2021
Good course to get started with concepts and how these technologies work together to form a finished product.
Mostafa
May 30, 2021
One of the advantages of this course is that work with both Phpadmin as well as MySql Workbench, although it seems the instructor prefers Workbench. For Php and Python section, having primary knowledge is essential.
Mohamed
May 7, 2021
A very nice crash course. Dedicated one moring and finished it. Looking forward to implmenting what I have learnt in my projects.
Jay
January 31, 2021
If you are looking for a more detailed course on MySql, PHP and Python, this is not for you you need to have some prior knowledge in order to understand and take away something good from this course

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

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

Related Topics

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