#guru_gobind_singh_indraprasth_univercity

[devi1garg]

Aggregate Functions of SQL

Aggregate Functions are all about

Performing  calculations on multiple rows

Of a single column of a table

And returning a single value.

The ISO standard defines five (5) aggregate functions namely;

1) COUNT 2) SUM 3) AVG 4) MIN 5) MAX 

Why use aggregate functions.

From a business perspective, different organization levels have different information requirements. Top levels managers are…

[devi1garg]

SQL WHERE Clause

The WHERE clause is used to filter records. The WHERE clause is used to extract only those records that fulfill a specified condition.

Syntax:-

SELECT column1, column2, … FROM table_name WHERE condition;

Example:-

SELECT * FROM Customers WHERE Country=’Mexico’;

Operators in The WHERE Clause a)   SQL Arithmetic Operators:-

Assume ‘variable a’ holds 10 and ‘variable b’ holds 20,…

[devi1garg]

Primary Key Constraint

The PRIMARY KEY constraint uniquely identifies each record in a table. Primary keys must contain UNIQUE values, and cannot contain NULL values. A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns (fields).

SQL PRIMARY KEY ON CREATE TABLE:-

The SQL creates a PRIMARY KEY on the “ID” column when the “Persons” table is created.

[devi1garg]

Data Query Language (DQL)

DQL is used to fetch the data from the database.

It uses only one command:

SELECT: The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set.

Syntax:

SELECT column1, column2, … FROM table_name;

Here, column1, column2, … are the field names of the table you want to select data from. If you want to select all the…

[devi1garg]

Transaction Control Language (TCL)

TCL commands can only use with DML commands like INSERT, DELETE and UPDATE only.

These operations are automatically committed in the database that’s why they cannot be used while creating tables or dropping them.

Here are some commands that come under TCL:

COMMIT:- If everything is in order with all statements within a single transaction, all changes are recorded together in the database…

[devi1garg]

Data Control Language (DCL)

DCL commands are used to grant and take back authority from any database user.

Here are some commands that come under DCL:

Grant:- SQL Grant command is used to provide access or privileges on the database objects to the users.

Syntax:-

“GRANT privilege_name ON object_name “””TO {user_name | PUBLIC | role_name} [with GRANT option];  

Example:

GRANT SELECT ON employee TO user1

Revo…

[devi1garg]

Data Manipulation Language (DML)

DML commands are used to modify the database. It is responsible for all form of changes in the database.

The command of DML is not auto-committed that means it can’t permanently save all the changes in the database. They can be rollback.

Here are some commands that come under DML:

INSERT:- The INSERT INTO statement is used to insert new records in a table.

Syntax:

It is possible to…

[devi1garg]

Data Definition Language (DDL)

DDL changes the structure of the table like creating a table, deleting a table, altering a table, etc.

All the command of DDL are auto-committed that means it permanently save all the changes in the database.

Here are some commands that come under DDL:

CREATE:-  The CREATE TABLE statement is used to create a new table in a database.

Syntax:

CREATE TABLE table_name (     column1 datatype,

[devi1garg]

SQL

Intoduction To SQL

SQL is a standard language for storing, manipulating and retrieving data in databases.

Our SQL tutorial will teach you how to use SQL in: MySQL, SQL Server, MS Access, Oracle, Sybase, Informix, Postgres, and other database systems.

What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American…

[devi1garg]

BBA - Guru Gobind Singh Indraprastha University

BBA – Guru Gobind Singh Indraprastha University

[embeddoc url=”http://edigipedia.com/wp-content/uploads/2019/09/BBA-usms-bba-020718.pdf” viewer=”google”] BBA SyllabusDownload

[devi1garg]

Indian Economy IP University BBA Notes

Indian Economy IP University BBA Notes

Indian Economy Unit 1Download Indian Economy Unit 2Download [embeddoc url=”http://edigipedia.com/wp-content/uploads/2019/09/IE-UNIT1.pdf” viewer=”google”] [embeddoc url=”http://edigipedia.com/wp-content/uploads/2019/09/IE-UNIT2.pdf” viewer=”google”]

[devi1garg]

Environmental Science Notes BBA IP University Semester 3.

Environmental Science Notes BBA IP University Semester 3.

Literary environment means the surrounding external conditions influencing development or growth of people, animal or plants; living or working conditions etc.

[embeddoc url=”http://edigipedia.com/wp-content/uploads/2019/09/UNIT-1-NOTES_-ECOSYSTEM_PART-1.docx” download=”logged” viewer=”microsoft”] [embeddoc url=”http://edigipedia.com/wp-content/uploads/2019/09/BIO-…

[devi1garg]

Business Law IP University BBA Notes Semester- 3

Business Law IP University BBA Notes Semester- 3

[embeddoc url=”http://edigipedia.com/wp-content/uploads/2019/09/BL-unit-1-part-1.pdf” download=”logged”] [embeddoc url=”http://edigipedia.com/wp-content/uploads/2019/09/BL-unit-1-part-2.pdf” download=”logged”]

[devi1garg]

Business Environment IP University BBA Notes

Business Environment IP University BBA Notes

unit-1-be.pdf

Click on the link^ above to see the Business Environment BBA IPU Notes