SQL Bootcamp with MySQL, PHP & Python : 5 Courses in 1
- Description
- Curriculum
- FAQ
- Reviews
=== 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.
-
5Data types in MySQL Part - 1Video lesson
-
6Data types in MySQL Part - 2Video lesson
-
7Creating Database & Table through PHPMyAdminVideo lesson
-
8Creating Database & Table through MySQL WorkbenchVideo lesson
-
9Understanding Primary Key, Database Users & their PermissionsVideo lesson
-
10Importing & Exporting DatabasesVideo lesson
-
11Introduction to MySQL Queries and SELECT ClauseVideo lesson
-
12Practical session on Insert + Update + DeleteVideo lesson
-
13Mastering Table Storage EnginesVideo lesson
-
14Mastering Table Joining: Part 1Video lesson
-
15Mastering Table Joining: Part 2Video lesson
-
16Working with Math and Strings: Part 1Video lesson
-
17Working with Math and Strings: Part 2Video lesson
-
18Working with Group By: Part 1Video lesson
-
19Working with Group By: Part 2Video lesson
-
20Mastering Sub-queries: Part 1Video lesson
-
21Mastering Sub-queries: Part 2Video lesson
-
22Transactions and sequencesVideo lesson
External Links May Contain Affiliate Links read more