Posts

My Own Understanding in Module 6

Image
Welcome back again to my Blogpost! Today i will be explaining these terminologies based on my own understanding.  A. WHAT IS XML? XML is a markup language just like HTML. From what i have learned, XML does require end tags unlike HTML. B. WHAT IS JSON? JSON looks just like HTML but the only difference they is that JSON is a lightweight data-interchange format. JSON is a data structure used for transmitting data through the web C. WHAT IS AJAX? AJAX or known as Asynchronous JavaScript and XML, is like the mother of all websites. AJAX communicates with other servers to create a better, faster, and more interactive web applications.  That is all for my Blog Thank you for Reading! Jordan I. Magbanua BSIT 1-A
Post a Comment
Read more

What is SQL?

Image
Welcome again to my Blog!  I will be sharing some information about SQL ! SQL stands for "Structured Query Language" It is a standard language for accessing and manipulating databases RDBMS What is RDBMS? It stands for "Relational Database Management System" RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. The data in RDBMS is stored in database objects called tables.  SQL COMMANDS These are some important SQL commands that you should know!   SELECT - extracts data from a database UPDATE - updates data in a database DELETE - deletes data from a database INSERT INTO - inserts new data into a database ALTER DATABASE - modifies a database CREATE TABLE - creates a new table ALTER TABLE - modifies a table DROP TABLE - deletes a table CREATE INDEX - creates an index (search key) DROP INDEX - deletes an index  That is all for this Blog Thank you for Reading ! Jordan I. Magbanua B
Post a Comment
Read more

Introduction to SQLivility

Image
 A. DATA DEFINITION LANGUAGE  Data Definition Language is used to define the structure of the database. It is used to create and destroy database, and database objects just like Microsoft Access.  B. INTERACTIVE DATA MANIPULATION LANGUAGE  Interactive Data Manipulation Language is like the modification of information in a database. From the word manipulation, we can already get an idea that we can modify it like a normal person using technology. C. EMBEDDED DATA MANIPULATION LANGUAGE Embedded Data Manipulation Language is the of DML that defined how SQL statements can be used with general-purpose programming.
Post a Comment
Read more

My Understanding in Laboratory Class

Image
  A.     FUNCTIONS OF DBMS -        The functions of DBMS include user-accessible catalog, concurrency, security, backup and recovery, integrity services, services to promote data independence and data descriptions. B.     ADVANTAGES OF DBMS -        There are lots of advantages for DBMS. A DBMS may store and retrieve data in a series of manners. -        It is reliable manager for handling numerous applications requiring identical data. C.     DISADVANTAGES OF DBMS -        Since most DBMS’s are complicated for starters, students/employees must be trained by someone who knows how to operate it. -        High cost of DBMS. Thanks For Reading! Jordan Magbanua BSIT 1-A
Post a Comment
Read more

My Understanding in Database

Image
   A.WHAT IS A DATABASE? - From what I have understood in the past lesson, database is like a collection of information that is stored in a computer system. Database is more of an organized and structured information. B.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL? - Microsoft Office Excel is an application software.   C.WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? - Microsoft Office Access is a database management system.                                 D.THINK OF ATLEAST TWO DIFFERENCES BETWEEN ACCESS AND                                              EXCEL.   Access -         Acts as a database program, its helps in collecting and storing data. -         I personally think that access is more complex than excel. Excel -         Excel helps to create charts, graphs and to perform calculations. -         It is also used for financial calculations. Thanks for reading ! Jordan Magbanua BSIT 1-A
Post a Comment
Read more