| 21-March-2022 |
1.5 hours |
Introduction of Database Systems its Practical Use, Course Contents. |
Lab Task |
|
|
1.5 hours |
Introduction to SQL Server Sql Serve Installation, Data Types Identifier |
Lab Task |
|
| 28-March-2022 |
1.5 hours |
DDL, DML DCL commands Create Database Query Create Table in SQL Queries, |
Lab Task |
|
|
1.5 hours |
Primary keys Foreign keys Concept and implementation using Ecommerce database, Select statement Queries, |
Lab Task |
|
| 4-April-2022 |
1.5 hours |
Ecommerce Database Example Activity, From statement Queries, |
Lab Task |
|
|
1.5 hours |
Data Insert Into Table queries , Where all related Queries in SQL, Assignment#1. |
Lab Task |
|
| 11-April-2022 |
1.5 hours |
Like In Between queries, Distinct Quiz#1. |
Lab Task |
|
|
1.5 hours |
Skip, Take, Top, Aliases, In SQL queries implementation using Ecommerce database, |
Lab Task |
|
| 18-April-2022 |
1.5 hours |
Alter Table, Add Drop, Rename, Modify a Column Statements queries. |
lab task |
|
|
1.5 hours |
Operators in SQL Arithmetic Operators Logical Operators Comparison Operators Special Operators Set Operators |
lab task |
|
| 25-April-2022 |
1.5 hours |
Constraints in SQL Not null, Unique, Default And check |
lab task |
|
|
1.5 hours |
Complex queries Class task to run different queries. |
lab task |
|
| 2-May-2022 |
1.5 hours |
Truncate, Drop, Delete database and table Difference b/w truncate drop and delete. QUIZ 2 |
lab task |
|
|
1.5 hours |
Practice complex queries |
lab task |
|
| 9-May-2022 |
1 Hour |
Mid Term |
|
|
| 16-May-2022 |
1.5 hours |
SQL Alias |
Lab task |
|
|
1.5 hours |
Practice Queries Task |
Lab Task |
|
| 23-May-2022 |
1.5 hours |
Group By , having& Order By queries, Assignment#2 |
lab task |
|
|
1.5 hours |
Introduction to Sub Queries Single Row subqueries |
lab task |
|
| 30-May-2022 |
1.5 hours |
Multiple row subqueries All And Any Operators, Exist And Not Exist |
Lab task |
|
|
1.5 hours |
All Joins and their use. Simple Inner join Quiz#3 |
Lab task |
|
| 6-June-2022 |
1.5 hours |
Outer join Left outer join Right outer join Self-Join. |
lab task |
|
|
1.5 hours |
Functions in SQL Number Functions Aggregate Functions Character Functions Conversion Functions Date Functions |
lab task |
|
| 13-June-2022 |
1.5 hours |
Store Procedures |
lab task |
|
|
1.5 hours |
Triggers |
lab task |
|
| 20-June-2022 |
1.5 hours |
Views |
Lab Task |
|
|
1.5 hours |
Indexing |
Lab Task |
|
| 27-June-2022 |
1.5 hours |
Backup and Recovery COMMIT ROLLBACK SAVEPOINT |
Lab Task |
|
|
1.5 hours |
Xampp server installation Introduction to xampp |
Lab Task |
|
| 4-July-2022 |
1.5 hours |
Database Connectivity Introduction to php and html |
Lab Task |
|
|
1.5 hours |
Database connectivity using php |
Lab Task |
|
| 11-July-2022 |
2 Hour |
Final Term |
|
|
