Module 00: Lesson 1 – Introduction

Preview

No matter how much ado is currently about big data, semi and unstructured data, the appropriate place for the most important data is still the relational database management system (RDBMS). If you need to take care about the data integrity, then you should use the relational model as the logical model for your data and database schema. You have to learn the standard language for working with data in a RDBMS, the Structured Query Language (SQL). 

In this course, you will learn the basics about the relational model, including normalization and constraints. You will start using the language that SQL Server and Azure SQL Database understand, the Transact-SQL (T-SQL) language. You will learn how to write basic and advanced queries. You will see how to create tables and insert, update, and delete data. You will learn how to handle errors and define user transactions. You will also understand the programmatic objects in a SQL database, including views, functions, stored procedures, and triggers. 

In this introduction to the course module, you will also get the information on the products and demo database used for the course, how to obtain, and how to install them. 

Module slides can be accessed here

Back to: Starting with SQL Server and Azure SQL Database Your Development Journey in the Relational World > Module 00: Course Introduction (Dejan Sarka)