Database

All labs's in Module

    • Assignment

    As your continuous assessment for this module, you are required to design and develop a database using MySQL.

    Installation

    In this lab, you will install MySQL and log in to MySQL Workbench.

    SQL Introduction

    In this lab we will become familiar with using MySQL Workbench.

    SQL 1

    In this lab we will learn about the basics of SQL and learn about the SELECT statement

    SQL 2

    In this lab we will learn about Aggregate Functions.

    SQL 3

    In this lab, we will use the Select statement to retrieve data from two tables.

    SQL 4

    In this lab, we will use the Select statement statement to look at multi table and outer Joins.

    Lab-01 SQL 5

    In this lab, we will look at Data Manipulation.

    Lab-01 SQL 6

    In this lab, we will look at Data Definition.

    Lab-01 SQL 7

    In this lab, we will look at Sub Queries and Views.

    Lab-01 SQL 8

    In this lab, we will look at creating Indexes, Triggers, and Users. We will also look at granting access to users.

    Backup and Restore

    In this lab, we will look at database backup and recovery in MySQL Workbench.

    Install MongoDB

    In this lab, we will install and test MongoDB, a non-relational database.

    Create

    This lab introduces the CREATE functions in MongoDB.

    Read (find)

    In this lab, we will explore the find() statement in MongoDB, including a range of operators used to filter query results.

    Update

    This lab examines the methods used for updating documents in MongoDB.

    Delete

    In this lab, we examine the MongoDB methods using for deleting documents from a collection.

    Powered by tutors-ts.