Python Programming from Scratch with My SQL Database

Home
Course
Web Development
Python Programming from Scratch with My SQL Database

Python Programming from Scratch with My SQL Database

Level: Intermediate
Modules: 153 Modules
Duration: 16 hours, 51 minutes
Students: 0

Dive into the world of programming with “Python Programming from Scratch with MySQL Database,” an ideal blend of two powerful tools that can elevate your coding skills. This course walks you through every essential aspect of Python programming, guiding you step-by-step through fundamental concepts and the nuances of working with MySQL databases. From building basic Python programs to mastering MySQL for handling complex data, this comprehensive course ensures you gain a solid understanding of both languages. With “Python Programming from Scratch with MySQL Database,” you’ll move confidently through topics such as HTML basics, Python data structures, and advanced SQL techniques. Whether you’re starting fresh or looking to strengthen your database management and programming skills, this course equips you with the knowledge needed to work effectively with Python and MySQL.

Learning Outcomes

Understand Python fundamentals from the ground up.
Learn the structure of HTML webpages.
Master Python operators and conditional statements.
Get familiar with MySQL installation and basic commands.
Develop proficiency in handling Python data structures.
Explore advanced MySQL queries and database management.

Why buy this Python Programming from Scratch with My SQL Database course?

Unlimited access to the course for forever
Digital Certificate, Transcript, student ID all included in the price
Absolutely no hidden fees
Directly receive CPD accredited qualifications after course completion
Receive one to one assistance on every weekday from professionals
Immediately receive the PDF certificate after passing
Receive the original copies of your certificate and transcript on the next working day
Easily learn the skills and knowledge from the comfort of your home

Certification

After studying the course materials of the Python Programming from Scratch with My SQL Database there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8.

Who is this Python Programming from Scratch with My SQL Database for?

Beginners eager to learn programming from scratch.
Individuals interested in database management.
Python enthusiasts looking to expand their skill set.
Students keen on building a career in programming.
Aspiring developers wanting to master Python and MySQL.
Professionals seeking to enhance their knowledge of SQL and Python basics.

Prerequisites

This Python Programming from Scratch with My SQL Database does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Python Programming from Scratch with My SQL Database was made by professionals and it is compatible with all PC’s, Mac’s, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection.

Career path

Python Developer: £45,000 to £65,000 per year
Full Stack Developer: £40,000 to £70,000 per year
Database Administrator (MySQL): £35,000 to £55,000 per year
Data Analyst: £30,000 to £50,000 per year
Back-End Developer: £45,000 to £65,000 per year
Software Engineer: £40,000 to £65,000 per year

Course Curriculum

Section 01: Getting Started
	Introduction	00:03:00
	How to Get Course requirements	00:02:00
	Getting Started on Windows, Linux or Mac	00:02:00
	How to ask a Great Questions	00:01:00
	FAQâ€™s	00:01:00
Section 02: HTML
	Introduction HTML	00:05:00
	Choosing Code Editor	00:06:00
	Installing Code Editor (Sublime Text)	00:04:00
	Overview of a Webpage	00:05:00
	Structure of a Full HTML Webpage	00:07:00
	First Hello World! Webpage	00:09:00
Section 03: HTML Basic
	Heading tags	00:09:00
	Paragraph	00:08:00
	Formatting Text	00:12:00
	List Items Unordered	00:05:00
	List Items Ordered	00:04:00
	Classes	00:09:00
	IDs	00:06:00
	Comments	00:04:00
Section 04: HTML Intermediate
	Images	00:12:00
	Forms	00:05:00
	Marquee	00:06:00
	Text area	00:06:00
	Tables	00:06:00
	Links	00:07:00
	Navbar – Menu	00:04:00
	HTML Entities	00:05:00
	Div tag	00:06:00
	Google Maps	00:07:00
Section 05: HTML Advanced
	HTML Audio	00:07:00
	HTML Video	00:05:00
	Canva	00:06:00
	Iframes	00:05:00
	Input Types	00:04:00
	Input Attributes	00:06:00
	Registration Form	00:04:00
	Contact Us Form	00:10:00
	Coding Exercise	00:01:00
	Solution for Coding Exercise	00:02:00
Section 06:Python Introduction
	Introduction to Python	00:02:00
	Python vs Other Languages	00:04:00
	Why It’s Popular	00:04:00
	Command Line Basics	00:07:00
	Command Line Basics	00:07:00
	PyCharm IDE Installation	00:08:00
	Getting Start PyCharm IDE	00:05:00
	First Python Hello World Program	00:07:00
Section 07: Python Basic
	Variables	00:16:00
	Data Types	00:13:00
	Type Casting	00:07:00
	User Inputs	00:08:00
	Comments	00:04:00
Section 08: Python Strings
	Strings	00:05:00
	String Indexing	00:05:00
	String Slicing	00:04:00
	String Built-in Functions	00:09:00
	Formatting String (Dynamic Data)	00:05:00
Section 09: Python Operators
	Arithmetic Operators	00:08:00
	Assignment Operators	00:05:00
	Comparison Operators	00:05:00
	Logical Operators	00:02:00
	AND Operator	00:04:00
	OR Operator	00:02:00
	NOT Operator	00:03:00
	Booleans	00:02:00
Section 10: Python Data Structures
	Arrays in Earler	00:02:00
	Lists	00:06:00
	Add List Items	00:03:00
	Remove List Items	00:01:00
	Sort Lists	00:03:00
	Join Lists	00:08:00
	Tuples	00:08:00
	Update tuples	00:07:00
	Join tuples	00:02:00
	Dictionaries	00:06:00
	Add Dictionary Items	00:04:00
	Remove Dictionary Items	00:03:00
	Nested Disctionaries	00:04:00
	Sets	00:04:00
	Add Set Items	00:03:00
	Remove Set Items	00:01:00
	Join Set Items	00:04:00
Section 11: Python Conditional Statements
	If Statement	00:03:00
	If-else Statement	00:04:00
	If-elif-else Statement	00:04:00
	If Statement Coding Excercise	00:05:00
Section 12: Python Control Flow Statements
	Flow Charts	00:06:00
	While Loops Statement	00:10:00
	For Loops Statement	00:06:00
	The range() Function	00:04:00
	Nested Loops	00:04:00
	2D List using Nested Loop	00:04:00
Section 13: Python Core Games
	Guessing Game	00:07:00
	Car Game	00:10:00
Section 14: Python Functions
	Creating a Function	00:03:00
	Calling a Function	00:06:00
	Function with Arguments	00:05:00
Section 15: Python args, KW args for Data Science
	args, Arbitary Arguments	00:04:00
	kwargs, Arbitary Keyword Arguments	00:06:00
Section 16: Python Project
	Project Overview	00:04:00
	ATM RealTime Project	00:13:00
Section 17: MYSQL Introduction
	Overview of Databases	00:10:00
	MySQL Installation	00:16:00
	MySQL Workbench Installation	00:09:00
	Connecting to MySQL using Console	00:09:00
Section 18: MySQL Basic
	Overview of Challenges	00:04:00
	SQL Statement Basic	00:16:00
	SELECT Statement	00:09:00
	SELECT DISTINCT	00:05:00
	Column AS Statement	00:12:00
	COUNT function	00:11:00
Section 19: MySQL Filtering Data
	SELECT WHERE Clause â€“ One	00:05:00
	SELECT WHERE Clause â€“ Two	00:11:00
	ORDER BY	00:08:00
	LIMIT	00:09:00
	BETWEEN	00:11:00
	IN Operator	00:11:00
	LIKE and ILIKE5	00:11:00
Section 20: MySQL Functions
	Overview of GROUP BY	00:06:00
	Aggregation function SUM()	00:08:00
	Aggregation MIN() and MAX()	00:06:00
	GROUP BY – One	00:09:00
	GROUP BY â€“ Two	00:12:00
	HAVING Clause	00:05:00
Section 21: MySQL Joins
	Overview Assessment	00:02:00
	Overview of JOINS	00:04:00
	Introduction to JOINS	00:04:00
	AS Statement table	00:03:00
	INNER JOIN	00:19:00
	FULL Outer Join	00:11:00
	LEFT Outer JOIN	00:08:00
	RIGHT JOIN	00:08:00
	Union	00:07:00
Section 22: MySQL Advanced Commands
	Advanced SQL Commands	00:04:00
	Timestamps	00:12:00
	EXTRACT from timestamp	00:10:00
	Mathematical Functions	00:12:00
	String Functions	00:22:00
	SUBQUERY	00:13:00
Section 23: MySQL Structure Creation
	Database and Tables	00:06:00
	DataTypes	00:12:00
	Primarykey and Foreignkey	00:06:00
	Create Table in SQL Script	00:13:00
Section 24: MySQL Data Queries
	Insert	00:11:00
	Update	00:07:00
	Delete	00:04:00
Section 25: MySQL Structure Queries
	Alter Table	00:10:00
	Drop Table	00:05:00
Section 26: MySQL Constraints
	NOT NULL Constraint	00:08:00
	UNIQUE Constraint	00:09:00
Section 27: MySQL Backup and Restore
	Overview of Databases and Tables	00:05:00
	Backup database using phpMyAdmin	00:12:00
	Restoring a Database	00:07:00