Page 2
[ 1, 2, 3 ]
SQL for designing and naintaining Databases using PostgreSQL :
- Introduction to Database concept - Schema, Table, Record and Fields
- The SQL statements, Views, Triggers and procedures
- Advanced SQL usage - Nested queries, joins etc.
Object Oriented Analysis and Design, and use of UML :
- Life cycle of a software.
- The importance of documentation - UML as a documentation tool.
- Using Use-case diagram to document understanding of the user requirements.
- Using Class diagram to document the relations between classes identified in the system
- Using Activity diagram for documenting complex activities in the system
- Using State diagrams for dynamic objects having critical processing based on states
- Using Sequence diagram to show interaction between Objects within the system for an activity
Tools for Application Development :
- Agile methodology for development of a software
- JUnit
- Build tools
- Version control
- Debugging techniques
- Pragmatic Programming