Visão Geral

Sempre que você estiver na web, você chegará a páginas PHP. De acordo com a maioria das contas, mais de um milhão de sites foram escritos em PHP, incluindo alguns dos maiores e mais conhecidos sites da atualidade. E esses sites geralmente usam MySQL como banco de dados.

Isso significa que há uma demanda contínua por desenvolvedores da Web que saibam usar PHP e MySQL em nível profissional.

Objetivo

Após concluir o curso, você aprenderá:

• a linguagem PHP
• o banco de dados MySQL
• as instruções SQL para MySQL
• as extensões PDO e mysqli
• o padrão MVC
• depuração e tratamento de exceções
• sessões e cookies
• PHP orientado a objetos
• expressões regulares e validação de dados
• SSL e conexões seguras
• formulários de autenticação e login
• e-mail e conteúdo de outros sites (como o YouTube)
• uploads de arquivos
• e mais!

Publico Alvo

• Desenvolvedores que desejam aprender como usar PHP e MySQL para construir sites baseados em banco de dados.
  

Pre-Requisitos

• Uma compreensão básica dos conceitos de internet e programação seria vantajosa.
  

Informações Gerais

Carga Horária: 40h

• Se noturno este curso é ministrado de Segunda-feira à sexta-feira, das 19h às 23h
• Se aos sábados este curso é ministrado das 9h às 18h
• Se in-company por favor fazer contato para mais detalhes.

Formato de entrega: 

• 100% on-line ao vivo, via Microsoft Teams na presença de um instrutor/consultor ativo no mercado.
• Nota: não é curso gravado. 

Lab:

• Laboratório + Exercícios práticos

Materiais

Conteúdo Programatico

Introduction to web development with PHP

1. The architecture of a web application
2. How to edit and test a PHP application
3. How to use NetBeans to develop a PHP application

How to code a PHP application

1. Basic PHP skills
2. How to get data from a request
3. How to work with data
4. How to code control statements
5. How to use the PHP documentation

Introduction to relational databases and MySQL

1. An introduction to relational databases
2. The SQL statements for data manipulation
3. An introduction to MySQL
4. How to use phpMyAdmin

How to use PHP with a MySQL database

1. PHP for working with MySQL
2. How to get data from a result set

How to use the MVC pattern

1. An introduction to the MVC pattern
2. How to code functions
3. How to redirect requests

How to test and debug a PHP application

1. An introduction to testing and debugging
2. How to debug with xDebug and NetBeans

How to work with form data

1. How to get data from a form
2. How to display data on a web page

How to code control statements

1. How to code conditional expressions
2. How to code the selection structures
3. How to code the iteration structures

How to work with strings and numbers

1. How to work with strings
2. How to work with numbers
3. Other skills for working with strings and numbers

How to work with dates

1. How to use timestamps to work with dates
2. How to use objects to work with dates

How to create and use arrays

1. How to create and use an array
2. How to create and use an associative array
3. How to use functions to work with arrays
4. How to work with arrays of arrays

How to work with cookies and sessions

1. How to work with cookies
2. How to work with sessions

How to create and use functions

1. Basic skills for working with functions
2. How to create and use a library of functions
3. Advanced skills for working with functions

How to create and use objects

1. How to create and use classes
2. How to code class constants, properties, and methods
3. Additional skills for working with How to work with inheritance

How to use regular expressions, handle exceptions, and validate data

1. How to use regular expressions
2. How to handle exceptions

How to design a database

1. How to design a data structure
2. How to normalize a data structure
3. A database design tool

How to use SQL to create a MySQL database

1. How to work with databases
2. How to work with tables
3. How to work with indexes
4. How to work with users and privileges
5. Other skills for creating a database

Professional PHP for working with MySQL

1. Three ways to use PHP to work with MySQL
2. How to work with PDO
3. How to work with mysqli

How to create secure web sites

1. How to use a secure connection
2. How to use authentication
3. How to work with encrypted data

How to send email and access other web sites

1. How to send email
2. How to get data from other servers

How to work with files, uploads, and images

1. How to work with files
2. How to upload a file
3. How to work with images