Thanks, Learning SQL at the moment and I’m using postgresql and this was really helpful. Some more sql, excel and other data analysis tools tutorials will be helpful
@@franccaroline4873 Thanks for the idea! I've never used Duck DB but i think it will be interesting to learn more about! I will take a look at the documentation in the near future.
Hello! SSMS is similar to Postgresql or pgAdmin which is the database management system for Postgresql. And the data does typically need to be a CSV/text or binary for importing into the database. Thanks for the comment!
To still import it in this way, I would recommend using Excel to format the column names and data types in a separate file to copy them into the Query! Thanks for the comment!
I believe this would happen if a JOIN can't find matching values in the tables, or if a column has NULL values. Maybe try to do something like [ UPDATE table_name SET column_name = 'some value' WHERE column_name IS NULL; ] and retry executing the query. Let me know how you go about fixing the error! Thanks for the comment!
@@ExcelHelps well idk but still face the issue? can you please tell me whats wrong and how to correct it in this dataset : drive.google.com/file/d/1sn_kc312omvWv2_QBMaWmYV0ulRMJCdA/view?usp=sharing
I always got this error: ERROR: invalid byte sequence for encoding "UTF8": 0xed 0x70 0x75 Even when I change the encoding to WIN1250 (which is the encoding my Excel file has) Any suggestions anyone?
I've realised what's the problem, i'll write it down if somebody has the same problem in the future: You have to change the encoding of the database itself as well (which is UTF8 by default), selecting the encoding only in the Import/Export panel won't be enough.
Hello, thanks for video 😊, I have an commas on my voters table like 38,333 . And i tried to import it but it doesn't worked. It's giving syntax error and i have description table which has more words and this one also giving error. Can you help me please, how should i create these column properly ?
Hello! Saving the file as a Text(tab delimited file) can help with avoiding the unwanted comma separation. And for the description you can create a varchar() data type with more characters allowed such as varchar(150) or varchar(200). Thanks for the comment!
Thanks, Learning SQL at the moment and I’m using postgresql and this was really helpful. Some more sql, excel and other data analysis tools tutorials will be helpful
Learnt more of use from this than in about 3 hours of a Udemy 'course'!! Excellent and thanks!!
The simple and clearly. Thank you
This was exactly what I needed thanks!!!
Thank you. This really helped.
Thou I had challenges with the character length… but it’s fixed now.
Love you man!
thanks buddy!
keep it up
thanks for the knowledge
What other SQL & Or database concepts would you be interested in seeing?
Duck db, I honestly don’t know how to use it.
@@franccaroline4873 Thanks for the idea! I've never used Duck DB but i think it will be interesting to learn more about! I will take a look at the documentation in the near future.
@@ExcelHelps Alright
Big query tutorial too..also Data Lake or other data warehouse..thanks
whats the difference with ssms and postgresql also is it needed to be a CSV when you import it to postgres?
Hello! SSMS is similar to Postgresql or pgAdmin which is the database management system for Postgresql. And the data does typically need to be a CSV/text or binary for importing into the database. Thanks for the comment!
how can i import the file with the columns my dataset have 36 columns and its tiring writing it down
To still import it in this way, I would recommend using Excel to format the column names and data types in a separate file to copy them into the Query! Thanks for the comment!
can you help me with this type of error : missing values in particular column type???
I believe this would happen if a JOIN can't find matching values in the tables, or if a column has NULL values. Maybe try to do something like [ UPDATE table_name SET column_name = 'some value' WHERE column_name IS NULL; ] and retry executing the query. Let me know how you go about fixing the error! Thanks for the comment!
If is from a JOIN then it could be that the JOIN is not compatible with the two Tables/Columns selected.
@@ExcelHelps well idk but still face the issue?
can you please tell me whats wrong and how to correct it in this dataset : drive.google.com/file/d/1sn_kc312omvWv2_QBMaWmYV0ulRMJCdA/view?usp=sharing
I always got this error: ERROR: invalid byte sequence for encoding "UTF8": 0xed 0x70 0x75
Even when I change the encoding to WIN1250 (which is the encoding my Excel file has)
Any suggestions anyone?
I've realised what's the problem, i'll write it down if somebody has the same problem in the future:
You have to change the encoding of the database itself as well (which is UTF8 by default), selecting the encoding only in the Import/Export panel won't be enough.
Hello, thanks for video 😊,
I have an commas on my voters table like 38,333 .
And i tried to import it but it doesn't worked. It's giving syntax error and i have description table which has more words and this one also giving error.
Can you help me please, how should i create these column properly ?
Hello! Saving the file as a Text(tab delimited file) can help with avoiding the unwanted comma separation. And for the description you can create a varchar() data type with more characters allowed such as varchar(150) or varchar(200). Thanks for the comment!
@@ExcelHelps Thanks !
Thanku so much
Hey! What can I do when I got accents in names in the csv's?
Hey Christopher! VARCHAR allows different types of characters to be used.
Thank you
Thanks