Week 3 learning journal SQL

 

This week I learned more about how SQL views work and how they compare to regular tables. An SQL view is essentially a saved query that behaves like a virtual table. I can use it to simplify complex queries, provide a layer of security, or just make my code easier to read. Views are similar to tables because I can query them using SELECT statements and treat them like they store data. However, they don’t actually hold physical data the way tables do. Instead, they pull data dynamically from the underlying tables. Another difference is that while I can insert, update, or delete rows in a table, those operations are usually limited or not possible in views, especially if the view is based on multiple tables or includes aggregate functions. Views also don’t have primary keys like tables do, since they aren’t storing unique rows themselves.

Now that we’ve wrapped up SQL, I’ve also been reflecting on how it compares to other programming languages I’ve studied, like Java. One similarity is that both SQL and Java use conditional logic—WHERE clauses in SQL remind me of if statements in Java, since both filter or control what happens based on a condition. Another connection is that SQL’s SELECT statement is a little like Java’s return statement, since both specify what the output should be. At the same time, SQL is really specialized for working with data and databases, while Java is a general-purpose language that lets me build applications. For example, in Java I can use loops, create objects, and control program flow, which aren’t part of SQL. On the other hand, SQL has powerful features for querying large datasets and performing calculations directly on data in a way that would take much more work in Java.

Overall, I see SQL and Java as complementary. SQL gives me the tools to manage and manipulate data efficiently, while Java gives me the structure and logic to build programs around that data. Learning how the two connect helps me understand how applications and databases communicate in the real world.

Comments

Post a Comment

Popular posts from this blog

Week 2 Learning Journal 5 Parts

  Part 1: Review and Reflect Learning Strategy Top 3 Strengths: Active Listening: I excel at fully concentrating, understanding, and responding thoughtfully during discussions, which enhances my learning and collaboration. Goal Setting: I consistently set clear, achievable goals, which helps me stay focused and motivated throughout my academic journey. Time Management: I effectively allocate my time to balance academic responsibilities, extracurricular activities, and personal commitments. Top 3 Areas for Improvement: Note-Taking Skills: I aim to develop more structured and efficient note-taking methods to better retain and review information. Critical Thinking: I seek to enhance my ability to analyze and evaluate information critically to strengthen my problem-solving skills. Public Speaking: I plan to build confidence and clarity in presenting ideas to groups, which is essential for academic and professional success. Part 2: Preview Time Management Sk...
Read more

Week 4 Journal

 Part One: Set Your Educational Goals My main academic objective at CSU Monterey Bay is to graduate with two full-stack apps designed and delivered, one individually and one jointly. These applications should have continuous deployment pipelines, automated testing suites, and version control. My goal is to obtain two industry-recognized certifications concurrently with my degree program: the CompTIA Security+ certification by December and the AWS Certified Cloud Practitioner by August. In addition to enrolling in a Security+ bootcamp and completing at least 85 percent of the practice tests and AWS modules every two weeks, I'll be keeping a strict timetable to track my progress. I will know I have accomplished this goal when I can confidently demonstrate an application that implements best-practice security measures and allocates cloud resources on AWS without consulting my notes. Part Two: Extended Career Goals To get practical experience and expand my professional network, I w...
Read more

BOOK REPORT EXTRA CREDIT

Book Report: The 21 Irrefutable Laws of Leadership: Follow Them and People Will Follow You by John C. Maxwell John C. Maxwell’s The 21 Irrefutable Laws of Leadership presents a comprehensive framework for understanding and practicing leadership across contexts—from small student organizations to large tech corporations. First published in 1998 and reissued in 2007, Maxwell’s text distills decades of research and experience into 21 guiding “laws” that promise to equip emerging leaders with the insights and habits necessary to inspire trust, drive change, and cultivate followership. As a senior in computer science preparing to transition into industry roles—where technical expertise must be matched by soft skills—Maxwell’s principles offer a structured roadmap for leading teams, managing projects, and influencing stakeholders. Structure and Organization Maxwell organizes the book into 21 chapters, each dedicated to one “law.” Every chapter follows a consistent pattern: Law Statement : ...
Read more