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
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024