< Nazad na kurseve

Uvod u SQL i baze podataka

Nauči da projektuješ baze podataka i pretražuješ ih. Nauči da barataš velikim podacima.

SQL kurs je za apsolutne početnike, ali se podrazumeva osnovna računarska pismenost.

Uvod

• Uvod u SQL
• Uvod u baze podataka
• Relacione baze podataka
  • Relacione vs nerelacione baza podataka (NoSQL)
• Sistemi za upravljanje bazama podataka
• Instalacija MySQL-a i phpMyAdmin-a

Pravljenje baze

• Modelovanje podataka
• Creating a table and inserting data
• Vežba: biblioteka
• Vežba: Design a store database

Upiti

• Querying the table
• Aggregating data
• More complex queries with AND/OR
• Querying IN subqueries
• Restricting grouped results with HAVING
• Calculating results with CASE
• Challenge: Gradebook

Relacije

• Designing relationships
• Splitting data into related tables
• Referencijalni integritet
• Vežba: odvoj autore knjiga u posebnu tabelu

Relacioni upiti

• JOINing related tables
• Joining related tables with left outer joins
• Joining tables to themselves with self-joins
• Combining multiple joins
• More efficient SQL with query planning and optimization
• Challenge: Customer’s orders

Modifying databases with SQL

• Using SQL to update a database
• Changing rows with UPDATE and DELETE
• Altering tables after creation
• Make your SQL safer

Normalizacija podataka

• Why normalize data?
• Normalization terms
• Levels of normalization
• Denormalization
• Vežba: Normalizing raw data

SQL kroz programske jezike

• Upotreba SQL-a kroz Python
• Upotreba SQL-a kroz PHP
• Upotreba SQL-a kroz JS