Databases and the Web - Dynamic Web Pages

Data Driven Web Pages

  • 3 ratings, 18 students enrolled

Course Overview

A web database is a system for storing information that can then be accessed via a website. For example, an online community may have a database that stores the username, password, and other details of all its members. The most commonly used database system for the internet is MySQL due to its integration with PHP — one of the most widely used server side programming languages. At its most simple level, a web database is a set of one or more tables that contain data. Each table has different fields for storing information of various types. These tables can then be linked together in order to manipulate data in useful or interesting ways. In many cases, a table will use aprimary key, which must be unique for each entry and allows for unambiguous selection of data. A web database can be used for a range of different purposes. Each field in a table has to have a defined data type. For example, numbers, strings, and dates can all be inserted into a web database. Proper database design involves choosing the correct data type for each field in order to reduce memory consumption and increase the speed of access. Although for small databases this often isn't so important, big web databases can grow to millions of entries and need to be well designed to work effectively.

What are the requirements?

  • You will need to download and install the free MySQL Server Community Edition and the free MySQL Workbench

What am I going to get from this course?

  • Create, query and update databases
  • Use triggers, views and stored procedures
  • Understand database users and security.

What is the target audience?

  • This course teaches you MySQL from the very beginning.
  • No prior knowledge is required, other than basic knowledge of your computer

About the Author

Hi, I'm Raj! I have been identified as one of  Top Instructors and my best-selling course has recently made it to the TOP 3 of the best Web Development courses.

Course Curriculum

Dynamic Web Page

  • Introduction
    00:04:44
  • How to Backup Database
  • Database Fundamentals
    31 Page
  • Storage
     
  • Quiz With Basic
     
  • PDF
    11 Page

reviews

  • sections are very interactive **
    3 years ago

advertisewith us

toprated

Idea Generation: Coming up wit

Improvisation is a creative process which can be s... Read More

Nov 2, 2015, 6 Comments

Java

Java is a set of computer software and specificati... Read More

Oct 29, 2015, 5 Comments

View More...