Week 2 learning journal CST 363

SQL has the flexibility to join tables on any column(s) using any predicate (=, >, < ).    Most of the time the join will use equality between a primary and foreign key.   Think of example where joining on something other than keys would be needed.  Write the query both as an English sentence and in SQL.  If you can't think of your own example, search the textbook or internet for an example.

English: Match each student to any course that gives more credits than the number of credits the student has already earned

SQL: select student.name, student.tot_cred, course.course_id, course.credits from student join course on course.credits > student.tot_cred;

What is your opinion of SQL as a language?  Do you think it is easy to learn and use?  When translating from an English question to SQL, what kinds of questions do you find most challenging?

This is the first class where I have really focused on SQL. TO be honest, I do find it easier to understand because it is very close to english. I think it still has its challenges, but the more practice you get the easier it becomes. Just now learning about different types of joins this week has been challenging for sure. Questions that are complex and require a long query can be hard to think of and find a solve. 

Comments

Post a Comment

Popular posts from this blog

Week 4 Learning Journal

Part 1: My goal is to graduate from the CS program with a strong foundation in software development, cybersecurity, and data systems so I can confidently land a full-time job as a cybersecurity engineer for the Department of Defense or a private defense contractor. I want to be skilled enough to pass security clearances, earn industry certifications like CompTIA Security+ and CISSP, and contribute to building secure, innovative technology that protects people and critical infrastructure. I see myself walking across the stage at graduation, proud of the hard work I've put in, and excited to step into a role where I can grow, learn, and make a real impact. Part 2: My goal is to become a cybersecurity engineer working with the Department of Defense or a top defense contractor like Lockheed Martin, where I can help design and protect mission-critical systems. I want to be part of projects that make a real difference in national security, using my skills to prevent cyber threats and bui...
Read more

Week 2 Learning Journal

Image
 Part 1: After reading the Effective Study Skills paper, I think the top 3 skills I am good at are developing a weekly schedule, making sure to read instructions to properly complete assignments, and ensuring I always have a quiet study space with no distractions. Some of these skills come with trial and error but they have proven to be most beneficial in studying successfully. I think 3 skills I need to work on are organizing my notes when researching, the SQ3R method, and making every hour count. These study skills and methods are important to practice because they will be a big step up in being efficient with studying.  Part 2: Activity log Part 3: Watching the three video presentations provided offered a lot of helpful tools that will boost my knowledge on project management. The first explained the five main phases of project management and the role of a project manager. The second showed how a Work Breakdown Structure (WBS) helps organize tasks into smaller parts for bet...
Read more

Week 7 Learning Journal

Part 1: For our team’s final research video project, we’ve been using Discord to communicate, and it’s worked really well. We chat frequently, ask each other questions, and keep everyone updated on progress. It’s been a smooth way to stay connected and make sure no one feels out of the loop. We’re using Google Slides to build our presentation and OBS Studio to record and edit the final video. So far, the process has been going pretty smoothly, but if I had to improve anything for next time, I’d suggest setting deadlines a little earlier to give ourselves more buffer room. Overall, the collaboration has been solid and productive. Part 2: This week’s materials made me think about how little things can have huge effects. I chose a TED talk on cybersecurity, I realized how something as simple as clicking a link can lead to serious consequences. It was a good reminder to stay alert online. A TED talk I was interested in was by Amy Cuddy. It was on body language and it was really interesting...
Read more