• Home
  • Courses
  • School
  • Programs
  • Problems
  • Contact Us
  • My account
  • Register

Have any question?

(+91) 98222 16647
info@simplycoding.in
RegisterLogin
Simply Coding
  • Home
  • Courses
  • School
  • Programs
  • Problems
  • Contact Us
  • My account
  • Register

DBMS

SQL: Introduction

  • Categories DBMS, Data Management, Database

In this post we will learn about SQL or Structured Query Language

SQL is short for Structured Query Language which is a standard Database language used to create, maintain and retrieve data in a relational database.

It was initially developed by IBM, however over the years many companies like Microsoft have added their extensions or introduced variants.

The Advantages of SQL are that

  • It is easy to learn & understand
  • It is portable and is widely supported.
  • It can run at high speeds

The disadvantage is that due to different vendor versions, SQL Versions are not portable across vendors. Depending upon the RDBMS you are using, the commands could have minor variations.

We are going to learn how to write queries or commands to work with relational data bases.

Some basic rules for the SQL Statements or Commands are:

  1. SQL Statements are not case sensitive
  2. Statements can span across multiple lines but words cannot
  3. Any non-numeric data such as Name or date need to be enclosed in single quotes (‘ ’)
  4. Semicolon (;) is used to terminate SQL statement

The queries or commands we are going to write are divided into 4 basic types.

  1. Data Definition Language: It is used create and maintain the database and tables itself. e.g; CREATE TABLE, ALTER TABLE, DROP COLUMN and so on.
  2. Data Control Language: It is used for access control of tables and transaction control language for this we used commands like GRANT and REVOKE.
  3. Data Manipulation Language: Once the database and its tables are created, DML queries are used to actually insert/update and delete data in the relations. e.g. commands like INSERT, DELETE, UPDATE.
  4. Data Query Language: It is used to extract the data from the relations. e.g.; SELECT

DML and DQL are the commands which you as an application programmer will mostly use, while DDL and DCL is something which will be taken care of by Database Administrator.

Check out our video: https://youtu.be/kamoCcaQvFg

  • Share:
author avatar
Simply Coding

Previous post

Basics of Database
December 10, 2020

Next post

SQL: Join
December 10, 2020

You may also like

Screenshot_20201209-112442__01
Index Commands in SQL
14 December, 2020
Screenshot_20201209-113227__01
SQL Select Statement: Tutorial
14 December, 2020
Screenshot_20201209-111403__01
SQL: Join
10 December, 2020

Leave A Reply Cancel reply

You must be logged in to post a comment.

Categories

  • Uncategorized
  • Programs
    • Python
    • Java
  • Problems
    • Python
    • Java
    • Web Development
      • Internet
    • Emerging Technologies
  • Notes
    • General
    • QBasic
    • MS Access
    • Web Development
      • XML
      • HTML
      • JavaScript
      • Internet
    • Database
    • Logo Programming
    • Scratch
    • Emerging Trends
      • Artificial Intelligence
      • Internet of Things
      • Cloud Computing
      • Machine Learning
    • Computer Fundamentals
      • Computer Networks
      • E-Services
      • Computer Hardware
    • Python
    • Java
  • School
    • ICSE
      • Computers Class 9
        • Java Introduction
        • Tokens & Data Types
        • Java Operators
        • Math Library
        • if & switch
        • For & While
        • Nested loops
      • Computer Class 10
        • Sample Papers
        • OOPS concepts
        • Functions in Java
        • Constructors
        • Arrays in Java
        • Strings in Java
    • SSC
      • IT Class 11
        • IT Basics
        • DBMS
        • Web Designing
        • Cyber Laws
      • IT Class 12
        • Web Designing
        • SEO
        • Advanced JavaScript
        • Emerging Tech
        • Server Side Scripting
        • E-Com & E-Gov
      • Computer Science 11
      • Computer Science 12
    • CBSE
      • Computer 9
        • Basics of IT
        • Cyber Safety
        • Scratch
        • Python
      • Computer 10
        • Sample Papers
        • Networking
        • HTML
        • Cyber Ethics
        • Scratch
        • Python
      • Computer Science 11
        • Computer Systems
        • Python 11
          • Python Basics
          • Python Tokens
          • Python Operators
          • Python if-else
          • Python loops
          • Python Strings
          • Python List
          • Python Tuple
          • Python Dictionary
          • Python Modules
        • Data Management
      • Computer Science 12
        • Sample Papers
        • Python 12
          • Python Functions
          • Python File Handling
          • Python Libraries
          • Python Recursion
          • Data Structures
        • Computer Networks
        • Data Management
    • ISC
      • Computer Science 11
        • Introduction to Java
        • Values & Data Types
        • Operators
        • if & switch
        • Iterative Statements
        • Functions
        • Arrays
        • String
        • Data Structures
        • Cyber Ethics
      • Computer Science 12
        • Sample Papers
        • Boolean Algebra
        • OOPS
        • Wrapper Classes
        • Functions
        • Arrays
        • String
Simply Coding Computer Courses for School                Privacy Policy     Terms of Use     Contact Us

© 2021 Simply Coding

Login with your site account

Lost your password?

Not a member yet? Register now

Register a new account

Are you a member? Login now