7.2 Data Frame Basics

7.3 Key Operations on Data Frames

#Module 8 : Python for Data Science: Computational Complexity

Section 8 is divided into sub sections

👉 8.1 Space and Time Complexity: Find largest number in a list

👉 8.2 Binary search

👉 8.3 Find elements common in two lists

👉 8.4 Find elements common in two lists using a Hashtable/Dict

8.1 Space and Time Complexity: Find largest number in a list

8.2 Binary search

8.3 Find elements common in two lists

8.4 Find elements common in the two lists using a Hashtable/Dict

#Module 9 : SQL

Section 9 is divided into sub sections

👉 9.1 Introduction to Databases

👉 9.2 Why SQL?

👉 9.3 Execution of an SQL statement.

👉 9.4 IMDB dataset

👉 9.5 Installing MySQL

👉 9.6 Load IMDB data.

👉 9.7 USE, DESCRIBE, SHOW TABLES

👉 9.8 SELECT

👉 9.9 LIMIT, OFFSET

👉 9.10 ORDER BY

👉 9.11 DISTINCT

👉 9.12 WHERE, Comparison operators, NULL

👉 9.13 Logical Operators

👉 9.14 Aggregate Functions: COUNT, MIN, MAX, AVG, SUM

👉 9.15 GROUP BY

👉 9.16 HAVING

👉 9.17 Order of keywords.

👉 9.18 Join and Natural Join

👉 9.19 Inner, Left, Right and Outer joins.

👉 9.20 Sub Queries/Nested Queries/Inner Queries

👉 9.21 DML:INSERT

👉 9.22 DML:UPDATE , DELETE

👉 9.23 DDL:CREATE TABLE

👉 9.24 DDL:ALTER: ADD, MODIFY, DROP

👉 9.25 DDL:DROP TABLE, TRUNCATE, DELETE

👉 9.26 Data Control Language: GRANT, REVOKE

👉 9.27 Learning resources

👉 9.28 Assignment-22: SQL Assignment on IMDB data

9.1 Introduction to Databases

9.2 Why SQL?

9.3 Execution of an SQL statement

9.4 IMBD dataset

9.5 Installing MySQL

9.6 Load IMBD data

9.7 USE, DESCRIBE, SHOW TABLES

9.8 SELECT

9.9 LIMIT, OFFSET

9.10 ORDER BY

9.11 DISTINCT

9.12 WHERE, COMPARISON OPERATORS, NULL