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.
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
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.
Hey Prashant, thank you for making this amazing and well-explained video on PostgreSQL. I completed this whole video in 4 days and learned a lot by understanding concepts. Appreciate all your effort. Great job man!! 🥰
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.😊
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.
Sir can I attend interview after this tutorial please reply i have very less knowledge on coding as I am working in support profile for last 7 year's and now I want to switch so please help
@@MPrashantTech thanks a lot for you reply sir currently I am going through the tutorial half of the lecture is finished an I am feeling confident already thank you 🙂😊
@@devanshdubey4588 mai to bolu my SQL say start Karo Mai postgresql say start Kiya phir uskay baad my SQL bhi agya jo bhi seekho ake database sahi say practice Karo phir uskay baad khud samjh jaogau
Thanks for the great video! It's a good refresher on SQL with some PostgreSQL extras. Did you cover the JSON topic? I watched the video but might have missed it. It's a key reason many people are switching to PostgreSQL.
Hi Prashant.. Many thanks for a very good one shot video on PostgreSQL. Need your help as I am unable to locate SQL Shell command line. How to get command line ??
Thanks for the feedback, If you are using windows, for CLI you can even use windows CMD, i have covered this part also.. here ruclips.net/video/cnzka7kF5Zk/видео.htmlsi=Q1RpM6XpFVPpS2TF&t=843
@@MPrashantTech Hi Prashant.. thanks for your reply and appreciate your quick response. Now it is working and I am enjoying learning new things. This is my first attempt to get introduced RDBMS. I am working professional in manufacturing unit and want to make new RDBMS for manufacturing management. May need your help and will get in touch with you, Thanks again.
See both MySQL and PostGres are used in industries, some companies using MySQL and some using Postgres, there is nothing like best. You can pick anyone, but if you learnt One you can easily switch to other SQL.
Hey prashant i watched your video ans it felt like im once again learning the same what i leanrned during MySQL My Question here is what are the things different to be learned in postgresql because i didnt find any difference Can you guide on this?
Sir I have install ubantu virtula VM and using putty to execute the command ,I want connect my postgresql with linux through putty (mai pgAdmin ko DBeaver se connect kiya hu aur esko putty ki through linux m chalana chahta hu) how to do thid sir please help
Prashant Bhai aap ek mongoDB and Redis par detailed video bana dijiye... Kyoki RUclips par bhot saari Videos available hai dusre youtuber ki, but aap jaise samjhate ho waise unka samj nahi aata hai... So, please it's a humble request to you🙏🏻....
@MPrashant TECH you taught us very good, but i have an issue can you tell me, how to Rename column when column name have SPACE in between like this. 'Product Line' ?
11:53 After username, if I'm pressing enter, in the next line password is not coming instead the application is getting closed by itself. What should I do?
Here are some suggestions you can try: 1. Open Command Prompt or PowerShell Manually Instead of using a shortcut that might close the terminal automatically, open a Command Prompt or PowerShell window manually: Press Win + R, type cmd or powershell, and press Enter. Once the terminal is open, try running psql again: psql -U postgres 2. Check if PostgreSQL Service is Running Ensure that the PostgreSQL service is running, as previously mentioned. If the service is not running, you won't be able to connect using psql, and it might be why the terminal closes. 3. Specify the Database Name Sometimes, explicitly specifying the database name might help. Try connecting with: psql -U postgres -d postgres Here, -d postgres specifies the postgres database, which is the default database created during installation. 4. Check Environment Variables Make sure that PostgreSQL's bin directory is included in your system's PATH environment variable. This directory typically looks something like C:\Program Files\PostgreSQL\14\bin. 5. Check for Errors Since the terminal is closing immediately, it might be helpful to redirect any potential error messages to a file to see what's going wrong: psql -U postgres > error_log.txt 2>&1 After running this command, check the error_log.txt file for any error messages that might indicate the issue. 6. Run as Administrator Sometimes running psql with administrative privileges can resolve certain issues. Right-click on the Command Prompt or PowerShell shortcut and choose "Run as administrator," then try connecting again. 7. Reinstall PostgreSQL If none of the above steps work, there might be an issue with your PostgreSQL installation. Consider reinstalling PostgreSQL, ensuring that the installation completes without any errors.
Sir when i import csv file into postgresql then file is not imported due to too many comma in a single column how i import that column with commas in postgre database pls reply whenever you free
Link for the Notes/Slides of this Video - www.canva.com/design/DAGGQI3jsQo/aZYZy0_PSEFsRfFUMNZx2g/edit?DAGGQI3jsQo& Queries www.canva.com/design/DAGHTuBSR90/9uE-LC--W-7nXKBoQKP9Dg/edit?DAGHTuBSR90&
are bhaiyaa har baar dil jitate ho aap
ek hi dil hai kitne baar jitoge❤❤❤❤❤❤
Hope it will be helpful!!
@@MPrashantTech really a good guy. plz keep it up
8😊😊😊@@aryamaan_1
This guy explaining it like we are sitting in front of him in a classroom. Thank you so much sir 😁
Appreciate your feedback!
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.
please guys support him he is best
Appreciated!!
Thank you, sir, for sharing this valuable content. Your teaching style is excellent.❤❤
Glad it was helpful! Appreciate your feedback
Thanks for making this tutorial.
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 ❤
Will try
Sir kindly make detail vedio for Aws Event bridge and Aws Elastic beanstalk or Aws Athena or Aws Api gateway and code family
Watch tech with Nana for docker,AWS and kubernetes
bhai watch bhupinder rajput's aws series , it is worth watching
Yes sir pls 😢@@MPrashantTech
Thanks sir for recording this. It is very simple and helpful ❤️
Most welcome 😊
Thank You, I have watched complete video.
Great 👍
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
It's my pleasure
bro MYSQL VS postgreSQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
very good explanation...totally worth it !!!
Glad you liked it
really amazing tutorial!! Loved it!
Thank you! Cheers!
first lecture 07/07/2024
48:20
second lecture 07/07/2024
1:50:01
third lecture 08/07/2024
2:30:41
fourth lecture 09/07/2024
3:25:40
fifth lecture 10/07/2024
3:54:45 (partially attend this lecture need to revise these concept specially)
sixth lecture
4:47:54 / 4:47:54
finally completed
Good going,
@@MPrashantTech thank your very much sir
The way of explanation easy to understandable. One time you will get idea. Such a great & helpful videos
Glad you think so!
Thank you dada bohut bohut shukriya for this kind of contents 🤗❤ . Love from West Bengal.
Glad you liked it!! ❤️
bro MYSQL VS postgreSQL me best konsa hai for data analytics
Very awesome tutorial. Thanks for making this tutorial.
Glad it was helpful!
bro MYSQL VS postgreSQL me best konsa hai
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
Bhaiya finally aapne iss black subscribe button ko grey krne par majboor kar diya.....
BEST VIDEO REALLY GOOD
Glad you think so!
Amazing thanks a lot !!
No worries!
Wonderful course 👏🏻
Glad you think so!
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.
correct !!
Thanx for the video its very helpful for the real time working 👍👍
Glad to hear that!!
I have Completed this course 🥳🥳 Great Teaching!!
Great job! Appreciate your feedback!
bro MYSQL VS postgreSQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
This is the best video I ever seen ❤ 🔥
Glad to hear that!!
bro MYSQL VS postgreSQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
4:22:52, In Olympics, Rank is based like this only
Hey Prashant, thank you for making this amazing and well-explained video on PostgreSQL. I completed this whole video in 4 days and learned a lot by understanding concepts. Appreciate all your effort. Great job man!! 🥰
Glad it helped!!
Appreciate your feedback!
such a great and helpful video 💖💖💖
Glad you think so!
Thank you sir ❤❤
Most welcome!!
This is one of the basic and very nice video thankyou bro
Welcome 👍
Really appreciatable 👍👍
Thanks for liking
Thanks for this detail video about Postrgresql 😊... please also make detail video on spring boot
As soon as possible
You are brilliant sir ❤sir plzz make a video on power bi
Very soon
Thank you Bhaiya your video really help me specially you mentioned Everything ❤
My pleasure 😊
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.😊
Appreciate your feedback!!
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.
Appreciate your suggestion and feedback!!
bro MYSQL VS postgreSQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
@@devanshdubey4588 Both are good but i am biased toward PostgreSQL
@@devanshdubey4588 poste
Thank you Sir .. Perfect
Welcome!
i have no words to thank you.
2:10:27 meh Raju sharma hai. Table mein Raj sharma hai. Waha par Replace wala use karna padega
good catch
Sir can I attend interview after this tutorial please reply i have very less knowledge on coding as I am working in support profile for last 7 year's and now I want to switch so please help
Ofcourse, this will be very helpful
Easy language, easy examples, covered all major concept with usecase.
@@MPrashantTech thanks a lot for you reply sir currently I am going through the tutorial half of the lecture is finished an I am feeling confident already thank you 🙂😊
I am from Myanmar.Your video is very helpful for me.Plz,plz make video in MongoDB
soon
Hi sir please could you make a video on objection js with postgresql because in RUclips no one explained it
thnx for sharing this informative video
Thanks for liking!!
Awesome
Plz make one video on computer network..
where to practice sql for interviews?
BTW ❤ this video very informative
Leetcode you can practice sql too
To the point.
bro MYSQL VS postgreSQL me best konsa hai for data analytics
thanks sir for your effort
Most Welcome!
NIce Content 🔥🔥
Glad to hear that!!
bro MYSQL VS postgreSQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
Complete ho gaya❤❤
Well Done
bhai ak question he koi sql me 0 knowledge hoga to oo ish seris ko dhkake samajh payega...kindly say.....as soon as possible....
@@pabitramondal6749ha Sikh jaayega tu
Amazing sir
Thanks
Thankyou Sir Ji
Thanks Sir
Welcome!!
Thanks brother isi ka wait tha ❤️❤️👏🏻👏🏻
Hope it will be helpful!!
bro MYSQL VS postgreSQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
@@devanshdubey4588 mai to bolu my SQL say start Karo Mai postgresql say start Kiya phir uskay baad my SQL bhi agya jo bhi seekho ake database sahi say practice Karo phir uskay baad khud samjh jaogau
Thanks for the great video! It's a good refresher on SQL with some PostgreSQL extras. Did you cover the JSON topic? I watched the video but might have missed it. It's a key reason many people are switching to PostgreSQL.
Great suggestion!
Thank you sir, itna acchese toh paid lectures me bhi nai sikhate
Appreciate your feedback!!
I only watched till 14:48 and I want to know what is the difference between sql and postgresSql
SQL is just a language and queries like SELECT, UPDATE
PostgreSQL is a tool(DBMS) which use SQL to manage your data in database.
nice video bhaya..
thanks!!
My first lec 26/7/24....scary mood 😮
2nd 27 😊
3rd 28😅
good going!!
found it very useful. Explained very clearly. Looking for front-end as well, specifically HTML CSS, any such plan ?
if that's still in demand, I can create one.
Done 👍👍👍
awsm
Sir kindly make a detailed Course on AWS 🔥❤
Very soon
@@MPrashantTech Thank you very much sir
At 4:01:41 'IN' is refers to 'Input parameter' not for 'Integer'
thanks for the correction
5:36 In this case:
DBMS = DBMS + DB
=> DB = DBMS - DBMS
=> DB = 0
Hence proved 😉 😂
DB ✖︎
DBMS ✔︎
How to check all column data type in table with use code one to 3 line
Sir Oracle Database administrator ka course laao
Thanks Bro
Welcome!!
Hi Prashant.. Many thanks for a very good one shot video on PostgreSQL. Need your help as I am unable to locate SQL Shell command line. How to get command line ??
Thanks for the feedback,
If you are using windows, for CLI you can even use windows CMD, i have covered this part also.. here
ruclips.net/video/cnzka7kF5Zk/видео.htmlsi=Q1RpM6XpFVPpS2TF&t=843
@@MPrashantTech Hi Prashant.. thanks for your reply and appreciate your quick response. Now it is working and I am enjoying learning new things. This is my first attempt to get introduced RDBMS. I am working professional in manufacturing unit and want to make new RDBMS for manufacturing management. May need your help and will get in touch with you, Thanks again.
Bro this is actually a banger 🍉
bro MYSQL VS postgreSQL me best konsa hai for data analytics
sir can we start career by just learning databases?
There are so many roles based on databases only like data analytics. so yes you can.
Please active translate in parameters of vidéo. Good vidéo
Sir can you explain few projects using PostgreSQL
I will bring videos on project soon.
Waiting @@MPrashantTech
sir, data analytics ke liye best konsa he, mysql yaa postgresql
See both MySQL and PostGres are used in industries, some companies using MySQL and some using Postgres, there is nothing like best.
You can pick anyone, but if you learnt One you can easily switch to other SQL.
Hey prashant i watched your video ans it felt like im once again learning the same what i leanrned during MySQL
My Question here is what are the things different to be learned in postgresql because i didnt find any difference
Can you guide on this?
Right conceptual level, both are same
If you have learn one, it's easy to switch to other
I will try to make a separate video to cover the difference
bro MYSQL VS postgreSQL vs SQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
Sir I have install ubantu virtula VM and using putty to execute the command ,I want connect my postgresql with linux through putty (mai pgAdmin ko DBeaver se connect kiya hu aur esko putty ki through linux m chalana chahta hu) how to do thid sir please help
Great
bro MYSQL VS postgreSQL me best konsa hai for data analytics
bhiya EOL on elephant sql kya or ab seekhna chiye postgres ya nhi
what was the diff Stored Procedure and User Defined Function both look same use . when it use
plz go through the section again, Prcedure doesn't return anything , Its just perform the task & User defined function Returns a Table .
Bhaiya should i watch the mysql tutorial before watching this as i don't know about MySQL
you can directly watch this one, however I will sugget you to first watch MySQL as that video is very detailed
Prashant Bhai aap ek mongoDB and Redis par detailed video bana dijiye... Kyoki RUclips par bhot saari Videos available hai dusre youtuber ki, but aap jaise samjhate ho waise unka samj nahi aata hai... So, please it's a humble request to you🙏🏻....
Okay, coming soon.
@MPrashant TECH you taught us very good, but i have an issue can you tell me, how to Rename column when column name have SPACE in between like this. 'Product Line' ?
Let me try to answer this.
We don't use space but use underscores ( _ ) in between two or three words
Ex. product_line
@@VishwanathSarode Thanks for suggestion, I solved this issue by Python, but if there any trick in SQL to solve it please let me know.
bro MYSQL VS postgreSQL vs SQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
Awesome!!
bro MYSQL VS postgreSQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
post video in english sir..we could not understand Hindi..post english subtitle
Sir pehle plsql se pehle oracle sql sikhna jaroori hai kya ?
hello . i forget my sql shell password, can you how to recover..
01:38:06
It is showing server mode off ?
Sir I request to you
Kindly upload full python tutorial vedeo for data Analytics
Sir I have fully need sir python
Will try
how to connect pg admin with postgres server
11:53
After username, if I'm pressing enter, in the next line password is not coming instead the application is getting closed by itself.
What should I do?
Here are some suggestions you can try:
1. Open Command Prompt or PowerShell Manually
Instead of using a shortcut that might close the terminal automatically, open a Command Prompt or PowerShell window manually:
Press Win + R, type cmd or powershell, and press Enter.
Once the terminal is open, try running psql again:
psql -U postgres
2. Check if PostgreSQL Service is Running
Ensure that the PostgreSQL service is running, as previously mentioned. If the service is not running, you won't be able to connect using psql, and it might be why the terminal closes.
3. Specify the Database Name
Sometimes, explicitly specifying the database name might help. Try connecting with:
psql -U postgres -d postgres
Here, -d postgres specifies the postgres database, which is the default database created during installation.
4. Check Environment Variables
Make sure that PostgreSQL's bin directory is included in your system's PATH environment variable. This directory typically looks something like
C:\Program Files\PostgreSQL\14\bin.
5. Check for Errors
Since the terminal is closing immediately, it might be helpful to redirect any potential error messages to a file to see what's going wrong:
psql -U postgres > error_log.txt 2>&1
After running this command, check the error_log.txt file for any error messages that might indicate the issue.
6. Run as Administrator
Sometimes running psql with administrative privileges can resolve certain issues. Right-click on the Command Prompt or PowerShell shortcut and choose "Run as administrator," then try connecting again.
7. Reinstall PostgreSQL
If none of the above steps work, there might be an issue with your PostgreSQL installation. Consider reinstalling PostgreSQL, ensuring that the installation completes without any errors.
Best
I am unable to input the password into the psql shell terminal, as it does not allow me to enter the password.
pronunciation is wrong VARCHAR
but good course appreciated the efforts
haha, appreciate your feedback!!
Sir when i import csv file into postgresql then file is not imported due to too many comma in a single column how i import that column with commas in postgre database pls reply whenever you free
where is the link of query sheet
Link for the Notes/Slides of this Video - www.canva.com/design/DAGGQI3jsQo/aZYZy0_PSEFsRfFUMNZx2g/edit?DAGGQI3jsQo&
Queries
www.canva.com/design/DAGHTuBSR90/9uE-LC--W-7nXKBoQKP9Dg/edit?DAGHTuBSR90&
I know SQL very well can you tell me what exactly Postgres has different commands and what is different the oracle
bro MYSQL VS postgreSQL me best konsa hai for data analytics , bhut confusion ho rha konsa kru
Bhaiya agar possible ho toh Power BI ka course kara dejiyea na please🙏
Will try soon
Bhaiya ek aisehi course MS Excel pe... please 🥲
okay soon
shell sql command im enable to enter the password . im stucked there