Introduction to SQL Server
In this section we will see what SQL database language is and its main characteristics as well as the SQL Server Management System, the advantages of the relational model and the main elements for the treatment of information: data types, tables and their components, key types and relationships. We will also provide a step-by-step guide for the installation and preparation of the environment
Introduction to SQL and SQL Server
Introduction to SQL Server, famous as a relational database management system developed by Microsoft, based on the use of Transact-SQL, that expands the possibilities of standard SQL. Introduction to DDL, DML and DCL
Installing SQL Server and SQL Server Management Studio (SSMS)
This section will serve as a guide to prepare the development environment. For this we will see step by step how to download, install and configure the free SQL Server Developer edition and after that the SQL Server Management Studio (SSMS) tool
SQL databases (relational databases)
Introduction to Relational Databases (RDB) and the relational model. In this section we will delve into the main element that forms it: the tables with their fields, records and keys
Data types
There are many different data types that each field in a database table can hold. The purpose of this section is to classify and list each of them according to their main characteristics
SQL database relationships
In this section we will focus on explaining and exemplifying the different types of essential relationships in the administration of relational databases
Entity Relationship Model (ERM)
The Entity Relationship Model (ERM) is a data modeling diagram whose main function includes the graphic design and debugging of relational databases. In this section we will see its main components: entities, attributes and relationships