Introduction to Agile:

• What is project management?
• Classic (Waterfall) vs Agile methodology
• The Agile Manifesto

Application of the Scrum methodology:

• Scrum methodology and roles
• Scrum Ceremonies

Working with Jira using the Scrum methodology:

• Teamwork

Kanban and IT project management using Waterfall and Agile:

• Introduction to the Kanban methodology
• IT project jargon
• Project management tools

• The emergence of testing
• Why is testing important?
• What are the qualities of a good tester?
• Types of testing
• Development of test scenarios and cases
• Testing environment
• Differences between manual and automated testing

Creating, filling, deleting tables

• Creating tables - CREATE statement;
• Data types;
• Primary key/foreign key, indexes, uniqueness;
• Commenting on columns;
• Filling tables - INSERT statements;
• Deleting tables - TRUNCATE/DROP/DELETE statements;
• Normalization rules

Creating queries

• The query statement is SELECT;
• Connecting several tables - LEFT/RIGHT JOIN;
• Primary key/foreign key;

Introduction to standard functions

• Standard functions such as UPPER, LOWER, SUM, MAX, MIN, CASE, etc.;
• Sorting/grouping functions ORDER BY/ GROUP BY;

Introduction to tools and software.

• Introduction to Power BI (history, what it's used for)
• Connecting to data (external files and databases
• Core functionality of Power BI
• Data types
• Data analysis process (sheets/ dashboard/story)
• Creating new columns/parameters/sets
• Using formulas to create new columns of data
• Data filtering, sorting
• Creating color palettes and icons
• Applying graphs in Power BI (practical problem solving)

HTML, CSS:

• HTML elements and attributes
• HTML elements are designed for search engines
• Creating a style
• Page layout
• Responsive design
• Familiarity with CSS libraries

JavaScript:

• Functions
• Objects and their properties
• Dynamic creation of HTML elements
• Managing browser caches (localStorage and sessionStorage)
• JSON reading and data mapping
• Familiarity with JavaScript libraries

• Prototyping (Figma)
• Website programming
• Presentation of theses

1. Communication skills

• Active listening
• Effective communication
• Dealing with difficult customers
• Creating a connection

2. Problem solving strategies

• Problem analysis and diagnostics
• Determination of solutions
• Troubleshooting methods
• Root cause analysis of the problem
• Latest problem solving technologies
• How to get feedback from managers
• Professional development

3. Time management and organization

• Prioritization of tasks
• Workload management
• Delegation and collaboration

4. Emotional intelligence

• Understanding and managing emotions
• Empathy and compassion
• Conflict resolution
• Stress management

5. How to learn more and faster and less
to forget

•  5 minute brain exercise
• Clear your "mental fog" with these 5
  delicious brain foods
•  Learn a powerful memory technique to
  you would never miss a meeting