Microsoft SQL Server for Beginners | Crash Course

☑ Introduction to Database Management System (DBMS)

☑ Understand and Use Databases

☑ Data Models

☑ Relational Database Management System (RDBMS)

☑ How Primary Key works

☑ How Composite Key works

☑ How Foreign Key works

☑ Structured Query Language (SQL)

☑ Type of Relationships e.g. One to One relationship , One to Many relationship and Many to Many Relationship

☑ Step by Step guide to install Microsoft SQL Server

☑ Create new Database by using Microsoft SQL Server Management Studio

☑ CRUD Operations

☑ Selection of DISTINCT Records

☑ Writing SQL Queries to learn different type of SQL Joins

☑ SQL Development by using Microsoft SQL Server

☑ Database Development

☑ Definition of Aggregate Functions

☑ Count function

☑ Min Aggregate function

☑ Max Aggregate function

☑ Sum Aggregate Function

☑ Different variations of Group By Clause

☑ Converting values in Upper case

☑ Converting values in Lower Case

☑ Substring function

‘;
}
});