Learn basic SQL commands using the student table

Crystal X
5 min readJul 28, 2024

I have been studying SQL in an attempt to improve my skillset. Structured query language, commonly called SQL, is a language that has been written to interact with relational database management systems, or RDBMS,

I had been working on bigquery datasets in Kaggle, a data science company. Kaggle even has a mini course on their website, which I started, that will give its users a jump start into the language. The problem that I found was that the SQL commands are written within a comment of Python code. While Kaggle provides a good introduction to SQL, the fact that the website requires the user to use bigquery libraries within the Python programming language is a bit worrying to me.

Because I wanted to be successful in any potential interview, I decided that I wanted to explore some other avenues to learn the language. I therefore decided to take a SQL course presented in a YouTube video, which can be found here:- https://www.youtube.com/watch?v=HXV3zeQKqGY

The SQL course, which is on the freecodecamp.org website, uses software that needs to be installed on the computer, but since I am a bit risk averse, I decided to use an online SQL compiler, OneCompiler. I have therefore used the OneCompiler website to demonstrate the basic SQL code that I picked up on YouTube.

--

--

Crystal X

I have over five decades experience in the world of work, being in fast food, the military, business, non-profits, and the healthcare sector.