What you'll learn:
- Install and use SQL Server database engine and studio
- Analyse data looking for patterns and behaviours
- Expertly code quantitative analysis using SQL
- Write SQL using LAG(), NTILE(), OVER, PARTITION logic and many more analytics functions
- Understand Primary and Foreign keys
- Understand the difference between DML and DDL
- Understand the relational database model
- Make data driven decisions in your enterprise
- Master all types of table joins (incl. Complex Apply joins)
- Answer those gnarly interview questions, yes we will always have those !
Greetings,
With so much data stored in SQLdatabases, how can we get at it ?
You use SQLto get at this data, no matter what the SQL Database product is (e.g SQLServer, Oracle and many more).
Coding SQL to analyse datacan be a daunting andcomplex task, hence the reason for building this course.
In this course I will teach you how code SQL to performdata analysis in orderto answer complex questions that you will encounter daily in your job.
Ask yourself these simple questions ...
Do you know all of theTABLEJOINtypes that can be applied in a SQLquery?
Have you everused OUTERAPPLY, which is so easy andpowerful to use ?
Can you write arunning totalin a singleline of SQL ?
Where do you use a ROLLUP statement and why would you use it?
What is LAG() ?
If you could not answer these simple questions then this course will definitely change all of that for you.
You definitely should know all ofthis to survive the SQL environment you work in !
All course materials are provided e.g. Sample databases (with real data), code scripts, practice exercises and quizzes.
Don't forget, there is a 30 Day money back guarantee if this course does not deliver what you expected.
Best Regards
Paul
Data Analyst and Visualisation Engineer
