1. Source downloads
https://launchpad.net/test-db/
http://dev.mysql.com/doc/employee/en/employees-introduction.html
2. Data load
C:\employees_db>c:\mariadb\bin\mysql -u root -p employees < employees.sql
Enter password: *****
INFO
CREATING DATABASE STRUCTURE
INFO
storage engine: InnoDB
INFO
LOADING departments
INFO
LOADING employees
INFO
LOADING dept_emp
INFO
LOADING dept_manager
INFO
LOADING titles
INFO
LOADING salaries
3. Data validation
C:\employees_db>c:\mariadb\bin\mysql -u root -p employees
Enter password: *****
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 8
Server version: 10.0.15-MariaDB mariadb.org binary distribution
Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [employees]> select count(dept_no) from departments ;
+----------------+
| count(dept_no) |
+----------------+
| 9 |
+----------------+
1 row in set (0.00 sec)
MariaDB [employees]> select count(emp_no) from employees ;
+---------------+
| count(emp_no) |
+---------------+
| 300024 |
+---------------+
1 row in set (0.12 sec)
MariaDB [employees]> select count(emp_no) from dept_emp;
+---------------+
| count(emp_no) |
+---------------+
| 331603 |
+---------------+
1 row in set (0.10 sec)
MariaDB [employees]> select count(dept_no) from dept_manager;
+----------------+
| count(dept_no) |
+----------------+
| 24 |
+----------------+
1 row in set (0.00 sec)
MariaDB [employees]> select count(emp_no) from salaries ;
+---------------+
| count(emp_no) |
+---------------+
| 2844047 |
+---------------+
1 row in set (0.42 sec)
MariaDB [employees]> select count(emp_no) from titles;
+---------------+
| count(emp_no) |
+---------------+
| 443308 |
+---------------+
1 row in set (0.16 sec)
MariaDB [employees]>
4. Data Schema
(- http://dev.mysql.com/doc/employee/en/sakila-structure.html)
Melting