CLASS XII - IP (Python) - Unit II : Database Query using SQL (CH8 SETS and JOINS -in Mysql)

 


This note is prepared based on Informatics Practices written by Sumita Arora in the text book and board questions.

Click here to download notes.

Location: Karnataka, India

Comments

Post a Comment

Popular posts from this blog

CLASS XI_IP_CH 11 Structured Query Language(SQL)

Image
  5 Surprising SQL Secrets That Change How You See Databases Introduction: The Hidden Language of Data Every time you stream a movie, book a flight, or 'like' a photo, you're sending a message to a hidden world—a world run by databases. These vast, invisible systems don't speak English or Spanish; they communicate using a universal language called Structured Query Language, or SQL. At first glance, SQL seems simple—a straightforward way to ask for information. But beneath its surface lies a set of powerful, and sometimes counter-intuitive, rules and capabilities that are not immediately obvious. This post will reveal five of the most surprising and impactful concepts from the world of SQL that will change how you see this hidden language of data. 1. It’s a “What, Not How” Language Unlike most programming languages where you must provide a detailed, step-by-step recipe for the computer to follow (a procedural approach), SQL is different. It's a non-procedural, or dec...
Read more