Master POSTGRESQL in ONE VIDEO: Beginner to Advanced Course For Beginners in Hindi | MPrashant

@MPrashant #postgres #postgresql #sql

PostGreSQL FULL COURSE
PostGreSQL COURSE IN HINDI
PostGreSQL FOR BEGINNERS
PostGreSQL Tutorial in Hindi
POSTGRES In Hindi
SQL in Hindi
Complete SQL Course for Beginners

Queries- TaskDB

Want to learn PostGreSQL but don't know where to start? Then this is the video for you! In this beginner to advanced PostGreSQL course, you'll learn everything you need to know to start using PostGreSQL from the ground up.

From beginner basics to more advanced features, this video will teach you everything you need to get started with PostGreSQL. By the end of this course, you'll be able to use PostGreSQL to create, manage, and query databases with ease. So whether you're a beginner or an expert, this video is a great way to get started with PostGreSQL!

Topics and Timeline

00:00 Introduction to PostGreSQL Course
02:25 What is database?
04:00 Database vs DBMS
06:32 What is RDBMS?
08:36 Postgres Installation on Windows
15:36 Postgres Installation on MAC
20:40 Postgres Installation on Linux
25:40 Database vs Schema vs Table
27:33 Section 1 - Database and CRUD
27:56 Database Create, DROP, List & Switch
34:35 What is CRUD
36:23 CREATE Table
39:43 INSERT Data
43:52 READING (SELECT)
45:21 UPDATING
48:16 DELETE
51:22 Section 3 - Datatypes and Contraint
52:00 Datatypes
59:39 Constraint
57:00 Primary Key
58:13 NOT NULL and Default
01:01:04 Task1 Create a Employee Table
01:17:15 Data Refining - WHERE, ORDER BY, DISTINCT, LIMIT, LIKE
01:25:25 Operators - Relational and Logical
01:38:56 Aggregate Functions - Count, Min, Max, Avg etc
01:43:19 GROUP BY
01:49:59 String Functions - Concat, Replace, Substr etc
02:17:19 Exercises
02:22:45 ALTER Query - Modify Table
02:30:46 CHECK Constraint
02:37:23 CASE Expression
02:46:41 Relationship and its type
02:54:48 Foreign Key
02:55:49 One to One Relationship Example
03:00:41 JOINS and its types
03:12:25 MANY to MANY Relationship Example
03:25:42 Project of E-STORE
03:45:05 VIEWS
03:48:57 HAVING Clause
03:54:00 Stored Procedure
04:03:05 User Defined Function
04:13:39 WINDOW Functions
04:27:06 CTE (Common Table Expressioon)
04:39:34 TRIGGERS

PostGreSQL tutorial in Hindi
Learn PostGreSQL in Hindi
PostGreSQL for beginners Hindi
Advanced PostGreSQL Hindi
PostGreSQL database course Hindi
PostGreSQL programming in Hindi
PostGreSQL training videos Hindi
Hindi PostGreSQL lessons
PostGreSQL full course in Hindi
PostGreSQL in Hindi for beginners
PostGreSQL database tutorial Hindi
Hindi PostGreSQL database guide
SQL in Hindi
PostGreSQL query tutorial Hindi
PostGreSQL video series Hindi
PostGreSQL basics in Hindi
PostGreSQL advanced concepts Hindi
PostGreSQL Hindi lectures
PostGreSQL practical tutorial Hindi
PostGreSQL Hindi tutorial for beginners
PostGreSQL step by step tutorial Hindi
Complete PostGreSQL guide in Hindi
SQL database course in Hindi
PostGreSQL hands-on training Hindi
PostGreSQL Hindi explanation

sql for beginners,
SQL Full Course in Hindi,
sql basics for beginners,
sql tutorial for beginners,
learn sql for beginners,
free sql course,
sql crash course,
sql full course,
sql tutorial for beginners in hindi,
sql in hindi,
sql server full course,
sql learning for beginners,
how to learn sql for beginners,
sql beginners,
sql programming for beginners,
sql queries,
learn sql in 1 hour,
how to learn sql,
learn sql,
what is sql,
sql course in hindi,
sql interview

[Ankit_Chopade]

are bhaiyaa har baar dil jitate ho aap
ek hi dil hai kitne baar jitoge❤❤❤❤❤❤

[iamakashkumarram]

Sir kindly make a detailed Course on AWS because AWS ke upar ekbhi achi videos nahi ha youtube pe. So please make a detailed Course on AWS ❤

[Shivamyadav-rpeh]

00:01 Learn Postgresql from basics to advanced level in a simple manner
02:20 Importance of organizing and accessing data in a database
07:11 Postgres SQL installation process is simple
10:20 Introducing PG Admin for PostgreSQL management.
14:31 Setting up PostgreSQL environment variables and installation process
16:57 Installation process and accessing the PG Admin dashboard
20:37 Setting up Postgresql on Linux
23:22 Executing PostgreSQL commands as a user
27:40 Covering basic database management and operation
29:36 Creating and using a database in PostgreSQL
33:35 Managing databases and basic operations in PostgreSQL
35:31 Learn how to create a database table
39:38 Storing data using INSERT query
41:40 Insert multiple data using the insert query
45:59 Updating data in PostgreSQL tables using UPDATE query.
48:00 Avoid using generic or duplicate names
52:14 Understanding data types and their usage.
54:24 Understanding decimal numbers and their precision in PostgreSQL.
59:14 Setting default values and auto increment in PostgreSQL
1:01:17 Creating a table in PostgreSQL with specific column and data type requirements.
1:05:10 Creating a new database and table in PostgreSQL using PG Admin
1:07:32 Learn about PostgreSQL query execution and table structure.
1:11:32 Automatically assigning employee ID using default or starting from the backend
1:13:23 Explaining setting default values in sequences
1:17:10 Using SQL clauses and practical examples
1:19:06 Using WHERE clause to fetch specific data from a table.
1:23:31 Using AND operator in PostgreSQL for multiple conditions.
1:25:53 Understanding logical operators and conditions in PostgreSQL
1:30:26 Extracting unique values using Distinct and sorting data using Order By
1:32:28 Using ORDER BY and LIMIT in PostgreSQL for sorting and limiting results
1:36:21 Finding names with specific characters in specific positions
1:38:24 Introduction to Aggregate Functions in PostgreSQL
1:42:19 Understanding Aggregate Functions and Group By in Postgresql
1:44:25 Understanding the usage of GROUP BY in SQL for data grouping.
1:48:17 Introduction to grouping and counting in PostgreSQL
1:50:19 Important string functions in PostgreSQL
1:54:53 Explaining how to apply separators and formats in PostgreSQL
1:57:02 Extracting and replacing text in PostgreSQL
2:01:21 How to find the length of a word and manipulate strings in PostgreSQL
2:03:33 Manipulating characters in PostgreSQL for beginners
2:07:40 Learning to use separators in PostgreSQL queries
2:09:54 Working with functions and combining data in PostgreSQL
2:14:21 Using left function to get the first character of a department
2:16:30 Using count and group by functions in PostgreSQL queries.
2:21:01 Understanding subqueries and using ALTER query to modify table structure
2:23:12 Adding and removing columns in PostgreSQL tables
2:27:23 You can modify table names and columns in PostgreSQL.
2:29:29 Setting default values and constraints in PostgreSQL tables
2:33:44 Understanding constraints in PostgreSQL
2:35:47 Understanding constraints for mobile number validation
2:39:53 Adding a new salary category based on salary ranges
2:42:03 Calculating bonus based on salary amount
2:46:07 Understanding salary categories and groupings.
2:48:15 Understanding different types of relationships in PostgreSQL
2:52:36 Organizing data in tables for efficient structure
2:54:54 Understanding Primary and Foreign Keys in PostgreSQL
2:58:46 Exploring the process of inserting data into customer and order tables in PostgreSQL.
3:00:40 Learning about joining tables in PostgreSQL
3:04:52 Understanding inner join and group by in PostgreSQL
3:07:21 Introduction to grouping and counting in PostgreSQL
3:11:33 Understanding one-to-many and many-to-many relationships in POSTGRESQL
3:13:31 Creating a third table for many-to-many relationship
3:17:33 Combining data using INNER JOIN in POSTGRESQL
3:19:32 Joining students with courses using PostgreSQL.
3:23:50 Understanding PostgreSQL queries and table joins.
3:25:55 Create and manage data sets with advanced concepts
3:29:44 Creating and managing multiple tables in PostgreSQL
3:31:41 Ordering and inserting data in PostgreSQL
3:36:01 Connecting order items to the product table using SQL
3:38:14 Order processing and data joining in SQL
3:42:49 Summarizing the process of calculating total billing
4:12:46 Learn PostgreSQL from beginner to advanced level in Hindi
Crafted by Merlin AI.

[SandeepJirge]

The way of explanation easy to understandable. One time you will get idea. Such a great & helpful videos

[techwolves]

Thank You, I have watched complete video.

[SurajSinghal-xm]

Bhaiya finally aapne iss black subscribe button ko grey krne par majboor kar

[ndroidLover]

Hi Prashant, first of all a huge thanks for creating wonderful playlist on MySQl and one shot video on PostgreSQL. A humble request to create one shot video on Python and Power Bi (from begineer to advanced). Also best of luck for your future journey and keep creating such informative videos.

[biprajitdutta]

Thank you dada bohut bohut shukriya for this kind of contents 🤗❤ . Love from West Bengal.

[ashadhanwal]

A lots of thank you!! Sir
Aap really bahut achhe method ke sath padhate hai really I am very happy for watching your tutorial sir

[AayushBartaula]

This is one of the basic and very nice video thankyou bro

[BKYADAV-zmyv]

I know m writing unprofessionally but it's true sala mprashant sir ka video dekhne k baad koi doubt hi nhi rhta and no more video need to watch dil krta hai jo bhi search kru mujhe mprashant sir ka hi video mile .Thank you sir love you from bhadohi district

[rahulagre]

Great video….just one suggestion, kindly adjust the sound to mono coz while using earphones the sound is more concentrated on left earpiece….otherwise this was really a banger video overall.😊

[AnuragSharma-bgbn]

very good explanation...totally worth it !!!

[ArunChaudhary-kdgq]

Very awesome tutorial. Thanks for making this tutorial.

[not_a_userz]

where to practice sql for interviews?
BTW ❤ this video very informative

[TaufikKhatik-pn]

I have Completed this course 🥳🥳 Great Teaching!!

[rahulkoli]

Thanx for the video its very helpful for the real time working 👍👍

[shivani]

Thanks for this detail video about Postrgresql 😊... please also make detail video on spring boot

[iamakashkumarram]

This is the best video I ever seen ❤ 🔥

[arnabsamanta]

SELECT setval('employees_emp_id_seq', (SELECT MAX(emp_id) FROM employees));

we need to use this command after a failed insert you should have mentioned it because the counter of emp_id is getting incremented after a failed insert.