Database Modeling, Design & Implementation

Database Modeling, Design & Implementation

Using Microsoft SQL Server

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

Database Modeling, Design & Implementation

  • Length

96 hours

  • Effort

8 hours per week

  • Price

300,000 MMK

  • Delivery

20% Theoretical + 80% hands-on practical

  • Validation

75% attendance

  • Institution

iNet College

  • Sections

Week-Day Section

Monday to Thursday

(2 hours per day)

Weekend Section

Saturday and Sunday

(4 hours per day)

More Courses

Our Programmes and Courses

University Partnership

Diploma Awarding Partner