Information Management 1 LECTURE- MODULE NO.4 BY JAVIER

JAVIER JOHN IVERSON S.

BSCS 1D

SQL, or Structured Query Language, is like the language used to talk to databases. It helps us manage and get information from big sets of data stored in databases. With SQL, we can do things like find specific information, add new data, change existing stuff, or even get rid of things we don't need anymore. It's like having a special key to unlock a treasure chest full of useful information.

Think of it this way: Imagine you have a giant library with books all over the place. SQL is like the librarian who helps you find the book you want. You can ask SQL questions like "Show me all the books by this author" or "Tell me how many books were published this year." SQL understands these questions and finds the answers for you in the database. It's like having a super-smart assistant who can find what you need quickly.

And it's not just about finding stuff – SQL also helps organize data. Just like we put things in different places at home, SQL helps organize data into tables in databases. You can set up rules to keep data clean and make sure everything stays organized. In simple terms, SQL helps us make sense of data, turning it from a messy pile into something we can use to learn, make choices, and come up with new ideas.


Comments

Post a Comment

Popular posts from this blog

MIDTERM - LECTURE SEATWORK - JAVIER, JOHN IVERSON S.

Image
INFORMATION MODEL An information model is like a plan for organizing data, making it easier to understand and use. It helps us see how different pieces of information are connected. For instance, in a database, it shows how tables relate to each other. By using an information model, we can design better systems for storing and finding data. It's sort of like creating a map for how information should be organized and accessed. In short, information models help us manage data more effectively. DATA MODEL A data model is like a plan for organizing information so it will be easy to use. It puts data into groups called entities and shows how they're connected through diagrams. Entities are like collections of things, and attributes describe those things.  The model makes sure the data stays correct by checking that it's all linked properly. Plus, it lets us ask questions and get answers using queries, which are like requests for specific information from the data. There are 3 ma...
Read more