SQL and Database for Analysts – Increase your team value

Course Curriculum

Chapter 1: Introductions: The course, databases and the tools

Lecture 1: Introduction to the lecturer and the course

Lecture 2: Introduction to Relational Databases

Lecture 3: Downloading and installing MS SQL Server

Lecture 4: SQL 2017: Checking your installation and Setup files

Lecture 5: Exercise: Experiment with the spreadsheet

Lecture 6: Meet The Geek – How to contact me

Chapter 2: Structured Query Language (SQL), DML and SELECT

Lecture 1: Overview of SQL

Lecture 2: Reading from a table using SELECT

Lecture 3: Some Hints

Lecture 4: Exercise: Choose the information YOU want

Lecture 5: Exercise: What else might you want to know?

Chapter 3: Introducing Derived Columns and Functions

Lecture 1: The database doesn't have to contain everything!

Lecture 2: Derived columns

Lecture 3: Functions (COUNT, MAX, MIN, AVG, SUM)

Lecture 4: Exercise: Derived Columns and Functions

Chapter 4: Changing data in a table

Lecture 1: DML: Data-changing statements

Lecture 2: Adding new data: the INSERT statement

Lecture 3: Removing data: the DELETE statement

Lecture 4: Changing existing data: the UPDATE statement

Lecture 5: INSERT, UPDATE and DELETE using Management Studio

Lecture 6: Summary: INSERT, UPDATE and DELETE

Lecture 7: Exercise: Experiment with changing data

Chapter 5: More with SELECT

Lecture 1: The ORDER BY clause

Lecture 2: Working with text: the LIKE comparison

Lecture 3: Functions and GROUP BY

Lecture 4: Exercise: LIKE, ORDER BY and GROUP BY

Chapter 6: The Database Manager and the Database Administrator

Lecture 1: The Database Manager and the Database Administrator

Lecture 2: Exercise: Exploring Instance and Database settings

Chapter 7: Defining the database: Data Definition Language (DDL)

Lecture 1: Introducing DDL

Lecture 2: Creating and changing a table

Lecture 3: Creating and changing a database

Lecture 4: Exercise: Creating and changing the PhoneBook

Lecture 5: Exercise: Do you always have a value?

Chapter 8: NULL: a load of fuss over nothing!

Lecture 1: What does NULL really mean?

Lecture 2: What does NULL mean in practice?

Lecture 3: Exercise: NULL

Lecture 4: Exercise: Who is that? Which one is that? (identity)

Chapter 9: A question of identity?

Lecture 1: What's the problem? Double trouble!

Lecture 2: The solution: "Identifiers" or "Keys"

Lecture 3: Exercise: Identity and keys

Lecture 4: Exercise: Using a real phone book

Chapter 10: Indexes

Lecture 1: What is an index and what does it do?

Lecture 2: Creating and using indexes

Lecture 3: Exercise: Creating and Dropping INDEXes for yourself

Lecture 4: Exercise: More (and more) information

Chapter 11: Normalization, Data Modelling and JOIN

Lecture 1: What's the problem with PhoneBook?

Lecture 2: How do we "Normalize" PhoneBook?

Lecture 3: Exercise: Examine the normalized database

Lecture 4: The SELECT statement with JOIN

Lecture 5: Exercise: Normalization, Data Modeling and JOIN

Chapter 12: Temporary tables and VIEWs

Lecture 1: Temporary tables: SELECT INTO

Lecture 2: Introducing VIEWs

Lecture 3: Exercise: Temporary tables and VIEWs

Chapter 13: Securing the database: Data Control Language (DCL)

Lecture 1: Introducing DCL

Lecture 2: Making security more convenient with Roles

Lecture 3: Exercise: DCL and User privileges

Chapter 14: Course review

Lecture 1: What we've covered together

Lecture 2: Next steps: Where do you go from here?