Resurse BAC IT —
Cheat Sheets & Referințe

x = 10
name = "Ion"
is_ready = True

int, float, str, bool
list, tuple, dict, set

+, -, *, /, //, %, **
==, !=, <, >, <=, >=
and, or, not

if x > 0:
  print("pozitiv")
elif x == 0:
  print("zero")
else:
  print("negativ")

for i in range(5):
  print(i)

while x > 0:
  x -= 1

def greet(name):
  return f"Salut, {name}!"

result = greet("Ion")

lst = [1, 2, 3]
lst.append(4)
lst.remove(2)
len(lst)  # 3

d = {"cheie": "valoare"}
d["nou"] = 99
print(d.get("cheie"))

try:
  x = int("abc")
except ValueError:
  print("Eroare!")

with open("f.txt", "r") as f:
  content = f.read()

with open("f.txt","w") as f:
  f.write("text")

SELECT coloana FROM tabel
WHERE conditie
ORDER BY coloana DESC
LIMIT 10;

INNER JOIN -- doar rânduri comune
LEFT JOIN  -- toate din stânga
RIGHT JOIN -- toate din dreapta
FULL JOIN  -- toate

COUNT(*), SUM(col)
AVG(col), MIN(col), MAX(col)
GROUP BY col
HAVING COUNT(*) > 5

CREATE TABLE elevi (
  id INT PRIMARY KEY,
  nume VARCHAR(100),
  nota DECIMAL(4,2)
);

INSERT INTO elevi VALUES (1,'Ion',9.5);
UPDATE elevi SET nota=10 WHERE id=1;
DELETE FROM elevi WHERE id=1;

SELECT * FROM elevi
WHERE nota > (SELECT AVG(nota)
              FROM elevi);