About Lesson
MODULE – 1 Introduction to RDBMS. 12 HOURS
a Overview Of Database Management System  
b Entity-Relationship Model  
c Relational Model  
d Structured Query Language  
e Database Security Na Recovery  


MODULE – 2 Introduction to MS SQL Server 8 HOURS
a The Basic Architecture of SQL server.  
b Versions editions and installation of MS SQL Server Express edition  
c Getting started with SQL server management studio  


MODULE – 3 Introduction T-SQL 24 HOURS
a Sets, Predicate logic  
b Creating tables using DML statements  
c Writing simple select statements  
d Filtering and sorting  
e Eliminating duplicates  
f Using exists, grouping, aggregate  
g Using table aliases, writing case example  
h Subqueries  
i Union, except and intersect operators  
j Joins, Inner and outer joins  


MODULE – 4 Advanced T-SQL 12 HOURS
a Creating stored procedures and triggers  
b Passing parameters to stored procedures  
c T_SQL error handling  
d Backup and recovery
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar