Software development tools and environment

COURSE DESCRIPTION

The course provides an overview of various commonly used software development tools and environments. Basic emphasis is placed on tools for project management, business process analysis, database design, user interface generation, business intelligence, data warehouse design, and low- code/no-code application automated development.
As part of the practical part of the course, students acquire practical skills in working with various software development tools and environments, developing practical works both in the classroom and at home.

CONTENT

1. Software development tools and environments. Explanation of CASE concepts. Positive and negative characteristics of using tools. General description of software development tools
2. Use of CASE tools in the development of information systems. Classification of CASE tools. The most commonly used CASE tools and their use at different stages of program development
3. Software development project management tools. General project management tools Microsoft Project, Microsoft Visio, Workbench, etc. Software development project management tools Jira, Azure DevOps or equivalent
4. CASE tools in diagram modeling. Entity Relationship Diagram (ERD), Data Flow Diagram (DFD), Work Flow Diagram (WFD), Organizational Diagram (ORG), Business Process Diagram (BPD)
5. Entity Relationship Diagram (ERD) construction tools. Database design tools Power Designer, Toad Data Modeler or equivalent. Tool options. Conceptual data model and physical data model. Code generation. Reverse engineering
6. Business process modelling. Diagrams for business process modeling. Business Process Modeling Language Standards. Business Process Modeling Notation (BPMN). BPMN tools
7. Frameworks for generating data- and process-oriented user interfaces
8. Designing of data warehouses. Data warehouse structures. Data warehouse design tools
9. Data online analytical processing (OLAP). Cube structure. Building a cube using external data sources, query, multiple data sources
10. Business intelligence tools for extracting data from various data sources and processing them. Creating simple and complex reports. Data retrieval, cleaning, data structure creation and representation
11. Low-code/no-code platform capabilities for automated software development: data analysis, process automation, automated application generation and chatbot development