prikaz prve stranice dokumenta Prozorske funkcije u SQL-u
  Download
PDF 2.34 MB
undergraduate thesis
Prozorske funkcije u SQL-u
2022. urn:nbn:hr:165:264518
Matić, Josip
Virovitica University of Applied Sciences

Cite this document

Matić, J. (2022). Prozorske funkcije u SQL-u (Undergraduate thesis). Virovitica: Virovitica University of Applied Sciences. Retrieved from https://urn.nsk.hr/urn:nbn:hr:165:264518

Matić, Josip. "Prozorske funkcije u SQL-u." Undergraduate thesis, Virovitica University of Applied Sciences, 2022. https://urn.nsk.hr/urn:nbn:hr:165:264518

Matić, Josip. "Prozorske funkcije u SQL-u." Undergraduate thesis, Virovitica University of Applied Sciences, 2022. https://urn.nsk.hr/urn:nbn:hr:165:264518

Matić, J. (2022). 'Prozorske funkcije u SQL-u', Undergraduate thesis, Virovitica University of Applied Sciences, accessed 11 April 2024, https://urn.nsk.hr/urn:nbn:hr:165:264518

Matić J. Prozorske funkcije u SQL-u [Undergraduate thesis]. Virovitica: Virovitica University of Applied Sciences; 2022 [cited 2024 April 11] Available at: https://urn.nsk.hr/urn:nbn:hr:165:264518

J. Matić, "Prozorske funkcije u SQL-u", Undergraduate thesis, Virovitica University of Applied Sciences, Virovitica, 2022. Available at: https://urn.nsk.hr/urn:nbn:hr:165:264518

Please login to the repository to save this object to your list.
Metadata
TitleProzorske funkcije u SQL-u
Title (english)SQL WINDOW FUNCTION
AuthorJosip Matić
MentorDamir Vuk (mentor)
MentorEnes Ciriković (komentor)
Committee memberEnes Ciriković (predsjednik povjerenstva)
Committee memberDamir Vuk (član povjerenstva)
Committee memberMarko Hajba (član povjerenstva)
GranterVirovitica University of Applied Sciences
Virovitica
Defense date and country2022-11-22, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Electrical Engineering
Abstract
U radu se obrađuje tema prozorskih funkcija u SQL-u. Rad obuhvaća teorijsku obradu, ali i praktičnu primjenu pomoću više alata za manipulaciju baza podataka. U radu je korištena literatura iz internetskih izvora, knjiga i časopisa, U teorijskom dijelu obrađeni su koncepti, klauzule i prozorske funkcije SQL standarda. U praktičnom dijelu korišteni su i provjeravani jednostavniji primjeri implementirani u četiri sustava za upravljanje bazama podataka: PostgreSQL, SQL server, SQLite i MySQL. Na primjerima su utvrđene sličnosti i razlike u implementaciji u tim sustavima za upravljanje bazama podataka.
Abstract (english)
The paper deals with the topic of window functions in SQL. The work includes theoretical processing, but also practical application using several tools for database manipulation. Literature from internet sources, books and magazines was used in the paper. Concepts, clauses and window functions of the SQL standard were covered in the theoretical part. In the practical part, simpler examples implemented in four database management systems were used and checked: PostgreSQL, SQL server, SQLite and MySQL. Similarities and differences in the implementation of these database management systems have been determined on the examples.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:165:264518
Study programmeTitle: Undergraduate Professional Study Of Electrical Engineering; specializations in: Telecommunications and Information Technology
Course: Telecommunications and Information Technology
Study programme type: professional
Study level: undergraduate
Academic / professional title: stručni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka elektrotehnike (stručni/a prvostupnik/prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka elektrotehnike)
Type of resourceText
File originBorn digital
Access conditionsOpen access
Terms of useLicence In copyright icon
Created on2023-02-08 14:33:50