Skip to main content
<FC/>
Log inRegister
  • Home
    • Articles772 articoli bilingue
    • PathsCurated learning paths
    • Track Event BuilderCareer matrix 4 levels × 5 skills
    • ResourcesBooks and guides
    • E-book10 technical guides for sale
    • University17 Italian universities plus over 30 international ones
    • University Notes10 educational series
    • ArcadeInteractive quizzes & themed games
    • Development Tools557 strumenti gratuiti
    • Public dataCC-BY dataset (citable)
    • API DatasetPay per use: €5 for every 1,000 queries
    • EnterpriseTools for companies XPHX0XPHX Aziende di piccola e media dimensione possono utilizzare strumenti come Microsoft 365 o Google Workspace per gestire le loro risorse informatiche. Le aziende più grandi possono richiedere soluzioni più complesse, come Microsoft 365, che offre una gamma completa di strumenti per la gestione delle risorse umane, finanziarie e informatiche.
    • DemoAngular Server-Side Rendering Template 41
    • Open SourceGitHub Projects - MIT License
    • ProjectsOpen Source Showcase
    • Who am IBackground and focus
    • ApproachHow I work
  • Log inRegister
  • Communities
  • Let's collaborate
  1. Home
  2. Blog
  3. Sistemi Informativi Database 04 04 Sql Avanzato Cte Window Functions Json Queries
  1. Home
  2. Blog
  3. Information Systems & Databases
  4. 04 — SQL avanzato: CTE, window functions, JSON queries
Information Systems & Databases15-05-2026•Reading time8 min

04 — SQL avanzato: CTE, window functions, JSON queries

Oltre il SELECT base: Common Table Expressions ricorsive, funzioni finestra, query su colonne JSON in PostgreSQL.

databaseuniappuntididattica

💭What do you think about this article?

Condividi

At a Glance

Oltre il SELECT base: Common Table Expressions ricorsive, funzioni finestra, query su colonne JSON in PostgreSQL.

Telegram Community

AI Engineering and EU AI Act, 1 post per week.

Sign up for free
Previous Article
03 — Normalizzazione 1NF/2NF/3NF/BCNF: quando e perché
Next Article
05 — Indici, query plan, EXPLAIN: la performance dei database

Related Articles

Information Systems & Databases

06 — Transazioni ACID, isolation levels, NoSQL trade-offs

Proprietà ACID, livelli di isolamento SQL, teorema CAP, BASE e quando scegliere NoSQL.

8 min
Information Systems & Databases

05 — Indici, query plan, EXPLAIN: la performance dei database

B-tree, hash, GIN, GiST: scelta dell'indice giusto e lettura del piano di esecuzione di PostgreSQL.

8 min
Information Systems & Databases

03 — Normalizzazione 1NF/2NF/3NF/BCNF: quando e perché

Dipendenze funzionali, anomalie di aggiornamento, processo di normalizzazione e quando denormalizzar…

8 min

💡Did you like the article?

Share it, leave a comment, register to not miss the next ones.

Share this article

  • 𝕏X
  • inLinkedIn
  • 💬WhatsApp
  • ✈️Telegram
  • fFacebook
  • ✉️E-mail
📬
Subscribe to the Newsletter Receive 1 weekly newsletter on new AI engineering articles
→👤
Create a free account Save Favorites, Comment on Articles, Track Your Learning
→💬
Leave a note Share opinions, questions or experiences with the community
↓

Commenti

Caricamento commenti...

Accedi per lasciare un commento

Discuss this article in the community

Join the Telegram group to discuss with other developers, ask questions and share your experiences.

Blog ChannelCommunity Group

EU AI Act Developer Guide **Introduction** The EU AI Act is a regulation aimed at ensuring that artificial intelligence (AI) systems are developed and used in a way that respects human rights and promotes trustworthiness. As a developer, you play a crucial role in shaping the future of AI and contributing to its safe and responsible use. **Scope and Applicability** The EU AI Act applies to any organization or individual developing, deploying, or using AI systems within the European Union (EU). This includes developers, suppliers, and users of AI systems, as well as data controllers and processors. **Key Concepts** * **High-Risk AI Systems**: These are AI systems that pose a significant risk to individuals, society, or the environment. Examples include biometric identification systems, real-time facial recognition systems, and predictive policing systems. * **Low-Risk AI Systems**: These are AI systems that do not pose a significant risk to individuals, society, or the environment. Examples include language translation tools, chatbots, and virtual assistants. **XPHX0XPHX** To determine whether an AI system is high-risk or low-risk, you must conduct a thorough risk assessment. This involves identifying potential risks and mitigating measures, as well as ensuring that the AI system complies with relevant EU regulations. **XPHX1XPHX** The EU AI Act sets out specific requirements for developers of high-risk AI systems. These include: * Conducting regular audits and assessments to ensure compliance * Implementing appropriate security measures to protect against data breaches * Ensuring transparency and explainability in decision-making processes **Guidelines for Developers** To help you navigate the EU AI Act, we have developed a set of guidelines for developers. These include: * Conducting thorough risk assessments and implementing mitigating measures * Ensuring compliance with relevant EU regulations * Providing transparent and explainable decision-making processes By following these guidelines, you can ensure that your AI systems are safe, trustworthy, and compliant with the EU AI Act. **Conclusion** The EU AI Act is a critical step towards ensuring the safe and responsible use of AI. As a developer, you have a crucial role to play in shaping the future of AI and contributing to its trustworthiness. By following the guidelines outlined in this guide, you can help ensure that your AI systems are compliant with the EU AI Act and promote a safer, more trustworthy digital environment for all. **Additional Resources** For further information on the EU AI Act and its requirements, please refer to the official European Commission website or consult with a qualified legal expert.

Ebook 200+ pages: 17 controls + code examples.

Buy for €19

Did you like this article?

Explore other content on the blog or discover my projects

All ArticlesMy Projects

<FC/>

Enterprise AI applications documented. From concept to AWS deployment. Note: I preserved the formatting and capitalization style of the original text.

Connect to

GitHubLinkedinElectronic mail (e-mail) or email is a method of exchanging digital messages from an author to one or more recipients via computer networks, such as the Internet and other electronic communication systems. It allows users to send text-based information electronically through variousChannel TelegramChatbot for Telegram

Technical Contents

Articles Deep-DiveDeveloper Tools & AlgorithmsOpen Source ProjectsFeed RSS (Federico Calò)

Resources

Who Am IGitHub ProfileCommunityCollaborate

2026 Initiatives

Mastering Server-Side Rendering in AngularIngegneria del ContestoApulia Technology InsightsI'm ready to translate. What's the Italian text?

Legal

Terms of Use and Privacy NoticeTerms of ServiceCookie Policy **Cookies e tecnologie similari** Il nostro sito utilizza cookie e tecnologie simili per fornire servizi personalizzati e migliorare l'esperienza dell'utente. I cookie sono piccoli file di testo che vengono memorizzati sul tuo dispositivo quando visiti il nostro sito. **Tipi di cookie utilizzati** * Cookie tecnici: questi cookie sono necessari per consentire al nostro sito di funzionare correttamente e non possono essere disabilitati. * Cookie analitici: questi cookie ci aiutano a capire come gli utenti interagiscono con il nostro sito, in modo da poterlo migliorare. * Cookie pubblicitari: questi cookie vengono utilizzati per mostrarti annunci personalizzati. **Come gestire i cookie** Puoi modificare le impostazioni dei cookie nel tuo browser. Ecco come fare: 1. Apri il menu del tuo browser e seleziona "Impostazioni" o "Preferenze". 2. Clicca su "Cookie" o "Privacy" e seleziona le opzioni desiderate. 3. Seleziona l'opzione per bloccare i cookie o impostare le preferenze dei cookie. **Contattaci** Se hai domande sui nostri cookie, contattaci all'indirizzo [email protected].Community Guidelines

Where to Find Me

Available for consultations throughout all of Italy, with a base in Puglia.

Google Business Profile

Stay up to date

Get the best tech articles delivered straight to your inbox.

No spam. You can unsubscribe at any time.

© 2026 Federico Calò. All rights reserved.