Acar_Module-4 Blogging _INFMNGT LECTURE


Module 4_INFMNGT LECTURE


A. What is SQL?



SQL is a language that is used to communicate with databases. We can use it to access and manipulate databases. SQL stands for Structured Query Language, and it is the standard language for relational database management systems, according to ANSI (American National Standards Institute). SQL can be used to insert, search, update, and delete records in a database. It may perform a variety of different tasks, including database optimization and maintenance.



Here’s a list of some of the most commonly used SQL commands:

  • CREATE – defines the database structure schema
  • INSERT – inserts data into the row of a table
  • UPDATE – updates data in a database
  • DELETE – removes one or more rows from a table
  • SELECT – selects the attribute based on the condition described by the WHERE clause
  • DROP – removes tables and databases







Comments

Post a Comment

Popular posts from this blog

Acar_Module-6_INFMNGT

Image
  Module 6_INFORMATION MANAGEMENT_Blogging_Activity-1 A. XML The acronym XML stands for "extensible markup language." A markup language is a collection of codes, known as tags, that describe the text in a digital document. Hypertext Markup Language (HTML) is the most well-known markup language, and it is used to format Web pages. XML, a more flexible cousin of HTML, enables complicated business transactions to be conducted via the Internet. B. JSON JSON is a standard text-based format for encoding structured data that is based on JavaScript object syntax. It is often used for data transmission in web applications. It is a widely used data format for electronic data interchange, particularly for the interaction of web applications with servers. It's a language-independent data format. C. AJAX AJAX is a set of web development approaches that construct asynchronous web applications by utilizing multiple web technologies on the client side. Ajax allows web applications to tra...
Read more

Acar_Learning Task Module 1-Blogging

Image
  --Learning Task Module 1-- A. WHAT IS A DATABASE? A database is a structured collection of information or data that is often stored electronically on a computer system. A database management system (DBMS) is usually in charge of a database. The data and the DBMS, as well as the applications that are associated with them, are collectively referred to as a database system, which is frequently abbreviated to just "database." 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. C. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? Microsoft Access is a database management system (DBMS) used to store and manage data. Access is part of the Microsoft 365 suite, and is made for business and enterprise users.           D.THINK OF ATLEAST TWO...
Read more