The course covers from database theories, concepts, normalization, conceptual data modeling, logical data modeling, physical data modeling, building tables in database, creating constraints, implementing indexes, SQL statements (SELECT, INSERT, UPDATE, DELETE), Join (Inner, Outer, Cross), developing user-defined functions, views, stored procedures and implementing server-side business rules using triggers.
This course fits all types of Windows/ Web/ Mobile developers whose purpose is to build data processing applications. Lecture will be delivered using Microsoft SQL server but the same concept/ technique can be applied in all types of RDBMS like MySQL.c