MySQL Query Lab III 25 Points

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