Business Analyst - SQL Survival Guide (Udemy.com)

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

( 13 Reviews )

Created by: Daniel Gater

Produced in 2021

What you will learn

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 80 / 100

Course 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 isHow applications use databasesEntity Relationship DiagramsWhat a data warehouse is and how organisations use themWhat software you'll need to connect to a databaseHow to create your own test databaseThe essential SQL commands you'll need to query datafrom one or many tables in a SQLdatabaseCommands you'll need to manipulate data (insert, update, and delete)How to export data to ExcelTo 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.
Who this course is for:
Business Analysts involved or are interested in data analysisBusiness Analysts curious about using SQL to query dataAnyone who wants a quick start in SQL basics

Time: 2.5h

Instructor Details

Daniel Gater

4.0 Rating
13 Reviews

My name is Dan. Im a Senior Business Analyst and Ive 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.

SQL Server - zapytania. Querying. Exam 70-761

SQL Server - zapytania. Querying. Exam 70-761 (2021)
4.8 (99 Reviews)

- Provider: Udemy
- Time: 5h

$11.99

Oracle Database 12c SQL Certified Associate 1Z0-071

Oracle Database 12c SQL Certified Associate 1Z0-071 (2021)
4.7 (336 Reviews)

- Provider: Udemy
- Time: 20h

$11.99

Introduction to Structured Query Language (SQL)

Introduction to Structured Query Language (SQL) (2017)
4.7 (313 Reviews)

- Provider: Coursera
- Time: 3h

Free

Learn C# With Windows Forms and SQL Server

Learn C# With Windows Forms and SQL Server (2021)
4.7 (269 Reviews)

- Provider: Udemy
- Time: 12.5h

$11.99

Microsoft Access SQL: SQL for Non-Programmers

Microsoft Access SQL: SQL for Non-Programmers (2021)
4.7 (240 Reviews)

- Provider: Udemy
- Time: 3.5h

$11.99

The Ultimate Oracle SQL Course (2021)
4.7 (237 Reviews)

- Provider: Udemy
- Time: 11.5h

$11.99

All sql courses

Reviews

4.0

13 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Projna Sadhukhan on 11/27/2020

Concept and content wise the course is good. For a beginner coming from entirely functional domain, the course is helpful to grasp the basic understanding.
The pace of the explanation is quite fast which is making difficult to follow at a stretch. This part need improvement.

By Prabhat Sengar on 9/15/2020

Too fast speaking and very small text

By Simran Khurshid on 8/9/2020

Language is not clear

By Dan Smith on 8/5/2020

This is exactly what I was after, just the basics of SQL that I'll need as a BA. I've already used some of the techniques at work and now feel a lot more confident about navigating databases and data structures - the Entity Relationship Diagram walkthrough was extremely helpful.

By Anvesh on 7/23/2020

Teaching speed could be bit slow, as slow listeners can also be helped.

By Bret Schuurman on 7/3/2020

Poor sound and lecturers speed of presentation

By Isha Srivastava on 6/12/2020

Voice quality is not good.

By Shashank Kalanithi on 5/16/2020

The course instructor taught the basics of SQL from a BA stand point along with the video and the course materials published as resources. I feel more confident now and recommend the course for anyone seeking to learn SQL

By Hakan Erdem on 5/4/2020

In less than a week, I learned how SQL works, I associated my learning with my work and finally understood how the BI team has built the connections to the platforms I used as an analyst. I bought this course to just initialize before I join a more extensive course, however even now I feel qualified enough to use SQL and solve problems.

By Marco Raul-Luis Lourenco on 3/23/2020

It was a good course to get an overview of SQL as a tool for a BA. I think the course would be more attractive with more practicals, these can be googled but it would make this course even better if available. all in all a great start to learning SQL and a complete overview!

By Ryan Kelly on 9/24/2019

As a BA who knows nothing about SQL - I found this course useful as it used a real world example to help explain the . However a fair few acronyms and technical names were thrown out , so it would be good if a glossary was included or referenced.
Would be good if it gave you a chance to correct the assignments and perhaps had a few smaller tests to complete with shorter code strings.

By Kazi Saifur Rahman on 9/9/2019

Great course! Very easy to navigate and concepts very well explained. I have used this course to cement my understanding and have gone on to do many SQL related projects in my company.