MMaryinmaryjonah.hashnode.dev8 Week SQL Challenge - Case Study 5 (Data Exploration) Here we go with responses to questions in the second focus area: 2. Data Exploration of Case Study #5 - Data Mart What day of the week is used for each week_date value? SELECT DISTINCT DAYNAME(week_d17h ago·1 min read
MMaryinmaryjonah.hashnode.dev8 Week SQL Challenge - Case Study 5 (Data Cleansing Steps)Welcome to Case Study #5 - Data Mart and the section 1. Data Cleansing Steps In a single query, perform the following operations and generate a new table in the data_mart schema named clean_weekly_sal1d ago·2 min read
NSNuno Silvainedge-case.hashnode.devThe N+1 Problem in Spring Data JPA: A Practical GuideSpring Data JPA solves a real problem. It lets you model your domain as an object graph and persist it to a relational store without hand-writing every SQL statement. For writes, this is largely a goo3d ago·12 min read
SMStephen Mwangiinsqlnuggets.hashnode.devDay 2: SQL Filtering BasicsSQL allows users to filter data based on their preferences. WHERE The WHERE keyword allows users to filter data based on a certain condition. For data to be returned the set condition must equate to t4d ago·5 min read
APArnaud Pouppevilleinarnaudp.devHow Z-Order Cut My Databricks ETL Time in HalfI spent years working with SQL Server before moving to Databricks. In SQL Server, clustered indexes are second nature. You define them, the engine physically organizes rows on disk in that order, and your queries fly. When I started building data pip...4d ago·7 min read
ETEduard Tymchenkoinreleemdev.hashnode.devMySQL Memory Usage A Guide to OptimizationStruggling with MySQL memory spikes? Knowing how and where memory is allocated can make all the difference in maintaining a fast, reliable database. From global buffers to session-specific allocations, understanding the details of MySQL’s memory mana...4d ago·4 min read
SMStephen Mwangiinsqlnuggets.hashnode.devDay 1: Getting Started with SQLBasic Introduction SQL, short for Structured Query Language, is a language used to access and work with data stored in a database. To break it down: Data – Think of data as information about objects.E4d ago·4 min read
SSSaurabh Singh Rajputinbasics-of-sql.hashnode.dev🚀 The Ultimate Sql Master Guide1️⃣ What is SQL? (Foundation Strong Karo) SQL = Structured Query Language Used for: Storing data Retrieving data Managing data Controlling access Handling transactions SQL works with Relational Databases 2️⃣ How Relational Database Actually L...4d ago·4 min read
JJebitokinsharonjebitok.comDatabase SQL Basics (TryHackMe)Database SQL Basics is a pre-security room by TryHackMe that allows beginners to learn fundamentals of databases and the query language SQL which comes handy when learning about SQLI(SQL Injection) or other cybersecurity CTF challenges where the SQL ...5d ago·7 min read
MMaryinmaryjonah.hashnode.dev8 Week SQL Challenge - Case Study 4 (Data Allocation Challenge)This focus area: C. Data Allocation Challenge needed a lot of brainstorming between me and Claude AI. The summary of this focus area is that the bank has decided that data allocation will be based on The customer’s balance at the end of the previous...5d ago·1 min read
