Back to Courses
Python Programming from Scratch with My SQL Database
Python Programming from Scratch with MySQL Database is a beginner-friendly course designed to teach you everything you need to know to start with Python programming and MySQL databases. Using these powerful tools, you’ll learn how to build dynamic web applications and websites.
Course Highlights
Python Programming from Scratch with MySQL Database is a comprehensive course that will teach you the fundamentals of Python programming and MySQL databases. You will learn to create and manipulate data, write functions and classes, and build web applications. By the end of the course, you will have the skills to develop your own database-driven applications using Python and MySQL.
Unlock the full potential of web development by joining our “Python Programming from Scratch with MySQL Database” course. This well-structured program will guide you through the realms of HTML, Python, and MySQL, equipping you with the essential tools and knowledge to conquer the digital world. From the roots of HTML to Python’s complexities and MySQL’s intricacies, we cover it all.
But that’s not all! We’ve intricately woven lessons on using Python for data science, giving you a competitive edge in today’s data-driven environment. And when it comes to database management, our MySQL sections will turn you into a pro, teaching you everything from creating structures and filtering data to utilizing functions and managing databases with precision.
So, whether you’re a beginner eager to step into the world of programming or an experienced coder looking to enhance your skillset, our course has something for everyone. With our expertly crafted modules, practical insights, and a project-based approach, you’ll gain knowledge and apply what you’ve learned in real-world scenarios. Enroll now and embark on a journey that promises to be not just educational, but transformative, equipping you with the skills and confidence to make your mark in the digital universe.
Learning outcome
- Develop a solid foundation in HTML and Python programming.
- Understand the intricacies of Python strings, operators, and data structures.
- Master the usage of Python for data science applications.
- Gain proficiency in MySQL database management and queries.
- Learn to create and manage database structures effectively.
- Acquire the skills to backup and restore MySQL databases.
- Implement learned concepts through a Python project.
Course media
Why should I take this course?
- Comprehensive coverage of HTML, Python, and MySQL in one course.
- Learn from meticulously crafted modules catering to all skill levels.
- Master essential skills for web development and database management.
- You will learn from an experienced instructor who is passionate about teaching.
- You will join a community of students who are also learning Python and MySQL.
Career Path
- Web Developer
- Database Administrator
- Python Developer
- Data Analyst
- Software Developer
- Back-end Developer
Requirements
- A computer with internet access.
- Basic understanding of programming concepts.
- Eagerness to learn and apply new skills.
Course Curriculum
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 | ||
| 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 | ||
Don't just take our word for it
Amazing workshop.
Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.
Aarini Sinha 
It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.
Varsha Sivamohan 
I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.
Judith Taylor 
The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable.
I am very grateful for the support
Charlie Anderson 
Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it.
Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.
Parmjit Dosanjh 
I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.
Shan 
I was a bit nervous about the course but I gave a try,it's perfect and I still can't believe I paid a peanut to acquire such a course,the sliding show and introduction was well understood.i will recommend skill up to anyone interested to persuade a meaningful career,and also to the support team keep doing the good work.💪
Sara Nana 
Original price was: $457.31.$34.75Current price is: $34.75.
1 Year Access 
2 Students 
16 hours, 50 minutes