Database programming for beginners
What you'll learn
- Understand basic SQL statement and get used to DB programming
This course includes how to use basic SQL statement, how to develop easy web app by PHP and MySQL.
After you finished this course, you will fully understand the relationship between web app and database.
And also, you will have skills of database programming and PHP/HTML programming!
Fundamental SQL and PHP programming by sample source code is offered in this course,
so you will get used to database programming and app programming easily.
This course contents are as follows.
1 What is database ?
1.1. Relationship between database and application
1.2. Relational database
1.3. Manipulate database by SQL
2 Make database and table
2.1. Download and install XAMPP to your PC
2.2. Start MySQL
2.3. Start Admin tool of MySQL
2.4. Make database
2.5. Make user
3 Manipulate data by SQL
3.1. INSERT statement – add record to table -
3.2. SELECT statement – refer to record from table -
3.3. UPDATE statement – update record to table -
3.4. DELETE statement – delete record from table -
4 Manipulate table from program
4.1. Basics of database processing
4.2. Insert record to DB from PHP application
4.3. Get record from DB by PHP application
5 Manipulate table from web app
5.1. Insert input data of web page to DB
5.2. Take measures against invalid data input
6 Bonus Lecture
Finally, thank you for enrolling this course. Let's start database programming!
Who this course is for:
- IT engineer want to acquire basic database programming skill
Hi, I'm a web application engineer at one of the biggest IT company in Japan.
My major is Java programming, Java Servlet and JSP especially, and AWS related technology.
I always had a passion for making teaching theory by myself.
I will share my knowledge and skill as much as possible.
Please subscribe my course and share your impression. Thanks!