[Free] Sql : The Hitch Hikers Guide To Writing Sql Queries
Get started with the SQL query language and easily master the complexities of table joins – Free Course
What you’ll learn
- Proficiency in Table Join queries
- A complete understanding of the structure of a SQL query
- How to write aggregation based queries
- Prepared and ready to learn more advanced SQL query techniques for data analysis and discovery
- How to do backups and restores
- Import raw data ready for analysis
Requirements
- No prior knowledge required
- A Windows PC or (virtual box running Windows e.g. on a Mac) as you will want to code/modify the sample queries
- This course is taught using SQLServer 2014 Express which is free from Microsoft (and later versions e.g 2016 Express can be used)
- Only have a Mac ? You can use Virtual Box, Windows Server Trial edition and SQL 2014 express or later.
Description
G’Day from Australia,Welcome, this is a SQL course that I am sure you will complete and benefit substantially from.
The course is aimed at Beginners to Intermediate levels.
It covers all the bases for you to get up to speed with writing SQL before you progress on to more advanced SQL for
transforming and analysing data.
I will explain everything step by step and in detail so you get to know SQL very well.
The course uses SQLServer 2014 express (Later versions are compatible) , and we all know the popularity of SQL Server and the thousands of enterprises that use it.
All data are included (for download) in the course so that you can practice what I teach and more.
Best
Paul
Data Analyst and SQL Developer
Qld, Australia
Author(s): Paul Scotchford
