Web Design
Building Dynamic Web Sites with LAMP Stack
Building Dynamic Web Sites with MySQL and PHP
Creating a LAMP Stack

Building Dynamic Web Sites with MySQL and PHP

Course Number:
wd_lamp_a02_it_enus
Lesson Objectives

Building Dynamic Web Sites with MySQL and PHP

  • start the course
  • compare different methods to connect MySQL with PHP
  • install and configure MySQLi
  • use persistent connections with MySQLi
  • use prepared statement with MySQLi
  • use stored procedure with MySQLi
  • use multiple statements with MySQLi
  • create transactions with MySQLi
  • create database and tables by using MySQLi
  • insert data into database by using MySQLi
  • retrieve data from database by using MySQLi
  • update data by using MySQLi
  • delete data by using MySQLi
  • insert, update, delete, and retrieve data by using MySQLi
  • install and configure PDO
  • create connections by using PDO
  • create transactions and autocommit by using PDO
  • use prepared statements with PDO
  • use stored procedure with PDO
  • use error handling with PDO
  • create database and tables in MySQL by using PDO
  • insert data into database by using PDO
  • retrieve data from database by using PDO
  • update data by using PDO
  • delete data by using PDO
  • insert, update, delete, and retrieve data by using PDO

Overview/Description
Dynamic web sites are highly in demand and are created by using PHP and MySQL. In this course, you will learn to connect PHP with MySQL by using MySQLi and PDO. You will also learn to create, retrieve, update, and delete data in MySQL by using PHP, and display the result on a web page.

Target Audience
This course is targeted toward individuals who wish to create LAMP stacks and use them in Web development.

Building Dynamic Web Sites with MySQL and PHP

Course Number:
wd_lamp_a02_it_enus
Lesson Objectives

Building Dynamic Web Sites with MySQL and PHP

  • start the course
  • compare different methods to connect MySQL with PHP
  • install and configure MySQLi
  • use persistent connections with MySQLi
  • use prepared statement with MySQLi
  • use stored procedure with MySQLi
  • use multiple statements with MySQLi
  • create transactions with MySQLi
  • create database and tables by using MySQLi
  • insert data into database by using MySQLi
  • retrieve data from database by using MySQLi
  • update data by using MySQLi
  • delete data by using MySQLi
  • insert, update, delete, and retrieve data by using MySQLi
  • install and configure PDO
  • create connections by using PDO
  • create transactions and autocommit by using PDO
  • use prepared statements with PDO
  • use stored procedure with PDO
  • use error handling with PDO
  • create database and tables in MySQL by using PDO
  • insert data into database by using PDO
  • retrieve data from database by using PDO
  • update data by using PDO
  • delete data by using PDO
  • insert, update, delete, and retrieve data by using PDO

Overview/Description
Dynamic web sites are highly in demand and are created by using PHP and MySQL. In this course, you will learn to connect PHP with MySQL by using MySQLi and PDO. You will also learn to create, retrieve, update, and delete data in MySQL by using PHP, and display the result on a web page.

Target Audience
This course is targeted toward individuals who wish to create LAMP stacks and use them in Web development.

Creating a LAMP Stack

Course Number:
wd_lamp_a01_it_enus
Lesson Objectives

Creating a LAMP Stack

  • start the course
  • describe the Linux architecture
  • install the Linux operating system
  • work with the Linux command line
  • edit a file using the vi editor
  • start and stop a network service
  • install the Apache Web server on Linux
  • start and verify the HTTPd daemon on Linux
  • view the access and error logs of the Apache web server
  • store data in a table in RDBMS
  • install MySQL on Linux
  • start and verify the MySQL service on Linux
  • set password for the root user in MySQL
  • create a user and a database in MySQL
  • create a table and add data in MySQL
  • install PHP packages in Linux
  • use if...else statements and switch operators for controlling flow
  • use while and for loops in PHP
  • connect PHP with the MySQL database server
  • select data from the MySQL table and display the table
  • install and use phpMyAdmin to add and view data
  • create users and assign permissions by using phpMyAdmin
  • install LAMP and then connect PHP with the MySQL server

Overview/Description
Since LAMP is a very popular stack to create dynamic web sites, it is important for the Web developers to understand the various technologies used in this stack. In this course, you will learn to create a LAMP stack by installing the Linux operating system and using the Linux command line. You will also learn to install the Apache Web server, host a page on the Apache Web server, and install and work with the MySQL database. In addition, you will install the PHP language and learn the basics of this language.

Target Audience
This course is targeted toward individuals who wish to create LAMP stacks and use them in Web development.

Creating a LAMP Stack

Course Number:
wd_lamp_a01_it_enus
Lesson Objectives

Creating a LAMP Stack

  • start the course
  • describe the Linux architecture
  • install the Linux operating system
  • work with the Linux command line
  • edit a file using the vi editor
  • start and stop a network service
  • install the Apache Web server on Linux
  • start and verify the HTTPd daemon on Linux
  • view the access and error logs of the Apache web server
  • store data in a table in RDBMS
  • install MySQL on Linux
  • start and verify the MySQL service on Linux
  • set password for the root user in MySQL
  • create a user and a database in MySQL
  • create a table and add data in MySQL
  • install PHP packages in Linux
  • use if...else statements and switch operators for controlling flow
  • use while and for loops in PHP
  • connect PHP with the MySQL database server
  • select data from the MySQL table and display the table
  • install and use phpMyAdmin to add and view data
  • create users and assign permissions by using phpMyAdmin
  • install LAMP and then connect PHP with the MySQL server

Overview/Description
Since LAMP is a very popular stack to create dynamic web sites, it is important for the Web developers to understand the various technologies used in this stack. In this course, you will learn to create a LAMP stack by installing the Linux operating system and using the Linux command line. You will also learn to install the Apache Web server, host a page on the Apache Web server, and install and work with the MySQL database. In addition, you will install the PHP language and learn the basics of this language.

Target Audience
This course is targeted toward individuals who wish to create LAMP stacks and use them in Web development.

Creating a LAMP Stack

Course Number:
wd_lamp_a01_it_enus
Lesson Objectives

Creating a LAMP Stack

  • start the course
  • describe the Linux architecture
  • install the Linux operating system
  • work with the Linux command line
  • edit a file using the vi editor
  • start and stop a network service
  • install the Apache Web server on Linux
  • start and verify the HTTPd daemon on Linux
  • view the access and error logs of the Apache web server
  • store data in a table in RDBMS
  • install MySQL on Linux
  • start and verify the MySQL service on Linux
  • set password for the root user in MySQL
  • create a user and a database in MySQL
  • create a table and add data in MySQL
  • install PHP packages in Linux
  • use if...else statements and switch operators for controlling flow
  • use while and for loops in PHP
  • connect PHP with the MySQL database server
  • select data from the MySQL table and display the table
  • install and use phpMyAdmin to add and view data
  • create users and assign permissions by using phpMyAdmin
  • install LAMP and then connect PHP with the MySQL server

Overview/Description
Since LAMP is a very popular stack to create dynamic web sites, it is important for the Web developers to understand the various technologies used in this stack. In this course, you will learn to create a LAMP stack by installing the Linux operating system and using the Linux command line. You will also learn to install the Apache Web server, host a page on the Apache Web server, and install and work with the MySQL database. In addition, you will install the PHP language and learn the basics of this language.

Target Audience
This course is targeted toward individuals who wish to create LAMP stacks and use them in Web development.

Creating a LAMP Stack

Course Number:
wd_lamp_a01_it_enus
Lesson Objectives

Creating a LAMP Stack

  • start the course
  • describe the Linux architecture
  • install the Linux operating system
  • work with the Linux command line
  • edit a file using the vi editor
  • start and stop a network service
  • install the Apache Web server on Linux
  • start and verify the HTTPd daemon on Linux
  • view the access and error logs of the Apache web server
  • store data in a table in RDBMS
  • install MySQL on Linux
  • start and verify the MySQL service on Linux
  • set password for the root user in MySQL
  • create a user and a database in MySQL
  • create a table and add data in MySQL
  • install PHP packages in Linux
  • use if...else statements and switch operators for controlling flow
  • use while and for loops in PHP
  • connect PHP with the MySQL database server
  • select data from the MySQL table and display the table
  • install and use phpMyAdmin to add and view data
  • create users and assign permissions by using phpMyAdmin
  • install LAMP and then connect PHP with the MySQL server

Overview/Description
Since LAMP is a very popular stack to create dynamic web sites, it is important for the Web developers to understand the various technologies used in this stack. In this course, you will learn to create a LAMP stack by installing the Linux operating system and using the Linux command line. You will also learn to install the Apache Web server, host a page on the Apache Web server, and install and work with the MySQL database. In addition, you will install the PHP language and learn the basics of this language.

Target Audience
This course is targeted toward individuals who wish to create LAMP stacks and use them in Web development.

Creating a LAMP Stack

Course Number:
wd_lamp_a01_it_enus
Lesson Objectives

Creating a LAMP Stack

  • start the course
  • describe the Linux architecture
  • install the Linux operating system
  • work with the Linux command line
  • edit a file using the vi editor
  • start and stop a network service
  • install the Apache Web server on Linux
  • start and verify the HTTPd daemon on Linux
  • view the access and error logs of the Apache web server
  • store data in a table in RDBMS
  • install MySQL on Linux
  • start and verify the MySQL service on Linux
  • set password for the root user in MySQL
  • create a user and a database in MySQL
  • create a table and add data in MySQL
  • install PHP packages in Linux
  • use if...else statements and switch operators for controlling flow
  • use while and for loops in PHP
  • connect PHP with the MySQL database server
  • select data from the MySQL table and display the table
  • install and use phpMyAdmin to add and view data
  • create users and assign permissions by using phpMyAdmin
  • install LAMP and then connect PHP with the MySQL server

Overview/Description
Since LAMP is a very popular stack to create dynamic web sites, it is important for the Web developers to understand the various technologies used in this stack. In this course, you will learn to create a LAMP stack by installing the Linux operating system and using the Linux command line. You will also learn to install the Apache Web server, host a page on the Apache Web server, and install and work with the MySQL database. In addition, you will install the PHP language and learn the basics of this language.

Target Audience
This course is targeted toward individuals who wish to create LAMP stacks and use them in Web development.

Creating a LAMP Stack

Course Number:
wd_lamp_a01_it_enus
Lesson Objectives

Creating a LAMP Stack

  • start the course
  • describe the Linux architecture
  • install the Linux operating system
  • work with the Linux command line
  • edit a file using the vi editor
  • start and stop a network service
  • install the Apache Web server on Linux
  • start and verify the HTTPd daemon on Linux
  • view the access and error logs of the Apache web server
  • store data in a table in RDBMS
  • install MySQL on Linux
  • start and verify the MySQL service on Linux
  • set password for the root user in MySQL
  • create a user and a database in MySQL
  • create a table and add data in MySQL
  • install PHP packages in Linux
  • use if...else statements and switch operators for controlling flow
  • use while and for loops in PHP
  • connect PHP with the MySQL database server
  • select data from the MySQL table and display the table
  • install and use phpMyAdmin to add and view data
  • create users and assign permissions by using phpMyAdmin
  • install LAMP and then connect PHP with the MySQL server

Overview/Description
Since LAMP is a very popular stack to create dynamic web sites, it is important for the Web developers to understand the various technologies used in this stack. In this course, you will learn to create a LAMP stack by installing the Linux operating system and using the Linux command line. You will also learn to install the Apache Web server, host a page on the Apache Web server, and install and work with the MySQL database. In addition, you will install the PHP language and learn the basics of this language.

Target Audience
This course is targeted toward individuals who wish to create LAMP stacks and use them in Web development.

Close Chat Live