Speedy SQL. This course covers the six constituent parts of the SELECT statement, before looking at saving code using both views and procedures. Finally, it will show you how to export reports into Excel statistically and dynamically.
On completion, you will be able to start writing and using your own code.
WHO IS THE COURSE FOR?
This course is suitable for anybody who wants a quick overview of the SELECT statement.
Basic knowledge of opening a spreadsheet is ideal. No prior knowledge of SQL Server is needed.
Requirements: SQL Server Management Studio (SSMS) installed on your computer.
- Build your own SQL Server SELECT statements.
- GROUP BY
- ORDER BY
- Encapsulate your statements as views or procedures.
- Dynamically connect the results of you SELECT statements into Excel.
“The best SQL crash course there is. 8 years in the tech field using T-SQL and PL-SQL and I am seeing the basics of Stored Procedures finally thanks to this course! I’d absolutely recommend it to my juniors.” Lavanya
“Easy to follow with relevant examples. It was basic, condensed material but due to the clear structure, one can easily finish it in less than three hours (with breaks), including installation. Highly recommend. Thank you.” Razvan
“Learned a couple of new things in the first 10 minutes. Great review of these basic materials. Learned some nifty tips, especially in regards to using SQL with Excel.” Chris
“Wonderful intro – great amount of detail and context. Thank you!” Corinne
READY TO START?