5. INNER JOIN | Coursetakers

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)

Teach online with

5. INNER JOIN

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock