Let's get started
- What is this FREE course about ? it's about SQL !
- Download and install SQL 2014 Express
- Introduction to the SQL Server management studio
- What is a relational database ?
- Pop quiz
SQL Foundation skills
- Anatomy of a query
- Where are the sample database and script files ?
- The SELECT statement
- Practice session with SELECT
- The SELECT statement with a WHERE predicate
- Practice session with SELECT with a WHERE predicate
- The Group By clause
- Practice session with Group By
- A few tips about data types
- Pop Quiz - Data types
Table joins, how they work
- Where are the sample database and script files ?
- Review the Chapter 3 database and model (PK/FK)
- Brain Teaser
- How to do an Inner Join
- Prac time
- How to do a Left Outer Join
- How to do a Right Outer Join
- How to do a Full Outer Join
- Prac time
- How to do a Cross Join
Transform data using aggregation functions
- Where are the sample database and script files ?
- Counting stuff using the Count() function
- Prac Count()
- Adding up using the Sum() function
- Calculate the mean using the Avg() function
Bonus content to enhance your knowledge
- What the heck is a UNION ?
- How to insert data to a table
- Importing raw data from non database files
- Backup your database(s)
- How to use the Case statement
- Award based Course Certificates
