SQL / MySQL Tutorial
43 videos • 187,097 views • by CodeEra
We will upload two video every week. So keep learning.
1
Learn SQL From Scratch : Launching Our New SQL Course | Zero To Hero | FREE
CodeEra
Download
2
1- What is Data, Database, DBMS and Types of Database | Fundamentals of Database
CodeEra
Download
3
2- Important Database Terms| Fundamentals of Database | Tuple | Relations | Primary Key | Columns
CodeEra
Download
4
3 - What is SQL | Advantages of SQL | Introduction to SQL
CodeEra
Download
5
4- SQL vs NoSQL | Difference Between SQL & NoSQL | MySQL vs MongoDB | Which One Should You Use ?
CodeEra
Download
6
5 - How to install MySQL 8.0.30 Server and Workbench on Windows 10 | Latest Version | Step by Step
CodeEra
Download
7
6-Introduction to MySQL Workbench | Create new Database & Table| Import & Export Data| E-R Diagram
CodeEra
Download
8
7-SQL Commands| Example | DDL, DML, DQL, DCL and TCL Commands in SQL | Interview Questions
CodeEra
Download
9
8- Datatypes in SQL | SQL Datatype | String | Numeric | Character | DateTime | | Interview Questions
CodeEra
Download
10
9- CREATE Command in SQL | Create Database & Table | Interview Questions | SHOW, USE & DESC Commands
CodeEra
Download
11
10 - INSERT Command in SQL | Insert Data into Tables | Insert Single/Multiple Rows | DML Command
CodeEra
Download
12
11 - Constraints in SQL | Example | Primary Key | Foreign Key | NOT NULL | Unique | Check | Default
CodeEra
Download
13
12-SELECT Command in SQL | DISTINCT | FROM Clause | AS - Alias | DQL Command | Practice Questions
CodeEra
Download
14
13 - WHERE Clause in SQL | Types of Operators | WHERE With Comparison Operator | Practice Questions
CodeEra
Download
15
14 - AND, OR, NOT Operators in SQL | Logical Operators | With SQL Queries | WHERE Clause | Example
CodeEra
Download
16
15 - SQL BETWEEN & NOT BETWEEN Operator | IN & NOT IN Operator in SQL | Example | Practice Question
CodeEra
Download
17
16-LIKE Operator & Wildcard Characters | NOT LIKE Operator | ESCAPE Character | SQL Queries
CodeEra
Download
18
17- IS NULL & IS NOT NULL Operators | What is NULL | NULL Value Handling | IFNULL Function | Example
CodeEra
Download
19
18- ORDER BY Clause in SQL | On Single & Multiple Columns | ASC & DESC | SQL Query | Interview Topic
CodeEra
Download
20
19- LIMIT and OFFSET in SQL | Find Nth highest salary using LIMIT Clause | Interview Question
CodeEra
Download
21
20 -TOP Clause in SQL | FETCH FIRST Clause | LIMIT vs TOP | SQL Practice Query | Oracle | SQL Server
CodeEra
Download
22
21-Aggregate Functions in SQL | SUM | COUNT | AVG | MAX | MIN | Important Interview Query | COUNT(*)
CodeEra
Download
23
22 -GROUP BY Clause in SQL | Use Of GROUP BY | Interview Questions | Examples | Multiple Column| SQL
CodeEra
Download
24
23-HAVING CLAUSE in SQL | Use Of HAVING | Interview Questions | Example| Single & Multiple Condition
CodeEra
Download
25
24-Difference Between WHERE and HAVING CLAUSE in SQL | Examples | Most Important Interview Question
CodeEra
Download
26
25-String Functions in SQL | Types of SQL Functions | Examples | SUBSTR(),CONCAT(),UPPER(),REVERSE()
CodeEra
Download
27
26-Numeric Functions in SQL | Types of SQL Functions | Examples | ABS(),MOD(),SQRT(),CEIL(),POWER()
CodeEra
Download
28
27-Date & Time Functions in SQL | Types of SQL Functions| Examples | DATE_FORMAT(), DATE_ADD(),etc..
CodeEra
Download
29
28-Conversion Functions in SQL | Types of SQL Functions| CAST VS CONVERT | STR_TO_DATE | DATE_FORMAT
CodeEra
Download
30
29-SET Operators in SQL | Union | Union All | Intersect | Except or Minus | Examples | SQL Tutorial
CodeEra
Download
31
30-Introduction to Joins & its types | Need of Joins with example | Relational Tables | Joins Query
CodeEra
Download
32
32-How to Join 3 or more tables in SQL | Join Multiple Tables | Using Inner Join | Interview Topic
CodeEra
Download
33
33 -SQL JOINS Tutorial | LEFT & RIGHT JOIN | FULL JOIN | Types of JOINS | Examples| Interview Topic
CodeEra
Download
34
34-CROSS JOIN in SQL | Cartesian Product | How does it work | CROSS JOIN with MULTIPLE TABLES | SQL
CodeEra
Download
35
35-SELF JOIN in SQL |JOIN Tutorial | JOINS Interview Query |Types of JOIN |Why do we need SELF JOIN
CodeEra
Download
36
31-INNER JOIN & NATURAL JOIN in SQL | INNER vs NATURAL JOIN |Practice SQL Query using JOINS |Example
CodeEra
Download
37
36 Subquery in SQL | Complete Subqueries Tutorial in ONE Video | Types of Subqueries | Advance SQL
CodeEra
Download
38
37-Subquery Using ALL,ANY & EXISTS Operators in SQL | Example | Advance SQL | EXISTS vs IN vs JOINS
CodeEra
Download
39
38-UPDATE Command In SQL | How To UPDATE Records In Table | DML Command | UPDATE Query With Example
CodeEra
Download
40
39 - ALTER Command in SQL | ALTER vs UPDATE | Add, Rename, Modify, Drop Column/Table | DDL Command
CodeEra
Download
41
40 - Difference Between DELETE, DROP and TRUNCATE | SQL | Interview Question | Examples | DBMS
CodeEra
Download
42
41- ACID Properties with Examples | Transactional Command | DBMS | What is Transaction in SQL ?
CodeEra
Download
43
42-Transactional Command in SQL | COMMIT | ROLLBACK | SAVEPOINT | SQL Interview Preparation
CodeEra
Download