1.51k likes | 1.61k Views
MySQL Query Lab III 25 Points. MySQL TU Database 3343 Dr. Thomas Hicks . You May Do This Lab On Your Own Personal Computer Or On Your Database System. Your Name _________________ Name This Presentation: Tom-Hicks-MySQL-Query-3.pptx {Substitute Your First & Last Names}.
E N D
MySQL Query Lab III • 25 Points • MySQLTU Database 3343 • Dr. Thomas Hicks
You May Do This Lab On Your Own Personal Computer Or On Your Database System
Your Name _________________ Name This Presentation: Tom-Hicks-MySQL-Query-3.pptx{Substitute Your First & Last Names}
Computer Used Is _________________ {My Personal Computer or CS-??}
Your Slide Presentation Should Include Screen Captures That Are Cropped – Clear & Easy To Read
Helpful HintThere Will Often Be A Colored Title Bar At The Top Of A Slide If This Bar Is Light Blue – It Is Info That You Should Read! If This Bar Is Red – You Will Have Screen Captures To Replicate And/Or Questions To Answer If This Bar Is Green – You Will Have To Create Original Screen Captures And/Or Questions To Answer
Use The Snippping Tool To Help You With Your Screen Captures Use Both The Rectangular Snip & The Window Snip As Is Appropriate!
Use Good/Neat/Readable Captures Crop Your CapturesDon’t Include Extraneous Stuff! This Is Not Good! BAD!
Use The Document Query • Format For All Slides! • SELECT …. First LineFROM … Next Line • WHERE … Next Line If ThereORDER BY … Next Line If There Document Query Format
Use The MySQL Command Line ClientAnswer All QuestionsReplace Screen Captures
The Basics Of SQL Are Generic Many Implementations Of MySQL Offer Additional Enhancements (i.e. MySQL Might Have A String Function, Or Mathematical Function, That Might Not Be Available In MSSQL) You Can Generally Add Your Own Custom Functions To Most SQL Environments.
Your Slide Presentation Should Include Screen Captures That Are Cropped – Clear & Easy To Read
Helpful HintThere Will Often Be A Colored Title Bar At The Top Of A Slide If This Bar Is Light Blue – It Is Info That You Should Read! If This Bar Is Red – You Will Have Screen Captures To Replicate And/Or Questions To Answer If This Bar Is Green – You Will Have To Create Original Screen Captures And/Or Questions To Answer
Use The Snippping Tool To Help You With Your Screen Captures Use Both The Rectangular Snip & The Window Snip As Is Appropriate!
Use Good/Neat/Readable Captures Crop Your CapturesDon’t Include Extraneous Stuff! This Is Not Good! BAD!
Use The Document Query • Format For All Slides! • SELECT …. First LineFROM … Next Line • WHERE … Next Line If ThereORDER BY … Next Line If There Document Query Format
Use The MySQL Command Line ClientAnswer All QuestionsReplace Screen Captures
The Basics Of SQL Are Generic Many Implementations Of MySQL Offer Additional Enhancements (i.e. MySQL Might Have A String Function, Or Mathematical Function, That Might Not Be Available In MSSQL) You Can Generally Add Your Own Custom Functions To Most SQL Environments.
Getting Ready To Change Window Properties Using the mouse, Right Mouse Click On The Top Of The Window and Select Properties
Set The Window Screen Text To WhiteSet Your Background To Red, Black, Green, Or NavyDo Not Select Maroon Background
Set The Window Screen Text To WhiteSet The Background To Red, Black, Green, Or NavyDo Not Select Maroon Background
Put File Library-Hicks.sql On Your DesktopShow The Size In General Properties
Don't Necessarily Expect Your Output To Be Exactly Like Mine! • The Queries Will Work. Check Your Own Output!
Select CatalogsMake Sure That Your Library Database Is Included In The List
Select Restore. Select Another Schema. Select Your Library??Push Open Backup File
Select/Open • A Database • The Open Database Is Often Called The Default Database
All Of The Fields In Your Database Will Match Those In My Database 100% • I Reserve The Right To Use Slightly Different Data In An Effort To Ensure That You Carefully Examine Your Own Queries! • All Of The Relationships In Your Database Will Match Those In My Database 100% • All Of The Table & Field Names Will Match 100%
Show All Databases On Your System. Open Your Library?? Database. Only One Database May Be Open At A Time.Replace The Capture Below!
Display TheDatabase • Tables • Show Tables (Open Database)
Show All Tables In The Open Database.Replace The Capture Below!
Display TheDatabase Table • Layout • (Fields, DataTypes, Etc.)
1] Open Your Library?? Database2] Display The Tables In The Open Database3] Show The Table Layout For UsersInclude The Capture Below!
1] Show The Table Layout For TeamMembersInclude The Capture Below!
Display A Query List, Called Names, That Contains All Of The User First Names And All Of The Server TeamNames.Replace The Capture Below!
A User May Be A Member Of One Or More Teams. Teams Shall Be A Relationship Between The Users & The Servers. This Will Be Explained More Later In The Presentation.
Entity-Relationship • E-R Diagrams