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.
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,...
-
Have you ever created an app before, either for Android or iPhone? How did it go? Do you have any ideas for apps that you could create ...
-
This week, we learned about debugging techniques. There are multiple ways to do this such as glass-box, black-box, testing edge conditions, ...
-
Microservices Microservices are used by companies to make their code more reusable by allowing engineers to combine ready made parts i...
No comments:
Post a Comment