SQL server – from setup to execution

Master SQL and Database Design in this SQL Bootcamp - Use Advanced Queries for Data Analysis and Analytics - SQL Server

Created by: Daniel Tait
Database Instructor

What Will I Learn?

• How to write accurate SQL queries against a database
• Use SQL to perform data analysis
• Learn to perform GROUP BY Statements
• Learn how to join multiple tables - including complex joins
• Learn how to use window functions, correlated subqueries, set operators, CTEs and much more
• Best practices in SQL
• Replicate real-world situations and query reports
• How to create tables, views and stored procedures
• How to make your queries run faster by making them sargable
• Be comfortable putting SQL and SQL Server on your resume

Requirements

• You will need to have a Windows-based computer to download and run Microsoft SQL Server.
• This course is suitable for everyone who has a desire to learn and advance in their career. No prior SQL knowledge is needed.

Target audience

• Anyone interested in learning SQL or data analysis!
• Those who are interested in working with SQL Server. This course uses Microsoft SQL Server and T-SQL (Microsoft SQL) variant of the SQL language.
• If you work in: marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data
• Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career