SQL Server


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


SQL Server Analysis Services overview 

    Analysis Services is an analytical data engine (Vertipaq) used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.

    Installed as an on-premises server instance, SQL Server Analysis Services supports tabular models at all compatibility levels (depending on version), multidimensional models, data mining, and Power Pivot for SharePoint.

Database Engine:

    The Database Engine is the core service for storing, processing and securing data. The database engine provides controlled access and rapid transaction processing to meet the requirements of the most demanding data consuming application within your enterprise.

    We can use the database engine to create relational databases for online transaction processing or online analytical processing data. 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.

There are 3 types of database systems :

  • hierarchical database system
  • network database system 
  • object-oriented database system




Groups Table:



Students Table:



Marks Table:



Subject/Teacher Table:


Subjects Table:



Database Diagram:




Comments

Post a Comment