Me, Myself and I

Hey there, web warriors! Another blog post for you guys! In my last blog post, we've talked a little bit about SQL but now let's delve deeper in studying the field of managing information! When it comes to building killer web experiences, we've got a trio of tech rockstars leading the charge: XML, JSON, and AJAX. In this blog post, we're gonna hang loose and get to know these cool cats and how they team up to bring us dynamic and interactive web applications. So, grab your shades, and let's dive in!

XML: The Structured Data Champ:

Alright, picture this: XML is like the wise old owl of structured data formats. It's got this knack for organizing information with tags, creating a tree-like structure that's easy to follow. XML can handle all sorts of data, from customer profiles to product catalogs. It's the organizational guru of the web development world.

JSON: The Lightweight Data Superstar:

Now, let's meet JSON, the young and sprightly sibling of XML. JSON is all about keeping things light and breezy. It's like the cool kid on the block that everyone loves. JSON's simplicity and readability make it a hit. It's like having a chat with your data in a language that's effortlessly understood by both humans and machines. Talk about good vibes!

AJAX: The Web App Magician:

Last but not least, let's introduce AJAX, the ultimate web app magician. AJAX stands for Asynchronous JavaScript and XML (we've got XML making an appearance again!). This sorcerer of the web world is all about making things happen in the blink of an eye. It lets your web page communicate with the server behind the scenes, fetching data and updating content on the fly. No more boring page refreshes—AJAX brings the fun and interactivity to the party!

How They Jam Together:

XML and JSON make quite the power couple in the data exchange dance. XML's structure is great for organizing data on the server side, while JSON's simplicity makes it perfect for sending that data across the web. They complement each other like two peas in a pod, making data communication smooth as silk.

But wait, there's more! AJAX swoops in to take the stage. It combines JavaScript, XML, and JSON to create web apps that are as lively as a rock concert. With AJAX, you can send requests to the server in the background, get data, and update specific parts of your web page without interrupting the groove. It's like having a conversation with the server while your users keep on jamming.

Hey there! In our Information Management 1 class, we're diving deeper into the world of SQL and how to use it effectively. Join me as we explore the ins and outs of this powerful tool and learn how to implement it like a pro!

Before we delve deeper into the complexities of SQL, let's take a quick refresher on the basics. In my previous blog, I briefly introduced SQL as an acronym for Structured Query Language, which allows us to easily access and manipulate databases. As a quick recap, SQL is an essential tool for managing and organizing large amounts of data, and it's used in a wide range of industries from finance to healthcare.

Guess what? SQL isn't just any ordinary language—it's THE standard language for accessing and playing around with databases! And you know what's even cooler? It's passed the super important ANSI standard. Hold up, what does that mean? Well, it basically means that SQL has been officially recognized and adopted by the American National Standards Institute (ANSI). Talk about legit!

Why is this ANSI recognition such a big deal? Well, it ensures that SQL is implemented consistently across different database management systems (DBMS). That's right, whether you're using MySQL, Oracle, or any other DBMS, you can count on SQL to work its magic. This standardization also brings a whole bunch of benefits like portability and interoperability. In simple terms, it means you can easily move your SQL code between systems without any major headaches.

So, next time you're tackling a database project or trying to make sense of all that data, remember that SQL is your trusty sidekick. It's the language that keeps things running smoothly, ensuring your data is accessible, manageable, and ready for action. With SQL by your side, you'll conquer the database world like a pro!

SQL (Structured Query Language) is an incredibly powerful tool that opens up a whole new world of possibilities when it comes to managing and manipulating data. Whether you're a developer, data analyst, or business professional, SQL is a must-have skill that can revolutionize the way you work with databases.

So, what exactly can SQL do? Let's dive in!

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

In conclusion, SQL is a game-changer in the world of data management and analysis. As the standard language for accessing and manipulating databases, it has proven its worth by passing the ANSI standard, gaining recognition and adoption by the American National Standards Institute. This achievement ensures consistency and compatibility across various database management systems, allowing for seamless portability and interoperability.

With SQL, you have the power to retrieve data, modify records, create and manage databases, perform calculations, generate reports, and ensure data integrity. It's a versatile tool that empowers developers, data analysts, and business professionals to efficiently work with data, extract valuable insights, and make informed decisions.

By investing time and effort in mastering SQL, you unlock a world of possibilities in harnessing the potential of your data. Whether you're crunching numbers, organizing information, or generating reports, SQL is your go-to language for efficient and effective data manipulation.

Hello! I’m back again! Today I’m going to share my understanding about SQL and it own DDL and DML Commands!  First let's start by defining SQL is. SQL stands for Structured Query Language and it let’s us access and manipulate database. In other words, it helps us to administer the proper executions and manipulations of entire database itself.

In SQL it has its own DDL and DML. DDL stands for Data Definition Language and DML stand for Data Manipulation languages. These two are a component of SQL.

DDL or Data Definition Language is a set of SQL commands used to define relation schemes and constraints of a database.  DDL is mainly used for changing the structure of the database.

Here we are again another content about my newfound knowledge in Information management 1! In this blog I’m going to talk about my understanding about these three key words: database, excel, and access. I know right. What excel and access have to do with databases? Well, let’s unfold what I leaned about this topic.

First of all, as to not mix up things, let us first talk about my understanding about database. What is a Database? Well, basically database is an organized collection of information, or data. Or in other words, database let us store information in an organized way for specific purpose.  Database have three components, which is the definition, rules for validating and manipulating data, and the data itself. Definitions is the origin of a field that references a data domain and determines the data type and the format of data entry. For examples, title field, data types, and limitations. Meanwhile, rules for validating and manipulating data, is just the rules and functions that we need to know and do in managing data in databases. Lastly is the data itself. Data is will not be missing if we are talking about data base components because this is the reason why there is database and database are the one where we store information or data in a organize way.

Also, we have to keep in mind that database have four types which is the flat, hierarchical, relational, and object-oriented database. Let’s explain each of them. In Flat database, all entries are recorded as single rows of data separated by tabs or commas, and each database must be represented as a single table. Which means that flat database is prone to data redundancy and errors. Next, is hierarchical database. In this type of database, information is kept in records and arranged into a parent-child structure that resembles a tree, with one parent node having several child nodes that are connected by links. In a relational database, data is kept in one or more tables of columns and rows, making it simple to see and comprehend how various data structures connect to one another. Data is organized in relational databases according to predetermined relationships. Lastly, we have object-oriented database. This type of database that is based on the principles of object-oriented programming.

There are also other things about database that I learned, but I will not talk about it. I mean come on, give me a break. Anyways. Let’s go to the next topic, Microsoft excel and access. This two software are so well known that you’ve probably heard and used it right? We’ll I hope so because if not, I don’t even know what to say. Anyways. Excel, by the way, is a spreadsheet software program that is traditionally used to manage numerical information. While, access is called a relational database management program, because the tables are linked, or related.

So, what does excel and access have to do with database? Because these two is used to create database! However, excel is cannot really create an authentic database, it’s just like a database because it can store data and is widely used to solve simple database problem. But Excel is an example of a flat file database. Access is used to make a database itself. If I were to think the difference between Excel and Access is that access manage data better than excel. You can maintain organization, searchability, and availability for several concurrent users with the aid of Access. In general, Excel is preferable for data analysis since it can handle complex computations, explore potential outcomes, and create excellent visualizations. Another one is the range of uses is where Excel and Access fundamentally diverge. Spreadsheet software can be utilized in Microsoft Excel. On the other hand, Microsoft Access may be utilized as a database application. Microsoft Excel is simple to use and simple to master.

Just what is DBMS or Database Management System? Well, a database management system or DBMS is essentially nothing more than a computerized data-keeping system. From what I leaned in my class discussions, DBMS have five functions.

First are the data definition. In data manager we have the database definition because we define the field name that we will use in each table that we will create inside of our database. For example, we will define the data type, data format, and the limitations that we will set on the fields. I don’t know if I understand the data definition is correctly but oh well. Never mind.

 Second is the data manipulation. Data manipulation is where the three major operations in database management comes forth, which is the adding, updating and deleting data to the database. Third is the data security and integrity. In this function, DBMS have security so that information’s and records inside the database will be always safe. The fourth function is the data recovery and concurrency. In this function, DBMS will be able to recover from a system crash. DBMS also have concurrency. It means that DBMS have the ability to allow multiple users to access data at the time. Last function is the data dictionary. DBMS provide a system called database dictionary. This is where it provides all the technical information and small details about your data. Any data or record we will input in our data base, it collects all its names, definitions and attributes.

I learned in my class that data can be stored in many ways but many of those ways is not as good as how DBMS manage data. DBMS is created so that we can manage a database easily. Of course, database have advantages, but that does not mean that it doesn’t have disadvantages.

One of the good things about DBMS is that it reduced data redundancy. Meaning, it only keeps a single copy of the data and does not have duplication. Data redundancy increases the size and complexity of our database so the ability of DBMS to reduce it is an advantage. Data integrity is also one of the advantages of DBMS. It means that any changes we made in that single copy of a particular data will be recorded so that we what the data is before the changes for future purposes. Of course, DBMS also have data independence. It helps to improve the data security of the database. With the help of physical data independence, we can change the storage and file structure of the database without affecting the application program. For security, of course we will not worry because DBMS have that. Additional security measure will always be a part of DBMS. In data consistency, of course our DBMS will not lose. Data consistency is ensured in a database because there is no data redundancy. When the data is consistent, there is no data redundancy, and that also means that the storage capacity is utilized properly. Also, if we want to use data easier, the DBMS is perfect. Remember DBMS help us to share data quickly, effectively, and securely. DBMS also promotes maintains less storage. That is because data redundancy is reduced.

But as I mention earlier, disadvantage is always there in DBMS no matter what. Most people problem is the expenses. The expenses in software, hardware, data storage and others will make your wallet cry. Vulnerability is also a disadvantage of DBMS. It is vulnerable to database failure. Since all the data or information is stored in one centralized database. If the database fails, then the data is lost, then it is a very big problem if that happens in an organization. Yieeks. Anyways. Size is also a problem because it limits the database. For example, when a user inputs a large amount of data, then it will become a problem because the database system will not run properly. That would be annoying right? Training cost is also a disadvantage in DBMS. We all know that we cannot use DBMs and will eventually very proficient at it right? So, organizations or company need to cry golden tears to train individual to be their database administrator in case a new database product is purchased. Compatibility of database system to others is also considered because sometime, because if your database system is not compatible with other database systems, that will pose a problem. Another headache because you need to make adjustment. Another problem is that DBMS have a locking-in technology, which is also an annoying part of DBMS. For example, a vendor abandoning a product will give a possibility of constructing the entire system from the scratch. That will be terrible right? Doing an entire system again will leave you in tears while constructing it.

Hello Guys! Here I am again! I’m very happy to tell that I successfully finished the first semester of being a first-year college student with a wonderful grade! Now, I’m currently in second semester and I’m studying a bunch of new exciting subjects.

One of these subjects is Information management 1. This subject is about data, information and databases. In this subject, I learned many things. Like how Data and information is not the same and that data is a collection of letters, numbers or facts, which by itself derive little or no value. Information only comes when the data is passed as input to an Information System to be processed and transformed. That’s why Information have value.

In this subject, my knowledge about data and information become broader and clearer. I also learned about how to store data in many ways. That also includes databases. A database system is an automated system for maintaining records. Our instructor said that we are going to create databases. It makes this subject more exciting and fulfilling because I know activities like this will help me gain important knowledge to make my career in the world of technology to be successful. In this subject I slowly learned how important a good information management means having access to reliable, high-quality information and timely sharing of that information.

So all I can say about this subjects is this is a crucial one for my career in the future so I will going to take my time and listen to my instructor and learn.

Hello! My Name is Mary Rose, 18 years old! I'm currently lived here in Subic, Zambales, Philippines. To be honest this is my first time doing a blog and I'm quite embarrassed for no reason. Maybe because I'm introducing myself to everyone that may read this first blog of mine. Anyways, enough of that.

I'm a collage student and my chosen course is BS in Computer Science. Maybe some of you are just like me. Someone who chose computer science in college because programming is kinda cool. I know it's funny and stupid but that not the only reason why I choose computer science. One of the important reason because it have many job opportunities. One of the reason a person is studying is to get a better and stable job in the future right? So yeah, I will have many job opportunities that's why I choose this course. Another, reason is as a person who lives with the convenience technology gives, I'm really interested what is happening behind this so called 'technology'. I want to know how computer works, whether knowing things about its hardware and software, I want to know everything.

Well, we all agree that technology is amazing right?

Anyways, I'm still in my first year and I still have a long way to go in getting to know technology. Technology is very complicated, and my brain is....well, you know what I mean. Ahem. So yeah, I hope that everything goes well and I hope to catch-up to my fellow unfair classmates who is already so amazing in programming as soon as possible. I really do hope so.