Me, Myself and I (Who is Neol Mathew)

WHAT IS SQL?   SQL stands for Structured Query Language. It is a programming language used for managing and manipulating relational databases. SQL provides a standard way to communicate with databases, allowing users to perform various operations such as creating databases and tables, inserting, updating, and deleting data, and querying the data to retrieve specific information. SQL is designed to be a declarative language, meaning that users can specify what they want to achieve (the desired result), and the database management system (DBMS) takes care of figuring out the most efficient way to execute the query. This makes SQL a user-friendly language for interacting with databases, even for users who are not proficient in programming. SQL operates on relational databases, which organize data into tables consisting of rows and columns. It provides a rich set of commands and statements to perform different tasks, such as: 1. Data Definition Language (DDL): These statements are use...

 DATA DEFINITION LANGUAGE: DATA DEFINITION LANGUAGE (DDL) is a subset of SQL (Structured Query Language) used for defining and managing the structure of a database. DDL provides a set of SQL commands that allow users to define, modify, and manage the various database objects such as tables, views, indexes, constraints, and schemas. CREATE: Used to create new database objects such as tables, views, indexes, constraints, and schemas. ALTER : Used to modify the structure of existing database objects such as tables, views, and schemas DROP: Used to delete existing database objects such as tables, views, indexes, constraints, and schemas.  TRUNCATE: Used to remove all data from a table while keeping the structure intact. For example: RENAME: Used to rename existing database objects such as tables, views, indexes, constraints, and schemas.  DDL commands are typically executed by users with appropriate privileges, such as database administrators or users with ownership right...

 WHAT IS A DATABASE? Base on Google DATABASE is a a structured set of data held in a computer, especially one that is accessible in various ways WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL? Microsoft Excel is a spreadsheet program that features calculation, graphic tools, pivot tables, and macro programming language support for Windows and Mac operating systems. See more on Excel with Microsoft 365.J WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? Microsoft Access is a well-known database management system produced by Microsoft and is part of the Microsoft 365 office suite. Microsoft Access combines Microsoft's relational Jet Database Engine with software development tools and a graphic user interface (GUI). THINK OF AT LEAST TWO DIFFERENCES BETWEEN ACCESS AND EXCEL In general, Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users. Excel is generally better for analyzing data: performing com...

  Function of a DBMS allowing numerous people to view a single database at once. establishing and maintaining user access permissions and security guidelines.   frequent data backups and speedy data recovery in the event of a breach. establishing database policies and guidelines to safeguard data integrity.   ADVANTAGE OF DBMS A DBMS can streamline your data processes and boost the commercial value of your company's data assets while relieving users throughout the company of tedious and time-consuming data processing duties. The outcome? improved data regulation compliance, a more productive workforce, and better decision-making.   Disadvantages of DBMS Increased Cost. High cost is one of the main disadvantages of DBMS, the cost can be of many types like hardware or software costs, data storage costs, etc. ... Complexity. Database Failure. ... Performance. ... Frequent Updates/Upgrades. ... Huge Size.      

What is Technology? Technology , the application of scientific knowledge to the practical aims of human life or, as it is sometimes phrased, to the change and manipulation of the human  environment. How does it help our daily lives? Almost every element of modern life is impacted by technology, including productivity, socializing, food and healthcare access, and transportation efficiency and safety. The power of the internet has facilitated the emergence of international communities and made it easier to exchange information and resources. Advantage and Disadvantage It increases the utility of products and services and contributes to value creation. It benefits us in several ways and makes any task easier. Both positive and bad effects of technology exist. Many people utilize it for their personal development, while others use it to harm society and the environment.

 Good Morning Everyone , nice to meet you! I am very glad to be here to introduce myself. My Name is Neol Mathew. I am 19 years old. I was born in Olongapo City, but now I study in Gordon College in Olongapo. I'm a First year College student. My Hobbies are Playing Games, read, listen to K-pop.