Posts

Introduction to SQL

Image
 WHAT IS SQL?      SQL stands for Structured Query Language. SQL is used to communicate with a database. It is the standard language for relational database management systems. SQL statements are used to perform tasks such as updati ng data on a database or retrieving data from a database. Some common relational database management systems that use SQL are Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc.      Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as “Select”, “Insert”, “Update”, “Delete”, “Create”, and “Drop” can be used to accomplish almost everything that one needs to do with a database. WHAT SQL CAN DO? SQL can execute queries against a database SQL can retrieve data from a database   SQL can insert records into a database   SQL can update records in a database  S...
Post a Comment
Read more

Introduction to JSON

Image
 WHAT IS XML?     XML or Extensible Markup Language is a markup language and file formal for sorting, transmitting, and reconstructing arbitrary data.  It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. XML emphasizes simplicity, generality, and usability across the Internet. It is a textual data format with strong support via Unicode for different human languages. Although the design of XML focuses on documents, the language is widely used for the representation of arbitrary data structures such as those used in web services. JSON JavaScript Object Notation (JSON) is a standard text-based format for representing structured data based on JavaScript object syntax. It is commonly used for transmitting data in web applications. JSON (JavaScript Object Notation) is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate and it is ...
Post a Comment
Read more

Introduction to SQL

Image
 What is Data Definition Language?      Data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. In the context of SQL, data definition or data description language is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining data structures, especially database schemas.       Data Definition Language (DDL) is a subset of SQL. It is a language for describing data and its relationships in a database. You can generate DDL in a script for database objects to keep a snapshot of the database structure. Set up a test system where the database acts as the production system but contains no data. What is Interactive Manipulation Language? Interactive manipulation language is a component of the SQL that is used to insert, delete and update tuples in a relation. What is Embedded Data...
Post a Comment
Read more

Database Mangement

Image
DATABASE MANAGEMENT SYSTEM  What is DBMS?     DBMS is a software system that manages databases. A database management system (or DBMS) is essentially nothing more than a computerized data-keeping system. Users of the system are given facilities to perform several kinds of operations on such a system for either manipulation of the data in the database or the management of the database structure itself.  Function of DBMS Here are some important functions of Database Management System: Data Dictionary Management, Data Storage Management, Data Transformation and Presentation, Security Management, Multi-user Access Control, Backup and Recovery Management, Data Integrity Management, Database Access Languages and application Programming Interfaces and Database Communication interfaces. Function of DBMS 1. Data Dictionary Management           Data Dictionary Management is one of the most important functions of the database management s...
Post a Comment
Read more

Database Management System

Image
A. What is Database?     In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage      A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). B. What type of Software is Microsoft Office Excel?      Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. With Office 365, you are able to download the application to your hard drive and will also have access to the online version.      Microsoft Excel is a software program produced by Microsoft that allows users to organize, format, and calculate data with formulas using a spreadsheet system. This software is part of the Microsoft Office suite and...
Post a Comment
Read more

Information Management 1 Class Expirience

Image
 Information Management 1 Class Experience My experience in Information Management was very entertaining and fun. We learned many things about data and how information is different from the data and how is data transformed into information. At first, our teacher or instructor introduced herself and explain the course syllabus to us. We didn't have to introduce ourselves because our teacher or instructor is the same instructor we had in our first semester. After that, our instructor introduced data to us. First, is What is data? Data is an individual unit that contains raw materials which do not carry any specific meaning.      Data is a collection of letters, numbers, or facts, which by itself derive little or no value. When data is passed as input to an Information System to be processed and transformed, it becomes Information. Data are individual facts, statistics, or items of information, often numeric. In a more technical sense, data are a set of values of quali...
Post a Comment
Read more