Tuesday, January 15, 2019

WEEK 17 CST 363 Intro to Database Systems

This week, we had an introduction to SQL which included client/server systems, the relational database model, SQL and SQL based systems, and SQL statements. In Chapter 2, we learned about using the MySQL workbench, running SQL statements, and how to use the command line client. In Chapter 3, we learned about the select, where, order by, and limit clauses to process data. We used inner and outer joins to get data from two or more tables and practiced using unions. In Chapter 5, we made new rows, updated existing rows and deleted existing rows.

Initially, I had some trouble connecting to the server in chapter 2. I later found out that I needed MySQL server to do that. After reading more online and at the end of chapter 2, I downloaded the necessary programs and was able to continue with the homework.
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

cst 499 week 8

This week, we finished writing the paper in order to do the best job possible even if it was a little bit late. Now that everything is done,...

  • cst499 capstone week 2
    This week, our group discussed the effective meetings reading from last week. It seemed like we already used a few ideas in the article thro...
  • cst325 w4
    This week, we learned about raytracing and it's similarities and differences from rasterization. We also learned about the CPU and GPUs ...
  • CST 338 M4 Software Design
    Give an example of polymorphism and what what be inherited between classes. After the learning this week, can you identify the difference...