SQL Server Course

There is far too much data in your company, and you have outgrown Excel, management is talking about bringing in a data expert but with our Excel to SQL course, it’s your time to shine as you take this challenge on

Sign Up!

About the course

Companies are producing more data than ever, and this trend will only continue so the ability to deal with that data for the average professional is now a necessity rather than a ‘nice to have’…

Pivot Tables can make the challenge of dealing with your data seamless.

In our ‘Rapid Pivot Tables’ course, you will learn ‘over the shoulder’ as we show you how to quickly summarise your data and create value add reports that will make a difference to your company.

THIS COURSE IS FOR THREE TYPES OF PROFESSIONALS

  1. You’ve been working with Excel and your companies’ data volumes have grown to the point where you need a more robust solution to handle the higher volume of data
  2. You’ve started working in a company or a new project that already has SQL server and you need to get up to scratch to start querying it to create analysis and reports
  3. Finally, you are a project manager or business analyst who won’t be building or querying a database but you need to understand databases so you can be a better bridge between IT and the business

What you will learn

As you look to move beyond Excel, we will get you up and running with SQL Server

  • How a SQL server database works and set one up
  • Tables: layouts, keys, data types and queries to interrogate a table
  • Database structure: the relational model, foreign keys, and cardinality
  • Joins: Essentially filter a database and make sure we get only the information we are interested in
  • Advanced SQL: Stored procedures, functions and exporting

THIS COURSE IS FOR 3 TYPES OF PEOPLE

  • 1. You’ve been working with Excel and your companies’ data volumes have grown to the point where you need a more robust solution to handle the higher volume of data
  • 2. You’ve started working in a company or a new project that already has SQL server and you need to get up to scratch to start querying it to create analysis and reports
  • 3. Finally, you are a project manager or business analyst who won’t be building or querying a database but you need to understand databases so you can be a better bridge between IT and the business

Course Content

1.1 – SQL BI Course Introduction 2.08
1.2 – Software Layout 4.09
1.3 – Database Setup 3.48
1.4 – Intro Conclusion 1.05
2.1 – Tables Introduction 3.57
2.2 – Table Theory 19.42
2.3 – Table Queries 32.15
2.4 – Tables Conclusion 2.4
4.1 – Joins Introduction 3.06
4.2 – Joins Theory 12.18
4.3 – Join Queries 37.37
4.4 – Joins Conclusion 3.21
20. Filtering – Part 1

03:17

21. Filtering – Part 2

03:00

22. Slicer – Insert Style Property

04:31

23. One Slicer connected to Multiple Pivots

04:01

24. Timeline Slicer

04:40

5 – Stored Procedures, Functions & Exporting 20.53