Databases & Web Development
BUT Computer Science

Databases & Web Development BUT Computer Science Revision Sheets

Databases and web development are the most used skills in companies: 70%+ of IT projects involve SQL and/or a web stack. BUT Info trains in these two disciplines in depth from year one.

AI sheets in 30sAdapted to BUT Computer Science curriculum100% free

Databases & Web Development curriculum in BUT Computer Science

The curriculum covers data modeling (Merise: CDM, LDM, PDM; UML: class, sequence diagrams), in-depth SQL (DDL, DML, joins, subqueries, window functions, ACID transactions), relational DBMS (MySQL, PostgreSQL) and NoSQL (MongoDB, Redis basics), full-stack web development (HTML5, CSS3, JavaScript ES6+, React or Vue client-side, Node.js or PHP/Symfony server-side), and REST APIs.

Merise modeling: CDM, LDM, PDM
UML modeling: class, sequence, state
Advanced SQL: joins, subqueries, windowing
ACID transactions and isolation
NoSQL: MongoDB, Redis, ElasticSearch
HTML5, CSS3, JavaScript ES6+
Frontend frameworks: React, Vue.js
Backend: Node.js, Symfony, Express, REST API

How to study databases & web development in BUT Computer Science?

3 simple steps for effective databases & web development revision.

1

Upload your course

Import your databases & web development course (PDF, text or photo) into Revizly.

2

Generate study sheets

AI analyzes your course and generates structured revision sheets in 30 seconds.

3

Practice with quizzes

Test your knowledge with automatically generated quizzes and flashcards.

Tips to succeed in databases & web development BUT Computer Science

1
Tip 1

Master SQL joins (INNER, LEFT, RIGHT, FULL OUTER) with use cases: tested in every exam and job interview

2
Tip 2

For web, learn HTML/CSS/JS fundamentals BEFORE diving into React or Vue: too many students skip and struggle later

3
Tip 3

Build 3-4 complete web projects on GitHub during BUT: your showcase for recruiters

4
Tip 4

Learn REST APIs: HTTP verbs (GET, POST, PUT, DELETE), status codes (200, 201, 400, 401, 404, 500), JSON formats. Essential in modern architecture

FAQ — Databases & Web Development BUT Computer Science

Difference between SQL and NoSQL?

SQL (Structured Query Language) is used with relational databases (MySQL, PostgreSQL, Oracle) where data is structured in tables with rigid schema and inter-table relations. ACID transactions guarantee consistency. NoSQL groups multiple paradigms (document with MongoDB, key-value with Redis, graph with Neo4j, columnar with Cassandra) with flexible schema. SQL is preferred for structured data needing strong consistency (banking, ERP). NoSQL for large volumes, semi-structured data, and horizontal scalability (social networks, IoT).

React or Vue.js: which for BUT Info?

React (Meta) has the largest ecosystem and job market (60-70% of front-end offers require React). Vue.js (Evan You) is more accessible for beginners but with a more limited market (~15-20% of offers). Pragmatic advice: first learn JavaScript ES6+ fundamentals then React (more profitable for employment). Vue.js can be learned as a bonus in a few weeks once React is mastered — concepts are transferable (components, props, state, hooks). In 2026, Angular remains 3rd but declining.

How to build a developer portfolio in BUT Info?

Five essential elements: 1) Clean GitHub profile with 5-10 personal projects (not just BUT), 2) A personal static site (Next.js, Astro) with presentation, projects, technical blog, 3) Complete LinkedIn profile (clear title: "BUT Info Student, Full-Stack Developer in training"), 4) Diversified projects: 1 full-stack web, 1 mobile, 1 data, 1 open source contribution, 5) Detailed READMEs for each project (tech used, challenges solved, demo link). Invest 5h/week on the portfolio during BUT — massive ROI in job search.

Start your databases & web development revision

Join thousands of students studying databases & web development more efficiently with Revizly.

Start for free

Other BUT Computer Science subjects

Continue your revision