We will install a version of SQL Server Express for free, install it, and create a database and table.
Microsoft SQL Server - An Introduction (2018 edition) |
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.
Who this course is for:
- This beginner's course is for you if you want to learn about SQL Server and the various programs.
- If you have already heard about SQL Server, and wish to learn more about T-SQL, then please have a look at my courses.
- Get the course