Python programming with MySQL database: for Data Science

Metla Sudha Sekhar

153 Lessons 16h 45m

8. Installing Code Editor (Sublime Text)

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 devel...

Lesson assistant

Ask about what you’re watching

Subscriber benefit

See something confusing? Subscribe to ask the lesson assistant about it.

Ask about what’s on screen. The assistant uses the current video frame and available subtitles.
Get clear answers to up to 5 lesson questions each day.
Enrol in up to 4 included courses each month and learn while subscribed.
Save 75% on eligible courses outside the subscription.

Already subscribed? Sign in

No suggested offers right now

Continue through the course and check back later for relevant recommendations.

View Downloads

Course Content

0% Completed

Introduction

1. Introduction 3m 2. How to Get Course Requirements 3m 3. Getting Started on Windows, Linux, or Mac 2m 4. How to Ask Great Questions 2m 5. FAQs 2m

HTML

6. Introduction to HTML 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

HTML Basics

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

HTML Intermediate

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

HTML Advanced

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

Python Introduction

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

Python Basics

48. Variables 17m 49. Data Types 14m 50. Type Casting 8m 51. User Inputs 8m 52. Comments 4m

Python Strings

53. Strings 5m 54. String Indexing 6m 55. String Slicing 4m 56. String Built-in Functions 9m 57. Formatting String (Dynamic Data) 5m

Python Operators

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

Python Data Structures

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

Python Conditional Statements

83. If Statement 4m 84. If-else Statement 5m 85. If-elif-else Statement 4m 86. If Statement Coding Exercise 5m

Python Control Flow Statements

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

Python Core Games

93. Guessing Game 8m 94. Car Game 10m

Python Functions

95. Creating a Function 4m 96. Calling a Function 7m 97. Function with Arguments 5m

Python args, KW args For Data Science

98. args, Arbitrary Arguments 5m 99. kwargs, Arbitrary Keyword Arguments 7m

Python Project

100. Project Overview 4m 101. ATM Realtime Project 14m

MySQL Introduction

102. Overview of Databases 11m 103. MySQL Installation 16m 104. MySQL Workbench Installation 10m 105. Connecting to MySQL Using Console 9m

MySQL Basics

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

MySQL Filtering Data

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

MySQL Functions

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

MySQL Joins

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

MySQL Advanced Commands

134. Advanced SQL Commands 4m 135. Timestamps 13m 136. Extract From Timestamps 10m 137. Mathematical Functions 12m 138. String Functions 23m 139. SUBQUERY 14m

MySQL Structure Creation

140. Database and Tables 7m 141. Data Types 11m 142. Primary Key and Foreign Key 6m 143. Create Table in SQL Script 14m

MySQL Data Queries

144. Insert 11m 145. Update 8m 146. Delete 5m

MySQL Structure Queries

147. Alter Table 10m 148. Drop Table 6m

MySQL Constraints

149. NOT NULL Constraint 8m 150. UNIQUE Constraint 10m

MySQL Backup and Restore

151. Overview of Databases and Tables 5m 152. Backup Database Using phpMyAdmin 13m 153. Restoring a Database 8m

Python programming with MySQL database: for Data Science

Ready for the next lesson?

8. Installing Code Editor (Sublime Text)

Ask about what you’re watching

No suggested offers right now

About This Lesson

No questions yet

Course Overview

Metla Sudha Sekhar