1 / 186

MySQL Query Lab I 25 Points

MySQL Query Lab I 25 Points. MySQL TU Database 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-1.pptx {Substitute Your First & Last Names}. Computer Used Is

imala
Download Presentation

MySQL Query Lab I 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 I • 25 Points • MySQLTU Database • 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-1.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 MySQL Command Line ClientAnswer All QuestionsReplace Screen Captures

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

  12. SQLStructured Query Language

  13. SQL? SQL is an acronym for _____________________________________________________

  14. MySQLFully RelalationalDatabase • Free Community VersionAvailable

  15. Starting MySQL In The LabsOpen A CMD Window

  16. Starting MySQL In The LabsOn Your ComputerReplace The Bottom Screen Capture With Yours

  17. Open MySQL Command Line ClientReplace The Capture Below! We Are Using MySQL Server Version _?_ {4.4.3-beta below}

  18. Put File • Library-Hicks On Your Desktop

  19. Put File Library-Hicks.sql On Your DesktopShow The Size In General PropertiesReplace The Capture Below!

  20. HELP • List MySQL Commands

  21. Display The MySQL CommandsReplace The Capture Below!

  22. Configure • MySQL 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 BelowReplace The Capture Below!

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

  27. CREATE DATABASE • Library?? • Replace ?? With Your Initials

  28. Create Database Library?? [Replace ?? With Your Initials]Show All Databases On Your SystemReplace The Capture Below!

  29. Restore Library Database Using MySQL WorkBench

  30. Start MySQL WorkBench

  31. Push The New Connection Link In SQL Development

  32. Enter localhost Push Store In Vault Button

  33. Enter The Root Password!

  34. Push The Test Connection Button

  35. If Connection OK  Push The OK Button

  36. Double-Click On connection (localhost)

  37. Open The Script File

  38. Select Library-Hicks.sql From The Desktop

  39. Double-Click On connection (localhost)

  40. Save The Script To File

  41. Refresh – Right Mouse Click – Schemas/Databases

  42. You Should Have Database LibraryTH

  43. Change The 3 References To LibraryTHTo Library?? Where ?? Are Your Initials

  44. Doug Wolf Would Make The Following ChangesExecute & Save & Refresh

  45. It Is That Easy To Make Test Copy Of A DatabaseFrom The .sql Backup File

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

  47. A Database Is More Than A Collection Of Tables • Tables, Programs, Indexes, Views, Forms, Reports, Relationships, Etc.

  48. Definitions of Database on the Web: A database is an organized body of related information wordnetweb.princeton.edu/perl/webwn A database is a structured collection of records or data that is stored in a computer system. The structure is achieved by organizing the data ...en.wikipedia.org/wiki/Database A database is a systematically arranged collection of computer data, structured so that it can be automatically retrieved or manipulatedvalidwebdesigns.com/glossary/ A database is a collection of data organized for search and retrieval.summitschool.com/8review/dbssterms.doc A collection of interrelated data items stored together without unnecessary redundancy, to serve one or more applications.www.4pcb.com/index.php

  49. USE … (Database) • Open A Database • The Open Database Is Often Called The Default Database

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

More Related