Business Analyst - SQL Survival Guide

Business Analyst - SQL Survival Guide

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.

Get started in SQL; learn how databases work, connect to one, and get the data you need.

Url: View Details

What you will learn

• Database fundamentals (including Entity Relationship Diagrams)
• Basics of SQL Management Studio
• Essential SQL commands that can build powerful queries

Rating: 3.85

Level: Beginner Level

Duration: 2.5 hours

Instructor: Daniel Gater