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

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