From the course: Preparing to Get a Job in Data Analytics
Unlock the full course today
Join today to access over 24,400 courses taught by industry experts.
How to learn SQL for data analytics
From the course: Preparing to Get a Job in Data Analytics
How to learn SQL for data analytics
- Now that we've discussed the basics of analytics and BI visualization tools, the next natural question is where do you get the data from? Sure, you can use Excel sheets while learning analytics, but Excel sheets all the time isn't super realistic unless you're working in consulting or finance. Most companies use databases and data warehouses to store data because they're much more scalable, automated, and agile, and they access it using my favorite language, SQL. SQL, also called SQL, stands for structured query language. SQL is the way that you can talk to the database and communicate what data you need. Having database knowledge is super important for a career in analytics because you'll constantly be pulling your own data sets for analysis. Sometimes, you might pull data from the database and export it to Excel for an ad hoc analysis or a one-time quick request from a stakeholder, and sometimes, you might be…
Contents
-
-
-
-
(Locked)
Skills needed in data analysis1m 53s
-
(Locked)
How to learn statistics for data analytics3m 59s
-
(Locked)
How to learn basic data skills for data analytics2m 52s
-
(Locked)
How to learn Power BI and Tableau for data analytics3m 50s
-
(Locked)
How to learn SQL for data analytics4m 1s
-
(Locked)
How to learn programming in Python or R for data analytics3m 19s
-
(Locked)
-
-
-