This course is a brief presentation of SQL Server.
We will install a version of SQL Server Express for free, install it, and create a database and table.
We’ll also add some data and retrieve it.
We’ll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).
Following this, we’ll create SQL Views and Procedures, connect it to Excel, and have a brief look at SSRS (SQL Server Reporting Services) and backup and restore a database.
No prior knowledge is required – just a willingness to learn.
See you on the course.