This intermediate course builds on Beginning SQL and goes deeper into the language as well as how to design and implement your own databases from scratch.
During the course we will make use of SQL Server 2016 Express, but most things you learn here also work with previous versions of SQL Server.
The course also contains many exercises in both SQL and database design, where you learn to go from specification to database.
The instructor is also actively working as a consultant, and shares his practical experiences of databases
For you who want to deppen your SQL knowledge, and learn to create your own databases.
You should have skills corresponding to *Beginning SQL*, and knowledge about how to construct queries in SQL, including `JOIN` and `GROUP BY`.
What you will learn
Things covered by the course
- Creating database
- Creating tables
- Index (clustered and non-clustered)
- Database diagrams
- Stored procedures
- Error handling
- Data integrity and constraints