International Certification Software Programmer Fundamentals + Python PDA + C Sharp Azure Developer Associate (AZ-204) Program

Software Programmer Fundamentals

• General description of monitoring in Azure.
• Instrumenting an application for monitoring.
• Analysis and troubleshooting of applications.
• Implementing code that handles transient failures.

2.1. Use Case Diagrams

• Identification of actors.
• Diagrams of main and alternative scenarios.
• Extended and general use cases.

2.2. Sequence Diagrams

• Representation of the interaction between objects and events.
• Modeling of data flow and message sequence.

2.3. Activity Diagrams

• Representation of activities, decisions, and alternative flows.
• Activity diagrams with partitions (swimlanes)

3.1. Data Types and Operators

• Primitive data types: integers, floats, booleans, strings.
• Arithmetic, logical, comparison, assignment, and bitwise operators.
• Data type conversion (casting).

3.2. Conditional Control Structures and Loops

• Conditional statements: if, else, elif, switch.
• Counter-controlled loops: for and while.
• Condition-controlled loops: do-while.
• Concepts of recursion vs iteration.

3.3. Declaration and Use of Functions

• Return and non-return functions.
• Parameters by value and by reference.
• Nested and recursive functions.
• Use of lambda functions.

3.4. Practice: Problem Solving with Functions

• Functional decomposition exercises to solve problems.
• Code modularization to enhance reusability.

4.1. Lists, Tuples, Dictionaries, and Sets

• Basic operations on data structures: creation, updating, deletion.
• Advanced methods and operations: append, pop, sort, reverse.
• Dictionaries and handling key-value pairs.

4.2. Sorting Algorithms (Bubble, Selection)

• Step-by-step implementation of sorting algorithms.
• Time and space complexity: O(n^2), O(n log n).
• Comparison between sorting algorithms: efficiency and appropriate usage.

4.3. Search Algorithms (Binary, Linear)

• Implementation of sequential search and binary search.
• Necessary conditions to use binary search.
• Comparison of complexities.

4.4. Practice: Implementation of Algorithms in Python

• Exercises on searching and sorting with lists and dictionaries.
• Optimization of search code for large volumes of data.

5.1. Basic concepts of objects and classes

• Definition of objects, classes, attributes, and methods.
• Encapsulation, abstraction, and modularity.

5.2. Creation of objects and methods

• Creation and use of objects in Python.
• Public, private, and protected methods.

5.3. Inheritance and polymorphism

• Concept of inheritance and class reusability.
• Overridden methods and polymorphism.

5.4. Practice: Modeling objects and their interaction

• Practical exercise to model entities using OOP.

6.1. Types of Databases (Relational and Non-relational)

• Key differences between relational and non-relational databases.
• Examples of relational databases (MySQL, PostgreSQL) and non-relational databases (MongoDB).
• When to use a relational database vs a non-relational one.

6.2. Database Components: Tables, Rows, Columns

• Definition and creation of tables.
• Relationships between tables: one-to-one, one-to-many, and many-to-many.
• Data types in SQL: VARCHAR, INT, DATE, etc.

7.1. Entity-Relationship Diagrams

• Definition of entities, attributes, and relationships.
• Creation of ER diagrams to represent data models.

7.2. Primary and Foreign Keys

• Definition of primary keys and how they ensure the uniqueness of records.
• Foreign keys and their importance in linking tables.

7.3. Database Normalization

• Concept of normalization and its levels (1NF, 2NF, 3NF).
• Practical exercises to avoid redundancy in databases.

8.1. Creation of tables and relationships

• Basic SQL syntax: CREATE TABLE, ALTER TABLE.
• Definition of constraints (PRIMARY KEY, UNIQUE, NOT NULL).

8.2. SQL Queries: SELECT, INSERT, UPDATE, DELETE

• Read queries: SELECT with filters, operators, and sorting.
• Data insertion, modification, and deletion queries: INSERT INTO, UPDATE, DELETE.

8.3. Aggregate functions: COUNT, SUM, AVG

• Use of functions to calculate aggregates over data sets.
• Data grouping with GROUP BY and filtering with HAVING.

Python Developer Associate PDA

• What is Python
• Variables and basic data types
• Reading keyboard input

• Outputs
• Input Collection

• If statement
• Else and elif statements
• And and or operators

• Strings in Python
• String Methods in Python
• String Formatting in Python
• Operators
• Numbers
• Conversion of Strings to Numbers and Use of Absolute Values

• Introduction to lists
• Working with numbers in lists
• Manipulation of list data

• While
• For
• Dictionaries
• Dynamic programming with dictionaries

• Functions
• Function arguments
• Keyword arguments
• Variable arguments

• Lambdas
• Regular expressions
• Data comprehension

• Classes and objects
• Constructor of a class
• Attributes
• Inheritance
• Encapsulation
• Polymorphism

• How to find errors
• Controlling exceptions
• Generating exceptions

• Working with the file system
• Directories and files
• Create a file, manage files

C# - Asp.net Core MVC

Programming in C#

• Overview of writing applications using C#
• Data types, operators, and expressions
• Constructs of the C# programming language

• Create and invoke methods
• Creating overloaded methods and using optional and output parameters
• Exception control
• Monitoring applications

• Creation of classes
• Definition and implementation of Interfaces
• Implementation of collection type safety

• Creating class hierarchies
• Extending .NET Framework classes
• Creating generic types

• Reading and writing files
• Serialize and deserialize data
• Perform using input-output streams

• Creation and use of entity data models
• Querying data using LINQ
• Updating data using LINQ

• Using XAML to design a user interface
• Data binding controls
• A stylish user interface

• Multitasking application using tasks and Lambda expressions
• Performing operations asynchronously
• Concurrent access to synchronized data

• Examination of the metadata object
• Creation and use of custom attributes
• Generation of managed code
• Version control, signing, and deployment of assemblies

Developing ASP.NET MVC Web Applications

• Planning in the project design phase
• Design of models, controllers, and views

• Configuration of Middlewares
• Configuration of Services

• Writing drivers and actions
• Route configuration
• Writing action filters

• Create views with Razor syntax
• Use of HTML Helpers and Tag Helpers
• Reusing Code in V

• Create MVC models
• Working with forms
• Validate the M application

• Introduction to Entity Framework Core
• Working with Entity Framework Core
• Using Entity Framework Core to connect to Microsoft SQL Server

• Use of layouts
• Using CSS and JavaScript
• Using jQuery

• Apply styles
• Use of Task Runners
• Responsive design

• Authentication in ASP.NET Core
• Authorization in ASP.NET Core
• Defense against attacks

• Implementation of a caching strategy
• Management state
• Bidirectional communication

• Introduction to Web API
• Developing a Web API
• Calling a Web API

C# - International Certification Azure Developer Associate (AZ-204)

• Basic concepts of Azure App Service
• Create a web application with Azure App Service
• Configuration and monitoring of applications with App Service
• Scaling applications with App Service
• Storage environments of Azure App Service

• Overview of Azure Functions
• Development of Azure Functions
• Implementing Durable Functions

• Basic concepts of Azure Blob storage
• Managing the lifecycle of Azure Blob storage
• Working with Azure

General overview of Azure Cosmos DB

Data structure of Azure Cosmos DB

Working with Azure Cosmos DB resources and data

• Provisioning virtual machines (VMs) in Azure
• Creating and deploying ARM templates
• Creating container images for solutions
• Publishing a container image in Azure Container Registry
• Creating and running container images in Azure Container Instances

• Microsoft Identity Platform v2.0
• Authentication with Microsoft Authentication Library
• Using Microsoft Graph
• Authorize data operations in Azure storage

• Manage keys, secrets, and certificates using the KeyVault API
• Implement managed identities for Azure resources
• Secure application configuration data using Azure App Configuration

• Overview of API Management
• Definition of policies for APIs
• Securing APIs

• General description of Azure Logic Apps
• Create custom connectors for Logic Apps

• Implement solutions that use Azure Event Grid
• Implement solutions that use Azure Event Hubs
• Implement solutions that use Azure Notification Hubs

• Implement solutions that use Azure Service Bus
• Implement solutions that use Azure Queue Storage queues

General overview of monitoring in Azure.

Instrumenting an application for monitoring.

Analysis and troubleshooting of applications.

Implementing code that handles transient failures.

• Developing for Azure Cache for Redis
• Developing for CDN storage