Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

SQL NOTES FOR PROGRAMMING, Cheat Sheet of Computer Programming

These notes provide a detailed and structured overview of Structured Query Language (SQL), suitable for beginners and intermediate learners. Compiled during the 2024 academic year, the material is based on content from the Database Management Systems (DBMS) course offered in the B.Sc. Computer Science program at University. The document covers both theoretical concepts and practical SQL commands, ideal for students, self-learners, and exam preparation.

Typology: Cheat Sheet

2024/2025

Available from 05/11/2025

tarun-singh-jodha-1
tarun-singh-jodha-1 🇮🇳

3 documents

1 / 30

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e

Partial preview of the text

Download SQL NOTES FOR PROGRAMMING and more Cheat Sheet Computer Programming in PDF only on Docsity!

| _SBGis cintrodueiiones] faa ae Database + J} [s on Organized collection of x | data so -thar tt can be easily (Occesse tre + [6_manage these databases, DBms (Database | Managem ent Suystera ) ave used. Database | DBMS ss | | [8s 2 lee ZA ey, “ BaaesRe, este ey | [TS pes _©F DEMS j- eqUL cumee ( Linkedin [Tooteres ¢ | Kelotional DBMS a AEA tt SSC Teteqeaes | Non- ‘Relational DRMS _Reiatfonal DBMS t- Th this DBms data Stored | \n -mble fermot. founio | Nome class | \ Jot 5x zi 2 frmax a" 3 Frnus ad y Ram A Foy CyamPlet- My Sot, Oracle. eee LASSTIME}Pg. No. Dee He “Roll No” + 1, i mney Gp & tome.) Savane ie ( nton ~ [2elational Dems). odB , Redts SOL Tt stand fox 7 CQL Between t-_ he Th ts used +n Giter deta based on o range —— of Values In a were clouse. Cuntoy s- SELecT Columnt , Column 2,--. ERom +table_ name. winere Column name Between \yoatuet AnD Value 2 5 — i SQ. Auras a Tt ig used to give @ tern porary nam 2 +o a toble or a “Column_in a _query is | Cuntoy ee > ceveer Columnaname af abias_ name __ ____ Beforn srodale 1 oun es