• Home
  • Services
    • HR Services
      • HR Advisory Services
      • Contract Staffing
      • HR Outsourcing Services
      • Manpower Supply Services
      • Payroll Processing
      • Permanent Placement
      • Recruitment and Placement Services
      • Recruitment Process Outsourcing
      • Staffing Agency Services
    • DBA Support
      • DBA Consultancy Services
      • PostgreSQL Support
    • Website Maintenance
    • Company Registration Services
    • Virtual Office Space Address
  • Company
    • FAQs
    • About Us
    • Contact
  • Locations
  • Blogs
    • Blog
    • Blog – PostgreSQL Support
    • Blog – PostgreSQL Migration
    • Blog – All DB’s
    • Blog – Linux
  • Courses

    About Courses

    • List Of Courses
    • Become an Instructor
    Greenplum

    Greenplum

    $1,500.00
    Read More
    Have any question?
    (+91)8838953252
    ITsupport@rayafeel.com
    Login
    RayaFeeL
    • Home
    • Services
      • HR Services
        • HR Advisory Services
        • Contract Staffing
        • HR Outsourcing Services
        • Manpower Supply Services
        • Payroll Processing
        • Permanent Placement
        • Recruitment and Placement Services
        • Recruitment Process Outsourcing
        • Staffing Agency Services
      • DBA Support
        • DBA Consultancy Services
        • PostgreSQL Support
      • Website Maintenance
      • Company Registration Services
      • Virtual Office Space Address
    • Company
      • FAQs
      • About Us
      • Contact
    • Locations
    • Blogs
      • Blog
      • Blog – PostgreSQL Support
      • Blog – PostgreSQL Migration
      • Blog – All DB’s
      • Blog – Linux
    • Courses

      About Courses

      • List Of Courses
      • Become an Instructor
      Greenplum

      Greenplum

      $1,500.00
      Read More

      PostgreSQL Types

      • Home
      • PostgreSQL Types

      PostgreSQL Types

      • Posted by Nijamutheen J
      • Date February 13, 2019

      1.DDL-Data Definition Language, which is used to create and modify the structure of database objects in database.
      It’s a auto commit. automatically saved when you create,alter,drop,truncate,comment,rename commands issued
      ALTER – alters the structure of the existing database
      CREATE – to create database and its objects like (table, index, views, store procedure, function and triggers)
      DROP – delete objects from the database(Delete “data+metadata”)
      TRUNCATE – remove all records from a table, including all spaces allocated for the records are removed(Delete “data only performance is faster than delete”)
      COMMENT – add comments to the data dictionary
      RENAME – rename an object

      2.DML-Data Manipulation Language. which is used to store, modify, delete, insert and update data in database.
      It’s not a autocommit.it will save when u issue commit commands
      INSERT – insert data into a table
      UPDATE – updates existing data within a table
      DELETE – Delete all records from a database table
      MERGE – UPSERT operation (insert or update)
      CALL – call a PL/SQL or Java subprogram
      EXPLAIN PLAN – interpretation of the data access path
      LOCK TABLE – concurrency Control

      3.DRL-Data retrieval language. which is used to retrieve data from database
      It’s not a autocommit.it will save when u issue commit commands
      SELECT – Retrieves data from a table

      4.DCL-Data Control Language. which is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it.
      It’s not a autocommit.it will save when u issue commit commands
      GRANT – Gives user’s access privileges to database
      REVOKE – Withdraws user’s access privileges to database given with the GRANT command

      5.TCL – Transaction Control Language. which dis used to manage different transactions occurring within a database.
      It’s not a autocommit.it will save when u issue commit commands
      COMMIT – Saves work done in transactions
      ROLLBACK – Restores database to original state since the last COMMIT command in transactions
      SAVEPOINT – to rollback the transaction making points within groups
      SET TRANSACTION – specify characteristics for the transaction

      Contact Us

      Fields with (*) are compulsory.

      • Share:
      Nijamutheen J
      Nijamutheen J

      Nijamutheen J 7+ years of experience in PostgreSQL, Linux admin , web hosting - apache server , Oracle ,mySQL, Mriadb, vertica DB & Server security administrator

      My updated resume is https://www.tutorialdba.com/p/hi-i-have-4.html

      Previous post

      Script For Finding slow Running Query In postgres
      February 13, 2019

      Next post

      Postgres Script - Query running more than X minutes ?
      February 13, 2019

      Search

      ADVERTISEMENT

      Latest Posts

      Tips to Choose the Best Serviced Office for Your Business
      24May2022
      What key considerations do you need to keep in mind when choosing a new serviced office to house your business?
      24May2022
      The Benefits of Coworking
      24May2022
      The Long-Term Impact of Coworking
      24May2022
      Are you spending more money than you earn? Outsource with Ease and Move When You’re Ready
      24May2022
      PostgreSQL

      PostgreSQL

      $800.00 $500.00
      Greenplum

      Greenplum

      $1,500.00
      Oracle Database

      Oracle Database

      $350.00
      2ndquadrant.in

      (+91) 8838953252

      ITsupport@rayafeel.com

      Company

      • About Us
      • Our Team

      COURSES

      • List Of Course
      • Become An Instructor

      Support

      • DBA Support
      • Consultancy Services

      Recommend

      • Login
      • Contact Us

      IT Services by rayafeel.com. Powered by Rayafeel Technologies Pvt Ltd.

      • Privacy
      • Terms

      Become An Instructor?

      Join thousand of instructors and earn money hassle free!

      Get Started Now

      Connect with

      Login with Google Login with Twitter Login with Linkedin Login with Windowslive Login with Yahoo

      Login with your site account

      Connect with



      Lost your password?