*Changes may apply

Syllabus System Analyst

Introduction to PC, Servers, Networks

Knowing the Personal computer

  • Windows OS fundamentals and administration
  • Quick introduction: Google Drive, Docs, and Meet, MS Office 365, SharePoint, Teams
  • Managing your data and hard disk

 

Quick review of Windows server, concepts and tools

  • Windows server administration
  • Active Directory
  • Permissions management
  • DHCP & DNS

 

Introduction to networking and security

  • Network Devices: Routers, modem, repeaters etc.
  • IP Addressing, IPv4/6, TCP/IP Model
  • Lan/Wan, Network architectures
  • How to build a secured organization network?
Introduction to Linux
  • Linux OS fundamentals
  • Installing and configuring Linux
  • System Administration
  • File system on Linux
Basic Java Programming
  • The IDE: working with IntelliJ
  • Representation of numbers:
    • Decimal, Binary and Hexadecimal
    • Moving between representations
    • Boolean logic: Using AND, OR, NOT and combinations.
  • Introduction to programming and flow diagrams
  • Java development environment, compiling, executing and debugging
  • Variables, arrays, strings, and other basic data types
  • Math and string operand, operations, and functions
  • Flow control: terms, loops, conditionals, functions and more
  • Introduction to Object Oriented Programming and Inheritance
  • Working with files. XML and JSON formats
  • Java APIs. Web and REST APIs
  • Using AI tools for faster coding, Gemini, Duet and others
  • Version control for your code with Git and GitHub
From Spreadsheets to Databases, SQL and Big Data
  • Introduction: Collect data with Google Forms and present it with Google Sheets
  • Working with Excel: row and columns, conditional formatting, duplication removal, data validation, functions, pivot tables, visualization, basic scripting
  • Using AI for spreadsheet data processing and visualization
  • What is a database and why we need it?
  • Cardinality and ERD
  • SQL basics: select, order, group by, sum, count
  • Types of variables and how to handle them with SQL
  • SQL using several tables: join, over
  • SQL analytical functions
  • DDL vs. DML commands
  • Stored procedures
  • Database Structures
  • Using AI tools for writing SQL
  • Accessing a database from Java
  • Big Data in modern high-tech companies
  • Introduction to cloud technologies and Google Cloud Platform
  • Introduction to Google BigQuery

Development Processes and Tools
  • The software life cycle
  • Development models, Waterfall, Iterative, Scrum
  • Being Agile and using Jira
  • System models concepts, Monolith and Microservices
  • Introduction to Automation
    • Shell and basic scripting
    • CI/CD concepts
    • Working with Jenkins: install and configure, using plugins, scheduling and notifications
Testing
  • Introduction to testing and automation
  • Testing levels: Unit testing, Integration testing, System testing and Acceptance testing.
  • Testing types and considerations: Functional, Security, Load, Compatibility, User experience, Regression.
  • JUnit, Postman, and other tools
Working in a High-Tech Company
  • Working with customers
  • Customer support & service management
  • Project management
  • Time management
Implementing Customer Relation Management “CRM” System
  • Introduction
  • Items and lists, build-in and custom objects, searching, building pages
  • Data Import and export, data manipulation and validation
  • Analysis and reports
  • Users and permissions management
  • Advanced implementation topics
  • Automation, synchronous vs asynchronous processes, hierarchy of processes.
Power Skills

The Power Skills chapter will focus on developing essential skills necessary for career success. The practical exercises and tips included in this chapter will help the students to develop and refine their abilities in public speaking, time and task management, teamwork, decision making, interviewing, personal LinkedIn page and resume, and business English for Hi-tech industry.

Read More