About this course

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.

Prerequisite

• Programming in any language
• Will be more beneficial if you have developed applications in the field of data processing (TPS, MIS)

Who is this course for?

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.

What will you learn?

• Introducing to RDBMS
• Database modeling & design (ER-Modeling)
• Creating tables
• RDBMS internal data management
• Constraints
• SQL queries (SELECT, WHERE, GROUP BY, HAVING, etc.)
• Joining tables (INNER, OUTER, CROSS, SELF)
• Adding rows with INSERT, INSERT-SELECT
• Modifying data using DELETE & UPDATE
• Programming in SQL
• Positioned updates using CURSOR
• Functions & Stored-procedures
• Views
• Creating server-side business rules using Triggers

Values and Benefit

• Comprehensive RDBMS data processing skill
• Able to implement the learnt concept in all RDBMS