Database-Lab

Database Lab Homeworks

Overview

1. Introduction to SQL Fundamentals
2. Set operators, CASE, Group by, Having
3. Permissions, Login, Roles
4. Aggregate functions, Nested queries, Windowing, Grouping Sets, ROLLUP, CUBE
5. PPIVOT, Functions
6. Stored Procedure, Trigger,
7. Import-Export (BULK INSERT, OPENROWSET,xp_cmdshell, Bilk Copy Program)
8. Transactions

Contact

Find me at Elaheh Toulabinejad