. . : MSSQLServer Management Studio DATABASE DDLTABLES (PK, FK) DML (QUERIES) (STRING, DATES, NUMBERS) T-SQL TRIGGERS FUNCTIONS PROCEDURES In this course, you will learn how to build databases for real projects and how to apply them to your job and your own projects. This course is not for basic knowledge only. It will help you to be excellent in your job and in your own projects. After completing this course you will be able to: Understanding the main concepts of databasesinstalling MSSQLServer engineinstalling MSSQLServer Management StudioCreating Deleting databasesUnderstanding the main concepts of Data Definition Language (DDL)Building TablesBuilding Relations (PK, FK)Understanding the main concepts of Data Manipulation Language (DML)Building QueriesUsing MSSQL Server functionsUnderstanding all basics of T-SQLBuilding triggersBuilding functionsBuilding stored proceduresGettings advice for building databases for real projects
