MySQL tunning| BT môn thiết kế và quản trị cơ sở dữ liệu| Trường Đại học Bách Khoa Hà Nội

MySQL tunning| BT môn thiết kế và quản trị cơ sở dữ liệu| Trường Đại học Bách Khoa Hà Nội. Tài liệu gồm 3 trang giúp bạn đọc ôn tập và đạt kết quả cao trong kỳ thi sắp tới. Mời bạn đọc đón xem.

12 6 lượt tải Tải xuống
Chia sẻ Báo cáo tài liệu

Môn: Thiết kế và quản trị cơ sở dữ liệu

Trường: Đại học Bách Khoa Hà Nội

Thông tin:

3 trang 3 tháng trước

Tác giả:

Profile Trịnh Thảo Anh
3
Expriments in ICT : Database
Database creation
Instructor : Viet-Trung Tran
Promotion : VN – K58
1. Mysql Database tunning
Given the follwoign sample database
https://launchpad.net/test-db/
a. Importing this database into your MySQL instance
b. Finding out Department Name (start with ‘S’) and its number of
employees
c. Experiment with index, and without index
2
Expriments in ICT : Database
Database creation
Instructor : Viet-Trung Tran
Promotion : VN – K58
1. Mysql Database tunning
Given the follwoign sample database
https://launchpad.net/test-db/
a. Importing this database into your MySQL instance
b. Finding out department with the most number of employee
titles
c. Sorting employee names by alphabet order
d. Experiment with index, and without index to improve query
performance
5
Expriments in ICT : Database
Instructor : Viet-Trung Tran
Promotion : VN – K58
1. Mysql Database tunning
Given the following sample database
https://launchpad.net/test-db/
a. Importing this database into your MySQL instance
b. List department name with its total salary and its manager
name
c. Experiment with index, and without index to improve query
performance
d. Please use Explain command and analyze the results.
| 1/3
| | Tải xuống

Có thể bạn quan tâm:

Preview text:

3 Expriments in ICT : Database Database creation Instructor : Viet-Trung Tran Promotion : VN – K58 1. Mysql Database tunning
Given the follwoign sample database https://launchpad.net/test-db/ a.
Importing this database into your MySQL instance b.
Finding out Department Name (start with ‘S’) and its number of employees c.
Experiment with index, and without index 2 Expriments in ICT : Database Database creation Instructor : Viet-Trung Tran Promotion : VN – K58 1. Mysql Database tunning
Given the follwoign sample database https://launchpad.net/test-db/ a.
Importing this database into your MySQL instance b.
Finding out department with the most number of employee titles c.
Sorting employee names by alphabet order d.
Experiment with index, and without index to improve query performance 5 Expriments in ICT : Database Instructor : Viet-Trung Tran Promotion : VN – K58 1. Mysql Database tunning
Given the following sample database https://launchpad.net/test-db/ a.
Importing this database into your MySQL instance b.
List department name with its total salary and its manager name c.
Experiment with index, and without index to improve query performance d.
Please use Explain command and analyze the results.