SQL Bootcamp With MySQL, PHP & Python 5 Courses In 1

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 GorbachovThe 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.
Overview
Section 1: Introduction to Course
Lecture 1 Introduction
Section 2: Introduction to MySQL and Installation
Lecture 2 What is MySQL?
Lecture 3 XAMPP Installation
Lecture 4 MySQL Workbench Installation
Section 3: MySQL Basics
Lecture 5 Data types in MySQL Part - 1
Lecture 6 Data types in MySQL Part - 2
Lecture 7 Creating Database & Table through PHPMyAdmin
Lecture 8 Creating Database & Table through MySQL Workbench
Lecture 9 Understanding Primary Key, Database Users & their Permissions
Lecture 10 Importing & Exporting Databases
Lecture 11 Introduction to MySQL Queries and SELECT Clause
Lecture 12 Practical session on Insert + Update + Delete
Section 4: MySQL Advanced
Lecture 13 Mastering Table Storage Engines
Lecture 14 Mastering Table Joining: Part 1
Lecture 15 Mastering Table Joining: Part 2
Lecture 16 Working with Math and Strings: Part 1
Lecture 17 Working with Math and Strings: Part 2
Lecture 18 Working with Group By: Part 1
Lecture 19 Working with Group By: Part 2
Lecture 20 Mastering Sub-queries: Part 1
Lecture 21 Mastering Sub-queries: Part 2
Lecture 22 Transactions and sequences
Section 5: Mastering PHP
Lecture 23 PHP Basics
Lecture 24 PHP Advanced: Part 1
Lecture 25 PHP Advanced: Part 2
Lecture 26 PHP Advanced: Part 3
Lecture 27 PHP Advanced: Part 4
Lecture 28 PHP Advanced: Part 5
Section 6: PHP + MySQL : Practical Project
Lecture 29 PHP + MySQL: Basic Project # Part 1
Lecture 30 PHP + MySQL: Basic Project # Part 2
Section 7: Python Basics + Databased Programming with MySQL
Lecture 31 Introduction to Python Variables
Lecture 32 Python Datatypes
Lecture 33 Creating MySQL Database through Python
Lecture 34 Loading data into tables
Lecture 35 Displaying data in HTML Tables
Lecture 36 Database programming using Python Classes
Who want to expert in SQL

Homepage

https://www.udemy.com/course/complete-sql-bootcamp-with-mysql-php-python/

SQL Bootcamp With MySQL, PHP & Python 5 Courses In 1 Fast Download
SQL Bootcamp With MySQL, PHP & Python 5 Courses In 1 Full Download