Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
L38 : Complete SQL Course for Beginners | Full Tutorial in One Video
Play lesson

SQL Course in 2024 | Placements | Semester Exams | Jobs - L38 : Complete SQL Course for Beginners | Full Tutorial in One Video

4.0 (2)
32 learners

What you'll learn

This course includes

  • 13 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

In this video, we delve into Complete SQL Course for Beginners Join the journey into data! Announcement video(with syllabus) : https://youtu.be/eylFMNSJCQo Notes for the lecture : https://drive.google.com/drive/folders/1jM3nZuSjJHkX2E-X3ov8qF77wFm21fvr?usp=sharing Repo for the series : https://github.com/riti2409/Dbms_Series Drive link for notes : https://drive.google.com/drive/folders/1mTp-XiRQ3i31PfBi7sEWmzV0oIgzuHJK?usp=sharing Series link : https://youtube.com/playlist?list=PLrL_PSQ6q062cD0vPMGYW_AIpNg6T0_Fq Timestamps: (hour : minutes : seconds) L1 : Lets Start with SQL- 00:00:17 L2 : What is SQL- 00:05:24 L3 : MySQL Installation - 00:08:58 L4 : Types of SQL Commands- 00:13:11 L5 : Databases and related SQL commands- 00:18:26 L6 : Tables and related SQL command- 00:37:08 L7 : Building a Database- From Tables to data insertion- 00:45:33 L8 : Datatypes in SQL- 00:53:24 L9 : Keys in SQL- 01:03:36 L10 : Constraints in SQL- 01:09:23 L11 : Foreign Key in SQL- 01:24:32 L12 : Update Command in SQL- 01:37:35 L13 : Delete Command in SQL- 01:49:55 L14 : Select Command in SQL- 01:53:24 L15 : Where Clause in SQL - 01:55:29 L16 : ALTER Command in SQL- 01:58:59 L17 : RENAME Command in SQL- 02:09:09 L18 : TRUNCATE Command- 02:13:13 L19 : Difference between TRUNCATE, DELETE & DROP in SQL - 02:16:29 L20 : Distinct Keyword in SQL- 02:18:31 L21 : Operators in SQL- 02:23:20 L22 : Clauses in SQL- 02:39:03 L23 : Aggregate Functions in SQL- 02:47:50 L24 : GROUP BY and HAVING clause in SQL - 02:57:35 L25 : Difference between HAVING and WHERE clause in SQL- 03:08:45 L26 : Practice Question on clause and Aggregate Function in SQL- 03:11:26 L27 : General Order of SQL command- 03:23:44 L28 : Joins in SQL- 03:25:31 L29 : Inner Join in SQL- 03:31:28 L30 : Left Outer Join in SQL - 03:37:56 L31 : Right Outer Join in SQL- 03:41:43 L32 : Full Outer Join in SQL- 03:44:34 L33 : Cross Join in SQL- 03:51:46 L34 : Self Join in SQL- 03:56:54 L35 : Exclusive Joins in SQL- 04:!0:48 L36 : UNION and UNION ALL in SQL- 04:21:16 L37 : Subqueries in SQL- 04:30:16 L38 : Nth Highest Salary in SQL- 04:45:21 L39 : Stored Procedure in SQL- 04:52:05 L40 : Views in SQL- 04:56:36 You can connect with me here 👇 Linkedin : https://www.linkedin.com/in/riti2409 Telegram : https://telegram.me/ritikumari Instagram : https://instagram.com/ritikumariupadhyay24 Twitter : https://x.com/riti2409 #ritikumari #dbmsseries #placementsprep #semesterexams #databasemanagement #techeducation #careerboost #examsuccess #techskills #interviewprep #academicexcellence #databaseconcepts #learningjourney #data #databases #dbms #databasenormalization #databasedesign #SQL #relationaldatabases #datamodeling #datamanagement #databaseoptimization #databasetheory #computerscience #SQL #MySQL #SQLTutorial #LearnSQL #SQLCourse #Database #Programming #Coding #TechEducation #SQLForBeginners #SQLTraining #WebDevelopment #DataScience #TechTutorial #FullCourse

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Related Courses

FAQs

Course Hive
Download CourseHive
Keep learning anywhere