Are you a business analyst and have either avoided getting to know SQL, or haven’t had the opportunity? Or, maybe you just want to a quick start to the basics of SQL without the advanced functions? If you’ve answered yes to any of these then this course is for you.
Starting with the absolute basics, this course covers;
What a database is
How applications use databases
Entity Relationship Diagrams
What a data warehouse is and how organisations use them
What software you’ll need to connect to a database
How to create your own test database
The essential SQL commands you’ll need to query data from one or many tables in a SQL database
Commands you’ll need to manipulate data (insert, update, and delete)
How to export data to Excel
To a business analyst, data is king. Accurate data is the easiest and most powerful way to prove or disprove a hypothesis or course of action, the challenge is getting your hands on it. If you don’t have access or the skills to query a database you are reliant on someone else getting the data that you’ve asked for, which might not be what you want.
I want to give you the skills to understand what a database is, how they work, and most importantly, how you access one and query the data so you can be self–sufficient getting the data you need.
Courses : 1
Specification: Business Analyst – SQL Survival Guide
4 reviews for Business Analyst – SQL Survival Guide