Chandana Mahapatratechblogchandana.hashnode.dev·Nov 29, 2023Understanding SQLWhen designing a database system for an educational institution, it's common to have tables that represent students, subjects, and the enrollment of students in various subjects. In this article, we'll explore a scenario where we want to count the nu...Discuss#sqlproblem
Saifur Rahman Mahinsaifur-rahman39.hashnode.dev·Nov 19, 2023Explore SQL (Structured Query Language)Explore SQL (Structured Query Language) SQL, or Structured Query Language, is a domain-specific programming language designed for managing and manipulating relational databases. It provides a standardized way to interact with databases, allowing user...Discuss·8 likesBack-EndSQL
ishwar kokkiliishwarkoki.hashnode.dev·Nov 15, 2023SQL Problem of the day #1Problem statement: Find the location where the users were last spotted on each day. Table creation and data insertion script: CREATE TABLE visit_log( user_id int, user_name varchar(20), user_visit_location varchar(20), user_visit_time datetime DEFAUL...DiscussSQL
Puneet kumar Pandeyarticles2023.hashnode.dev·Nov 8, 2023SQL for Beginners: A Beginner's Guide to Understanding and Mastering the BasicsStructured Query Language, or SQL, is your key to organizing and retrieving useful data from databases. Whether you're new to web development or data management, or you just want to improve your technical abilities, SQL is a crucial tool to learn. In...Discuss·10 likesSQL
Kevin Naidookevincoder.co.za·Oct 15, 20236 useful SQL queries for web developers (MySQL)As a web developer, SQL is a very integral part of my day-to-day development workflow. Even when I use ORM or NoSQL - I can't imagine an extended period of time where I am not writing SQL. In this guide - I will cover some of the basic SQL statements...DiscussMySQL
Tim Lewistimlewis.hashnode.dev·Sep 25, 2023Seamless Integration: A Comprehensive Guide to Connecting Your Application to SQL ServerThe capacity to effortlessly interface your application with a relational database is essential in the data-driven world of today. The capabilities of your application can be substantially increased by connecting to a powerful database like SQL Serve...DiscussSQL Server
Digital Footprintsdigitalfootprints.hashnode.dev·Sep 24, 2023Basic SQL Concepts - Part 2Introduction So, we have covered some of the SQL basics in Part 1, let's continue from where we stopped and talk about different types of SQL first. SQL subsections Based on what the SQL commands do, they are divided into different subsections as bel...DiscussOracle
Digital Footprintsdigitalfootprints.hashnode.dev·Sep 21, 2023Basic SQL Concepts - Part 1Introduction SQL or Structured Query Language is a programming language that we use to communicate with our database. We write statements called 'queries' in SQL to create, update, and delete database objects and data stored in the database. Database...DiscussOracle
IYASERE ELIZABETHforLiz's bloglizyasere.hashnode.dev·Sep 21, 2023Your Easy Guide to Understanding SQL with Supermarket DataIntroduction Alright, imagine you're in a supermarket, pushing a cart down the aisles, picking up items. Now, think about all the information on those items: their names, prices, where they're located etc. Well, in the world of computers, there's a s...Discuss·1 like·52 readsSQL
Wobbly Geekwooblygeek.hashnode.dev·Sep 16, 2023SQL Data CleaningLEFT Pulls a specified number of characters for each row starting from the beginning i.e. the left side. product_idproduct_name 1Apple iPhone 13 2Samsung Galaxy S21 3Google Pixel 6 SELECT product_id, LEFT(product_name, 3) AS abbreviated_na...DiscussLearn SQLWomenWhoTech
