SQL SERVER (INTRODUCTION)

  

SQL SERVER

Aim: Overview of SQL Server 2018 Databases and Analysis Services. Create a Sample Database Schema using SQL Server Management Studio.

Database Engine:

The database engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming application within your enterprise.

This includes creating table for storing data and database objects such as index, views and stored procedure for viewing, managing and securing data. You can use SQL Server Management Studio to manage the database objects, and SQL server Profiler for capturing server events.

 Database created named Student with 5 tables –

Groups Table

Students Table-

Marks Table-

Subject/Teacher Table-

Subjects Table-

Database Diagram -

Filling up data into all the Columns of the given Tables-

Conclusion:

Here, I have created a database and tables in SQL management studio and inserted data of different student in it and have seen the primary and foreign key concept in it.