technifyed

Gate Smashers via YouTube Video playlist

SQL Full Course

Videos in this playlist 31

  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-79: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS
  9. Lec-76: Like Command in SQL with example in Hindi | Learn SQL in Easiest Way| DBMS
  10. Lec-123: Single row and Multi row functions in SQL
  11. Lec-124: Character functions in SQL with execution | Oracle LIVE
  12. Lec-125: View in Database | Oracle, SQL Server Views | Types of Views
  13. Lec-78: How SQL Query executes?? Order of SQL Query Execution⏳🔄
  14. Lec-69: SQL Queries and Subqueries (part-3) | Group By clause | Database Management System
  15. Lec-71: SQL Queries and Subqueries (part-4) | Having clause | Database Management System
  16. Lec-83: Difference between Joins, Nested Subquery and Correlated Subquery | Most Imp Concept of SQL
  17. Lec-84: Find Nth(1st,2nd,3rd....N) Highest Salary in SQL | Imp for Competitive & Placement exam
  18. Lec-73: SQL Queries and Subqueries (part-6)| use of IN and Not IN | Database Management System
  19. Lec-81: Correlated Subquery in SQL with Example | Imp for Placements, GATE, NET & SQL certification
  20. Lec-75: EXIST and NOT EXIST Subqueries(part-8) | Database Management System
  21. Lec-49: Question on Inner, Left, Right & Full Outer Joins Explanation | DBMS
  22. Lec-132: Top 15 SQL Interview Questions Answers | Most Important Questions for Job Interview
  23. Rank() vs Dense_Rank() Window Function() | SQL Interview🎙Questions🙋🙋‍♀️
  24. Delete🧽 Duplicate Rows from Table📑| SQL Interview Preparation | SQL Interview Questions
  25. Lec-86: Introduction to PL-SQL in DBMS
  26. Query Optimization | SQL Query Optimization with Examples
  27. Lec-136: Procedures in PL-SQL | Local Procedure vs Stored Procedure
  28. Lec-137: How to Fetch Data from Database using Procedures | PL-SQL Procedure
  29. Lec-139: %TYPE & %ROWTYPE in PL-SQL with Examples
  30. Lec-138: What is Cursor in PL-SQL with example
  31. Lec-140: Data Cleaning using SQL Functions with examples

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 (31 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.

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.