[go: up one dir, main page]
Scribd
Upload
9 views2 pages

Index Dbms File

The document lists 20 SQL database practical topics including creating and modifying database objects, inserting, viewing, updating and deleting records, using constraints, aggregate functions, operators, string functions and joins.

Uploaded by

ANNU SHARMA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views2 pages

Index Dbms File

The document lists 20 SQL database practical topics including creating and modifying database objects, inserting, viewing, updating and deleting records, using constraints, aggregate functions, operators, string functions and joins.

Uploaded by

ANNU SHARMA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

INDEX

S.No. Name of Practical

1 Database, DBMS definition


2 Introduction to SQL, Installation of SQL server.
3 Components of SQL, Data types
4 Opening the Sql Server application of the computer and
connection to the database engine.
5 Creating a new project in to SQL server
6 Writing queries in to the Query Editor
7 DDL Queries or commands:
CREATE command to define a new database object, USE
command
8 Inserting values into the table
9 For Viewing Data In The Table
10 Elimination Of Duplicate Rows
11 Sorting Data In A Table
12 Modifying The Structure Of A Table :Alter Command
13 To drop a table from a database
14 To Update A Record(S) Of A Table

15 To delete a record(s) from a table

16 Constraints: NOT NULL, Primary Key, Foreign Key, Unique Key

17 Aggregate Functions: COUNT (), MAX (), MIN (), SUM ()


AND AVG ().

18 Predicate or Operators: LIKE , NOT LIKE, IN and


BETWEEN
19 String Functions: UPPER (),
LOWER(), CONCAT (), LEN (), REVERSE ()

20 SQL JOINS: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL


JOIN

You might also like