Содержание
- 2. Learning objectives describe relational databases and their use use the terms attribute, entity, index record, table
- 3. Success criteria knows and understands the purpose of using the database can provide examples of the
- 4. A database is a collection of information that is organized so that it can be easily
- 5. Hierarchical model This model presents data to users in a hierarchy of data elements that can
- 6. Network model: In the network model of database, there are no levels and a record can
- 7. Relational model: The most recent and popular model of database design is the relational database model.
- 8. Main database objects Tables – Data collection objects Queries – Questions of your data Forms –
- 9. Main objects Field (attribute): a single piece of information. Could be a name, or a number.
- 10. MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL).
- 11. SQL Commands: SQL commands are instructions, coded into SQL statements, which are used to communicate with
- 12. Data Definition Language (DDL) - These SQL commands are used for creating, modifying, and dropping the
- 13. Transaction Control Language (TCL) - These SQL commands are used for managing changes affecting the data.
- 14. SQL Create DataBase CREATE DATABASE database_name SQL Alter DataBase The ALTER DATABASE Statement is used to
- 15. SQL CREATE TABLE CREATE TABLE table_name (column_name1 datatype, column_name2 datatype, ... column_nameN datatype ); CREATE TABLE
- 16. SQL ALTER TABLE Statement The SQL ALTER TABLE command is used to modify the definition (structure)
- 17. Local server XAMPP XAMPP is a free and open source cross-platform web server solution stack package
- 18. Click Apache – MySQL – Start. Where MYSQL click Admin. You can see next localhost site
- 20. Скачать презентацию