1 / 151

MySQL Query Lab III 25 Points

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}.

habib
Download Presentation

MySQL Query Lab III 25 Points

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. MySQL Query Lab III • 25 Points • MySQLTU Database 3343 • Dr. Thomas Hicks

  2. You May Do This Lab On Your Own Personal Computer Or On Your Database System

  3. Your Name _________________ Name This Presentation: Tom-Hicks-MySQL-Query-3.pptx{Substitute Your First & Last Names}

  4. Computer Used Is _________________ {My Personal Computer or CS-??}

  5. Your Slide Presentation Should Include Screen Captures That Are Cropped – Clear & Easy To Read

  6. 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

  7. Use The Snippping Tool To Help You With Your Screen Captures Use Both The Rectangular Snip & The Window Snip As Is Appropriate!

  8. Trying To Capture SHOW FIELDS Command: Good!

  9. Use Good/Neat/Readable Captures  Crop Your CapturesDon’t Include Extraneous Stuff! This Is Not Good! BAD!

  10. 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

  11. Use The MySQL Command Line ClientAnswer All QuestionsReplace Screen Captures

  12. 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.

  13. Your Slide Presentation Should Include Screen Captures That Are Cropped – Clear & Easy To Read

  14. 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

  15. Trying To Capture SHOW FIELDS Command: Good!

  16. Use The Snippping Tool To Help You With Your Screen Captures Use Both The Rectangular Snip & The Window Snip As Is Appropriate!

  17. Use Good/Neat/Readable Captures  Crop Your CapturesDon’t Include Extraneous Stuff! This Is Not Good! BAD!

  18. 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

  19. Use The MySQL Command Line ClientAnswer All QuestionsReplace Screen Captures

  20. 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.

  21. SQLStructured Query Language

  22. ConfigureThe Command Window

  23. Getting Ready To Change Window Properties Using the mouse, Right Mouse Click On The Top Of The Window and Select Properties

  24. Set The Window Screen Text To WhiteSet Your Background To Red, Black, Green, Or NavyDo Not Select Maroon Background

  25. Set The Window Properties As Illustrated Below

  26. Set The Window Screen Text To WhiteSet The Background To Red, Black, Green, Or NavyDo Not Select Maroon Background

  27. Put File Library-Hicks.sql On Your DesktopShow The Size In General Properties

  28. LOADTHEDATA

  29. Reload The Library-Hicks-1.sql

  30. Don't Necessarily Expect Your Output To Be Exactly Like Mine! • The Queries Will Work. Check Your Own Output!

  31. Start MySQL AdministratorConfigure & Login

  32. Select CatalogsMake Sure That Your Library Database Is Included In The List

  33. Select Restore. Select Another Schema. Select Your Library??Push Open Backup File

  34. Select Library-Hicks.sql From The Desktop

  35. Start The Restore

  36. Close

  37. Select/Open • A Database • The Open Database Is Often Called The Default Database

  38. 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%

  39. Show All Databases On Your System. Open Your Library?? Database. Only One Database May Be Open At A Time.Replace The Capture Below!

  40. Display TheDatabase • Tables • Show Tables (Open Database)

  41. Show All Tables In The Open Database.Replace The Capture Below!

  42. Display TheDatabase Table • Layout • (Fields, DataTypes, Etc.)

  43. 1] Open Your Library?? Database2] Display The Tables In The Open Database3] Show The Table Layout For UsersInclude The Capture Below!

  44. 1] Show The Table Layout For TeamMembersInclude The Capture Below!

  45. UNION

  46. Display A Query List, Called Names, That Contains All Of The User First Names And All Of The Server TeamNames.Replace The Capture Below!

  47. Users & TeamsStart To Form A Relationship

  48. 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.

  49. Entity-Relationship • E-R Diagrams

  50. Do The Following Google Search

More Related