INTERNATIONAL CERTIFICATION PROGRAM SOFTWARE PROGRAMMER FUNDAMENTS + PHP-MYSQL + ANDROID

INTERNATIONAL CERTIFICATION PROGRAM SOFTWARE PROGRAMMER FUNDAMENTS + PHP-MYSQL + ANDROID

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

Este módulo consta de 12 horas, cubre completamente el modelo de seguridad de Android y las preocupaciones tanto del desarrollador como del punto de vista del usuario final.

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 declaraciones

  • 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
  • Codigos de estado HTTP

  • Instanciación
  • Modificadores / Herencia
  • Interfaces
  • Tipos de retorno
  • Autoload
  • Reflection
  • Type Hinting
  • Constantes de clase
  • Enlace estático tardio
  • Métodos mágicos (_ *)
  • Instancia, metodos 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
  • Configuracion 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

  • Kotlin History
  • Kotlin Advantages
  • How Kotlin Programs Work?
  • Kotlin Software Prerequisites
  • IntelliJ IDEA
  • Installing IntelliJ IDE
  • Creating a Kotlin Program
  • Running a Kotlin Program
  • The main( ) function
  • Writing Comments
  • Kotlin Variables
  • Kotlin Data Types
  • Input of Information to Kotlin Program

  • Introduction
  • If Statement
  • If ? Else Statement
  • If Else and Logical Operators
  • When Statement and Expression
  • For Loops
  • While Loops
  • Do-while Loops
  • Jump Expressions
  • Break Statement
  • Continue Statement
  • Return Statement
  • Functions
  • Function Structure
  • Creating a Function
  • Functions and Variable Scope

  • Object-Oriented Programming (OOP)
  • Object
  • Class
  • Creating a Class
  • Providing Constructors for Your Classes
  • Class Inheritance
  • Abstract Class
  • Interface Class
  • Generic Class
  • Class Variables
  • Member Variables
  • Kotlin Collections
  • Hashmaps
  • ArrayList
  • listof and mutableListOf

  • Introduction
  • Android Platform Architecture
  • Android Libraries
  • Components of Android Application
  • Types of Android processes and their priorities
  • Android Studio
  • Creating Kotlin Project Using Android Studio
  • Run Android App
  • Instant Run
  • Setup an Android Virtual Device
  • What is Android Studio Gradle?
  • Run your Apps on a Hardware Device (Physical Phone)
  • Run your Android App on Android Phone

  • Introduction
  • Android Project Structure
  • View
  • Adding a View to your application
  • Adding a View in an XML layout file
  • Adding a View using Kotlin code
  • Configuring Layout Views
  • Creating a User Interface
  • Adding a Text Box
  • Adding an Image
  • Adding a Check Box
  • Adding a Radio Button

  • Introduction
  • Views
  • Layouts
  • Constraint Layout
  • Linear Layout
  • Relative Layout
  • TableRow Layout
  • Frame Layout
  • Android Styles and Themes
  • App Manifest
  • App Icons

  • Snackbar Class
  • What is an Activity?
  • Activity Lifecycle
  • Managing the activity lifecycle
  • Android Intent 
  • Navigating Between Activities
  • Passing Data between Activities
  • Android Alert Dialog
  • Android Notifications
  • Creating an Android Notification
  • Notification Channel

  • Progress Bar
  • Seek Bar
  • Date and Time Picker Dialogs
  • Creating a Date Picker
  • Creating a Ttime Picker
  • Calendar View
  • Web View
  • Rating Bar
  • Video View
  • Texture View

  • Menus
  • Bottom AppBar
  • Recycler View
  • SearchView
  • TabLayout and ViewPager
  • Spinner
  • Drawer

  • Introduction
  • What is the JSON?
  • How does Firebase Database work?
  • Firebase Authentication (Signup and Login Android App)
  • Configure your App to use Firebase Services
  • Configuring Firebase Authentication
  • Using Firebase Assistant with Android Studio
  • Firebase Database
  • Real Time Database
  • Cloud Firestore Database

  • Introduction
  • What is GPS and how does it work?
  • Latitude and Longitude
  • Camera Position
  • Adding Google Maps to an Android app
  • Map Fragment
  • Getting a Google API key
  • Adding a Google Map Marker
  • Capture a Users Location on Google Maps
  • Reverse Geolocation on Google Map
  • Retrieving a Readable Address on Google Map

  • Testing and Feedback Your App
  • Setting up a Test Environment
  • Usability Testing by Participants
  • Starting Your Test Session
  • Analyzing Your Test
  • Firebase Test Lab
  • Publishing Android App on Google Play Store
  • Preparing your app for release
  • Publish App on Google Play Store

  • Introduction
  • Android Platform Architecture
  • Android Security Architecture
  • Application Signing
  • Installing Applications
  • Permissions
  • Why Permissions?
  • Enforcing Permissions
  • Levels of Permissions Protection
  • Application
  • Level Permissions
  • Component
  • Level Permissions
  • Extending Android Permissions

  • Introduction
  • The Manifest File
  • Manifest Tag Attributes
  • Application Tag Attributes
  • Modifying the Application Policy
  • Application Running with the Same Linux ID
  • Setting Application Permissions
  • Permissions for External Applications
  • External Storage
  • Debugging Mode
  • Backup

  • Introduction
  • Data Security Principles
  • Confidentiality
  • Integrity
  • Availability
  • The Mobile Environment
  • Data States
  • Vulnerabilities and Attacks Against Stored Data
  • Vulnerabilities of Stored Data
  • Threats on Stored Data
  • Protection Principles
  • Tips for Android Coding Vulnerabilities

  • Introduction
  • Data Storage Decisions
  • Privacy
  • Data Storage Period
  • Storage Mech
  • Introduction
  • Data Storage Decisions
  • Privacy
  • Data Storage Period
  • Storage Mech
  • SharedPreferences
  • File
  • File Operations on an External Storage
  • Cache
  • Database

Este modulo consta de 12 horas, que cubre exhaustivamente las preocupaciones sobre las aplicaciones de Android UI / UX Design y las técnicas de monetización de las aplicaciones Andoid UI / UX Design y publicidad de las aplicaciones de Android.

  • Introduction
  • UX Designer
  • UI Designer
  • The Difference between UI and UX Design
  • Understanding Users? and Business needs
  • Strategy and Content
  • What is Content Strategy?
  • Wire-framing and Prototyping
  • Uses of App Wireframes and Prototypes
  • Wireframes Levels
  • Elements of Wireframes and Prototypes
  • The difference between Wireframe and Prototype
  • Execution and Analytics
  • Usability and User?s Feeling
  • Testing and Feedback
  • Visual design and user?s interaction
  • Functionality
  • Compatibility, performance and stability
  • Security
  • Setting up a Test Environment
  • Usability Testing by Participants
  • Starting Your Test Session
  • Analyzing Your Test

  • Introduction
  • Why is wireframe the first step
  • Do?s and Don?ts for a Successful UX design
  • Paper Prototyping
  • Storyboard That Software
  • Adobe XD (Experience Design)

  • Introduction
  • Pizza Pizza Application
  • The Weather Network Application

  • Introduction
  • Different Monetization Techniques
  • Paid Applications
  • Lite vs. Pro
  • dvertising and Ad Mediation
  • In-App Purchase
  • Subscriptions
  • Ad Format
  • Ad Types
  • Best Technique for Your Business
  • Adding In-App Ads to Your Android Application
  • Revenue Metrics

  • Introduction
  • Preparing your App for Release
  • Releasing your App to Users
  • Releasing your App through an Application Marketplace
  • Releasing your Application through Email
  • Releasing Through a Web Site
  • Signing your Application
  • The Publishing Process on Google Play
  • Google Play In-App Billing Service
  • Releasing App Best Practices

  • Introduction
  • Licensing your Application
  • Google Play Licensing
  • Setting up Licensing
  • Adding Licensing to Your App
  • Monitoring your App
  • Benefits
  • Using Google Analytics

The program is designed to introduce participants in the world of software programming, with a practical approach in the development of web applications using PHP and MYSQL. This program prepares participants to obtain international certifications:

  • Programmer Fundament Software (Softf-001)
  • Zend Certified Php Engineer (Exam 200-710)
  • Participants will learn to develop software from scratch, applying data structures, algorithms and object -oriented programming principles (POO)
  • In addition, they will focus on the creation and management of databases with MySQL, guaranteeing solid training in the development of dynamic and safe applications
  • Following the practical Learning Method approach, students will develop practical laboratories, simulations and real projects, ensuring the application of knowledge acquired in a work environment

At the end of the course, participants will be able to:

  • Understand the foundations of programming, including control structures and functions
  • Apply principles of programming logic and computational problem resolution
  • Develop dynamic web applications using PHP and MYSQL
  • Structure relational databases, guaranteeing the integrity and security of information
  • Apply good programming practices, including web applications
  • Obtain international certifications Software Programmer Fundares and Zend Certified PHP Engineer, validating your knowledge to the industry

To participate in this training, attendees must meet the following requirement:

  • Basic knowledge of computer science
  • This requirement guarantees that participants can focus on programming without initial technical difficulties

INTERNATIONAL CERTIFICATION PROGRAM SOFTWARE PROGRAMMER FUNDAMENTS + PHP-MYSQL + ANDROID Applies
INTERNATIONAL CERTIFICATION PROGRAM SOFTWARE PROGRAMMER FUNDAMENTS + PHP-MYSQL + ANDROID 156 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

The program is designed to introduce participants in the world of software programming, with a practical approach in the development of web applications using PHP and MYSQL. This program prepares participants to obtain international certifications:

  • Programmer Fundament Software (Softf-001)
  • Zend Certified Php Engineer (Exam 200-710)
  • Participants will learn to develop software from scratch, applying data structures, algorithms and object -oriented programming principles (POO)
  • In addition, they will focus on the creation and management of databases with MySQL, guaranteeing solid training in the development of dynamic and safe applications
  • Following the practical Learning Method approach, students will develop practical laboratories, simulations and real projects, ensuring the application of knowledge acquired in a work environment

Objectives

At the end of the course, participants will be able to:

  • Understand the foundations of programming, including control structures and functions
  • Apply principles of programming logic and computational problem resolution
  • Develop dynamic web applications using PHP and MYSQL
  • Structure relational databases, guaranteeing the integrity and security of information
  • Apply good programming practices, including web applications
  • Obtain international certifications Software Programmer Fundares and Zend Certified PHP Engineer, validating your knowledge to the industry

To participate in this training, attendees must meet the following requirement:

  • Basic knowledge of computer science
  • This requirement guarantees that participants can focus on programming without initial technical difficulties

offers

INTERNATIONAL CERTIFICATION PROGRAM SOFTWARE PROGRAMMER FUNDAMENTS + PHP-MYSQL + ANDROID Applies
INTERNATIONAL CERTIFICATION PROGRAM SOFTWARE PROGRAMMER FUNDAMENTS + PHP-MYSQL + ANDROID 156 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