3 trang 15 lượt tả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

30

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.

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

Trường: Đại học Bách Khoa Hà Nội 2.8 K tài liệu

Tác giả:

Profile

Trịnh Thảo Anh

8 tháng trước
Danh sách Quiz
/3
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.

Tài liệu khác của Đại học Bách Khoa Hà Nội

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.

Tài liệu liên quan: