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

  • CST 499 Week 5
    This week we continued working on our project. Initially, I was working entirely in my own Github branch. It was many commits behind the mas...
  • cst438 software engineering
    This week, we finished up the final project for the class. We met with the professor last week in order to review the project plan with the ...
  • cst 325 w3
    This week, we learned how vectors and matrices are connected. We also learned how matrices are used to manipulate space and how to solve p...