dbmsindex

2
INDEX S.N o Name Of The Experiment SIGN . 1. Introduction to DDL and DML 2. To create Table queries using constraints 3. To perform the function of Insert statement in table. 4. To perform the function of update statement with and without WHERE clause 5. To perform the function of select statement using Boolean operators, logical operators, IN, BETWEEN, LIKE etc. 6. To perform the function of GROUP BY clause and ORDER BY clause. 7. To perform the function of DELETE statement with and without WHERE clause. 8. To perform the function of ALTER statement 9. To perform the function of inbuilt SQL Functions like SUM, MAX, MIN, AVG, COUNT, DISTINCT etc. 10. To create and modify the Sequences. 11. To create and modify the Indexes.

Upload: divyesh-kumar

Post on 28-Sep-2015

213 views

Category:

Documents


0 download

DESCRIPTION

Index

TRANSCRIPT

INDEX

S.NoName Of The ExperimentSIGN.

1.Introduction to DDL and DML

2.To create Table queries using constraints

3.To perform the function of Insert statement in table.

4.To perform the function of update statement with and without WHERE clause

5.To perform the function of select statement using Boolean operators, logical operators, IN, BETWEEN, LIKE etc.

6.To perform the function of GROUP BY clause and ORDER BY clause.

7.To perform the function of DELETE statement with and without WHERE clause.

8.To perform the function of ALTER statement

9.To perform the function of inbuilt SQL Functions like SUM, MAX, MIN, AVG, COUNT, DISTINCT etc.

10.To create and modify the Sequences.

11.To create and modify the Indexes.

12.To create and modify the View.