Do you want to build reliable, efficient, and maintainable databases, whether they are for OLTP or analytical workloads? If the answer is yes, then this is the session for you.

While building a database is easier than it has been, especially with the tools available now. However, building one which will last the test of time needs some careful planning and understanding of the trade-offs during the development phase.

This workshop will go back to the fundamentals and build up from the core foundations. From concepts such as understanding what the database is, and what it is used for, through to normalization and modelling, then looking at how we can use the tools to build quickly and leverage CI/CD in our processes. At the end of the day, you will have all the materials to refer to and skills needed to build better databases.

For the practical side of this training day, we will focus on the Microsoft SQL technology stack and deploy it to Azure SQL Database.

Agenda
1. What are databases, why do we need them, and what forms do they come in?
2. Database design, including modelling, normalization of data entities, the use of constraints and appropriate data types.
3. Turning the model into code, building the core SQL Server database objects for storing the data, as well as writing stored procedures to read and write data to the database. We will also look at core security concepts and where the line is between developer and DBA.
4. How to use source control and automation to store your code, track changes, and deploying to a target database automatically.
5. Operational aspects of databases including indexing strategies, how to handle deployments of updates to database schemas and codebases to minimize impact as well as more options for securing the database.