Do THIS instead of watching endless tutorials - how I’d learn SQL FAST in 2024
1 Video View·Nov 7, 2024
My mission is to help you grow your career, especially in the world of data analysis. Switching careers to become a data analyst from a non-tech background was overwhelming. I made a lot of mistakes and wasted time trying to figure it out. But having been a manager of data analytics and now a senior business intelligence engineer at Amazon, I've learned a lot and I'm excited to use my experiences to help you navigate your career path. I hope this channel gives you the clarity and motivation to get started!
SQL is a key data skill but where do you learn it? How do you learn it? And what are the important
topics? I know it's extremely intimidating even thinking about what is the first step,
especially because I came from a non-technical background when I was first learning SQL.
But hindsight, now that I've been using SQL for many years as a data professional,
I know the more efficient and easier way to learn SQL and I will walk you through the exact steps
that I would take if I'm learning SQL today. First off, let me get started with what is SQL?
SQL stands for Structured Query Language and it allows you to interact with data. For example,
with this statement of select star from table where number is greater than 5, this is just saying
give me all the data from the table where the numbers are greater than 5. So it's very much
like simple English and it's something that I really believe you can pick up without a computer
science background. Now why should you learn SQL? Can't AI do it? Yes, AI can code but SQL is still
very much a required skill set on many job listings including data analyst, data scientist,
data engineer, project manager. So if you're interested in any of these job titles, SQL is a
skill that you should start learning. In fact, according to Stack Overflow survey from last year,
SQL remains the third most used programming language across professional developers and
employers value not just your ability to use SQL but your ability to use it to be able to draw
insights to make business decisions. As Reddit user Mamertine Best puts it, I'm not paid because I can
write SQL. I'm paid because I can understand data. Employers are looking for you to not just use SQL
but your ability to critically think about data and learning SQL will help you start doing this.
Now that we know SQL is fundamental, how would I learn it? These are the three steps that I would
take. Step one, choose an environment. SQL is used within a specific environment called database
management system, DBMS, and each DBMS has its own flavor of SQL. According to Stack Overflow survey
where over 90,000 professional developers responded, they said that the three most commonly
used DBMSs are PostgreSQL, MySQL, SQLite, and I'll make sure I include the links to these
descriptions below so that you can start downloading them. Now what's the difference between these three
and which one should you choose on the list? Well it really doesn't matter. I would say the syntax
is very similar across all three and they are all open source and free to download so I wouldn't be
too concerned about which one to choose because you really can't go wrong but in my experience
I've used PostgreSQL and Microsoft SQL Server and I really did not have any trouble transitioning
between them so I would just say pick one and then move on to step two. I'll also mention that
if you don't prefer to download any software onto your laptop, there are always cloud databases as
an option which are on AWS, Google Cloud, and Microsoft Azure. They have limited free options
as well so check that out. Step two, learn the basics quickly. In this step, I am not going to
try to memorize all the syntax or learn all of it as much as possible because there is a lot of
SQL syntaxes and nobody memorizes them. What I do want to focus on is learning the fundamentals
and by fundamentals I mean what is a database, what is a relational database, what is SQL,
and what is its uses. Then I want to focus on the SQL syntax and structure. This includes some of
the statements like earlier, select from where, as well as the CRUD operations which stands for
create, read, update, and delete. And how am I going to learn this? Well, SQL is best learned by doing
and research shows that when you passively learn, you only retain about 20% of it whereas active
learning allows you to retain about 75% to 90% of the information. Interactive learning is really
important when learning SQL and that's why I chose Datacamp when I was first learning SQL
because the platform is very interactive and it allows you to code directly within their platform.
Datacamp is sponsoring this video and I'm so excited to tell you about their SQL Associate
Certification. The certification tests not only your SQL skills for practice but also it includes
a learning path so that you can start learning the fundamentals and get started with the guided
courses of learning to practice SQL hands-on. The SQL Associate Certification is a great way to
improve your skills and level up your SQL ability. And I'm really excited to share that Datacamp is
offering 25% off using my link in the description so make sure you take advantage of this offer and
check it out. Now on to step 3, learn SQL in context not syntax. The wrong way to learn SQL
is by memorizing all the syntax. This will only teach you how to query the data but not actually
understand it. How I would start learning SQL in context is to start with a familiar small data set
like my credit card statement with about 20 to 30 rows of data. I'll then analyze it and try to
answer questions like what is my spending habit and that will teach me how to load data, how to
create a data table, and then be able to order my data set and start doing a lot of what a data
analyst would do and start writing my own queries. And as I do this, these are the topics I would
progress from beginner to advanced SQL. So how much SQL should you know? The answer really depends on
what your role is. If you're a project manager, a beginner level SQL is enough to be self-sufficient
and be able to do your own queries and gather your own data. But if you're looking for a more
data heavy role like a data analyst or a data scientist but more junior, I would say a beginner
to intermediate level is enough and that is about the level that a technical interview will be
for SQL. And then for advanced SQL, I would say that's really for more senior level data roles
as well as data engineers who are more heavy on the data infrastructure side. My tip for learning
SQL is to continue practicing it in context because this will solidify your knowledge
as well as give you the confidence in your ability. There's a concept called curve of forgetting
which relates to the idea of how we retain information. On day one, we remember about 100%
of what we learn, but on day 30, we only remember about 2 to 3%. However, when we expose ourselves
to the same information daily, whether it be 10 minutes, even 2 to 4 minutes as time progresses,
we tend to get closer to the 100% mark of what we retain. And this concept very much applies
to learning SQL. It's not a skill that you can learn in a day, but it is a skill that as you
practice, you will get good at it and you will retain it. So have the confidence and continue
to practice your SQL skills. If you found this video helpful, please like and subscribe to the
channel and watch my next video where I give my honest advice about data analysts and I have way
more tips over there to get you started. Thank you so much and I will see you on the next one.

