- 1. Introduction 2m 43s
- 2. How to Get Course Requirements 2m 27s
- 3. Getting Started on Windows, Linux, or Mac 1m 32s
- 4. How to Ask Great Questions 1m 21s
- 5. FAQs 1m 4s
Python programming with MySQL database: for Data Science
About this course
In this course, we will learn the basic tools that every web developer needs to know. We will start from scratch by learning how to implement trending web development with HTML, Python, and MySQL databases.
Learning to code HTML, Python, and MySQL databasesfor Data Science is The first step to Coding you need to learn to succeed in application development, it is easy to learn and understand our online HTML, Python, and MySQL basic Training course is designed for you with the complete steps to require learn Complete Application Developer topics. Mr. Sekhar Metla [MCP - Microsoft Certified Professional] will explain to you even complex topics to simplify and teach you that even beginners can easily understand with real-time examples.
This Web Development course is without a doubt the most comprehensive development course available online. Even if you have zero programming experience, this course will take you from beginner to mastery. Here's why:
The course is taught by the lead instructor having 20+ years of professional experience
Become a Full-Stack Developer with just ONE course. HTML, Python, and MySQL database
The course has been updated to be trending technology ready and you'll be learning the latest tools and technologies used at large companies such as Microsoft, Apple, Facebook, Google, and Netflix.
The curriculum was developed over a period of four years, with comprehensive student testing and feedback on who is working and applying these coding examples.
We've taught many students how to code and many have gone on to change their lives by becoming professional developers or starting their own tech startups.
We'll take you step-by-step through engaging video tutorials and teach you everything you need to know to succeed as a web or application developer.
The course includes HD video tutorials and builds your programming knowledge while making real-world websites and web apps.
Learn from real-world experts
Throughout this comprehensive course, we cover a massive amount of tools and technologies, including:
Front-End Web Development
HTML 5
HTML5 controllers
HTML5 tags
Apply table creation
Creating div area elements
Formatting text on the page
Website Layout
I frame in a single page
Canvas
Forms creation
Google maps adding
Images
Registration form creation
Login form creation
and more..
Python
Datatypes
Strings
Lists
Sequences
If else statements
Control flow statements
Code Development
Web Design
Lists
Tuples
Dictionaries
Functions
Operators
Logical coding
Sets
Arguments
and more..
Database
MySQL
Structure creation
SQL queries
SQL statements
Table creations
Data types
SELECT statements
Where clause statement
Aggregation functions
Data Analytic functions
Operators
JOINS
Functions
Advanced SQL
Constraints
Database backup and restore
and more..
By the end of this course, you will be fluent in programming and ready to make any application you can dream of.
Sign up today, and look forward to:
HD Video Lectures
Code Challenges and Coding Exercises
Beautiful Real-World dynamic Projects
Database queries
ABOUT YOUR INSTRUCTOR
Sekhar Metla is a software engineer with 20+ years of professional experience. He is the author of several online-selling courses with more than 50,000+ students in many countries. He has a Master of Science in Computer Applications in Software Engineering. His students describe him as passionate, pragmatic, and motivational in his teaching.
What are you waiting join now to start learning how to make your own Web Application Developer Career TODAY :)
What you'll learn
- In this course, we will learn the basic tools that every web developer needs to know.
- We will start from scratch by learning how to implement trending web development with HTML, Python, and MySQL databases.
- Learning to code HTML, Python, and MySQL databasesfor Data Science is The first step to Coding you need to learn to succeed in application development, it is easy to learn and understand our online HTML, Python, and MySQL basic Training course is designed for you with the complete steps to require learn Complete Application Developer topics.
- Mr.
Curriculum
153 Lessons • 16H 44M- 1. Introduction to HTML 4m 56s
- 2. Choosing Code Editor 6m 8s
- 3. Installing Code Editor (Sublime Text) 3m 48s
- 4. Overview of a Webpage 4m 35s
- 5. Structure of a Full HTML Webpage 7m 5s
- 6. First Hello World! Webpage 8m 59s
- 1. Heading Tags 8m 48s
- 2. Paragraph 7m 35s
- 3. Formatting Text 12m 23s
- 4. List Items Unordered 5m 8s
- 5. List Items Ordered 3m 56s
- 6. Classes 9m 24s
- 7. IDs 6m 14s
- 8. Comments 4m 14s
- 1. Images 11m 46s
- 2. Forms 5m 12s
- 3. Marquee 5m 29s
- 4. Text Area 6m 2s
- 5. Tables 6m 3s
- 6. Links 7m 19s
- 7. Navbar - Menu 4m 4s
- 8. HTML Entities 5m 17s
- 9. Div Tag 5m 49s
- 10. Google Maps 7m 14s
- 1. HTML Audio 7m 16s
- 2. HTML Video 4m 47s
- 3. Canvas 5m 35s
- 4. Iframes 5m 6s
- 5. Input Types 4m 6s
- 6. Input Attributes 6m 23s
- 7. Registration Form 4m 18s
- 8. Contact Us Form 9m 49s
- 9. Coding Exercise 1m 21s
- 10. Solution for Coding Exercise 2m 21s
- 1. Introduction to Python 2m 16s
- 2. Python vs Other Languages 3m 48s
- 3. Why It's Popular 3m 33s
- 4. Command Line Basics 6m 43s
- 5. Python Installation (Step By Step) 5m 47s
- 6. PyCharm IDE Installation 7m 56s
- 7. Getting Started With PyCharm IDE 4m 44s
- 8. First Python Hello World Program 7m 22s
- 1. Variables 16m 18s
- 2. Data Types 13m 9s
- 3. Type Casting 7m 4s
- 4. User Inputs 7m 54s
- 5. Comments 3m 53s
- 1. Strings 4m 58s
- 2. String Indexing 5m 21s
- 3. String Slicing 3m 52s
- 4. String Built-in Functions 8m 36s
- 5. Formatting String (Dynamic Data) 4m 35s
- 1. Arithmetic Operators 7m 48s
- 2. Assignment Operators 4m 40s
- 3. Comparison Operators 5m 20s
- 4. Logical Operators 2m 1s
- 5. AND Operator 4m 9s
- 6. OR Operator 2m 16s
- 7. NOT Operator 2m 52s
- 8. Booleans 2m 5s
- 1. Arrays in Earlier 1m 45s
- 2. Lists 5m 37s
- 3. Add List Items 2m 54s
- 4. Remove List Items 1m 16s
- 5. Sort Lists 2m 46s
- 6. Join Lists 7m 35s
- 7. Tuples 7m 43s
- 8. Update Tuples 6m 58s
- 9. Join Tuples 1m 50s
- 10. Dictionaries 6m 2s
- 11. Add Dictionary Items 4m 26s
- 12. Remove Dictionary Items 2m 41s
- 13. Nested Dictionaries 4m
- 14. Sets 3m 39s
- 15. Add Set Items 3m 7s
- 16. Remove Set Items 1m 27s
- 17. Join Set Items 3m 55s
- 1. If Statement 3m 20s
- 2. If-else Statement 4m 8s
- 3. If-elif-else Statement 3m 58s
- 4. If Statement Coding Exercise 4m 41s
- 1. Flow Charts 6m 25s
- 2. While Loops Statement 9m 42s
- 3. For Loops Statement 6m 18s
- 4. The range() Function 3m 37s
- 5. Nested Loops 3m 29s
- 6. 2D List using Nested Loop 3m 30s
- 1. Guessing Game 7m 14s
- 2. Car Game 9m 40s
- 1. Creating a Function 3m 9s
- 2. Calling a Function 6m 3s
- 3. Function with Arguments 4m 58s
- 1. args, Arbitrary Arguments 4m 5s
- 2. kwargs, Arbitrary Keyword Arguments 6m 1s
- 1. Project Overview 3m 29s
- 2. ATM Realtime Project 13m 23s
- 1. Overview of Databases 10m 23s
- 2. MySQL Installation 15m 49s
- 3. MySQL Workbench Installation 9m 4s
- 4. Connecting to MySQL Using Console 9m
- 1. Overview of Challenges 3m 43s
- 2. SQL Statement Basic 15m 30s
- 3. SELECT Statement 9m 19s
- 4. SELECT DISTINCT 4m 50s
- 5. Column AS Statement 11m 43s
- 6. COUNT Function 11m 3s
- 1. SELECT WHERE Clause – One 4m 36s
- 2. SELECT WHERE Clause – Two 10m 40s
- 3. ORDER BY 7m 41s
- 4. LIMIT 8m 34s
- 5. BETWEEN 11m 18s
- 6. IN Operator 10m 40s
- 7. LIKE and ILIKE 11m 11s
- 1. Overview of GROUP BY 5m 39s
- 2. Aggregation Function SUM() 8m 52s
- 3. Aggregation MIN() and MAX() 5m 29s
- 4. GROUP BY - One 9m 13s
- 5. GROUP BY – Two 11m 45s
- 6. HAVING Clause 5m 4s
- 1. Overview Assessment 1m 59s
- 2. Overview of JOINS 3m 35s
- 3. Introduction to JOINS 4m 1s
- 4. AS Statement Table 3m 4s
- 5. INNER JOIN 18m 29s
- 6. FULL Outer Join 11m 10s
- 7. LEFT Outer JOIN 7m 53s
- 8. RIGHT JOIN 7m 45s
- 9. Union 6m 44s
- 1. Advanced SQL Commands 3m 37s
- 2. Timestamps 12m 22s
- 3. Extract From Timestamps 9m 58s
- 4. Mathematical Functions 11m 39s
- 5. String Functions 22m 15s
- 6. SUBQUERY 13m 25s
- 1. Database and Tables 6m 9s
- 2. Data Types 10m 29s
- 3. Primary Key and Foreign Key 5m 32s
- 4. Create Table in SQL Script 13m 12s
- 1. Insert 10m 46s
- 2. Update 7m 8s
- 3. Delete 4m 8s
- 1. Alter Table 9m 30s
- 2. Drop Table 5m 20s
- 1. NOT NULL Constraint 7m 54s
- 2. UNIQUE Constraint 9m 14s
- 1. Overview of Databases and Tables 4m 50s
- 2. Backup Database Using phpMyAdmin 12m 27s
- 3. Restoring a Database 7m 3s
- 0.00 instructor rating
- 1 courses
- Systems students worldwide
Metla Sudha Sekhar
Learn from DragonZap instructors with practical, build-first lessons focused on systems, low-level programming, compilers, kernels, and real-world engineering fundamentals.
Student reviews
No student reviews have been posted yet.