- 3m
- 3m
- 2m
- 4. How to Ask Great Questions 2m
- 5. FAQs 2m
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
- You will learn about Python and data science
Who this course is for
- Beginner Python developers and MySQL development curious about data science
- Anyone who wants to generate new income streams
- Anyone who wants to build websites
- Anyone who wants to become financially independent
- Anyone who wants to start their own business or become freelance
- Anyone who wants to become a Full stack web developer
- Anyone who wants to start Python coding with database career
Requirements
- No programming experience needed. You will learn everything you need to know
- No pre-knowledge is required - you will learn from basic
- No software is required in advance of the course (all software used in the course is free)
Curriculum
153 Lessons • 16h 45m estimated learning time- 5m
- 7. Choosing Code Editor 7m
- 8. Installing Code Editor (Sublime Text) 4m
- 9. Overview of a Webpage 5m
- 10. Structure of a Full HTML Webpage 8m
- 11. First Hello World! Webpage 9m
- 12. Heading Tags 9m
- 13. Paragraph 8m
- 14. Formatting Text 13m
- 15. List Items Unordered 6m
- 16. List Items Ordered 4m
- 17. Classes 10m
- 18. IDs 7m
- 19. Comments 5m
- 20. Images 12m
- 21. Forms 6m
- 22. Marquee 6m
- 23. Text Area 7m
- 24. Tables 7m
- 25. Links 8m
- 26. Navbar - Menu 5m
- 27. HTML Entities 6m
- 28. Div Tag 6m
- 29. Google Maps 8m
- 30. HTML Audio 8m
- 31. HTML Video 5m
- 32. Canvas 6m
- 33. Iframes 6m
- 34. Input Types 5m
- 35. Input Attributes 7m
- 36. Registration Form 5m
- 37. Contact Us Form 10m
- 38. Coding Exercise 2m
- 39. Solution for Coding Exercise 3m
- 40. Introduction to Python 3m
- 41. Python vs Other Languages 4m
- 42. Why It's Popular 4m
- 43. Command Line Basics 7m
- 44. Python Installation (Step By Step) 6m
- 45. PyCharm IDE Installation 8m
- 46. Getting Started With PyCharm IDE 5m
- 47. First Python Hello World Program 8m
- 48. Variables 17m
- 49. Data Types 14m
- 50. Type Casting 8m
- 51. User Inputs 8m
- 52. Comments 4m
- 53. Strings 5m
- 54. String Indexing 6m
- 55. String Slicing 4m
- 56. String Built-in Functions 9m
- 57. Formatting String (Dynamic Data) 5m
- 58. Arithmetic Operators 8m
- 59. Assignment Operators 5m
- 60. Comparison Operators 6m
- 61. Logical Operators 3m
- 62. AND Operator 5m
- 63. OR Operator 3m
- 64. NOT Operator 3m
- 65. Booleans 3m
- 66. Arrays in Earlier 2m
- 67. Lists 6m
- 68. Add List Items 3m
- 69. Remove List Items 2m
- 70. Sort Lists 3m
- 71. Join Lists 8m
- 72. Tuples 8m
- 73. Update Tuples 7m
- 74. Join Tuples 2m
- 75. Dictionaries 7m
- 76. Add Dictionary Items 5m
- 77. Remove Dictionary Items 3m
- 78. Nested Dictionaries 4m
- 79. Sets 4m
- 80. Add Set Items 4m
- 81. Remove Set Items 2m
- 82. Join Set Items 4m
- 83. If Statement 4m
- 84. If-else Statement 5m
- 85. If-elif-else Statement 4m
- 86. If Statement Coding Exercise 5m
- 87. Flow Charts 7m
- 88. While Loops Statement 10m
- 89. For Loops Statement 7m
- 90. The range() Function 4m
- 91. Nested Loops 4m
- 92. 2D List using Nested Loop 4m
- 93. Guessing Game 8m
- 94. Car Game 10m
- 95. Creating a Function 4m
- 96. Calling a Function 7m
- 97. Function with Arguments 5m
- 98. args, Arbitrary Arguments 5m
- 99. kwargs, Arbitrary Keyword Arguments 7m
- 100. Project Overview 4m
- 101. ATM Realtime Project 14m
- 102. Overview of Databases 11m
- 103. MySQL Installation 16m
- 104. MySQL Workbench Installation 10m
- 105. Connecting to MySQL Using Console 9m
- 106. Overview of Challenges 4m
- 107. SQL Statement Basic 16m
- 108. SELECT Statement 10m
- 109. SELECT DISTINCT 5m
- 110. Column AS Statement 12m
- 111. COUNT Function 12m
- 112. SELECT WHERE Clause – One 5m
- 113. SELECT WHERE Clause – Two 11m
- 114. ORDER BY 8m
- 115. LIMIT 9m
- 116. BETWEEN 12m
- 117. IN Operator 11m
- 118. LIKE and ILIKE 12m
- 119. Overview of GROUP BY 6m
- 120. Aggregation Function SUM() 9m
- 121. Aggregation MIN() and MAX() 6m
- 122. GROUP BY - One 10m
- 123. GROUP BY – Two 12m
- 124. HAVING Clause 6m
- 125. Overview Assessment 2m
- 126. Overview of JOINS 4m
- 127. Introduction to JOINS 5m
- 128. AS Statement Table 4m
- 129. INNER JOIN 19m
- 130. FULL Outer Join 12m
- 131. LEFT Outer JOIN 8m
- 132. RIGHT JOIN 8m
- 133. Union 7m
- 134. Advanced SQL Commands 4m
- 135. Timestamps 13m
- 136. Extract From Timestamps 10m
- 137. Mathematical Functions 12m
- 138. String Functions 23m
- 139. SUBQUERY 14m
- 140. Database and Tables 7m
- 141. Data Types 11m
- 142. Primary Key and Foreign Key 6m
- 143. Create Table in SQL Script 14m
- 144. Insert 11m
- 145. Update 8m
- 146. Delete 5m
- 147. Alter Table 10m
- 148. Drop Table 6m
- 149. NOT NULL Constraint 8m
- 150. UNIQUE Constraint 10m
- 151. Overview of Databases and Tables 5m
- 152. Backup Database Using phpMyAdmin 13m
- 153. Restoring a Database 8m
- 0.00 instructor rating
- 24 courses
- 3 students worldwide
Metla Sudha Sekhar
Mr. Sudha Sekhar, He is a Teacher and an IT Specialist, and also passionate to teach every single real-time step that leads students as well as professionals to become successful and the vision to impart Good Quality Software Education to all I.T to aspirants make a strong bridge the gap between the software companies requirements and the beginners.
He is Professional about web development and technologies:
* Programming: Python, C# Asp.Net and PHP more..
* UI/UX : HTML, CSS, Bootstrap, JavaScript, AJAX and more...
* Database : MS-SQL, MySQL, PostgreSQL, MongoDB, MariaDB and
more...
* Operating Systems / Servers: Administration of LINUX, Ubuntu,
CentOS, Windows and more...
Start solving your challenge now | Enroll today and learn real world practical example courses.
He is passionate about:
* Teaching students the correct way.
* Making things simple and easy to understand.
* Providing the best audio and video qualities to my courses.
* Real-time Examples who will understand real-time skills easily.
Student reviews
No student reviews have been posted yet.