A query goes to a bar. He walks up to two tables and asks, “May I join you?”
Here’s How to Learn Beginner Level SQL
Have you asked yourself recently, “How do I get started learning SQL?” If you have, this is the place for you. Below are bite-sized lessons on the basic elements of SQL, as I learn them. Questions, comments requests? Let me know.
Yes, make ALL the things efficient! The IN statement allows us to make very granular queries against a database. In doing so, we can skip the headaches of multiple value = x OR statement lists, or working with a BETWEEN statement.
Large and complex data sets are a reality of data science. The LIKE statement employs pattern matching when you can’t remember what values you need to look up, or, when you just have plain messy or incomplete data.
Section Break – Test Your PostgreSQL Knowledge with a Beginner’s Skill Challenge
After a 4 month hiatus from articles, why not hop back in with a quiz on the GROUP BY SQL statement?
Notes, Legal, Disclaimers
Content and media on this site may not represent the positions of my employer(s), agents, affiliates, subsidiaries, clients and should not be interpreted as such. (The list includes, but is not limited to the aforementioned.)
This site may contain advertising and/or affiliate links.