Skip to content

sabrinasirens/MySQL_Lesson

BranchesTags

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

60 Commits
images
images
 
 
1_Design_and_Installation.md
1_Design_and_Installation.md
 
 
1_solution.md
1_solution.md
 
 
2_Relational_Databases.md
2_Relational_Databases.md
 
 
3_MySQL_Basics.md
3_MySQL_Basics.md
 
 
3_solution.md
3_solution.md
 
 
4_SQL_Basics.md
4_SQL_Basics.md
 
 
4_solution.md
4_solution.md
 
 
5_INSERT_and_SOURCE.md
5_INSERT_and_SOURCE.md
 
 
5_Lab_One.md
5_Lab_One.md
 
 
5_solution_one.md
5_solution_one.md
 
 
5_solution_two.md
5_solution_two.md
 
 
6_SELECT.md
6_SELECT.md
 
 
6_solution.md
6_solution.md
 
 
7_UPDATE_and_DELETE.md
7_UPDATE_and_DELETE.md
 
 
7_solution.md
7_solution.md
 
 
8_Access_Control.md
8_Access_Control.md
 
 
8_solution.md
8_solution.md
 
 
README.md
README.md
 
 
moviedb.sql
moviedb.sql
 
 

Repository files navigation

Lesson Plan Title:

Operational MariaDB/MySQL

Target Audience: Beginner level students interested in learning operational uses of database servers.

Objective: By the end of this lesson, students will be able to:

  • Demonstrate and use database servers and clients in practical ways.

Materials Required:

  • A virtual machine running a RHEL based linux OS.
  • Internet connection

Lesson Plan Outline:

I. Design and Installation

II. Basics of Relational Databases

III. MySQL Basics

IV. SQL Language Basics

V. Using INSERT and SOURCE

VI. Using the SELECT command

VII. Using UPDATE and DELETE

VIII. MySQL Access Control

begin_lesson

About

No description, website, or topics provided.

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

3 forks
Report repository

Releases

No releases published

Packages

No packages published