#ip_university

[shikshaadvisor]

Guru Gobind Singh Indraprastha University commenced the registration process for IPU CET MBA counselling in online mode on July 16. Earlier IP university released a schedule of centralized online counselling for MBA programme (only through CAT score) on July 14. IPU had extended the last date of submission of online application for MBA admission till May 31. IPU has also extended the correction window from June 1-3. IPU released the application form of IPU CET MBA 2020 on March 3. GGSIPU is conducting IPU CET MBA admission 2020 entrance exam to provide admission to candidates in two year MBA courses. #ggsipu #ip_university #ipucet2020 #ipucetmba #mba #mbacareer #mbaregistration #mbaentrance #mbacollege #mbauniversity #delhi #ip #ipuregistration #ipuexam #shikshaadvisor #careerguidance (at Shiksha Advisor) https://www.instagram.com/p/CCvQ2-3s8dF/?igshid=1ffvlftxnta4d

[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]

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”]

[shikshaadvisor]

IPU CET 2020 Application Form has been released. The exam will be conducted by Guru Gobind Singh Indraprastha University. This is a university level exam organized every year to offer admissions into various UG & PG courses. Candidates have to qualify the entrance test with the qualifying marks to be eligible for admission into various programmes in the University. Admission will be offered into B.Tech, BBA, BCA, LLB, LLM, MBA, MCA & various other courses in the GGSIPU and various affiliated colleges. For admission into BDS & MBBS, candidates have to apply through NEET Scores. #ipucet2020 #ggsipu #ipucet # #bba #bca #btech #mbbs #admission #neet #shikshaadvisor #mba #bds #jeemain #neet2020 #llb #llm #mca #engineering #management #commerce #medical #dental #ip_university #ipu_delhi # #neetug #jee #admissionguidance (at Shiksha Advisor) https://www.instagram.com/p/B9RHZ70AXxw/?igshid=8t99yr20yrjf