Complete Sql Bootcamp With Mysql Php Python

Tags: MySQL

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

Last updated 2022-01-10 | 4.2

- Do basic and complex queries using SQL
- PHP project with SQL
- Python project with SQL

What you'll 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

* Requirements

* No prior knowledge or expertise required

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.  

Who this course is for:

  • Who want to expert in SQL

Course content

7 sections • 36 lectures

Data types in MySQL Part - 1 Preview 04:04

Data types in MySQL Part - 2 Preview 02:57

Creating Database & Table through PHPMyAdmin Preview 06:19

Creating Database & Table through MySQL Workbench Preview 05:07

Understanding Primary Key, Database Users & their Permissions Preview 05:35

Importing & Exporting Databases Preview 03:58

Introduction to MySQL Queries and SELECT Clause Preview 08:02

Practical session on Insert + Update + Delete Preview 05:06

Mastering Table Storage Engines Preview 04:53

Mastering Table Joining: Part 1 Preview 04:41

Mastering Table Joining: Part 2 Preview 05:32

Working with Math and Strings: Part 1 Preview 05:38

Working with Math and Strings: Part 2 Preview 04:09

Working with Group By: Part 1 Preview 03:36

Working with Group By: Part 2 Preview 03:36

Mastering Sub-queries: Part 1 Preview 05:10

Mastering Sub-queries: Part 2 Preview 04:44

Transactions and sequences Preview 04:29

PHP Basics Preview 05:36

PHP Advanced: Part 1 Preview 05:39

PHP Advanced: Part 2 Preview 04:57

PHP Advanced: Part 3 Preview 04:30

PHP Advanced: Part 4 Preview 04:12

PHP Advanced: Part 5 Preview 05:52

PHP + MySQL: Basic Project # Part 1 Preview 05:31

PHP + MySQL: Basic Project # Part 2 Preview 05:27

Introduction to Python Variables Preview 03:26

Python Datatypes Preview 06:36

Creating MySQL Database through Python Preview 06:43

Loading data into tables Preview 05:08

Displaying data in HTML Tables Preview 05:27

Database programming using Python Classes Preview 07:09