SQL Tutorial for Beginners in Hindi (SQL Full Course) - Great Learning

preview_player
Показать описание

This SQL tutorial will give you a full understanding of SQL in Hindi. You will learn about various SQL commands, how to use them, and how to apply them to real-world scenarios. By the end of this tutorial, you will be able to confidently work with databases and manipulate data using SQL.
SQL is abbreviated as Standard Query Language. SQL is a Query language that lets you store, access, and update data in the database, and it also helps create a new database and implement functions. Knowledge of SQL is a step toward becoming a software developer.

Great Learning’s SQL Tutorial for beginner Hindi helps you master vital foundations and advanced SQL topics that would help the learner manage and administer the MYSQL database.
You will learn the powerful Structured Query Language (SQL) to build and manipulate the database by acquiring knowledge on intrinsic topics like DBMS, DDL, DBML, SQL operators, etc. You will also learn the administration skills required to manage the database.

🏁 Topics Covered:
00:00:00 - Agenda
00:01:18 - Introduction to DBMS & SQL
00:03:55 - Types of Data Models
00:09:09 - ER Diagram
00:09:39 - What is DBMS
00:14:17 - Introduction to RDBMS
00:16:14 - Features of RDBMS
00:18:30 - RDBMS vs Traditional Approach
00:19:10 - Normalization Subsets of Normalization
00:22:28 - Functional Dependency
00:25:42 - Types of Functional Dependency
00:27:55 - First Normal Form 1NF
00:30:20 - Second Normal Form 2NF
00:33:14 - Third normal form 3NF
00:34:44 - What is SQL?
00:36:06 - Why SQL?
00:36:54 - SQL Terms
00:37:48 - SQL Data Types
00:39:38 - SQL Constraints
00:42:50 - SQL Command Groups
00:43:06 - DDL
00:55:39 - DML
01:05:42 - DCL
01:05:45 - TCL
01:09:53 - SQL Operators
01:35:38 - SQL Functions
01:51:12 - SQL Joins
02:30:15 - Lab Session

Free SQL Courses With Free Certificates:

Here is a list of our other full course videos you can check out:

#sql #sqltutorial #sqlfullcourse #sqlforbeginners #sqltraining #GreatLearning
Рекомендации по теме
Комментарии
Автор

🔹 Topics Covered:
00:00:00 - Agenda
00:01:18 - Introduction to DBMS & SQL
00:03:55 - Types of Data Models
00:09:09 - ER Diagram
00:09:39 - What is DBMS
00:14:17 - Introduction to RDBMS
00:16:14 - Features of RDBMS
00:18:30 - RDBMS vs Traditional Approach
00:19:10 - Normalization Subsets of Normalization
00:22:28 - Functional Dependency
00:25:42 - Types of Functional Dependency
00:27:55 - First Normal Form 1NF
00:30:20 - Second Normal Form 2NF
00:33:14 - Third ormal form 3NF
00:34:44 - What is SQL?
00:36:06 - Why SQL?
00:36:54 - SQL Terms
00:37:48 - SQL Data Types
00:39:38 - SQL Constraints
00:42:50 - SQL Command Groups
00:43:06 - DDL
00:55:39 - DML
01:05:42 - DCL
01:05:45 - TCL
01:09:53 - SQL Operators
01:35:38 - SQL Functions
01:51:12 - SQL Joins
02:30:15 - Lab Session

greatlearning
Автор

My family is not financially strong. Fee courses for advanced computer languages are therefore not affordable. In this case your YouTube videos are a blessing. Please upload more such courses here. And a big thanks for explaining in hindi

joyeetachakraborty
Автор

विश्वास नही होता, sql tutorial हिंदी में, कोई तो है जो हिंदीभाषियों के बारे में भी सोचता है, हृदय से धन्यवाद

sameermalik
Автор

I am a Ruby on Rails developer and this course is very helpful for improving my SQL skills and I can easily relate to Rails databases.

siddhantsinha
Автор

🔹 Topics Covered:
00:00:00 - Agenda
00:01:18 - Introduction to DBMS & SQL
00:03:55 - Types of Data Models
00:09:09 - ER Diagram
00:09:39 - What is DBMS
00:14:17 - Introduction to RDBMS
00:16:14 - Features of RDBMS
00:18:30 - RDBMS vs Traditional Approach
00:19:10 - Normalization Subsets of Normalization
00:22:28 - Functional Dependency
00:25:42 - Types of Functional Dependency
00:27:55 - First Normal Form 1NF
00:30:20 - Second Normal Form 2NF
00:33:14 - Third ormal form 3NF
00:34:44 - What is SQL?
00:36:06 - Why SQL?
00:36:54 - SQL Terms
00:37:48 - SQL Data Types
00:39:38 - SQL Constraints
00:42:50 - SQL Command Groups
00:43:06 - DDL
00:55:39 - DML
01:05:42 - DCL
01:05:45 - TCL
01:09:53 - SQL Operators
01:35:38 - SQL Functions
01:51:12 - SQL Joins
02:30:15 - Lab Session

parth
Автор

Are bhaiya bhut bhut dhyanwaad, apne bharat mai sab angrez bne pde h... Are bhaiya insaan sabse best learning apni bhasha mai hi seekh paata h aache se

amazonshoppingstore
Автор

1:1:00 we don't need to enter the column name again and again once we create a table we can only use INSERT INTO Employees VALUE ( value, value, value );

Amanansari
Автор

Fantastic Job Sir
This 3 hours course is awesome for those students who are preparing for interviews.

AmitSharma-kdrj
Автор

At 1:35:08 - Group by clause, you have entered first name, max salary, dept from table group by dept.
1. For SALES we have JIMMY with max salary but the command returns JENNIFER.
2. For TECH we have MATT with max salary but the command returns CHARLIE.

Please check and let me know the correct command.

ankitkhurana
Автор

00:05 Learn SQL for data management.
02:31 Importance of a database in managing company data
07:24 Understanding relational data and graph base model in SQL
09:55 Database management system is essential for storing, managing, and retrieving data.
14:39 Relational data stored in tables with rows and columns
17:08 Understanding the importance of employee IDs for uniqueness in tables.
21:31 Understanding data modification and normalization in SQL
23:51 Understanding functional dependencies in SQL.
28:26 Normalization of data in SQL
30:40 Understanding partial dependency and decomposing tables
35:05 Introduction to SQL and its importance in database management
37:15 Introduction to RDBMS and Database Management Systems
41:51 Primary keys ensure uniqueness and identification in SQL databases.
44:01 Creating a table and altering the structure using SQL commands.
48:28 Creating and describing a table in SQL
50:38 Explaining the process of modifying and renaming columns in SQL.
56:16 SQL allows manipulation of data using commands like INSERT, UPDATE, and DELETE.
58:30 SQL basics for beginners in Hindi
1:04:29 Understanding and using delete commands in SQL
1:06:55 Understanding privileges and data control in SQL
1:11:24 Using logical operators to filter data in SQL.
1:13:57 Using SQL operators and conditions for data extraction.
1:18:57 Using comparison operators in SQL
1:21:31 Comparison operators and special operators in SQL
1:27:18 Understanding SQL numerical operations and functions
1:30:05 Using group by clause to group and update data in SQL.
1:35:09 Understanding GROUP BY clause in SQL
1:37:30 SQL query syntax for filtering and ordering data
1:42:12 Creating a table and using union operator in SQL
1:44:32 Creating and managing tables and records in SQL
1:50:54 Explanation of inner join in SQL
1:53:06 SQL join types and their usage
1:57:39 Creating and managing departments and their operations using SQL
2:00:34 How to perform extras in SQL queries
2:05:33 Illustrating SQL commands and joins
2:08:13 Understanding SQL table creation and data import
2:12:27 Using select and union operators in SQL with subquery
2:14:52 How to write queries for selecting specific data in SQL
2:20:12 Select players from match one with common player id in sms2
2:22:48 Select and from cricket players. Use like operator to extract names.
2:27:57 Using SQL commands to make changes in the database.
2:30:37 Creating tables and defining columns in SQL databases
2:35:00 The tutorial covers inserting data into tables and selecting data from tables
2:37:28 Exploring arm joint and database management
2:43:37 Modifying and manipulating tables and data in SQL
2:46:17 Creating and managing tables in SQL
2:52:51 Updating time in SQL for different time zones
2:56:34 SQL select statements and limits introduction

KrishnaSharma-lfjl
Автор

It is very useful content for everyone beginners. I have tried before multiple time learn SQL but didn't get but I saw your concept . it is very helpful. Thank you so much sir you are providing free leaning for everyone.

jyotisingh
Автор

1:35:30 - Group by clause showing wrong output, it shows max of salary by dept not by first name... the select query just fetching the first name

learnmorewithparas
Автор

SIr, this is the best video, I came across, Tomorrow I'm having interview....this has boosted my confidence. THANKS A TON, Sir :)

omialsovlogs
Автор

Indians are freaking intelligent people. And the way you guys teach is Nobel work for all of us. Thank you, from pakistan.

naib
Автор

Your videos are Awesome Sir. Just a note that there is one error at "1:35:09", This SQL query is wrong as When using the GROUP BY clause in an SQL query, any non-aggregated columns in the SELECT clause must be included in the GROUP BY clause. So in this we cannot use non-aggregate column (first_name) with SELECT clause. and same error at 1:38:35 in HAVING clause as well.

manaligoyal
Автор

Meko sql ka zero knowledge tha aapke video ki wjh se hi mai sql smjh paya aur query likhne lga thnks great learning ❤

shyariofr.k
Автор

You cleared so much up for me that I was confused about. Thanks a million!.... Plz show us Informatica in hindi too.

cymons
Автор

Government Shiksha ko free nhi kr rhi h but great Youtuber h jo free me content de rhe h study k liye, I hope Studdy/Shiksha Sabko mil payegi... with Acuracy and Quality, isse hmare Country Rapidly Progress krega.. Waise Ghenhu Chawal(Anaaj) free h UP me but ye Sawal paida nhi krti h jabki Shiksha Sawaal paida krti h learner k mind me gov se ask krne k liye.

pkpk
Автор

No .of Subscribers not show utuber capacity, hardwork.... Wonderfull 💯

Vv-xtrz
Автор

I never thought dbms can be this much easy, thankyou sir for your efforts😃

gouravraghuwanshi