Category: DBM438

I. OBJECTIVES Take a look at the process of creating and managing database backups and how these backups are used in recovery of the database when it becomes corrupted. II. ASSUMPTIONS At the end of this lab, you should have… Read More

I. OBJECTIVES Take a look at the process of creating and managing users in the database, as well as how user management helps support security. II. ASSUMPTIONS As a result of this lab, you will have gained a working knowledge… Read More

I. OBJECTIVES Take a look at various ways to optimize queries in MySQL and various ways that the Data Directory can help in analyzing the database. II. ASSUMPTIONS After completing this lab, you will have a general understanding of how… Read More

I. OBJECTIVES Taking a look at different data storage issues and basic table management. II. ASSUMPTIONS In this lab, you will look at how the database stores tables for both the InnoDB and MyISAM storage engines. This information will be… Read More

I. OBJECTIVES General analysis and administration of a MySQL server and database. II. ASSUMPTIONS In this lab, you will look at various ways to look at how the server is set up to act and react to various situations. You… Read More

I. OBJECTIVES Create a new MySQL database. II. ASSUMPTIONS In this lab, you will perform some standard commands to find out about the server environment and then create a new database. III. PROCEDURE For each lab it will be necessary… Read More

I. OBJECTIVES Compare MySQL, Oracle, and SQL Server database architectures. II. ASSUMPTIONS In this lab you will create a comparison document listing elements of the three database architectures and how they differ. III. PROCEDURE Download the DBM438_W1_iLab_Report document from Doc… Read More