Exclusive Deal! 94% Off, Today Only!
Buy 1 or more contact sale
Learn how to make a genuine difference in your life by taking our popular Python Programming from Scratch with My SQL Database Course. Our commitment to online learning and our technical experience has been put to excellent use within the content of these educational modules. By enrolling today, you can take your knowledge of Python Programming from Scratch with My SQL Database to a whole new level and quickly reap the rewards of your study in the field you have chosen.
We are confident that you will find the skills and information that you will need to succeed in this area and excel in the eyes of others. Do not rely on substandard training or half-hearted education. Commit to the best, and we will help you reach your full potential whenever and wherever you need us.
Please note that Python Programming from Scratch with My SQL Database provides valuable and significant theoretical training for all. However, it does not offer official qualifications for professional practice. Always check details with the appropriate authorities or management.
By completing the training in Python Programming from Scratch with My SQL Database, you will be able to significantly demonstrate your acquired abilities and knowledge of Python Programming from Scratch with My SQL Database. This can give you an advantage in career progression, job applications, and personal mastery in this area.
This course is designed to provide an introduction to Python Programming from Scratch with My SQL Database and offers an excellent way to gain the vital skills and confidence to start a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Full-time and part-time learners are equally supported, and the study periods are entirely customisable to your needs.
Once you have completed all the modules in the Python Programming from Scratch with My SQL Database course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards.
Show off Your New Skills with a Certification of Completion
The learners have to successfully complete the assessment of this Python Programming from Scratch with My SQL Database course to achieve the CPD accredited certificate. Digital certificates can be ordered for only £10. Learners can purchase printed hard copies inside the UK for £29, and international students can purchase printed hard copies for £39.
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 | ||
Canvas | 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 | ||
Python Installation (Step By Step) | 00:06: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 ILIKE | 00:11:00 | ||
Section 20: MySQL Functions | |||
Overview of GROUP BY | 00:06:00 | ||
Aggregation function SUM() | 00:09: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:11: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 |
1358
4.9
£799
848
4.9
£799
694
4.9
£799