Skip to main content

StudySphere

Search This Blog

Khayalon Ki Dunia - 5/365

on June 17, 2025

Get link
Facebook
X
Pinterest
Email
Other Apps

Your Father :

" The Person who lost Everything, Just to make you win."

Your Mother :

" The Person who was with you in every Pain."

Khayalon Ki Dunia

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Popular Posts

DAY_ 1 : Introduction In SQL

SQL _ Structured Query Language. * It is Standard Language used to manage, manipulate, and Query Relational databases. * It allows users to store, retrieve, update, and delete data efficiently. * SQL is widely used in database management systems like PostgreSQL, MySQL, SQL Server, and Oracle. # List of Basic SQL Query. * Database Operations * Table Operations * Insert Data * Retrieve Data ( SELECT ) * Filtering Data ( WHERE, LIKE, IN, BETWEEN ) * Sorting & Limiting Results * Updating & Deleting Data * Aggregate Functions * Joins ( Combining Data Fr...

DAY _ 5 : PostgreSQL Query Session.

👊 WHERE Clause The SELECT Statement returns all rows from one or more Columns in a table. To Retrieve rows that satify a specified condition, You use a WHERE Clause. SYNTAX : SELECT * FROM Table_Name WHERE First_Name = ' Phillip ' ; OR SELECT * FROM Table_Name WHERE First_Name = ' Phillip ' ; To Form the condition in the WHERE claiuse, You use comparison and logical Operators. Operator | Description = Equal > Greater Than < Less Than ...

DAY _ 2 : SQL Query Practice Session.

[ 1 ] Let's Begin Practice Session.👉 ..👉...👉 _ 👉. List down Existing databases. _ 👉. Check Prexisting Databases. SELECT datname FROM pg_database; _ 👉. Creating a new Database. CREATE DATABASE database_name; _ 👉. Change a Database. _ 👉. Deleting a Database. Here as, \c Database_name; DROP DATABASE database_name; _ [ 2 ] CRUD Operations 👊 Most Basic Operations in SQL Query. _ 👉. CREATE _ 👉. READ _ 👉. UPDATE _ 👉. DELETE _ # [ 3 ] Table : A Table is a collection of related data help in a table format with in a database. _ 👊. Creating a New Table 💭 CREATE _ : Creates a new table, database, index, etc. CREATE TABLE Person( Index INTEGER PRIMARY KEY ,"User_Id" VARCHAR(30) ,"First_Name" ...

DAY _ 6 : PostgreSQL Query Session.

👊 Data Types & Constraint 💬 Data Types : An attribute that specifies the type of data in a column of our databse table. PostgreSQL supports a wide variety of data types, broadly categorized into numeric, character, date/time, Boolean, Binary array, JSON, and other specilized types like UUID and Geometric types. These types are used to store different kinds in the database. (1). Numeric Types : (A). Integer : PostgreSQL offers several integer types : (i). Smallint (2 bytes) (ii). bigint (8 bytes) (iii). Integer (4 Bytes) ...

Khayalon Ki Dunia - 2/365

So True, Once I Made Mom cry, And the next Morning She Made me Breakfast. Than I Understand What True Love Look Likes. . .❤️ सच है, एक बार मैंने माँ को रुलाया, और अगली सुबह उसने मुझे नाश्ता कराया। तब मुझे समझ में आया कि सच्चा प्यार कैसा दिखता है. . .❤️

DAY _ 8 : Clauses in PostgreSQL

✅ Clauses in PostgreSQL : WHERE DISTINCT ORDER BY LIMIT LIKE We can operate with different operators in the WHERE clause: 🐦‍🔥 Relational Opeartors Greater Than or Equal to ( >= ) SELECT * FROM Employee WHERE Salary >= '100000'; Equal to ( = ) SELECT Emp_Id , First_Name , Last_Name , Depatment FROM Employee WHERE depatment = 'Engineering'; 🐦‍🔥 Logical Operators AND Operator - Combine two boolean expressions and return true if both expressions evaluate to true. SELECT * FROM Employee WHERE Depatment = 'Sales' AND Salary >= '100000' ; OR Operator - Combine two boolean expressions and return False if either expressions evaluate to false. SELECT * FROM Employee WHERE Hire_Date BETWEEN '07-07-2019' OR '09-07-2020'; 🐦‍🔥 LIKE LIKE Operator to match the first names of customers with a string using the following query. SELECT * FROM Employe...

Khayalon Ki Dunia - 1/365

मैं तुम्हें चाँद 🌙 कह दूं, ये मुमकिन तो है, मगर लोग 🧑🏻‍🤝‍🧑🏻 तुम्हें रात भर देखें, ये मुझे गवारा नहीं | It is possible for me to call you the moon 🌙 , but I cannot bear people 🧑🏻‍🤝‍🧑🏻 staring at you all night long.

IPL Sports Analysis Project in PostgreSQL

➣ IPL-Sports-Analysis-Project ➣ IPL Sports Analysis Project Using PostgreSQL. ➣ IPL - Indian Premier League 💬 IPL is a Professional Twenty20 Cricket League in India organised by the Board of Control for Cricket in India (BCCI). 💬 Founded in 2007, The League Features ten State or city based Franchies Teams. 💬 The IPL is the most Popular and richest Cricket League in the world and is held between March and May. 💬 IPL League Consists of Ten Teams. NO. | TEAM | City (01) | Chennai Super Kings(CSK) | Chennai, Tamil Nadu 💭 Chennai Super Kings (CSK) Owner : Narayanaswami Srinivas Won : 2010, 2011, 2018, 2021, 2023 Runner-UP : 2008, 2012, 2013, 2015...

DAY _ 7 : PostgreSQL Query Session.

✅ Assessment session for PostgreSQLQuery Session. To Create a table and insert data in PostgreSQL, use the CREATE TAB;E statement to define the table structure and the INSERT INTO statement to add rows. Now Create our first DATABASE where Named as " Employee Database " CREATE DATABASE Employee Database ; And Table name as "Employees" 🔜 Create a Table : CREATE TABLE Employees ( Emp_id SERIAL PRIMARY KEY, First_Name VARCHAR(50) NOT NULL, Last_Name VARCHAR(50) NOT NULL , Email VARCHAR(100) NOT NULL UNIQUE, Dept VARCHAR(50), Salary DECIMAL(10,2) DEFAULT 30000.00, Hire_Date DATE NOT NULL DEFAULT CURRENT_DATE ); ✅ This code snippet is from : CREATE TABLE Employees : Create table named "Employees". Emp_id SERIAL PRIMARY KEY : Create a column named "Emp_id" as unique,autoincrementing primary key. First_Name VARCHAR(...

Blinkit Grocery Analysis

✅Blinkit Analysis 🛒 ❇️ Business Requirements To conduct a comprehensive analysis of Blinkit's sales Performance, customer satisfaction, and inventory distribution to identify key insights and opportunities for optimization using various KPIs and visualizations in Power BI . ❇️ KPI's (Key Performance Indicator) Requirements 📊 (A). Total Sales : The Overall revenue generated from all items sold. (B). Average Sales : The Average revenue per sale. (C). Number of Items : The total count of different items sold. (D). Average Rating : The Average customer rating for items sold. ❇️ Chart's Requirements 📶 1️⃣ Total Sales by Fat Content 🎯 Objective : Analyze the impact of fat content on total sales. 📊 Additional KPI Metrics : Assess how other KPIs(Average Sales, Number of Items, Average Rating) vary with fat content. 📶Chart Type : Donut Chart. 2️⃣ Total Sales by Item Type 🎯 Objective : Identify the performance of different i...

Powered by Blogger

Theme images by konradlew