It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉
You’re a life-saver. I just got a software engineering job because of your SQL videos. I had very little experience with SQL and most of his questions had to do with it. Thank you so much!
Karl, we thought we had written back to you earlier - we were just blown away by your comment and we can't tell you how much it meant to us. Thank you for sharing - it has really inspired us to keep making videos.
@@Socratica You guys are great...I'm having assessment exam on one of the leading MNC and I started watching your videos...... Is the SQL series over or many more videos to come??
For those of you finding it difficult figuring out how to import the 'earthquake' table: 1. in pgAdmin: Tools - Query Tool 2. paste this in the Query Editor: CREATE TABLE public.earthquake ( earthquake_id integer NOT NULL, occurred_on timestamp without time zone, latitude numeric, longitude numeric, depth numeric, magnitude numeric, calculation_method character varying, network_id character varying, place character varying, cause character varying, CONSTRAINT earthquake_pkey PRIMARY KEY (earthquake_id) ) WITH ( OIDS = FALSE ) 3. now execute (F5) 4. right-click the 'earthquake' table 5. use Import (make sure the 'Header' switch is set to 'Yes') 6. how do you like them apples? :-)
Awesome. Thanks Nerdman! Just a note - under the Miscellaneous Section of Import, I had to toggle the HEADER switch from "NO" to "YES to make the import successful.
When trying to import to the table Im getting the error that says ERROR: missing data for column "occurred_on" CONTEXT: COPY earthquake, line 2: "" Any idea how to fix this?
Warning....This channel is addictive!!! I've spent the last 7 years writing sql queries for a living, and I've found myself watching a video about a Select statement, worse, I'm enjoying every second of it 😄👍
When importing be sure to do the following: 1) Create table first as described below by Nerdman 2) Right click the table, select the "Import/Export" option 3) Set Header to "Yes" 4) Set Delimiter to "," I appreciate the video a lot but please include stuff like this for us newbies!
I have struggled with SQL for YEARS, I'm not a "DB S/W Engineer" but just an "ORDINARY S/W Engineer". But just being a "NON DB S/W Engineer" I still had to 're-learn' the basics of SQL over and over. When I'm overwhelmed by ideas in just getting something small to work I tend to FORGET after the project everything SQL'is. This VIDEO like ALL the Socratica Videos on Python and now SQL is 'BRILLIANT"
It's so funny that i'm a chilean guy who is watching and learning this amazing content, i love to learn with this channel, i don't even speak english nice but i have to say that i can understand everything. THANK YOUUU
I heard many classes about sql but was not clear how much you presented it made really easy for many dreamers. Thanks to you will be more if you can start on Java
Love the way you are presenting the material. Very simple, easy to understand and most importantly keeps us engaging and looking for more. Keep these coming. Cheers!!
I think I am in love with ULKA! You are hilarious. You and the whole Socratic, for that matter, create the most amazing content. I am surprised that these are free! You guys are saviours who make the internet (or matrix wink wink..)more beautiful.
I appreciate your way of teaching mam. I became your student from today and I’ll learn from beginner level to professional I’m sure that your videos will make me professional Thanks
I love this channel so much! I was having a hard time understanding this and this video make me feel dumb I understood the basic. The way you explain the video is very engaging and amazing! Thank you again!
I absolutely loved your Python videos. They were and still are a class apart from anything on TH-cam. Now you're doing Postgres videos which is a database I just started learning and I can't be happier to see you again.
Thank you for making this video, i like when you teach with clearly. Now i know i have to follow this youtube to get more about SQL. Thats the greatest video tutorial about SQL that i ever see because in the end i understand what do you talk about. Good job!
For those of you finding it difficult figuring out how to import the 'earthquake' table: 1. in pgAdmin: Tools - Query Tool 2. paste this in the Query Editor: CREATE TABLE public.earthquake ( earthquake_id integer NOT NULL, occurred_on timestamp without time zone, latitude numeric, longitude numeric, depth numeric, magnitude numeric, calculation_method character varying, network_id character varying, place character varying, cause character varying, CONSTRAINT earthquake_pkey PRIMARY KEY (earthquake_id) ) WITH ( OIDS = FALSE ) 3. now execute (F5) 4. right-click the 'earthquake' table 5. Set Header to "Yes" 6) Set Delimiter to "," 7)Import it! And you are good to rock n roll. FYI: To save the csv file, click on 'View raw' , right click and save it as 'earthquake.csv' under all files type or csv if option is available. Thx to @Nerdman and @WarlordSquerk
i love the way you explain without wasting time like others youtubers speak for 1 hour at the end they are not clear one question i have if i want use your csv fille i must create a table based your csv fille right ?
Thank you, I went through an SQL/Azure class in college but learned nothing, continued on with a BI course that expected us to be well versed in SQL. This playlist has taught me more than all my classes combined, in regards to SQL.
This is a reminder from what I learned years ago: SELECT something FROM somewhere WHERE something = something. That's mostly what I remembered. But yes, ORDER BY and LIMIT. And especially LIMIT, since you sort the table you fetch in C# for example in that language, but getting 500 results back and then just picking the first one is a waste of network and processing power.
It's official! The Socratica Python Kickstarter was a success! Thank you to all of our supporters. Because of you, many more Python videos coming soon!! 💜🦉
Yours suppose to use, 'how do you like those apples', for something negative you receive. Thanks for the video.
Hello help
SELECT * FROM friends_of_pickles ORDER BY height_cm LIMIT 2;
Has anyone ever told you,
you sound like a computer?
You’re a life-saver. I just got a software engineering job because of your SQL videos. I had very little experience with SQL and most of his questions had to do with it. Thank you so much!
Karl, we thought we had written back to you earlier - we were just blown away by your comment and we can't tell you how much it meant to us. Thank you for sharing - it has really inspired us to keep making videos.
@@Socratica You guys are great...I'm having assessment exam on one of the leading MNC and I started watching your videos......
Is the SQL series over or many more videos to come??
@@Socratica Hey same here, I'm beggining my first day tomorrow
Niceee Hows the job now?
For those of you finding it difficult figuring out how to import the 'earthquake' table:
1. in pgAdmin: Tools - Query Tool
2. paste this in the Query Editor:
CREATE TABLE public.earthquake
(
earthquake_id integer NOT NULL,
occurred_on timestamp without time zone,
latitude numeric,
longitude numeric,
depth numeric,
magnitude numeric,
calculation_method character varying,
network_id character varying,
place character varying,
cause character varying,
CONSTRAINT earthquake_pkey PRIMARY KEY (earthquake_id)
)
WITH (
OIDS = FALSE
)
3. now execute (F5)
4. right-click the 'earthquake' table
5. use Import (make sure the 'Header' switch is set to 'Yes')
6. how do you like them apples? :-)
Awesome. Thanks Nerdman! Just a note - under the Miscellaneous Section of Import, I had to toggle the HEADER switch from "NO" to "YES to make the import successful.
@@X19-x5f You're welcome! Amended.
Thanks! to bad they didn't show how to do it /sad
and remember to switch to [switch] Not [switch] ;)
thanks a lot！works!
When trying to import to the table Im getting the error that says
ERROR: missing data for column "occurred_on"
CONTEXT: COPY earthquake, line 2: ""
Any idea how to fix this?
Warning....This channel is addictive!!! I've spent the last 7 years writing sql queries for a living, and I've found myself watching a video about a Select statement, worse, I'm enjoying every second of it 😄👍
When importing be sure to do the following:
1) Create table first as described below by Nerdman
2) Right click the table, select the "Import/Export" option
3) Set Header to "Yes"
4) Set Delimiter to ","
I appreciate the video a lot but please include stuff like this for us newbies!
still not working
thanks
thank you so much I was missing the header option
@@snakelings1919You're welcome :)
I have struggled with SQL for YEARS, I'm not a "DB S/W Engineer" but just an "ORDINARY S/W Engineer". But just being a "NON DB S/W Engineer" I still had to 're-learn' the basics of SQL over and over. When I'm overwhelmed by ideas in just getting something small to work I tend to FORGET after the project everything SQL'is.
This VIDEO like ALL the Socratica Videos on Python and now SQL is 'BRILLIANT"
This lady deserves a Nobel prize for being so funny and making the content so interesting
It's so funny that i'm a chilean guy who is watching and learning this amazing content, i love to learn with this channel, i don't even speak english nice but i have to say that i can understand everything. THANK YOUUU
You DID do a great job! :D I'm glad you're still making these videos. Love these.
You just taught in 8 minutes what the google data analytics course teaches in weeks, its fantastic!
Omg. This woman is hilarious. This is by far the most entertaining material on databases I have ever seen.
Do you love Socratica Programming videos? We have a Kickstarter to make 20 Advanced Python Lessons. Support what you love! bit.ly/PythonKickstarter
I always find it interesting how someone on youtube can explain something in 9 minutes what your teacher can't in 4 hours.
These are just awesome tutorials, I can’t learn SQL any other way right now.
I heard many classes about sql but was not clear how much you presented it made really easy for many dreamers. Thanks to you will be more if you can start on Java
Support what you love! bit.ly/PythonKickstarter
Please include a small video of how to import this data to pgadmin too. Nerdman below was life saver this time.
Love the way you are presenting the material. Very simple, easy to understand and most importantly keeps us engaging and looking for more. Keep these coming. Cheers!!
This video not only was super helpful for me but had me actually laughing the whole way through I loved it!
easily explained in 8 minutes what my professor couldn't in an hour.. ez like and subscribe
Gotta love the humor (5:26). I always get a strong GlaDOS vibe from Socratica
you have a very intuitive way of making this video worth watching and at the same time easy to understand. Kudos !
I think I am in love with ULKA! You are hilarious. You and the whole Socratic, for that matter, create the most amazing content. I am surprised that these are free! You guys are saviours who make the internet (or matrix wink wink..)more beautiful.
IDK who you are but you helped me understand this foreign concept. Thank you!
I appreciate your way of teaching mam. I became your student from today and I’ll learn from beginner level to professional I’m sure that your videos will make me professional
Thanks
Amazing tutorial, wonderful, clear, easy to understand, thank you, I subscribed right away!
Socratica is really a FANTASTIC channel, both funny and full of knowledge, I loooove it, thank for the quality of your work !
best channel i have ever found on yt actually. I have been binge-watching of smth, especially in CS. BUT NOW I AM! HAHA
Excellent content and VFX moreover mind blowing presentation...we are blessed to see your whole content for free
I love this channel so much! I was having a hard time understanding this and this video make me feel dumb I understood the basic. The way you explain the video is very engaging and amazing! Thank you again!
I never saw an explanation like this amazing Graphics usage
This series is pure gold.
I have never clicked 'like' faster in my entire life...
Dude, you were supposed to comment first...
Ok, commenting! Good job! Socratia as always explains everything in very light and understandable manner! Keep it up!
Thank you for your kind words!! 💜🦉
I just want to say... I love you! Literally the BEST tutorial channel on youtube.
Learning SQL is fun with your creative yet knowledgeable videos.
Knowledgeable, informative, thorough, and humorous.
I’m going to attempt this sometime this week. You definitely have another subscriber. 😊
These videos are so great and useful. I showed it to my 9-yr old daughter and she liked it too!
This is the best Video for SQL in TH-cam❤️
You guys are just extremely good at explaining complex issues, making them to be easily understood. Thank God, I found you at the right time.❤
Thanks!
You're amazing! Having ADHD and I manage to stay focused til the end... Thanks 🤙😎 1 + sub
Really nice and informative video also funny 😂. Thanks
You are a bad ass, your teaching method is amazing.
Ulka is the best. If she were a lecturer, attendance would be 100%, maybe more.
I absolutely loved your Python videos. They were and still are a class apart from anything on TH-cam. Now you're doing Postgres videos which is a database I just started learning and I can't be happier to see you again.
Thank you for the information you've provided. Very helpful.
Great tutorials! The narrative style is extremely effective. Driven by your ACTION to make a comment!
Thank you for making this video, i like when you teach with clearly. Now i know i have to follow this youtube to get more about SQL.
Thats the greatest video tutorial about SQL that i ever see because in the end i understand what do you talk about.
Good job!
Amazing work. The quality of the material is fantastic.
For those of you finding it difficult figuring out how to import the 'earthquake' table:
1. in pgAdmin: Tools - Query Tool
2. paste this in the Query Editor:
CREATE TABLE public.earthquake
(
earthquake_id integer NOT NULL,
occurred_on timestamp without time zone,
latitude numeric,
longitude numeric,
depth numeric,
magnitude numeric,
calculation_method character varying,
network_id character varying,
place character varying,
cause character varying,
CONSTRAINT earthquake_pkey PRIMARY KEY (earthquake_id)
)
WITH (
OIDS = FALSE
)
3. now execute (F5)
4. right-click the 'earthquake' table
5. Set Header to "Yes"
6) Set Delimiter to ","
7)Import it!
And you are good to rock n roll.
FYI: To save the csv file, click on 'View raw' , right click and save it as 'earthquake.csv' under all files type or csv if option is available.
Thx to @Nerdman and @WarlordSquerk
thanks!
Her explanation and graphics exceed expectations I get it now.
These SQL videos are great, thanks for making them.
I'm already an query expert. I just wanted to hear this woman talk.
I’m in love with this channel.
Ooooh!!! Socratica you make me smarter by the minute... Thanks
I cant believe you don't have more subscribers.
Videos are awesome.
This has really helped me get over a lot of doubt lol
You are simply wonderful. What an excellent way to teach.
Very clear voice.... 👏🏼👏🏼👏🏼...simple explanation.
Thanks
Yours tutorials are the best thanks !
i love the way you explain without wasting time like others youtubers speak for 1 hour at the end they are not clear
one question i have if i want use your csv fille i must create a table based your csv fille right ?
i am bangladeshi ,your tutorials are very beautiful
Your tutorials are awesome!
Just another awesome video that sadly hasn't more views.. Your vid rocks 👍
23.119 thanks to you, Socratica!
So far, SQL looks incredibly easy to use.
This video is fun to watch and learn a lot, keep it up and you made me subscribed, thank you :D
Thank you, I went through an SQL/Azure class in college but learned nothing, continued on with a BI course that expected us to be well versed in SQL. This playlist has taught me more than all my classes combined, in regards to SQL.
I so much appreciate this series. thank you so much
hey! Earthquake #18756 (7:22) was the one that ruined my school xD. Epic SQL course!
Thanks you, it helped me a lot with my subject at college
Socratica is great, Im learning a lot!
Incredible! This helps a lot. Thank you so much!
Your explanation is Wow!!
Clean and easy-to-follow. Thanks!
Yes u did! Amazing content always!
i learned something and i laughed my ass of. thank you, well done!
Very well explained. Thank you
Welcome to a new episode of fun with SQL with Dr Socratica!
Your Videos are amazing, sooo cool great, funny jokes, Gratulations!
Thank you very much for these videos. They are really wonderful.
When I saw your picture on thumbail, I taught its horror movie , before moving my focus towards Database
Great job and animation you are doing
I am inspired by your videos
thank you
Your videos are sooo good! Thankyou so much!
awesome. video! so much info packed into a short video :)
Thank you for this video, i learned a lot again!
Well deserved like! THANK YOU!
I love your videos! Thank you!
very interactive tutorials! Thank you very much.
thiss channel is greatt!!! thankyou so muchh!!
Clear and perfect. BTW, she looks like Donna from Suits lol.
Beautifully done! Thank you!!
Very educating..and entertaining. Thanks!
THAT WAS GOOD
i was lost at first but the end was more repressive
Yeah, I couldn't figure out how to get to 2:15. I appreciate the effort put for making instructions. However, I'm still super lost/confused.
very to the point ... great work .. keep it up ...
Amazing Ulka!
Smart edit! :) keep up the good work
This is a reminder from what I learned years ago: SELECT something FROM somewhere WHERE something = something. That's mostly what I remembered.
But yes, ORDER BY and LIMIT.
And especially LIMIT, since you sort the table you fetch in C# for example in that language, but getting 500 results back and then just picking the first one is a waste of network and processing power.
I love these videos and I love this girl
Good job, Lady and thank you!