Sql

SQL CHALLENGE #1: Danny’s Diner SQL Case Study In this article, I have solved Danny’s 8-Week SQL Challenge Case Study#1, I will explain how I have solved each question. Get access to the challenge here. To get the whole code click here. Introduction Danny seriously loves Japanese food so in the…

What is SQL Injection? SQLi is a kind of attack in web based application where the attacker canrun malicious queries in the a website’s database. SQL is a code injection technique used to execute malicious SQL statements. For example, if you want to login to the website and you forgotten the username and password…

How I’ve been learning SQL & developing results as a Data Analyst coming from a business, non-technical background After transitioning from a Business Development Specialist to a Data Analyst at Upaya, I had lots of catching up to do in terms of gaining technical skills. Before this, my role was…

1.1. CASE STATEMENT In this unit, we are going to learn about the CASE statement, it is an alternative conditional statement for the IF-Statement and CASE statement makes the code more efficient and readable. CASE statement has two forms: Simple CASE and Searched CASE. So, let’s learn about the CASE statement and their…

Tips to identify unreferenced values across your tables with Python If you have worked with relational databases, you must know SQL joins — they have many use cases, but in this post, I am going to focus on data cleaning. When performing left, right, or full outer joins, you create tables where either all records are present or just records…