Welcome to the Santa Rosa Junior College class on Structured Query Language, or SQL. This class is designed
- to introduce MySQL server as a tool to manage information in a relational database,
- to understand the SQL Database Language
- to explore how to design a database and develop a database-driven web application.
We will be following the Learning MySQL textbook liberally throughout this half semester, supplemented by pages on this website.
This week we focus on setting up our tools and exploring MySQL Workbench and the SQL Select statement.
Assignment – Due April 3
- Read these articles on wikipedia.org: SQL & MySQL
- Read my Getting Started with MySQL post
- Download & Install MySQL Workbench
- In MySQL Workbench, create a Database Connection using your ADMIN account, following the instructions in the blog post. (Our SRJC setup is such that only the ADMIN account has the privilege to create tables.)
- Download this music.sql file.
- Open a database session in MySQL Workbench. Using the Scratch Pad, enter (type in) and execute (click the lightening bolt icon) the SQL command “use xxxxxxxx” (where xxxxx is your database name. It is the same as your username. Mine is jperetz.) This will activate your database, i.e. all future commands will execute within that database.
- Open the music.sql file and execute it (click the lightening bolt).
- Using MySQL Workbench’s scratch pad, follow the textbook from page 137 – 162. There are many examples of the SQL Select statement using the four tables in the music database.
- Email me a list of your MySQL accounts and passwords. In the email, include answers to questions 1 and 2 on page 176 of the textbook. Include the answer to the question and the SQL statement that you used to determine the answer.
- Leave a comment on this blog post page. In one short paragraph, introduce yourself to the class., include your name, your experience with databases and objectives for taking this class, as well as anything else you’d like to share. In a second short paragraph, tell us about your experience with this assignment. Did you have any problems? What did you learn? Are you ready to learn more? Any resources to share with the class.