System analyst from zero to middle - course 142,080 rub. from Netology, training 12 months, Date August 14, 2023.

System Analyst, Skyeng

Teaches “Introduction to the Profession”, “Requirements Analysis”

Chief Analyst, Sber

Teaches “Introduction to the profession”, “Requirements analysis”, “Business process modeling”, “Testing and user training”

Software life cycle. Architecture
Gain insight into creating software products. You will learn about approaches to development in IT projects and types of information system architectures.
• The role of a systems analyst in software development
• Competencies of a systems analyst
• Software development life cycle
• Flexible methodologies and their development: Scrum, Kanban, lean manufacturing, Extreme Programming
• Types of architectures: local, file-server, client-server, three-layer, microservice

Requirements analysis
Learn to identify and fulfill customer requirements. Explore approaches to formalize, negotiate, and manage requirements change.
• Requirements for software development
• Requirements collection methods
• Methods for formalizing requirements
•Use Cases
• User Stories and Job Stories

• Coordination and management of requirements changes
• Unified Modeling Language (UML)
• Use case diagram
• Data flow diagram

Git and branching mechanisms
Learn why and how source code version control systems came into being. Get hands-on experience working with Git repositories.
• Purpose of a version control system
• Basic operations: committing and rolling back changes, search, history
• Working with the GitHub service
• Branches, branch merging and conflict resolution
• Team work with code
• Branching strategy. GitFlow
• Git for systems analyst

Development Basics
You will understand the types of programming languages, their terms and control structures. Master basic JavaScript syntax. Create your first project.
• Algorithms
• Variables, numbers and strings
• Code branching
• Multiple choice algorithm
• Errors in the code
• Arrays
• Cycles
• Subroutine, function
• Objects

System integration and API documentation
Learn about information systems integration methods. Review the OpenAPI specification. Learn to write application programming interfaces and publish them in Swagger.
• Process and levels of integration
• Integration approaches
• REST API, SOAP
• OpenAPI notation
• Swagger

Interface prototyping
Learn basic UX/UI principles. Get acquainted with the interface and basic functions of the Figma program. Master the process of creating an interface and interactive prototype.
• UX/UI Basics
• Behavior scenarios, Customer Journey Map
• A/B testing
• Basic principles of creating a layout
• Figma program overview
• Creation of an interface and interactive prototype

Software testing and deployment
Get acquainted with the main types and methods of testing. Understand the difference between QA and testing. Gain a basic understanding of modern development infrastructure. Learn how developers, testers and system administrators interact. Become familiar with the basic goals and concepts of DevOps.
• Manual and automated testing 
• Developer mode in the browser
• Basic DevOps practices
• CI/CD principles
• Containerization and orchestrators
• Overview of Docker, Kubernetes, Ansible, Terraform, Jenkins

Business Process Modeling
You will understand why business process modeling is needed and get acquainted with several approaches. You will understand which notation to use for different cases. Gain hands-on modeling skills in multiple tools.
• Business process modeling tasks
• BPMN and BPMN 2.0 notations
• AS-IS, TO-BE approaches
• Camunda Modeler
• Overview of the IDEF methodology
• Modeling in IDEF0, IDEF3 notations

Documentation in IT projects
You will understand the types of project documentation, the structure and purpose of artifacts. Gain insight into the application of BMC and CJM. Review documentation standards and learn about actual documentation processes within the software development cycle.
• Coordination and management of requirements changes
• Project documentation and artifacts
• Business Model Canvas
• Customer Journey Map
• Software requirements specification and technical specifications
• Documentation standards
• Approaches to documentation in IT projects

SQL for data analysis
Learn to retrieve, filter, aggregate, import and export data from databases - databases - using SQL.
• Set theory. Introduction to Relational Algebra
• Analysis of difficulties and issues when working with the environment
• Database Basics. Load scaling in a DBMS
• SQL Basics
• Deep dive into SQL
• Working with PostgreSQL
• Working with MongoDB
• Laboratory work on the block

SQL PRO
Learn advanced SQL tools to design, normalize, and denormalize databases.
• Working from the command line
• Output event triggers
• Database design. Client-server architecture model. Relational model
• Database normalization and denormalization
• Function scaling

Data Analysis in Python
You will be able to work with major analytical libraries using Python. Master visualization and statistics. Learn to delve into data, find connections and generate hypotheses.
• Control constructs and collections 
• Working with the file system and modules
• Exceptions and error handling
• Regular expressions and parsing basics
• NumPy library
• Pandas library

DWH design
Get to know the types of data warehouses. Take a closer look at DWH. You will understand its architecture and capabilities. Using an example, you will analyze popular tools for working with it.
• Concept of database, DBMS, data warehouse
• Architecture and principles of DWH construction
• Types of customers in the DWH development process
• Data Quality and Data Governance
• Overview of tools for working with DWH

BI solutions and multidimensional data model
Understand how to identify the needs and requirements of business users. Get to know Tableau and Power BI.
• Business Intelligence as the heart of analytics
• Getting to know Pentaho BI
• Multidimensional models
• Pentaho Analysis Services
• Real-time reporting
• Modern approaches

Final project
In the thesis, you will go through the main stages of DWH development: from collecting requirements and creating a DWH diagram to presenting data on visual dashboards. You will be supported by your thesis supervisor. An expert will analyze the work and explain how to improve it. You can work on your own project. If it is not available, we will provide training and requirements for it.