CST363: Learning Journal Week 2


1.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.


SELECT e.employee_id, e.employee_name, e.supervisor_id, s.supervisor_name

FROM employees e

LEFT JOIN supervisors s ON e.supervisor_id = s.supervisor_id;


2.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?


SQL is a powerful and widely used language for managing relational databases. It provides a standardized way to interact with databases, making it easy to retrieve, update, and manipulate data. The language is relatively easy to learn, especially for basic queries, and its syntax is expressive and readable.


When translating from an English question to SQL, the most challenging part might be structuring complex queries involving multiple tables or incorporating advanced features like subqueries or window functions. Understanding the database schema and relationships is crucial for crafting effective SQL queries.


Overall, SQL is a valuable skill for anyone working with databases, and its versatility makes it suitable for a wide range of applications.

Comments

Post a Comment

Popular posts from this blog

CST438 Week 6 Journal

This week i learned about Service-Oriented Architecture (SOA) and its significant impact on modern software development. I learned that SOA promotes the creation of independent services that can communicate over a network, enhancing interoperability and system flexibility. This architecture allows for better scalability, as services can be independently updated and reused across different applications. However, I also recognized the challenges associated with SOA, such as increased complexity and the need for effective data management and governance. Overall, understanding SOA has given me valuable insights into designing systems that can adapt to changing business needs while optimizing resource utilization.
Read more

CST439 Week 10 Journal

What project milestones did you accomplish this week? If you're working in a team, please list what you personally contributed, not the project status overall.     I looked for data for Ifo Business Climate and Manufacturing PMI for Germany. What is your plan for next week?     Look for  Ifo Business Climate and Manufacturing PMI for other European countries. What challenges, if any, are you currently facing in project development? Do you need instructor assistance?     None
Read more

CST499 Week 14 Journal

What project milestones did you accomplish this week? Started working on Part 1 and 2 of Project Status Update and Project Testing. Also started working on the presentation. What is your plan for next week? Finish the above. What challenges, if any, are you currently facing in project development? Do you need instructor assistance? None.
Read more