| 13-3-2023 |
1.5 hours |
Introduction of Database Systems its Practical Use, Course Contents. |
Task |
|
|
1.5 hours |
Introduction to SQL Server Sql Server Installation, Data Types Identifier |
Task |
|
| 20-3-2023 |
1.5 hours |
DDL, DML DCL commands Create Database Query Create Table in SQL Queries, |
task |
|
|
1.5 hours |
Primary keys Foreign keys Concept and implementation using Ecommerce database, Select statement Queries, |
task |
|
| 27-3-2023 |
1.5 hours |
Ecommerce Database Example Activity, From statement Queries, |
task |
|
|
1.5 hours |
Data Insert Into Table queries , Where all related Queries in SQL |
task |
|
| 3-4-2023 |
1.5 hours |
Like In Between queries, Distinct |
Task |
|
|
1.5 hours |
Skip, Take, Top, Aliases, In SQL queries implementation using Ecommerce database |
Task |
|
| 10-4-2023 |
1.5 hours |
Alter Table, Add Drop, Rename, Modify a Column Statements queries. |
task |
|
|
1.5 hours |
Operators in SQL Arithmetic Operators Logical Operators Comparison Operators Special Operators Set Operators |
task |
|
| 17-4-2023 |
1.5 hours |
Constraints in SQL Not null, Unique, Default And check |
task |
|
|
1.5 hours |
Complex queries Class task to run different queries. |
task |
|
| 24-4-2023 |
1.5 hours |
Truncate, Drop, Delete database and table Difference b/w truncate drop and delete. |
task |
|
|
1.5 hours |
Practice complex queries |
task |
|
| 1-5-2023 |
1 Hour |
Mid Term |
|
|
| 8-5-2023 |
1.5 hours |
Mid Term Exam |
Mid Term Exam |
|
|
1.5 hours |
Mid Term Exam |
Mid Term Exam |
|
| 15-5-2023 |
1.5 hours |
SQL Alias |
task |
|
|
1.5 hours |
Practice Queries Task |
task |
|
| 22-5-2023 |
1.5 hours |
Group By , having& Order By queries, |
task |
|
|
1.5 hours |
Introduction to Sub Queries Single Row subqueries |
task |
|
| 29-5-2023 |
1.5 hours |
Outer join Left outer join Right outer join Self-Join. |
task |
|
|
1.5 hours |
Functions in SQL Number Functions Aggregate Functions Character Functions Conversion Functions Date Functions |
task |
|
| 5-6-2023 |
1.5 hours |
Store Procedures |
task |
|
|
1.5 hours |
Triggers |
task |
|
| 12-6-2023 |
1.5 hours |
Views |
task |
|
|
1.5 hours |
Indexing |
task |
|
| 19-6-2023 |
1.5 hours |
Backup and Recovery COMMIT ROLLBACK SAVEPOINT |
task |
|
|
1.5 hours |
Microsoft visual studio installation Introduction to Visual studio |
task |
|
| 26-6-2023 |
1.5 hours |
Database Connectivity Database connectivity using C# with SQL Server |
task |
|
|
1.5 hours |
Data Accessibility Managing Users Managing Passwords Managing Roles |
task |
|
| 3-7-2023 |
2 Hour |
Final Term |
|
|
