This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Python programming with MySQL database: for Data Science
1. Introduction
1. Introduction (2:43)
2. How to Get Course requirements (2:27)
3. Getting Started on Windows Linux or Mac (1:32)
4. How to ask a Great Questions (1:21)
5. FAQs (1:04)
2. HTML
1. Introduction HTML (4:56)
2. Choosing Code Editor (6:08)
3. Installing Code Editor (Sublime Text) (3:48)
4. Overview of a Webpage (4:35)
5. Structure of a Full HTML Webpage (7:05)
6. First Hello World! Webpage (8:59)
3. HTML Basic
1. Heading tags (8:48)
2. Paragraph (7:35)
3. Formatting Text (12:23)
4. List Items Unordered (5:08)
5. List Items Ordered (3:56)
6. Classes (9:24)
7. IDs (6:14)
8. Comments (4:14)
4. HTML Intermediate
1. Images (11:46)
2. Forms (5:12)
3. Marquee (5:29)
4. Text area (6:02)
5. Tables (6:03)
6. Links (7:19)
7. Navbar - Menu (4:04)
8. HTML Entities (5:17)
9. Div tag (5:49)
10. Google Maps (7:14)
5. HTML Advanced
1. HTML Audio (7:16)
2. HTML Video (4:47)
3. Canvas (5:35)
4. Iframes (5:06)
5. Input Types (4:06)
6. Input Attributes (6:23)
7. Registration Form (4:18)
8. Contact Us Form (9:49)
9. Coding Exercise (1:21)
10. Solution for Coding Exercise (2:21)
6. Python Introduction
1. Introduction to Python (2:16)
2. Python vs Other Languages (3:48)
3. Why Its Popular (3:33)
4. Command Line Basics (6:43)
5. Python Installation (Step By Step) (5:47)
6. PyCharm IDE Installation (7:56)
7. Getting Start PyCharm IDE (4:44)
8. First Python Hello World Program (7:22)
7. Python Basic
1. Variables (16:18)
2. Data Types (13:09)
3. Type Casting (7:04)
4. User Inputs (7:54)
5. Comments (3:53)
8. Python Strings
1. Strings (4:58)
2. String Indexing (5:21)
3. String Slicing (3:52)
4. String Built-in Functions (8:36)
5. Formatting String (Dynamic Data) (4:35)
9. Python Operators
1. Arithmetic Operators (7:48)
2. Assignment Operators (4:40)
3. Comparison Operators (5:20)
4. Logical Operators (2:01)
5. AND Operator (4:09)
6. OR Operator (2:16)
7. NOT Operator (2:52)
8. Booleans (2:05)
10. Python Data Structures
1. Arrays in Earlier (1:45)
2. Lists (5:37)
3. Add List Items (2:54)
4. Remove List Items (1:16)
5. Sort Lists (2:46)
6. Join Lists (7:35)
7. Tuples (7:43)
8. Update tuples (6:58)
9. Join tuples (1:50)
10. Dictionaries (6:02)
11. Add Dictionary Items (4:26)
12. Remove Dictionary Items (2:41)
13. Nested Dictionaries (4:00)
14. Sets (3:39)
15. Add Set Items (3:07)
16. Remove Set Items (1:27)
17. Join Set Items (3:55)
13. Python Core Games
1. Guessing Game (7:14)
2. Car Game (9:40)
12. Python Control Flow Statements
1. Flow Charts (6:25)
2. While Loops Statement (9:42)
3. For Loops Statement (6:18)
4. The range() Function (3:37)
5. Nested Loops (3:29)
6. 2D List using Nested Loop (3:30)
11. Python Conditional Statements
2. If-else Statement (4:08)
1. If Statement (3:20)
3. If-elif-else Statement (3:58)
4. If Statement Coding Exercise (4:41)
14. Python Functions
1. Creating a Function (3:09)
2. Calling a Function (6:03)
3. Function with Arguments (4:58)
15. Python args, KW args for Data Science
1. args, Arbitrary Arguments (4:05)
2. kwargs, Arbitrary Keyword Arguments (6:01)
16. Python Project
1. Project Overview (3:29)
2. ATM Realtime Project (13:23)
17. MYSQL introduction
1. Overview of Databases (10:23)
2. MySQL Installation (15:49)
3. MySQL Workbench Installation (9:04)
4. Connecting to MySQL using Console (9:00)
18. MySQL basic
1. Overview of Challenges (3:43)
2. SQL Statement Basic (15:30)
3. SELECT Statement (9:19)
4. SELECT DISTINCT (4:51)
5. Column AS Statement (11:43)
6. COUNT function (11:03)
19. MySQL filtering data
1._SELECT_WHERE_Clause_-_One (4:36)
2._SELECT_WHERE_Clause_-_Two (10:40)
3._ORDER_BY (7:41)
4. LIMIT (8:34)
5._BETWEEN (11:18)
6._IN_Operator (10:40)
7._LIKE_and_ILIKE (11:11)
20. MySQL functions
1. Overview of GROUP BY (5:39)
2. Aggregation function SUM()() (8:52)
3. Aggregation MIN() and MAX() (5:29)
4. GROUP BY - One (9:13)
5. GROUP BY – Two (11:45)
6. HAVING Clause (5:04)
21. MySQL joins
1. Overview Assessment (1:59)
2. Overview of JOINS (3:36)
3. Introduction to JOINS (4:01)
4. AS Statement table (3:04)
5. INNER JOIN (18:29)
6. FULL Outer Join (11:11)
7. LEFT Outer JOIN (7:53)
8. RIGHT JOIN (7:45)
9. Union (6:44)
22. MySQL advanced commands
1. Advanced SQL Commands (3:37)
2. Timestamps (12:22)
3. EXTRACT from timestamp (9:59)
4. Mathematical Functions (11:39)
5. String Functions (22:15)
6. SUBQUERY (13:25)
23. MySQL structure creation
1. Database and Tables (6:09)
2. Data Types (10:30)
3. Primary key and Foreign key (5:33)
4. Create Table in SQL Script (13:12)
24. MySQL data queries
1. Insert (10:46)
2. Update (7:08)
3. Delete (4:08)
25. MySQL structure queries
1. Alter Table (9:30)
2. Drop Table (5:20)
26. MySQL constraints
1. NOT NULL Constraint (7:54)
2. UNIQUE Constraint (9:14)
27. MySQL Backup and Restore
1. Overview of Databases and Tables (4:50)
2. Backup database using phpMyAdmin (12:27)
3. Restoring a Database (7:03)
4. String Built-in Functions
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock