3.18 > DBMS lectures & practices
PHP technology
- PHP Tutorial
- Intro
- Syntax
- PHP Script examples /analysis & demo/
- Variables /analysis & demo/
- Echo & Print /analysis & demo/
- PHP forms
- Simple PHP form example /analysis & demo/
- Your selected actual PHP example /analysis & demo/
- PHP quiz
PHP-MySQL technology
- PHP connect to MySQL /PHP-MySQL junction/
- PHP-MySQL connect /analysis & demo/
- PHP-MYSQL interface
- PHP Select Data From MySQL
- e.g., PHP-MySQL select /analysis & demo/
- PHP Select Data From MySQL
====================================================
2nd task > Online DBMS user interface creation and demo [march-april].
- > Acquaintance with SQL, MySQL, PHP, phpMyAdmin, etc.,
- > PHP-MySQL junction creation, results demo and publishing,
- > PHP-MySQL interface creation, results demo and publishing.
SQL technology
- SQL quiz /preparing to the 1st colloquium/
- results analysis
- Your selected SQL query demo /~ from your published 10 actual queries/
Preparation for the 1st DBMS colloquium online test [moodle] /3.25/
- Test content > WordPress.implementation&usage + DBMS.introduction + SQL.queries
- Test Sources
- DBMS course > lectures&practices
- SQL slides > here
- DBMS introduction slides > here
- wordpress.org
- SQL practice tools
- Test details > ~20 questions
- About WordPress implementation and usage
- About DBMS theory /introduction/
- Problems solving with different types of SQL queries
- using SELECT queries
- simple queries [*, etc.]
- using DISTINCT
- conditional queries [WHERE, etc.]
- wildcards [LIKE, etc.]
- ordering [ORDER BY, etc.]
- aliases [AS, etc.]
- aggregate functions
- calculated fields
- ..
- using INPUT, UPDATE and DELETE queries
- using SELECT queries
- Tips
- It is advisable to analyse SQL queries examples given in the sources
- It is advisable to pre-test various SQL queries