Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Business Analyst – SQL Survival Guide

Get started in SQL; learn how databases work, connect to one, and get the data you need.
4.4
4.4/5
(82 reviews)
259 students
Created by

8.9

CourseMarks Score®

7.8

Freshness

9.7

Feedback

8.7

Content

Platform: Udemy
Video: 2h 15m
Language: English
Next start: On Demand

Table of contents

Description

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.

You will learn

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

Requirements

• There are no prerequisites for this course, all the basics will be covered

This course is for

• Business Analysts involved or are interested in data analysis
• Business Analysts curious about using SQL to query data
• Anyone who wants a quick start in SQL basics
Senior Business Analyst Contractor
My name is Dan. I’m a Senior Business Analyst and I’ve been working in the Financial Services, Banking, and Investments sector for just over 20 years. Around 15 of those have been spent analysing and managing enterprise level business and technology change.
I have worked on 15 (and counting) transformation and migration projects ranging from small scale team applications to large scale enterprise and data centre migrations, as well as a variety of business as usual initiatives.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 2h 15m
Language: English
Next start: On Demand

Students are also interested in