1.

Useful Resources

Answer»

To get introduced to SQL, we first need to know about Databases and Database Management Systems (DBMS).

Data is basically a collection of facts related to some object. A database is a collection of small units of data arranged in a systematic manner. A Relational Database Management System is a collection of tools that allows the users to manipulate, organize and visualize the contents of a database while following some standard rules that facilitate fast response between the database and the user side.

After getting introduced to the concept of data, databases, and DBMS/RDBMS, we can finally get introduced to SQL. SQL or Structured Query Language is basically the language that we (the user) use to communicate with the Databases and get our required interpretation of data out of it. It is used for storing, manipulating, and retrieving data out of a database.

SQL Features

SQL allows us to interact with the databases and bring out/manipulate data within it. Using SQL, we can create our own databases and then add data into these databases in the form of tables.

The following functionalities can be performed on a database using SQL:


  • Create or Delete a Database.

  • Create or Alter or Delete some tables in a Database.

  • SELECT data from tables.

  • INSERT data into tables.

  • UPDATE data in tables.

  • DELETE data from tables.

  • Create Views in the database.

  • Execute various aggregate functions.


  • DBMS Interview

  • SQL Cheat Sheet

  • Database Testing

  • Complete Technical Interview Guide

  • SQL Books

  • SQL Projects

  • SQL IDEs

  • SQL Commands

  • Learn SQL

SQL MCQs


Discussion

No Comment Found

Related InterviewSolutions