Database programming for beginners
Learn basic SQL statement and database programming with this course. Develop web apps using PHP and MySQL. Gain skills in database and PHP/HTML programming. Includes sample source code for easy understanding. Download XAMPP and start manipulating data and tables. Perfect for IT engineers looking to acquire basic database programming skills.
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
User Reviews
Be the first to review “Database programming for beginners”
You must be logged in to post a review.
There are no reviews yet.