What is SQL ?

SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS). It is designed based on relational algebra (Set theorem, Joins).

SQL consists of a data definition language(DDL), data manipulation language(DML), and Data Control Language(DCL).

The Data Definition Language (DDL) manages table and index structure in database. The most basic items of DDL are the CREATE, ALTER, RENAME, DROP and TRUNCATE statements.

The Data Manipulation Language (DML) manages add, update and delete data in database.

The Data Control Language (DCL) authorizes users to access and manipulate data. Its two main statements GRANT and REVOKE.

What is Relational model ?

The relational model (RM) for database management is an approach to  provide details of specific data pulled from various table based on existing relation mentioned between them.

For example, there are 3 tables and they are related by a common column named “Roll No” 

From this model we can get detailed data for Roll No 1 and 2.

A Relational Database is a digital database whose organization is based on the relational model of data.

What is Table ?

A table is a collection of related data held in a structured format within a database. It consists of columns, and rows.

What is Database Management System (DBMS) ?

A database management system is system software for creating and managing databases.

DBMS makes it possible for users to create, read, update and delete data in a database.

A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases.

DBMS provider company

1.   MySQL

2.   PostgreSQL

3.   Microsoft SQL Server

4.   Oracle

5.   Sybase

6.   SAP HANA

7.   IBM DB2

Why Database is required ?

1. Databases provide an efficient way to store the data. All organized collection of various data stored in single location or central storage.
2. More than one guys can retrieve and analyze data in same time from a single source of truth.

What is Database ?

A database is an organized collection of data. It is the collection of schema, tables, queries, reports, views and other objects.

Example: If we want to make a database for a school, then we have to collect some organized collection of Student Details, Staff Details, Class details, book subject details, Class wise fees details etc. Here all the information are related together.

POWER BI: Microsoft self service Business Intellegence

What is Power BI?

Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device.

Power bi Component:

It is not only one tool. It is suite tools.

1

        Power Bi Web Portal (3 major building Blocks of Power BI)

1.1  Dataset

1.2  Report

1.3  Dash Board

2   Power Bi Designer

2.1  Power Query

2.2  Power Pivot

2.3  Power View

Power Bi Analysis Services connector.

Look of Power BI Report