International Certification Program Programmer Fundamentals + PHP -Mysql + Java Se 17 OCP and Spring Professional Develop (Spring Core - Spring Boot)

International Certification Program Programmer Fundamentals + PHP -Mysql + Java Se 17 OCP and Spring Professional Develop (Spring Core - Spring Boot)

Módulos

1.1. Conceptos de algoritmo y su importancia  

  • Definición de algoritmos  
  • Estructura de un algoritmo: Entrada, Proceso y Salida  
  • Tipos de algoritmos: iterativos, recursivos y algorítmicos  
  • Ejemplos de algoritmos en la vida real  

1.2. Pensamiento computacional y resolución de problemas  

  • Descomposición de problemas en pasos más pequeños  
  • Reconocimiento de patrones y abstracción  
  • Estructura de la solución: Desarrollo y optimización  
  • Diseño de algoritmos eficientes  

1.3. Práctica: Resolución de problemas simples con pseudocódigo  

  • Modelado de problemas reales con pseudocódigo  
  • Conversiones entre pseudocódigo y diagramas de flujo  
  • Ejercicio práctico: Desarrollo de un pseudocódigo para resolver un problema matemático

2.1. Diagramas de casos de uso  

  • Identificación de actores  
  • Diagramas de escenarios principales y alternativos  
  • Casos de uso extendidos y generales  

2.2. Diagramas de secuencia  

  • Representación de la interacción entre objetos y eventos  
  • Modelado del flujo de datos y secuencia de mensajes  

2.3. Diagramas de actividades  

  • Representación de actividades, decisiones y flujos alternativos  
  • Diagramas de actividad con particiones (swimlanes)

3.1. Tipos de datos y operadores  

  • Tipos de datos primitivos: enteros, reales, booleanos, cadenas de texto  
  • Operadores aritméticos, lógicos, de comparación, asignación y bit a bit  
  • Conversión de tipos de datos (casting)  

3.2. Estructuras de control condicionales y bucles  

  • Sentencias condicionales: if, else, elif, switch  
  • Bucles controlados por contadores: for y while  
  • Bucles controlados por condiciones: do-while  
  • Conceptos de recursión vs iteración  

3.3. Declaración y uso de funciones  

  • Funciones de retorno y sin retorno  
  • Parámetros por valor y por referencia  
  • Funciones anidadas y recursivas  
  • Uso de funciones lambda  

3.4. Práctica: Resolución de problemas con funciones  

  • Ejercicios de descomposición funcional para resolver problemas  
  • Modularización de código para mejorar la reutilización

4.1. Listas, tuplas, diccionarios y conjuntos  

  • Operaciones básicas en estructuras de datos: creación, actualización, eliminación  
  • Métodos y operaciones avanzadas: append, pop, sort, reverse  
  • Diccionarios y manejo de pares clave-valor  

4.2. Algoritmos de ordenación (burbuja, selección)  

  • Implementación paso a paso de algoritmos de ordenación  
  • Complejidad temporal y espacial: O(n^2), O(n log n)  
  • Comparación entre algoritmos de ordenación: eficiencia y uso adecuado  

4.3. Algoritmos de búsqueda (binaria, lineal)  

  • Implementación de búsqueda secuencial y búsqueda binaria  
  • Condiciones necesarias para usar la búsqueda binaria  
  • Comparación de complejidades  

4.4. Práctica: Implementación de algoritmos en Python  

  • Ejercicios de búsqueda y ordenación con listas y diccionarios  
  • Optimización de código de búsqueda para grandes volúmenes de datos

5.1. Conceptos básicos de objetos y clases  

  • Definición de objetos, clases, atributos y métodos  
  • Encapsulamiento, abstracción y modularidad  

5.2. Creación de objetos y métodos  

  • Creación y uso de objetos en Python  
  • Métodos públicos, privados y protegidos  

5.3. Herencia y polimorfismo  

  • Concepto de herencia y reusabilidad de clases  
  • Métodos sobreescritos y polimorfismo  

5.4. Práctica: Modelado de objetos y su interacción  

  • Ejercicio práctico para modelar entidades usando POO

6.1. Tipos de bases de datos (relacionales y no relacionales)  

  • Diferencias clave entre bases de datos relacionales y no relacionales  
  • Ejemplos de bases de datos relacionales (MySQL, PostgreSQL) y no relacionales (MongoDB)  
  • Cuándo usar una base de datos relacional vs una no relacional  

6.2. Componentes de bases de datos: Tablas, filas, columnas  

  • Definición y creación de tablas  
  • Relaciones entre tablas: uno a uno, uno a muchos y muchos a muchos  
  • Tipos de datos en SQL: VARCHAR, INT, DATE, etc.

7.1. Diagramas entidad-relación  

  • Definición de entidades, atributos y relaciones  
  • Creación de diagramas ER para representar modelos de datos  

7.2. Claves primarias y foráneas  

  • Definición de claves primarias y cómo garantizan la unicidad de registros  
  • Claves foráneas y su importancia en la vinculación de tablas  

7.3. Normalización de bases de datos  

  • Concepto de normalización y sus niveles (1FN, 2FN, 3FN)  
  • Ejercicios prácticos para evitar la redundancia en las bases de datos

8.1. Creación de tablas y relaciones  

  • Sintaxis básica de SQL: CREATE TABLE, ALTER TABLE  
  • Definición de restricciones (PRIMARY KEY, UNIQUE, NOT NULL)  

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

  • Consultas de lectura: SELECT con filtros, operadores y ordenación  
  • Consultas de inserción, modificación y eliminación de datos: INSERT INTO, UPDATE, DELETE  

8.3. Funciones de agregación: COUNT, SUM, AVG  

  • Uso de funciones para calcular agregados sobre conjuntos de datos  
  • Agrupación de datos con GROUP BY y filtrado con HAVING

  • Sintaxis  
  • Operadores  
  • Variables  
  • Estructuras de control  
  • Constructores de lenguaje y funciones  
  • Namespaces  
  • Extensiones  
  • Config  
  • Caché de rendimiento / bytecode

  • Argumentos  
  • Variables  
  • Referencias  
  • Retorno  
  • Alcance variable  
  • Funciones anónimas, cierres  
  • Escribe declaración

  • Introducción a XML  
  • SimpleXml  
  • Extensión xml  
  • Introducción a Servicios Web  
  • SOAP  
  • JSON  
  • DateTime  
  • DOMDocument

  • Sesiones  
  • Formularios  
  • Datos Enviados por GET y POST  
  • Cookies  
  • Cabeceras HTTP  
  • Autenticaciones HTTP  
  • Códigos de estado HTTP

  • Instanciación  
  • Modificadores / Herencia  
  • Interfaces  
  • Tipos de retorno  
  • Autoload  
  • Reflection  
  • Type Hinting  
  • Constantes de clase  
  • Enlace estático tardío  
  • Métodos mágicos (_ *)  
  • Instancia, métodos y propiedades  
  • Standard PHP Library (SPL)  
  • Rasgos

  • Configuración  
  • Seguridad de la Sesión  
  • XSS - Cross-Site Scripting  
  • CSRF - Cross-Site Request Forgeries  
  • Inyección SQL  
  • Inyección de código remoto  
  • Inyección por mail  
  • Filtrar la entrada / Escapar la salida (Filter your input / escape your output)  
  • Algoritmos de encriptación y hash  
  • Subir archivos  
  • Configuración php  
  • Password hashing API

  • Archivos  
  • Lectura  
  • Escritura  
  • Funciones del sistema de archivos  
  • Corrientes  
  • Contextos

  • Delimitadores de cadenas  
  • Comparaciones  
  • Extracciones  
  • Búsquedas  
  • Sustituciones  
  • Formateo  
  • Expresiones regulares compatibles de Perl (PCRE)  
  • HEREDOC y NOWDOC  
  • Codificaciones de caracteres

  • SQL  
  • JOINS  
  • Prepared Statements  
  • Transacciones  
  • PHP Data Objects (PDO)

  • Arrays asociativos  
  • Recorrer un array  
  • Funciones Arrays  
  • SPL, objetos y arrays  
  • Casteo

  • Manejo de excepciones
  • Errores
  • Throwables

  • Key features of the Java language  
  • Java technology and development environment  
  • Running and testing a Java program

  • Java classes
  • The Main method
  • Adding a Main method

  • Introducing variables
  • Working with strings
  • Working with numbers
  • Manipulating numeric data

  • Working with conditions
  • Using IF statements
  • Working with a list of items
  • Processing a list of items

  • Working with objects and classes  
  • Defining fields and methods  
  • Declaring, instantiating, and initializing objects  
  • Working with object references  
  • Doing more with arrays

  • Using the String class  
  • Using the Java API docs  
  • Using the StringBuilder class  
  • More about primitive data types  
  • More numeric operators  
  • Promoting and casting variables

  • Using methods  
  • Method arguments and return values  
  • Static methods and variables  
  • How arguments are passed to a method  
  • Overloading a method

  • Access control
  • Encapsulation
  • Overloading constructors

  • Relational and conditional operators  
  • More ways to use IF/ELSE constructs  
  • Using switch statements  
  • Using the Netbeans debugger

  • Working with dates  
  • Parsing the args array  
  • Two-dimensional arrays  
  • Alternate looping constructs  
  • Nesting loops  
  • The ArrayList class

  • Overview
  • Working with subclasses and superclasses
  • Overriding methods in the superclass
  • Creating and extending abstract classes

  • Polymorphism  
  • Polymorphism in the JDK foundation classes  
  • Using interfaces  
  • Local-variable type inference  
  • Using the List interface  
  • Introducing Lambda expressions

  • Overview  
  • Propagation of exceptions  
  • Catching and throwing exceptions  
  • Handling multiple exceptions and errors

  • Packages, JARs, architecture
  • Application modification and requirements

  • The Module system  
  • JARs  
  • Module declarations  
  • Modular JDK

  • Testing code  
  • JShell basics  
  • JShell in an IDE

  • Functional Interfaces and Lambda Expressions  
  • Collections Streams, and Filters  
  • Built-in Functional Interfaces

  • Introduction to Modular Programming in Java  
  • Services in a Modular Application  
  • Migration to a Modular Application

  • Concurrency  
  • Parallel Streams  
  • Terminal Operations: Collectors  
  • Creating Custom Streams

  • I/O (Fundamentals and NIO2)
  • Secure Coding
  • Database Applications with JDBC
  • Localization

  • What is the Collections Framework?
  • Iterators
  • Type-Wrapper Classes
  • What are Generics?

  • Exceptions
  • Error handling
  • Assertions

  • What is the Spring Framework?
  • The DI Container
  • The Spring Framework History and EcoSystem

  • Java configuration and the Spring application context
  • @Configuration and @Bean annotations
  • @Import: working with multiple configuration files
  • Defining bean scopes
  • Launching a Spring Application and obtaining Beans

  • External properties & Property sources
  • Environment abstraction
  • Using bean profiles
  • Spring Expression Language (SpEL)

  • Component scanning
  • Autowiring using @Autowired
  • Java configuration versus annotations, mixing
  • Lifecycle annotations: @PostConstruct and@PreDestroy
  • Stereotypes and meta-annotations

  • The Spring Bean Lifecycle
  • The BeanFactoryPostProcessor interception point
  • The BeanPostProcessor interception point
  • Spring Bean Proxies
  • @Bean method return types

  • What problems does AOP solve?
  • Defining pointcut expressions
  • Implementing various types of advice

  • Spring and Test-Driven Development
  • Spring 5 integration testing with JUnit 5
  • Application context caching and the @DirtiesContext annotation
  • Profile selection with @ActiveProfiles
  • Easy test data setup with @Sq

  • How Spring integrates with existing data access technologies
  • Spring?s JdbcTemplate
  • DataAccessException hierarchy

  • Transaction overview
  • Transaction management with Spring
  • Transaction propagation and rollback rules
  • Transactions and integration testing

  • Introduction to Spring Boot Features
  • Value Proposition of Spring Boot
  • Creating a simple Boot application using Spring Initializer website

  • Dependency management using Spring Boot starters
  • How auto-configuration works
  • Configuration properties
  • Overriding auto-configuration
  • Using CommandLineRunner

  • Quick introduction to ORM with JPA
  • Benefits of using Spring with JPA
  • JPA configuration in Spring
  • Configuring Spring JPA using Spring Boot
  • Spring Data JPA dynamic repositories

  • Introduction to Spring MVC and request processing
  • Controller method signatures
  • Using @Controller, @RestController and @GetMapping annotations
  • Configuring Spring MVC with Spring Boot
  • Spring Boot packaging options, JAR or WAR

This course is designed to train software programming participants, combining programming foundations with advanced technologies in PHP, MySQL, Java Se 17 and Spring Boot. Prepare students to obtain international certifications such as:

  • Programmer Fundament Software (SOFTF-001)
  • Certified Php Engineer (200-710)
  • Java Se 17 OCP (Oracle Certified Professional) (1Z0-829)
  • Spring Professional Develop (2v0-72
  • 22)
  • The course is ideal for people interested in developing reliable software in Linux/Windows environments, including architects, programmers and database administrators
  • Following the practical Learning Method methodology, participants will apply the knowledge acquired in real projects, through laboratories and business simulations

At the end of the course, students can:

  • Fundamentals of programming and PHP-MYSQL
  • Understand the principles of programming and control structures
  • Apply software modeling techniques with UML
  • Program applications in PHP with connection to MySQL databases
  • Implement PHP security, including XSS, CSRF and SQL injection
  • Development in Java Se 17
  • Write Java code using POO (object oriented programming)
  • Manage exceptions, collections, threads and concurrence in Java
  • Implement databases with JDBC and JPA
  • Create applications in Java is 17 applying good practices and modularity
  • Spring Boot and Business Applications Development
  • Configure Spring Boot and Spring Core with Java Config and Annotations
  • Implement applications with Spring Data (JPA, JDBC)
  • Develop APIS Rest with Spring Boot and Webclient
  • Apply Spring Boot security with authentication and authorization
  • Practical approach:
  • Students will apply each concept through laboratories in real development environments, ensuring their preparation for the labor market and official certifications

To register in this course, participants must have:

  • Basic knowledge of computer science and management of operating systems

International Certification Program Programmer Fundamentals + PHP -Mysql + Java Se 17 OCP and Spring Professional Develop (Spring Core - Spring Boot) Applies
International Certification Program Programmer Fundamentals + PHP -Mysql + Java Se 17 OCP and Spring Professional Develop (Spring Core - Spring Boot) 212 hours

Learning Methodology

The learning methodology, regardless of the modality (in-person or remote), is based on the development of workshops or labs that lead to the construction of a project, emulating real activities in a company.

The instructor (live), a professional with extensive experience in work environments related to the topics covered, acts as a workshop leader, guiding students' practice through knowledge transfer processes, applying the concepts of the proposed syllabus to the project.

The methodology seeks that the student does not memorize, but rather understands the concepts and how they are applied in a work environment.

As a result of this work, at the end of the training the student will have gained real experience, will be prepared for work and to pass an interview, a technical test, and/or achieve higher scores on international certification exams.

Conditions to guarantee successful results:
  • a. An institution that requires the application of the model through organization, logistics, and strict control over the activities to be carried out by the participants in each training session.
  • b. An instructor located anywhere in the world, who has the required in-depth knowledge, expertise, experience, and outstanding values, ensuring a very high-level knowledge transfer.
  • c. A committed student, with the space, time, and attention required by the training process, and the willingness to focus on understanding how concepts are applied in a work environment, and not memorizing concepts just to take an exam.

Pre-enrollment

You do not need to pay to pre-enroll. By pre-enrolling, you reserve a spot in the group for this course or program. Our team will contact you to complete your enrollment.

Pre-enroll now

Infinity Payments

Make your payment quickly, safely and reliably


- For bank transfer payments, request the details by email capacita@aulamatriz.edu.co.

- If you wish to finance your payment through our credit options
(Sufi, Cooperativa Unimos or Fincomercio), click on the following link:
Ver opciones de crédito.

To continue you must

Or if you don't have an account you must

Description

This course is designed to train software programming participants, combining programming foundations with advanced technologies in PHP, MySQL, Java Se 17 and Spring Boot. Prepare students to obtain international certifications such as:

  • Programmer Fundament Software (SOFTF-001)
  • Certified Php Engineer (200-710)
  • Java Se 17 OCP (Oracle Certified Professional) (1Z0-829)
  • Spring Professional Develop (2v0-72
  • 22)
  • The course is ideal for people interested in developing reliable software in Linux/Windows environments, including architects, programmers and database administrators
  • Following the practical Learning Method methodology, participants will apply the knowledge acquired in real projects, through laboratories and business simulations

Objectives

At the end of the course, students can:

  • Fundamentals of programming and PHP-MYSQL
  • Understand the principles of programming and control structures
  • Apply software modeling techniques with UML
  • Program applications in PHP with connection to MySQL databases
  • Implement PHP security, including XSS, CSRF and SQL injection
  • Development in Java Se 17
  • Write Java code using POO (object oriented programming)
  • Manage exceptions, collections, threads and concurrence in Java
  • Implement databases with JDBC and JPA
  • Create applications in Java is 17 applying good practices and modularity
  • Spring Boot and Business Applications Development
  • Configure Spring Boot and Spring Core with Java Config and Annotations
  • Implement applications with Spring Data (JPA, JDBC)
  • Develop APIS Rest with Spring Boot and Webclient
  • Apply Spring Boot security with authentication and authorization
  • Practical approach:
  • Students will apply each concept through laboratories in real development environments, ensuring their preparation for the labor market and official certifications

To register in this course, participants must have:

  • Basic knowledge of computer science and management of operating systems

offers

International Certification Program Programmer Fundamentals + PHP -Mysql + Java Se 17 OCP and Spring Professional Develop (Spring Core - Spring Boot) Applies
International Certification Program Programmer Fundamentals + PHP -Mysql + Java Se 17 OCP and Spring Professional Develop (Spring Core - Spring Boot) 212 hours

Learning Methodology

The learning methodology, regardless of the modality (in-person or remote), is based on the development of workshops or labs that lead to the construction of a project, emulating real activities in a company.

The instructor (live), a professional with extensive experience in work environments related to the topics covered, acts as a workshop leader, guiding students' practice through knowledge transfer processes, applying the concepts of the proposed syllabus to the project.

The methodology seeks that the student does not memorize, but rather understands the concepts and how they are applied in a work environment.

As a result of this work, at the end of the training the student will have gained real experience, will be prepared for work and to pass an interview, a technical test, and/or achieve higher scores on international certification exams.

Conditions to guarantee successful results:
  • a. An institution that requires the application of the model through organization, logistics, and strict control over the activities to be carried out by the participants in each training session.
  • b. An instructor located anywhere in the world, who has the required in-depth knowledge, expertise, experience, and outstanding values, ensuring a very high-level knowledge transfer.
  • c. A committed student, with the space, time, and attention required by the training process, and the willingness to focus on understanding how concepts are applied in a work environment, and not memorizing concepts just to take an exam.

Pre-enrollment

You do not need to pay to pre-enroll. By pre-enrolling, you reserve a spot in the group for this course or program. Our team will contact you to complete your enrollment.

Download Syllabus