CST 363 Week 3

 An SQL View is a table based on the result of an SQL query or Script. It gets its data from one or multiple tables. An interesting use for views is getting what you want from multiple tables or just one table in a specific way using scripts that can have complex calculations. 

An example of would be if you have multiple tables and you want to get the data organized in one place. Even though this can be done without really creating a view, simply by using JPA to create your query or script, but sometimes it's easier to create the logic in SQL and then just read from the view directly into your java service layer. 


SQL is an interesting language, it has a lot of similarities to java and other languages that I used in the past like python and swift but it also has its uniqueness. Java is an object oriented general purpose programming language while SQL is table based language. In my opinion writing SQL is a lot easier and more efficient for data processing and getting things done. Normally I always get into this debate at work where some people prefer to manipulate their data in SQL (JPQL) first and get it sorted and ready to use into their objects, vs getting the raw data and using Java to do the work. At the end it's a personal preference but I think SQL is an essential language to learn because it can be very useful in some situations.  

Comments

Post a Comment

Popular posts from this blog

CST 462S - Learning Journal (service learning)

Working with the American Technology Initiative was really fun, informative, and rewarding. I spent most of my time on their volunteer portal, a prototype level app that makes volunteer reporting way easier. The codebase was almost release ready, so I got to dive in, explore its parts, and see how a familiar tech stack scales up for real users. Since the core features were already in place, I focused on user testing: hunting bugs, suggesting little tweaks, and polishing usability. Even though these were small changes, it felt great knowing they’d make a real difference for volunteers. If there’s one thing I’d change, it’d be the length of the service learning project. 25 hours (over eight weeks) barely gives you time to get comfortable with a new codebase. From my experience, you need at least forty hours just to learn the ropes and even more to add substantial features. I’d love to see future SL programs run at least 120 hours (about six months) so you can really dig in. The highlight...
Read more

CST 300 Week 7

Part 1: Arranging our ultimate research video project was a great experience for us as a team. The entire process was smooth, we all agreed with the concepts that were brought forth and maintained a steady vision during the planning phase. We collaborated mostly during our weekly zoom meetings. With different operating systems, we had to use various tools such as iMovie, powerpoint and Final Cut Pro (which is what I used). Looking back on it now though, what I would suggest is having timelines that allow us to finish the project at least a week early so that we can then look at it and try to improve it. However, our team has a strong bond so sharing each other’s ideas into our projects was easy for us. Part 2: I viewed Lera Boroditsky’s TED Talk “How Language Shapes the Way We Think.” The speaker discusses how much influence languages have on our thoughts and perceptions. She gives examples of different ways in which languages can shape reality, affecting even such basic phenomena as s...
Read more