Transcript My SQL In Six Days

Day 1 - Introduction
Topics To Be Covered
 Why do we want a DBMS?
 What does a DBMS do for me?

Welcome to the greatest lecture series of your lives!
Professor
 Mr/Mrs So-and-So
– E-Mail: [email protected]
– Office Hours: TBA
Teachers Assistant
 Mr/Mrs TA
– E-Mail: [email protected]
– Office Hours: TBA
CSE 498
Day 1 - Introduction
2 /7
Topics To Be Covered

Day 1 - Introduction
– Description of the Topics Covered
– Why do we want a DBMS?
– What does a DBMS do for me?

Day 2 - Basic Database Backbone
– How to Model a Database Using E/R Diagrams
– How an E/R Diagram Translate to a Real Database
CSE 498
Day 1 - Introduction
3 /7

Day 3 - Basics of MySQL
– MySQL Introduction
– Simple Tables
– Simple MySQL Commands

Day 4 - Simple Queries & More on Tables
– What is a query?
– Basic Format of a Query
– More Actions on Tables
CSE 498
Day 1 - Introduction
4 /7

Day 5 - More Complexity With Queries
–
–
–
–

Day 6 - Above and Beyond
–
–
–
–
–
CSE 498
What is a JOIN?
Type and Examples of JOINs
What is aggregation?
Examples…
Explanation of INDEX and Examples
Explanation of LOCK/UNLOCK TABLES and Examples
Explanation of User Rights in GRANT/REVOKE Commands
Explanation of Interface With a GUI Through JDBC
Reference Reading Materials
Day 1 - Introduction
5 /7
Why do we want a DBMS?
Suppose we are setting up a system to keep track of
the information for Blockbuster Video…
What do we need to consider?
 Data Storage (file organization, …)
 Transaction Reliability
 User Roles/Access Levels
 How do we query the information?
 How do we recover from crashes?
Do you want to create the system to do this?
No? Well then go buy the database system...
CSE 498
Day 1 - Introduction
6 /7
What does a modern database offer?








CSE 498
Efficient Data Storage Management
Reliable Transaction Assurance
High Level Query and Data Manipulation Language
Efficient Query Processing and Optimization
Reliable Transaction Processing
Easy Administration Ability to Set User
Roles/Access to the Database
Reliable Recovery System From Crashes
Able to Interface With Other High Level
Languages
Day 1 - Introduction
7 /7