ERP003- Agile development/ Data BASE / SQL / ITIL

Part 1- Team Working, Agility, Data Base Design – 6 Sessions

1.Agility & Team Working 1

  • Agile Data Method
  • Why Working Together is Hard?
  • Ineffective Architecting/Data Modeling
  • Potential Symptoms of Problems
  • Agile Software Development
  • Agile DBA / Application Developer

2.Agility & Team Working 2

  • Software Development Visions
  • Understand The Challenges You Face
  • Actually, Try Agility In Real Projects
  • Block Non-Agile Coworkers
  • Be Realistic / Be Patient
  • How You Can Become Agile
  • Team Working is the Only Way
  • Visual Total Task Manager

3.Entity Relation/ Data Modeling  1

  • E-R & EER Models/Diagram
  • Data Base Basic Concepts
  • Relationship Sets ( 1:1 , 1:N )
  • Keys (Primary, Foreign)
  • Entity-Relationship Diagram
  • Enhanced Entity Relation(EER)

4.Entity Relation/ Data Modeling  2

  • Create Table –SQL Command
  • Implement ER Model with SQL
  • Sale-Sample Program 1
  • Employee-Sample Program 2
  • Patient-Sample E-R Diagram 1
  • Bank– Sample E-R Diagram 2
  • Bank, Loan-Sample Program 3

5.Entity Relation/ Data Modeling  3

  • Manufacturing– Sample E-R Diagram 3
  • Manufacturing– Sample Program 4
  • Chemical– Sample E-R Diagram 4
  • Labor, Job– Sample E-R Diagram 5
  • Patient- Project 1: Create Database with Data, Browse Tables (no relation)

6.Implementing Database Diagram

  • Patient-Project 2:
  • E-R Model Draw in WORD/ Paint
  • E-R Model to Text Base/ User Story
  • Create Tables with Data
  • Establishing All Relations
  • Browse Tables, Move Records
  • Analysis Result & Data Relationships

Part 2- Normalization, SQL Essentials Training by Example – 6 Sessions

7.Database Normalization

  • Functional Dependency/Normalization
  • Anomalies in Relational Database
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Boyce Codd Normal Form (BCNF)

8.SQL by Example 1

  • VFP Debugger, Open & Modify  D.B
  •  VFP Field type, Browse, Delete, Recall
  • SQL by example, Select, Upper, Lower
  • Select, Where, Distinct, Order
  • Select Alias, Export to Excel, Date Field
  • Select, Aggregate Function
  • Select Average, Sum, Min, Max
  • Select Char String Functions, Alltrim

9.SQL by example 2:

  • Logical Operator, Exact
  • BETWEEN, INLIST, DATE fields
  • Null, Empty, Like
  • CNT, MIN, MAX
  • Char String Functions / SUBSTR

10.SQL by example 3:

  • Numeric/Logical Expression
  • Expression Evaluation Priority
  • Join, Nested Join
  • Aggregate Function
  • Group By
  • Difference of HAVING&WHERE

11.SQL by example 4:

  • Patient problem solving (all features)
  • Create Data Base from E-R diagram
  • Nested Inner Join
  • Update, Physical Order
  • Install MySQL in your Computer

12.SQL by example 5:

  • Sale problem solving (all features)
  • Create Data Base & Import CSV data
  • Data Base to Text Base/ User Story
  • Create Tables with Data
  • Re-Execute all SQL commands in MYSQL
  • Analysis the Results