Course Overview | Course Objectives | Course Contents | Workshop Benefits
Who Should Attend | Pre-requisite | Delivery Method |Trainers Profile
Data Modeling and Database Design for Developers
September 19 - 20, 2008 @ Bangalore, INDIA
Data Modeling and Database design is an important activity when designing and developing Software. Very few Software Professionals are formally trained in this area. This workshop is specially formulated for Team Leads and Senior Software Engineers who are responsible for Designing and Developing Software Modules.
Proper training of Software Professionals in this area will help Organizations improve the quality of software that they produce. It will also eliminate rework time during development and testing, which is often caused by poor Database Design.
The Workshop will formally train Software Professionals in Data Modeling and Database Design during the Software Design Phase. A case study based approach is adopted in order to give the participants an understanding of their practical application.
Participants will also be trained on using a freeware Database Design tool, which works with all popular databases.
- Why Data Modeling and Database Design
- The E-R Model
- The Planning and Analysis Process
- Identifying Data Objects and Relationships
- Developing the Basic Schema
- Refining the E-R Diagram
- Primary, Foreign and Secondary Keys
- Add Attributes to the Model
- Generalization Hierarchies
- Add Data Integrity Rules
- The Relational Model
- The ACID Model
- Joins
- Inner Join
- Left/Right/Full Outer Join
- NULL Values and Joins - Normal Forms
- First Normal Form
- Second Normal Form
- Third Normal Form
- Fourth Normal Form
- Fifth Normal Form - Meeting Performance objectives
- Impact of Reports on the Database
- Introduction to freeware tool for Database Design
- Case Studies / Exercises
Benefits/Takeaways / Workshop Motivation
The workshop will:
- Help the participants in implementing good Data Modeling and Database Design techniques in their applications.
- Introduce a freeware tool that will help them to implement what they have learnt effectively and easily.
- Address database integrity and performance objectives.
Project Leads, Teams Leads and Senior Software Engineers who are responsible for Designing and Developing Software Modules.
A background in Software Development or IT Support with basic knowledge of Databases and SQL.
Delivery Method - The course is instructor lead with practical examples, case studies and exercises designed to enable participants learn and implement the concepts.
Shobha Ramesh has a career spanning 20 years in the IT industry in organizations such as Satyam, SLK Software, Kirloskar Computer Services Ltd and BFL Software Ltd.
She has over 12 years of experience as a Project / Program Manager and has handled projects of sizes ranging from 1 – 100 person-years on UNIX, J2EE, Microsoft, TIBCO and Livelink platforms in various types of client engagement models like offshore model, onsite-offshore model, multi-site / multi-vendor model, staff augmentation model etc.
She has managed large ODCs containing development, maintenance and production-support activities.
As part of her project management activities, she has specialized in product development and in Release & Configuration Management for large projects with multiple teams.
She has managed projects for a wide variety of customers including domestic, US, Japanese, Chinese and Australian customers in the Retail, Automotive, Banking, Manufacturing and Business Performance Measurement domains.
Shobha’s analysis and design skills include OOAD, SSAD, Database Modeling and UML.
Shobha has completed her M.Sc in Mathematics in 1985 from IIT Chennai.
Some of the organizations where Shobha has trained:
- HCL Shipara Technologies
- IBM
- Intellinet
- Microsoft
- Misys
- Satyam Computer