Gokul Tech

                  SQL Queries are large in Number. We have multiple Queries and subqueries to get the desired data from the data from server. However, to all these Queries we have selected 5 Queries  is basic and essential to create commands. What are the Top 5 Queries?                    1)   Create,                 2)  Insert Into,                 3)  Update,                 4)  Delete,                 5)  Drop. 1) Create                              Create Query is the base where you can be able to create database, create table in SQL server. While creating table only we can be able to define total nu...

  Definition of DBMS:                    DBMS stands for DataBase Management System, which is a software system used to make CRUD Operations in the Database.  What is  CRUD??                    C - C reate                    R - R etrieve                 U - U pdate                    D - D elete                              all these actions are taken on the database to make changes as per the requirement from end user. Types of DBMS:     a) Flat File     b) Hierarichal     c) Network     d) Relational     e) Non - Relational What is Relational DBMS?         ...

  Definition:                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) .  What is Data?               Data is a raw or unprocessed information. Typically, the data is raw and there is no statistical or any analysis made before to understand whether it is a real one or not. Example:                    We are using smartphones with many social media applications. Each and every message as in the form of text, images (irrespective of formats), documents (irrespective of formats), links everything considered as Data.                      It can be processed by organizations, individuals or any other in need according t...