CST 363 Week 3

 1. An SQL view is similar to a table but is not stored the same way, a view manipulates or alters the way a table looks to give consistent formatting, or hide sensitive data. Views are useful for allowing ifferent levels of access to one table. 

2. SQL is very similar to java just with different syntax, SQL takes in some cases long strings of code to complete a task but feels very similar to writing a sentence where as other languages like java and C++ feel like you are writing out little bits of a though process where muliple lines each serving there own function form a thought process. Both often lead to similar ends and have common steps along the way like predicates, data types, but it is easy to tell that SQL is designed for the very specific purpose of databases where as C++ and Java have broader uses . 

Comments

Post a Comment

Popular posts from this blog

CST 370 Week 5

 This week we moved from learning how to read and understand algorithms, to a more direct approach to writing some of the more advanced algorithms that explore the more common mathematical and logical problems programmers tend to face. Learning about topological ordering, tree structuring, and quick sort was very interesting as these concepts are huge throughout the computer science landscape. COming off the test last week I feel reinvogorated to keep learning. 
Read more

CST 370 Week 2

 This week was very interesting, I had learned about time efficiency and Big O, Theta and Omega notation in the past but it was great to learn formal definitions and see some examples of how they can be applied. Understanding how to evaluate recursive algorithms was new for me and pretty difficult to understand at first but after reading the text book and other required materials it started to make a little more sense. I would like to continue practicing evaluating both recursive and nonrecursive algorithms  just to continue understand the asymptotic notations a little bit more. Overall it was a good week and the homework was challenging in a great way. 
Read more

CST 370 Week 4

 This week I was able to study some of the topics I struggled with in previous weeks like recurrence relationships. In preparing for the test being able to use two sheets of paper as notes was helpful for studying but also helpful for the test. A refresher on merge sort was also a welcome experience as well as the divide and conquer techniques. 
Read more