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

CSA05 LAB EXPERIMENTS

The document outlines a series of lab experiments focused on various SQL commands and programming extensions in MySQL. It includes exercises on DDL, DML, TCL, DCL commands, as well as advanced topics like queries with joins, views, and database connectivity using PHP. Additionally, it presents case scenarios for practical implementations such as a train ticket reservation system and a college admission form.

Uploaded by

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

CSA05 LAB EXPERIMENTS

The document outlines a series of lab experiments focused on various SQL commands and programming extensions in MySQL. It includes exercises on DDL, DML, TCL, DCL commands, as well as advanced topics like queries with joins, views, and database connectivity using PHP. Additionally, it presents case scenarios for practical implementations such as a train ticket reservation system and a college admission form.

Uploaded by

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

S. NO.

LAB EXPERIMENTS

1 DDL Commands using CREATE, ALTER , TRUNCATE and DROP

DDL Commands with Constraints – PRIMARY, FOREIGN KEY, UNIQUE,


2 CHECK, DEFAULT, NOT NULL

3 DML Commands using INSERT, SELECT

4 DML Commands using UPDATE, DELETE

5 TCL Commands – COMMIT, SAVEPOINT, ROLLBACK

6 DCL Commands – GRANT, REVOKE

7 SELECT with various clauses – WHERE, pattern matching

8 SELECT with various clauses – BETWEEN, IN, Aggregate Function

9 SELECT with various clauses – GROUP BY, HAVING, ORDER BY

10 Query with SubQuery& Correlated Query

11 Query with Joins – EquiJoin, InnerJoin, OuterJoin

12 Query with VIEW and INDEX

13 Query with AUTO_INCREMENT SEQUENCES

14 Simple programming using REPEAT and WHILE

15 Simple programming using CASE and LOOP

16 High Level Programming Extensions – Procedures

17 High Level Programming Extensions – Function

18 High Level Programming Extensions – Cursors

19 High Level Programming Extensions – Triggers

MYSQL String Functions- REPLACE, REPEAT, REVERSE, RIGHT, LEFT,


20 RPAD, LPAD

21 MYSQL String Functions- SPACE, SUBSTR, UPPER, LOWER, TRIM, LENGTH


S. NO. LAB EXPERIMENTS

22 Database Connectivity Using PHP and MYSQL

Case Scenario : MySQL Queries Implementation for Train Ticket


23 Reservation System to Receive Tickets through Social Network

Case Scenario : MySQL Queries Implementation for College Admission


24 Form

Case Scenario : MySQL Queries Implementation for QR Enabled Automatic


25 Bus Ticket Booking System

You might also like