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