CST-363 Week 3

 

  1. What is an SQL view.  How is it similar to a table? In what ways is it different (think about primary keys,  insert, update, delete operations) ?
    1. An SQL view can be used to simplify complex queries. They cannot be updated the same ways a table can.
  2. We have completed our study of SQL for this course.  This is not to imply that we have studied everything in the language.  There are many specialized features such as calculating rolling averages, query of spatial data (data with latitude and longitude) coordinates, and more. But take a minute to think about how SQL compares to other programming languages such as Java.  What features are similar , and which are present in one language but not in the other?  For example,  Java has conditional if statements which are similar to SQL WHERE predicates,  the SELECT clause is similar to a RETURN statement in that it specifies what data or expression values are to be returned in the query result (although it is strange that a statement should specify the RETURN as the first part of a SELECT. 
    1. SQL has similar functions to other languages, such as the min(), max(), and avg() functions. Unlike other languages, SQL has transactions which can rollback queries.

 

Comments

Post a Comment

Popular posts from this blog

Week 5

 Part 1 Support Teammates' goals. Teammate comment (Ysabelle):  CST300 Week 4 Second comment (Faith):  Week 4 Learning Journal Part 2 Possible Capstone. I am mainly interested in mobile development, so I think some possible capstones I could work on could have the goal of making user's life more convenient.  An application for businesses to create a virtual loyalty card which allows them to send a text message of a user's QR, so they can scan their card and "punch" it. An application for users to track their workouts. They will be able to create custom workouts and track sets, rest time, reps, weights, etc.  A third idea could be working on an existing application that allows open contributions from students. Part 3 Learning Journal AI In Writing Using AI to complement your writing can benefit you by improving your reading efficiency and content creation. Instructive prompting: Used to guide your AI to a specific task. Output must be inspected to ensure it is re...
Read more

Week 4

Part 1 Educational Goals. My main educational goal is to achieve my bachelor's degree in computer science in 2 years. Another educational goal of mine is to do well in my upper division classes so I can be prepared for a career in software development. I would also like to strengthen my collaboration skills through the use of group projects.  Part 2 Career Goals. One of my main career goals is to become a professional software developer after graduation. I hope to leverage my current internship as an Android developer to find a new internship next summer, so I can explore different fields in software development. Part 3 Guess ETS percentile. If I had to guess, I think I would be in the 70th percentile. I feel pretty comfortable with programming, but I think I would struggle more with the theory-based questions and would have to review my notes from discrete/data structures beforehand.  Part 4 Learning Journal.  Writing material:  For my Ethics essay, I will need to c...
Read more

Week 2

Image
Part 1. The top 3 items I am good at is taking notes, reviewing easy questions on exams first, and setting a schedule. I think one area I could improve on is asking the right questions. Part 2. Log        Part 3 Project Management basics.      Companies have experts that focus on project management. A board of directors will decide on a project to be completed while a project manager essentially acts as CEO over that project. The work breakdown structure is a fundamental tool of project management. It is common to break down projects into its own products/deliverables. To create a work breakdown structure, you create a hierarchical decomposition of all the deliverables. Level 0 is the project. Level 1 is the Keyline (organizing principles). Level 2 is the Major Deliverable. Level 3 is sub-deliverables (helps meet end deliverables). Level 4 and further decompose sub-deliverables. Finally, get feedback before presenting final work breakdown structure. Ea...
Read more