technifyed

Gate Smashers via YouTube Video playlist

Structured Query Language (SQL)

Videos in this playlist 44

  1. Lec-59: Introduction to Structured Query Language | All Points regarding its Features and Syllabus
  2. Lec-60: All Types of SQL Commands with Example | DDL, DML, DCL, TCL and CONSTRAINTS | DBMS
  3. Lec-61: Create table in SQL with execution | SQL for Beginners | Oracle LIVE
  4. Lec-63: ALTER Command (DDL) in SQL with Implementation on ORACLE
  5. Lec-64: Difference between Alter and Update in SQL with examples in Hindi | DBMS
  6. Lec-65: Difference between Delete, Drop & Truncate in SQL | DBMS
  7. Lec-66: Constraints in SQL in Hindi | DBMS
  8. Lec-67: SQL Queries and Subqueries (part-1) | Database Management System
  9. Lec-68: SQL Queries and Subqueries (part-2) | 2nd Highest Salary | Nested Queries | DBMS
  10. Lec-69: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System
  11. Lec-71: SQL Queries and Subqueries (part-4) | Having clause | Database Management System
  12. Lec-72: SQL Queries and Subqueries (part-5) | Database Management System
  13. Lec-73: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System
  14. Lec-74: SQL Queries and Subqueries (part-7)| use of IN and Not IN in Subquery | DBMS
  15. Lec-75: EXIST and NOT EXIST Subqueries(part-8) | Database Management System
  16. Lec-79: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS
  17. Lec-81: Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification
  18. Lec-83: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL
  19. Lec-84: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam
  20. Lec-85: 3 Imp Questions on SQL basic Concepts | DBMS
  21. Lec-86: Introduction to PL-SQL in DBMS
  22. Lec-121: Basic PL-SQL Programming With Execution | Part-1
  23. Lec-122: Basic PL-SQL Programming(While, For Loop) With Execution | Part-2
  24. Lec-123: Single row and Multi row functions in SQL
  25. Lec-124: Character functions in SQL with execution | Oracle LIVE
  26. Lec-132: Top 15 SQL Interview Questions Answers | Most Important Questions for Job Interview
  27. Lec-62: CREATE Command (DDL) in SQL with Implementation on ORACLE
  28. Lec-77: SEQUENCE in SQL with Syntax & Examples
  29. Lec-78: How SQL Query executes?? Order of SQL Query Execution⏳🔄
  30. Synonyms in SQL with Syntax & Examples | Why Synonyms are used in SQL
  31. Roles in Database | How Roles Created in SQL | Why Roles used?
  32. Delete🧽 Duplicate Rows from Table📑| SQL Interview Preparation | SQL Interview Questions
  33. Top 3 Highest Salary in every Department | 🔝Interview Questions SQL
  34. Employees👨‍💻 Taking More Salary🤑 than their Managers👨‍✈️| SQL INTERVIEW QUERIES
  35. Find 🔎 Customer🛂 Details who Never ❌ Order🧾 | SQL Interview Questions❓🙋🙋‍♀️
  36. Employee 👨‍💻 whose Salary 🤑 continuously Raises from 3 years | SQL INTERVIEW QUERIES
  37. Rank() vs Dense_Rank() Window Function() | SQL Interview🎙Questions🙋🙋‍♀️
  38. Lec-14: Foreign Key🔑 with On Delete Cascade with Execution
  39. Sql Triggers🔫 Real Life Example | SQL Interview♟ Questions🎯
  40. Display N-th row in the SQL Table | SQL Interview♟Questions🎯
  41. Lec-136: Procedures in PL-SQL | Local Procedure vs Stored Procedure
  42. Lec-137: How to Fetch Data from Database using Procedures | PL-SQL Procedure
  43. Lec-139: %TYPE & %ROWTYPE in PL-SQL with Examples
  44. Lec-138: What is Cursor in PL-SQL with example

Advantages and disadvantages

Advantages

  • Free and complete: every lecture is in the playlist, in order.
  • Watch at 1.5x, skip what you know, rewatch what you don't.
  • Taught in Hindi (or Hinglish), which many students find easier to follow.
  • Made for Indian students, with placement and exam context.
  • 2,522,567 views, so help and notes are easy to find.
  • Completely free.
  • Self-paced: start any time.
  • A clear syllabus (44 videos) you can see before you start.

Disadvantages

  • No certificate, deadlines or graded work.
  • Quality and depth vary: check that the playlist is finished before you start.
  • Less depth than a university course on some topics.
  • No certificate.
  • No graded assignments or feedback.
  • Recorded in 2019: tools may have changed since.

Some points apply to every course of this kind; see how we rank.

Free

  • Free: Watch on YouTube, no account needed.
  • Certificate: None. Code or take notes along to make it stick.

Gate Smashers is in Tier 3: good universities, respected companies, nonprofits and well-known teachers of our institution ranking (76/100). GATE and university CS subjects in Hindi.

Similar courses

Compare these

Massachusetts Institute of Technology · YouTube

MIT 15.S12 Blockchain and Money, Fall 2018

Instructor: Prof. Gary Gensler View the complete course: https://ocw.mit.edu/15-S12F18 This course is for students wishing to explore blockchain technology’s potential use - by entrepreneurs & incumbents - to change the world of money and finance. License: Creative Commons BY-NC-SA More information…

Free video23 videos, 29 hours

Massachusetts Institute of Technology · YouTube

MIT 6.006 Introduction to Algorithms, Fall 2011

This course provides an introduction to mathematical modeling of computational problems. It covers the common algorithms, algorithmic paradigms, and data structures used to solve these problems. The course emphasizes the relationship between algorithms and programming, and introduces basic performa…

Free video47 videos, 42 hours

Harvard University · YouTube

CS50's Introduction to Programming with Python (CS50P) 2022

This is CS50P, CS50's Introduction to Programming with Python. Register for free at https://cs50.edx.org/python. Slides and source code at https://cs50.harvard.edu/python. Playlist at https://www.youtube.com/playlist?list=PLhQjrBD2T3817j24-GogXmWqO5Q5vYy0V. An introduction to programming using a la…

Free video11 videos, 16 hours

Harvard University · YouTube

CS50x 2023 Lectures

This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming, for concentrators and non-concentrators alike, with or without prior programming experience. (Two thirds of CS50 students have never taken CS before.) This course teaches…

Free video12 videos, 26 hours

Massachusetts Institute of Technology · YouTube

MIT 6.100L Introduction to CS and Programming using Python, Fall 2022

Instructor: Ana Bell View the complete course: https://ocw.mit.edu/courses/6-100l-introduction-to-cs-and-programming-using-python-fall-2022/ *Note: Lectures 6, 10 have been updated! This subject is aimed at students with little to no programming experience. It aims to provide students with an under…

Free video26 videos, 28 hours

Stanford University · YouTube

Stanford Online Courses and Programs

Get more information about the courses and programs we offer. In this playlist you can learn more about course content, pricing, credentials and more!

Free video154 videos, 139 hours

Enter your email and the official page opens. Phone is optional.