INDEX
S.No TOPIC DATE
1 Introduction to Ms Access
2 Introduction to SQL
3 Create Database & Tables in MySQL
4 Insert values in a Table in MySQL
➔ Insert Multiple records at once
5 Retrieve records from a Table in MySQL
➔ Retrieve Distinct values
6 Using different Operators in Where clause in
MySQL (AND, OR, NOT, IN, BETWEEN,
LIKE)
7 Sort the Records fetched from a table in
MySQL
8 Create Alias names of a table’s attributes in
MySQL
➔ Creating new table from existing table
➔ Inserting new record in a table from
another table
9 Delete records from a table in MySQL
➔ Truncate command
➔ Drop table command
10 Update the values of a Record in a MySQL
table
11 Alter the Attributes of a MySQL table
➔ Add an attribute
➔ Modify an attribute
➔ Drop an attribute
➔ Rename an attribute
➔ Rename a relation
12 Constraints
-> Add using Create table command
-> Add using Alter table command
-> Drop constraints
13 Practice Questions set 1
14 Applying Aggregate functions
-> Using Group By clause
15 Perform Set operations on Tables
-> Union
-> Union All
-> Intersect
16 Creating views using SQL
17 Practice Questions set 2
18 Applying numeric, string, date & time
functions in SQL
19 Creating Sequences
20 Indexes- create, alter, show, drop
21 Joins in SQL
➔ Cross join
➔ Inner join
➔ Natural join
➔ On condition, Using clause
➔ Left outer join, Right outer join
➔ Full outer join
➔ Self-join
22 Creating Nested queries in SQL
23 Practice Questions set 3
24 Stored procedures and functions- create,
call, drop
25 Triggers-Create, Alter, Drop
