Business Analyst – SQL Survival Guide
Business Analyst – SQL Survival Guide, available at $69.99, has an average rating of 4.3, with 19 lectures, 1 quizzes, based on 113 reviews, and has 374 subscribers.
You will learn about Database fundamentals (including Entity Relationship Diagrams) Basics of SQL Management Studio Essential SQL commands that can build powerful queries This course is ideal for individuals who are Business Analysts involved or are interested in data analysis or Business Analysts curious about using SQL to query data or Anyone who wants a quick start in SQL basics It is particularly useful for Business Analysts involved or are interested in data analysis or Business Analysts curious about using SQL to query data or Anyone who wants a quick start in SQL basics.
Enroll now: Business Analyst – SQL Survival Guide
Summary
Title: Business Analyst – SQL Survival Guide
Price: $69.99
Average Rating: 4.3
Number of Lectures: 19
Number of Quizzes: 1
Number of Published Lectures: 19
Number of Published Quizzes: 1
Number of Curriculum Items: 24
Number of Published Curriculum Objects: 24
Original Price: £19.99
Quality Status: approved
Status: Live
What You Will Learn
- Database fundamentals (including Entity Relationship Diagrams)
- Basics of SQL Management Studio
- Essential SQL commands that can build powerful queries
Who Should Attend
- 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
Target Audiences
- 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
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.
Course Curriculum
Chapter 1: Course Introduction
Lecture 1: 1-1 – Course Introduction
Lecture 2: 1-2 – Curriculum Overview
Lecture 3: 1-3 – Widget Capital – The Background
Chapter 2: Introduction to databases
Lecture 1: 2-1 – What is a database, and how do applications use them?
Lecture 2: 2-2 – What is a data warehouse, and how are they used in organisations?
Lecture 3: 2-3 – Database design fundamentals – Entity Relationship Diagram
Chapter 3: Introduction to MS SQL Server Management Studio
Lecture 1: 3-1 – Download and install MS SQL Management Studio
Lecture 2: 3-2 – A quick tour of SQL Management Studio's User Interface
Lecture 3: 3-3 – Create a test database
Lecture 4: 3-4 – Populate database with data
Lecture 5: 3-5 – Cheat and use a remote database
Chapter 4: Essential SQL commands
Lecture 1: 4-1 Querying data – the SELECT statement
Lecture 2: 4-2 Power up your queries
Lecture 3: 4-3 Querying data – using JOIN to SELECT from multiple tables
Lecture 4: 4-4 Querying data – using SELECT CASE to transform data
Chapter 5: Bonus section – add, update, and delete data in a database
Lecture 1: 5-1 – Add data to database using INSERT
Lecture 2: 5-2 – Update data in a database using UPDATE
Lecture 3: 5-3 Delete data in a database using DELETE
Chapter 6: Knowledge roundup
Lecture 1: 6 – Course review against objective
Instructors
-
Daniel Gater
Analyst, Architect, Problem Solver
Rating Distribution
- 1 stars: 4 votes
- 2 stars: 5 votes
- 3 stars: 16 votes
- 4 stars: 35 votes
- 5 stars: 53 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Data Science & Real World Computing with Jupyter Notebook
- Angular – Complete Essential Guide
- Build REST APIs with PHP 7 and Laravel 5
- Business Analyst – SQL Survival Guide
- Scala for Spark – The Most Important Parts
- Advanced UX Techniques – Novice to Pro!
- Teradata Fundamentals – Comprehensive SQL course on Teradata
- Machine Learning and AI: Support Vector Machines in Python
- Intermediate and Advanced iOS – Build Real World Apps
- Deploy Fargate ECS Apps & Infrastructure: AWS with Terraform
- Beat the Codility Coding Interview in Ruby
- 2019 Calendar App: Let's Build It!
- Learn Godot by Creating an Idle Business Tycoon Game
- Microsoft BOT Framework & DialogFlow: Creating ChatBot
- The Art of product design in blender [10 Projects]
- Creo Parametric | Drafting module | Complete
- 8085 microprocessor:architecture,programming and interfacing
- NEW! Zbrush Hard Surface Sculpting Beginner to Advance
- Polymer Clay Jewelry Making Techniques for Beginners
- An Introduction to Urban Planning and Design