VirtualMV/MySQL

Table of contents

(In process of updating from http://11193.a.hostable.me/wiki/index.php?title=MySQL ) Tutorial SQL Introduction MySQL Overview MySQL - Getting started Basic commands | Answers Using Help | Answers Flatfile (Single table) Database First Database: Heights Tasks: Create simple Flat file databases Some SQL Theory SQL Components | Backus-Naur Form Data Definition Language (DDL) | Data types Data Manipulation Language (DML) Relational Database (dbHire): Sales, Hire and Repair Company dbHire: System Analysis - Sale/Hire/Repair Company dbHire - Database dbHire - Business table (Business) dbHire - Accounts tables (Client, Transaction) SQL Theory: Data Query Language (DQL) - SELECT Joins SQL Theory: Join examples dbHire - Human Resource tables (Staff, Timesheet) Task: Joins and Relations SQL Theory: Summarising (aggregating) data (SELECT-ORDER/GROUP) Hire tables (Client, Equipment, Hire) Stock tables Repair tables SQL Theory: DDL & DML

Issues Data Integrity Performance - Indexing Support Data types Installation | Windows Local installation | MySQL in WAMP Windows/Apache/MySQL/PHP Help Desk | Interactive Help Desk MySQL Console tricks Test Repository DipICT. DB500 - Database management systems

References

virtualMV  |  Superquick wiki guide  |  Please give me some feedback

VirtualMV/MySQL. (2024). In WikiEducator/VirtualMV wiki. Retrieved April 19, 2024, from http:https://wikieducator.org/VirtualMV/MySQL    (zotero)