02-2832610, 2832611

Database Modeling, Design & Implementation

Using Microsoft SQL Server

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.c

What will 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
  • Length

96 hours

  • Effort

8 hours per week

  • Length

300,000 MMK

  • Delivery

20% theoretical + 80% practical

  • Validation

75% attendance

  • Institude

iNet College

  • Week-Day Section

Monday - Thursday

2 hours per day

  • Weekend Section

Saturday and Sunday

4 hours per day

More Courses

66 (A) Street
Bet:Theikpan Street & 43rd Street, Mandalay
info@inet.edu.mm
02-2832610, 2832611

2000-2020 iNet College