CodeEra

39.3K subscribers

149 videos

Welcome to CodeEra 💻 This channel is dedicated to helping you learn SQL, Java, and crack technical interviews with simple and practical explanations. What yo...

Latest Videos

SQL Window Functions RANK vs DENSE RANK PARTITION BY SQL Interview Preparation Examples

Most Confusing SQL Topic ROW_NUMBER() + PARTITION BY vs GROUP BY

Top 9 SQL Interview Questions & Answers Updated SQL Tutorial Most Asked Mistakes To Avoid

42-Transactional Command in SQL COMMIT ROLLBACK SAVEPOINT SQL Interview Preparation

41- ACID Properties with Examples Transactional Command DBMS What is Transaction in SQL

40 - Difference Between DELETE, DROP and TRUNCATE SQL Interview Question Examples DBMS

Latest Accenture Interview Experience 2023 TOP Interview Questions & Answers ASE Interview Tips

39 - ALTER Command in SQL ALTER vs UPDATE Add, Rename, Modify, Drop ColumnTable DDL Command

Accenture Latest Interview Experience 2023 All Interview Questions & Answers ASE TR+HR 4.5LPA

38-UPDATE Command In SQL How To UPDATE Records In Table DML Command UPDATE Query With Example

37-Subquery Using ALL,ANY & EXISTS Operators in SQL Example Advance SQL EXISTS vs IN vs JOINS

36 Subquery in SQL Complete Subqueries Tutorial in ONE Video Types of Subqueries Advance SQL

35-SELF JOIN in SQL JOIN Tutorial JOINS Interview Query Types of JOIN Why do we need SELF JOIN

34-CROSS JOIN in SQL Cartesian Product How does it work CROSS JOIN with MULTIPLE TABLES SQL

33 -SQL JOINS Tutorial LEFT & RIGHT JOIN FULL JOIN Types of JOINS Examples Interview Topic

32-How to Join 3 or more tables in SQL Join Multiple Tables Using Inner Join Interview Topic

31-INNER JOIN & NATURAL JOIN in SQL INNER vs NATURAL JOIN Practice SQL Query using JOINS Example

30-Introduction to Joins & its types Need of Joins with example Relational Tables Joins Query

29-SET Operators in SQL Union Union All Intersect Except or Minus Examples SQL Tutorial

28-Conversion Functions in SQL Types of SQL Functions CAST VS CONVERT STR_TO_DATE DATE_FORMAT

27-Date & Time Functions in SQL Types of SQL Functions Examples DATE_FORMAT(), DATE_ADD(),etc..

26-Numeric Functions in SQL Types of SQL Functions Examples ABS(),MOD(),SQRT(),CEIL(),POWER()

25-String Functions in SQL Types of SQL Functions Examples SUBSTR(),CONCAT(),UPPER(),REVERSE()

24-Difference Between WHERE and HAVING CLAUSE in SQL Examples Most Important Interview Question

23-HAVING CLAUSE in SQL Use Of HAVING Interview Questions Example Single & Multiple Condition

22 -GROUP BY Clause in SQL Use Of GROUP BY Interview Questions Examples Multiple Column SQL

21-Aggregate Functions in SQL SUM COUNT AVG MAX MIN Important Interview Query COUNT()

20 -TOP Clause in SQL FETCH FIRST Clause LIMIT vs TOP SQL Practice Query Oracle SQL Server

19- LIMIT and OFFSET in SQL Find Nth highest salary using LIMIT Clause Interview Question

18- ORDER BY Clause in SQL On Single & Multiple Columns ASC & DESC SQL Query Interview Topic