Rishikant Dwivedi

Software Developer || Programmar || Author ||

[Rishikant Dwivedi @rishid9165]

@GlobalEllah Interested

[Rishikant Dwivedi @rishid9165]

@JobFound5 interested

[Rishikant Dwivedi @rishid9165]

Everyone in the team is temporary, but Washington Sundar seems to have a lifetime subscription to all three formats. 😭🏏

No matter who comes in or goes out, you'll always find Washington Sundar in the squad somewhere.

[Rishikant Dwivedi @rishid9165]

@dubeyjuganguly @mufaddal_vohra good point👍

[Rishikant Dwivedi @rishid9165]

@Rizzvi73 is bhadve ko sab unfollow kro bhai log

[Rishikant Dwivedi @rishid9165]

@Indian_Analyzer reservation should be 100%

[Anuradha Tiwari @talk2anuradha]

Dear 30% General Category,

Every political party has declared war against us.

We must unite and fight back — this is a battle for our survival.

[Rishikant Dwivedi @rishid9165]

@BJP4TamilNadu @grok convert in hindi

[Altamash Iqbal @altamashi25]

He is not Journalist ! He is just a troller with millions of followers ! 🤦🏻‍♂️ #ViratKohli𓃵 #ranjitrophy2025 #delhivsrailways #railwaysvsdelhi

[Rishikant Dwivedi @rishid9165]

Transaction Control Language (TCL)
Purpose: Manage transactions in the database, ensuring data integrity and consistency.

TCL commands work in conjunction with DML to handle changes.

[Rishikant Dwivedi @rishid9165]

Day 1: Introduction to SQL
Topics to Cover:

What is SQL?
Importance of databases and SQL.
Types of SQL commands: DDL, DML, DCL, TCL.
Setting up the environment (e.g., MySQL, PostgreSQL, or SQLite).
Writing your first SQL query: SELECT.

[Rishikant Dwivedi @rishid9165]

🔍 Types of SQL Commands: DDL, DML, DCL, TCL
SQL commands are categorized based on their purpose in managing and interacting with databases. Let’s dive into the four main types: DDL, DML, DCL, and TCL.

[Rishikant Dwivedi @rishid9165]

Data Control Language (DCL)
Purpose: Manage access permissions and security of the database.

DCL commands control who can access or manipulate data.

[Rishikant Dwivedi @rishid9165]

Purpose: Manipulates the data stored within tables.

DML commands do not auto-commit, allowing changes to be rolled back.
Common Commands:

INSERT: Add new records into a table
UPDATE: Modify existing records in a table
DELETE: Remove records from a table.
sqlCopyEdit

[Rishikant Dwivedi @rishid9165]

1️⃣ Data Definition Language (DDL)
Purpose: Defines and modifies the structure of database objects (tables, indexes, etc.).

These commands deal with the schema and structure of the database.
DDL commands are auto-committed, meaning changes are saved permanently.
Common Commands:

[Rishikant Dwivedi @rishid9165]

🌟 Importance of Databases and SQL 🌟
In today’s tech-driven world, data is the backbone of nearly every application, service, and decision-making process. Managing and accessing this data efficiently is crucial, and that’s where databases and SQL come into play.

[Rishikant Dwivedi @rishid9165]

SQL (Structured Query Language) is a standard programming language used to interact with relational databases. It enables users to store, retrieve, manipulate, and manage data efficiently.

[Rishikant Dwivedi @rishid9165]

What You Can Expect:
📌 Day 1-3: SQL Fundamentals

Introduction to SQL
Understanding Databases, Tables, and Relationships
Basic Queries: SELECT, WHERE, and ORDER BY

[Rishikant Dwivedi @rishid9165]

I’m excited to announce that I’ll be kicking off a 10-day SQL series where I’ll dive into the world of Structured Query Language (SQL)! 🎯 Whether you’re a beginner looking to learn the basics or someone who wants to refine their skills, this series is for you.

[Rishikant Dwivedi @rishid9165]

#Day5 #75DaysCoding #programmingprobs
@LeetCode

POTD [2661: First Completely Painted Row Or Column ]