1. Principles of information systems design based on UML. Basic concepts, software support. Life cycle of information systems design.
2. Requirements analysis in system and information engineering - creating functional and non-functional requirements, syntax, priority, status.
3. Identification of use cases – analysis of actors, use cases, scenarios a input/output constraints, relations.
4. Modeling of project's dynamic phase – sequence/communication diagrams, activity diagrams.
5. The static view of an information system - conceptual, design and implementation stages of the static model, the basic elements of the model class / data model.
6. Implementation phase of information systems design – component diagrams and deployment diagrams.
7. Testing of information system, process verification and validation, software deployment, documentation composition and generating of installation materials.
8. Installing and configuration of SQL Server, databases and files management, database tools, SQL, transaction processing.
9. Creating a database - the data object, data types, keys, indexes, constraints.
10. Data manipulation - the SQL query language, fundamentals queries, joins, grouping, views.
11. Flow control - stored procedures, cursors, triggers.
12. Fundamentals of ASP.NET design – configuration of database connection, Grid View, Data View, data security.
2. Requirements analysis in system and information engineering - creating functional and non-functional requirements, syntax, priority, status.
3. Identification of use cases – analysis of actors, use cases, scenarios a input/output constraints, relations.
4. Modeling of project's dynamic phase – sequence/communication diagrams, activity diagrams.
5. The static view of an information system - conceptual, design and implementation stages of the static model, the basic elements of the model class / data model.
6. Implementation phase of information systems design – component diagrams and deployment diagrams.
7. Testing of information system, process verification and validation, software deployment, documentation composition and generating of installation materials.
8. Installing and configuration of SQL Server, databases and files management, database tools, SQL, transaction processing.
9. Creating a database - the data object, data types, keys, indexes, constraints.
10. Data manipulation - the SQL query language, fundamentals queries, joins, grouping, views.
11. Flow control - stored procedures, cursors, triggers.
12. Fundamentals of ASP.NET design – configuration of database connection, Grid View, Data View, data security.