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

Focused View

Creative Online School

2:59:11

18 View

1 - Introduction to Course

1 - Introduction.mp4

02:09

2 - Introduction to MySQL and Installation

2 - What is MySQL.mp4

04:19

3 - XAMPP Installation.mp4

03:58

4 - MySQL Workbench Installation.mp4

04:53

3 - MySQL Basics

5 - Data types in MySQL Part 1.mp4

04:04

6 - Data types in MySQL Part 2.mp4

02:57

7 - Creating Database & Table through PHPMyAdmin.mp4

06:19

8 - Creating Database & Table through MySQL Workbench.mp4

05:07

9 - Understanding Primary Key Database Users & their Permissions.mp4

05:35

10 - Importing & Exporting Databases.mp4

03:58

11 - Introduction to MySQL Queries and SELECT Clause.mp4

08:02

12 - Practical session on Insert Update Delete.mp4

05:06

4 - MySQL Advanced

13 - Mastering Table Storage Engines.mp4

04:53

14 - Mastering Table Joining Part 1.mp4

04:41

15 - Mastering Table Joining Part 2.mp4

05:32

16 - Working with Math and Strings Part 1.mp4

05:38

17 - Working with Math and Strings Part 2.mp4

04:09

18 - Working with Group By Part 1.mp4

03:36

19 - Working with Group By Part 2.mp4

03:36

20 - Mastering Subqueries Part 1.mp4

05:10

21 - Mastering Subqueries Part 2.mp4

04:44

22 - Transactions and sequences.mp4

04:29

5 - Mastering PHP

23 - PHP Basics.mp4

05:36

24 - PHP Advanced Part 1.mp4

05:39

25 - PHP Advanced Part 2.mp4

04:57

26 - PHP Advanced Part 3.mp4

04:30

27 - PHP Advanced Part 4.mp4

04:12

28 - PHP Advanced Part 5.mp4

05:52

6 - PHP MySQL Practical Project

29 - PHP MySQL Basic Project Part 1.mp4

05:31

30 - PHP MySQL Basic Project Part 2.mp4

05:28

7 - Python Basics Databased Programming with MySQL

31 - Introduction to Python Variables.mp4

03:27

32 - Python Datatypes.mp4

06:36

33 - Creating MySQL Database through Python.mp4

06:43

34 - Loading data into tables.mp4

05:08

35 - Displaying data in HTML Tables.mp4

05:27

36 - Database programming using Python Classes.mp4

07:10

Description

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

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

Who is this for?

Who want to expert in SQL

What You Need to Know?

No prior knowledge or expertise required

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Creative online school offers a huge and ever growing range of high creative, quality and engaging learning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.