DBMS TUTORIALS | DATABASE MANAGEMENT SYSTEM TUTORIAL FOR BEGINNERS | FULL LECTURE COURSE IN HINDI
Introduction to DBMS - DBMS stands for Database Management System. We can break it like this DBMS = Database + Management System. The database is a collection of data and Management System is a set of programs to store and retrieve those data. Based on this we can define DBMS like this: DBMS is a collection of interrelated data and set of programs to store & access those data in an easy and effective manner.
What is the need of DBMS?
Database systems are basically developed for large amounts of data. When dealing with a huge amount of data, there are two things that require optimization: Storage of data and retrieval of data.
Database: Database is a collection of inter-related data that helps in efficient retrieval, insertion, and deletion of data from the database and organizes the data in the form of tables, views, schemas, reports, etc. For Example, a university database organizes the data about students, faculty, and admin staff, etc. which helps in efficient retrieval, insertion, and deletion of data from it.
DDL is the short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.
CREATE: to create a database and its objects like (table, index, views, store procedure, function, and triggers)
ALTER: alters the structure of the existing database
DROP: delete objects from the database
TRUNCATE: remove all records from a table, including all spaces allocated for the records are removed
COMMENT: add comments to the data dictionary
RENAME: rename an object
DML is the short name of Data Manipulation Language which deals with data manipulation and includes most common SQL statements such as SELECT, INSERT, UPDATE, DELETE, etc., and it is used to store, modify, retrieve, delete and update data in a database.
SELECT: retrieve data from a database
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
(Download 15000+ MCQ) Click Below Link-
Get Very Imp. E-Study Material for your Exam Click Below Link-
(FOR KVS PGT CS, IBPS IT, RRB IT, SBI IT, GATE CSE, UGC CS, IA, PROGRAMMER)
1, Hands-On DATABASE 2000 MCQ Test Series- Buy Link-
Buy Link- https://goo.gl/NzD6r3
2, Computer Fundamentals Success Master Edition-2000+ Imp.MCQ E-Book-
Buy Link- https://goo.gl/KhtRwE
3, Hands-on Operating Systems 1500 VERY IMP.MCQ Series-
Buy Link- https://goo.gl/t1DPpR
4, Hands-on Computer Networks 1500 VERY IMP.MCQ Series
Buy Link- https://goo.gl/LvzNWm
5, Hands-on Data Structures & Algorithms 1500+ MCQ
Buy Link- https://goo.gl/j82wUK
6, Hands-On Object Oriented Programming-1500+ MCQ Series
Buy Link- https://goo.gl/KYeC5g
7, Hands On Software Engineering -1000 IMP.MCQ Series
Buy Link- https://goo.gl/oBVtv9
8, Hands On Computer Science and IT 1000 IMP.MCQ Series
Buy Link- https://goo.gl/GFEjb9
9, Hands On Computer Architecture -1500 IMP.MCQ Series
Buy Link- http://goo.gl/joUVPH
10, Hands On RDBMS -1500 IMP.MCQ Series
Buy Link- https://goo.gl/DtG31d
11, CRACKING THE CODING INTERVIEW-2000+ JAVA INTERVIEW
QUESTION & ANSWERS AND 200+ SIMPLE INTERVIEW QUE.
Buy Link- https://goo.gl/75ytgQ
==================================
Follow us & clear your Queries & Doubts:-
1. Follow Me on "TWITTER"
/ it_exam_guruji
2. Follow Me on "INSTAGRAM"
/ it_exam_guruji
3. Follow Me on "FACEBOOK"
/ itexamguruji
4. Buy My Books PDF Now !!
https://play.google.com/store/books/a...
5. Our Website !!
https://itexamguruji.in/
#DBMS_Tutorials,#DBMS_Lectures,#DataBase_Tutorials,#Database_Management_System,
================================================================================