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!! 💜🦉
I took a SQL class 2 yrs ago and sadly forgot many things that I learned. Right now I'm in a PL/SQL class and seeing these videos is the refresher that i needed! Keep up the great work : )
Loving her execution of information. She cracks me up! I'm learning, not only the syntax, but also the application. Keep it up, awesomeness. Always looking forward to your videos. /Hi from Seattle
Absolutely fantastic video. I don’t think I’ll find a better explanation of basic SQL clauses that is this informative yet brief. Thank you thank you thank you 🙏🏼
was there on the vacation (Thailand tsunami at the 9.1 earthquakes off the west coast of northern Sumatra ) at the tsunami. life changing besides the fact i only was 7 years old great video btw
Verywell Presented. Would have been better if you would have shown how to import Earthquake csv in to PGAdmin. However successfully imported. All videos are very informative. Stiil watching the remaining one.
Just a thought, for the query for finding the most recent nuclear explosion (before 5:55), shouldn't you have as the where clause: WHERE cause = ''nuclear explosion' OR 'explosion' Given you said the explosion results were actually caused by nukes?
You are correct, in that using OR is a way to get the desired results but I think this was more used as an example to show that you're results will only be as good as the data you're working with. Whoever created the data should have had the 4 rows as Nuclear Explosion instead of Explosion so in a sense, they were incorrectly classified. If you already knew how many results you should have by using the search to return for Nuclear Explosion, you would think something was wrong because you would be 4 rows short. Maybe a lesson in not trusting the data itself.
In the question at 6 minute mark, what were 10 largest earthquakes from 1969 - 2018?, why don't we write a line to filter the dates between '1969-01-01' to '2018-12-31'?
select count(*) from earthquakes where place like '%Honshu%Japan%' and occurred_on between '2011-03-11'::date and '2011-03-17'::date; here using the datatype date returns 166 while if the query is changed to between the 11th and 18th it returns 168, illustrating discrepancy in how different datatypes work.
Just a question, this person is real yes? She moves and looks so perfect I first thought she might be some artificial very perfect rendered TTS bot. This is meant as a compliment
"""List of questions/queries: Q1: How many rows and columns are in the 'earthquake' table? Q2: What is timespan covered by the table? Q3: What magnitude range is covered by the table? DATA SUMMARY Table: earthquake SHAPE: Columns: 10 Rows: 23119 RANGES: Magnitude: 5.5 - 9.1 Dates: 1969-2018 Q4: What causes the earthquakes? Q5: How many earthquakes caused by every cause? Q6: Find the most recent earthquake caused by nuclear explosion. Q7: What were the 10 largest earthquakes from 1969 to 2018? Q8: Count the number of aftershocks for earthquake near cost of Honshu, Japan. """
@@cbraspen The previous video of soratica just taught us how to install pgAdmin4 and launch the server locally. In the description of this video we are provided with the csv on Github. I don't think there is a right issue with earthquake data since the channel makes it public on github.
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!! 💜🦉
Can't wait!
I’m an international student. You video not only help me to understand my assignment, but also teaches me English. Really appreciate it!
Oh my god i love her and shes back yesssssssss
Seeing a new Socratica video is my favorite way to start the day
This video series is fantastic. Probably the best at teaching about postgresql.
This is the best SQL learning series I have seen
I took a SQL class 2 yrs ago and sadly forgot many things that I learned. Right now I'm in a PL/SQL class and seeing these videos is the refresher that i needed! Keep up the great work : )
You don´t have the slightest idea of how much your videos helped me on my career. Thank you so much!
Loving her execution of information. She cracks me up! I'm learning, not only the syntax, but also the application. Keep it up, awesomeness. Always looking forward to your videos. /Hi from Seattle
BEST SQL COURSE EVER I love it! Thank you guys!!!
Absolutely fantastic video. I don’t think I’ll find a better explanation of basic SQL clauses that is this informative yet brief. Thank you thank you thank you 🙏🏼
You guys are awesome! Love the way you teach by citing relevant examples that pique our curiosity.
I never knew querying a database could be so interesting !
Thank you so much for making these videos. You explain every topic in a very interesting manner.
wonderful explanation mam , thanks ....
your teaching method really created my interest in SQL
was there on the vacation (Thailand tsunami at the 9.1 earthquakes off the west coast of northern Sumatra ) at the tsunami. life changing besides the fact i only was 7 years old
great video btw
How terrifying. Glad you are still with us.
I absolutely LOVE these videos. Such a good job.
this is so comforting, thank you sooooo much
Do you love Socratica Programming videos? We have a Kickstarter to make 20 Advanced Python Lessons. Support what you love! bit.ly/PythonKickstarter
Great video, and I appreciate the puns/humor.
Thank you! Sending love from Poland
Found you just Last week. Can't look at other training videos now.
Super useful and clearly presented 😊
we crave for the concise one-by one explanation. thank you very much
These are the best videos about it ever made
I love you, so grateful right now.
Please add some more videos on basics. The content and presentation is very good. I like the videos. Thanks
She explains so clear. 😍🥰😘😍😍😍😍😀
so much good information at the same time as being interesting and funny!
Such a great session
Please do insert and remove next!
Looking forward to the Join statements video
i think i love this girl, she's amazing LOL
it's very utility. Thank you Socratica
Awesome video, Thanks
and again this is fire!
And I'm so jealous to share your videos with friends, and you know why 😁 :)
Verywell Presented. Would have been better if you would have shown how to import Earthquake csv in to PGAdmin. However successfully imported. All videos are very informative. Stiil watching the remaining one.
Again, quick, short, clear...
Just a thought, for the query for finding the most recent nuclear explosion (before 5:55), shouldn't you have as the where clause:
WHERE cause = ''nuclear explosion' OR 'explosion'
Given you said the explosion results were actually caused by nukes?
You are correct, in that using OR is a way to get the desired results but I think this was more used as an example to show that you're results will only be as good as the data you're working with. Whoever created the data should have had the 4 rows as Nuclear Explosion instead of Explosion so in a sense, they were incorrectly classified. If you already knew how many results you should have by using the search to return for Nuclear Explosion, you would think something was wrong because you would be 4 rows short. Maybe a lesson in not trusting the data itself.
Great video!
5:18 "Example illustrates *common problem* with, How people can confuse, I mean yes Data Base!"
When i watch your video i feel like Starcraft terran computer teaching me something.
Fabulous! Thanks!
Like before watching the video)))
Loved it 😍
How did you upload Earthquake table onto PGadmin?
Her voice sounds like introduction video in Need For Speed games
The last stance, lol priceless
sql my new favourite
Thank you 💜🦉
How did you count the number of columns?
this is fun:
look at this...place...ups
select *
from earthquakes
where cause='nuclear explosion'
order by magnitude desc
;
Please make more videos on DBMS
Isn’t she awesome teacher
shes a nut case for making these vids. I appreciate it though
Thank you so much
Thank you vrey much.
In the question at 6 minute mark, what were 10 largest earthquakes from 1969 - 2018?, why don't we write a line to filter the dates between '1969-01-01' to '2018-12-31'?
@3:57 "Houston we have a problem"...and I thought that phrase was applicable only for astronauts/cosmonauts and not in an earthquake situation
Thanks
So good
select count(*) from earthquakes where place like '%Honshu%Japan%' and occurred_on between '2011-03-11'::date and '2011-03-17'::date;
here using the datatype date returns 166
while if the query is changed to between the 11th and 18th it returns 168, illustrating discrepancy in how different datatypes work.
It was very helpful but plz make a video about pgAdmin.
Ulka Simone is so funny in this videos.
i like her magic smile
WHY ARE YOU NOT FAMOUS. sorry i was writing sql along.
It's like watching a movie 🍿
Just a question, this person is real yes? She moves and looks so perfect I first thought she might be some artificial very perfect rendered TTS bot. This is meant as a compliment
beautiful
"""List of questions/queries:
Q1: How many rows and columns are in the 'earthquake' table?
Q2: What is timespan covered by the table?
Q3: What magnitude range is covered by the table?
DATA SUMMARY
Table: earthquake
SHAPE:
Columns: 10
Rows: 23119
RANGES:
Magnitude: 5.5 - 9.1
Dates: 1969-2018
Q4: What causes the earthquakes?
Q5: How many earthquakes caused by every cause?
Q6: Find the most recent earthquake caused by nuclear explosion.
Q7: What were the 10 largest earthquakes from 1969 to 2018?
Q8: Count the number of aftershocks for earthquake near cost of Honshu, Japan.
"""
I wish I could look so happy as she does, no matter what's going on.
Thank you
Mass Effect soundtrack?
how to calculate count of columns if it has large amount of columns??7
9.1 magnitude god I hope to never be in something that intense
that smile
Eagerly waiting for the joints
yay!!!!!!
select statements never looked sexier :D
whoever put 2069...ily
Is this chick a Robot? Or a simulation? She surely speaks like one
Very helpful video. Also computer lady is pretty. Too bad she is just a program in the matrix
i love u
Anyone else notice that none of the causes was "fracking"?
i love her
Adding the table earthquake in my own database is not trivial!
You can create a table with matching columns and right click your table in pgAdmin and click import and then import the csv file.
Of course you can also do this in command line. I am just telling you the pgAdmin solution which is easy for beginners.
Wayne when your own database is on your home server you have problems with the rights.
Wayne this is working with a remote server. It is not easy!
Thanks for your responses.
@@cbraspen The previous video of soratica just taught us how to install pgAdmin4 and launch the server locally. In the description of this video we are provided with the csv on Github. I don't think there is a right issue with earthquake data since the channel makes it public on github.
"wheb you think about it with your brain" haha
The stock footage is killing me
can you like . . . teach everything?
upvote ISO 8601
biliblib
She is my dream robot gf i never had
bilibili
nbilbilbli
she is beautiful...
Hmmm. U like a robot actually...
Do you?