YujinSQL 101 | Chapter 7: Using Joins to Combine and Unify DataJoins allow you to combine data from multiple tables. Learn how these can be the foundation of recommendations and collaborative filtering…3d ago3d ago
YujinSQL 101 | Chapter 6: Elevating Data Presentation — Advanced Sorting Techniques for Deeper InsightsThis chapter delves into multi-level sorting, sorting based on computed columns, and handling case-insensitive or locale-specific…Nov 11Nov 11
YujinSQL 101 | Chapter 5: Advanced SQL Filtering — How to Refine Your Queries for Better Data InsightsThis chapter covers WHERE conditions, pattern matching, range filtering, and null checking, providing clear examples and explanations…Nov 4Nov 4
YujinSQL 101 | Chapter 4: SQL Aliases — Learn How to Improve Query Readability and MaintainabilityLearn how SQL aliases can make your queries cleaner and easier to understand. This article breaks down how to use aliases for columns and…Oct 28Oct 28
YujinSQL 101 | Chapter 3: Mastering Data Retrieval with SELECT StatementsLearn how to master data retrieval with SQL in this comprehensive guide. Explore SELECT basics, filtering with WHERE, sorting with ORDER…Oct 21Oct 21
YujinSQL 101 | Chapter 2: Setting Up Your Database EnvironmentSetting up a robust and efficient database environment is a crucial step for businesses and individuals alike. Whether you’re managing data…Oct 14Oct 14
YujinSQL 101 | Chapter 1: Understanding SQL and DatabasesHow do databases serve as efficient repositories of structured data, and how does SQL (Structured Query Language) enable businesses to…Oct 7Oct 7
YujinSQL 101 | Summary of Most Used SQL Syntax for Data AnalysisThis comprehensive summary sheet / cheat sheet covers from basic `SELECT` statements to advanced joins, subqueries, and query optimization.Sep 30Sep 30
YujinThe Future of Web Apps — “Offline-First” and “Peer-to-Peer” DesignAs the web continues to evolve, developers are seeking new ways to enhance the performance, privacy, and resilience of web applications…Sep 23Sep 23
YujinThe Secrets of Cloud Services — Avoid Hidden Traps and Maximize BenefitsThe secret of cloud services. Before you use it, there are some things you should know. How can you maximize the benefits of using the…Sep 10Sep 10