Typing on a Computer

SQL

What is SQL ?

  • Structured query language.

  • SQL is used to communicate with a database.

  • According to ANSI (American National Standards Institute), it is the standard language for relational database management systems.

  • SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.

  • Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Microsoft Access, Ingres, etc.

What can SQL do?

  • 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

Working Cafe
Mobile Phone

Benefits of SQL: Why You Should Use SQL

  • You can use SQL as a programmer to write apps using databases

  • Several users of a database can, via SQL, receive different views of the structure and content of the database; thus, SQL offers multiple data views.

  • People use SQL to create and manage databases and their security. SQL is a complete language for a database, and its main use is in retrieving, updating, and sharing data with more than one user.

  • You can use SQL in a 3-tiered internet architecture, including a database, a client, and an application server.

  • You can also use SQL to connect your clients or front-end computers and servers or back-end databases while supporting a solid client-server architecture.

  • SQL is widely considered a very desirable skill with many jobs such as web development, IT support, and business data analysts needed the skills in SQL.

 

sql.png