Business Analyst - SQL Survival Guide

Description

In this course, you will learn :

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

Syllabus :

1. Introduction to databases

• What is a database, and how do applications use them?
• What is a data warehouse, and how are they used in organisations?
• Database design fundamentals - Entity Relationship Diagram

 

2. Introduction to MS SQL Server Management Studio

• Download and install MS SQL Management Studio
• A quick tour of SQL Management Studio's User Interface
• Create a test database
• Populate database with data
• Cheat and use a remote database

 

3. Essential SQL commands

• Querying data - the SELECT statement
• Power up your queries
• Querying data - using JOIN to SELECT from multiple tables
• Querying data - using SELECT CASE to transform data

Show more