img

DBMS (Database Management System) Part 3

Foundations of SQL Essentials: Mastering the Basics of Structured Query Language for Effective Data Management and Analysis.

Gate Smashers | Author Level 1

0.0
(0) 0 Students

What you will learn

  • Introduction to SQL

  • Database table concepts

  • Filtering and sorting data

  • Joining multiple tables

  • Data insertion and updating

  • Data querying and manipulation

  • SELECT statements

  • Aggregating data

  • Creating and altering tables

SQL Basics offers an introductory understanding of Structured Query Language (SQL) used for data querying and manipulation in databases. It encompasses fundamental concepts like database tables, data retrieval with SELECT statements, filtering, sorting, aggregation, and table joins. The material also delves into creating, modifying tables, and overseeing data entry and updates.

play
Lec-67: 3 Imp Questions on SQL basic Concepts | DBMS | NTA NET CSE June 2021
Preview 09:37
play
Lec-68: Introduction to PL-SQL in DBMS
Preview 06:24
play
Lec-69: Introduction to Transaction Concurrency in HINDI | Database Management System
Preview 12:41
play
Lec-70: ACID Properties of a Transaction | Database Management System
Preview 13:57
play
Lec-71: Transaction States | Database Management System
Preview 11:56
play
Lec-72: What is Schedule | Serial Vs Parallel Schedule | Database Management System
Preview 10:46
play
All Concurrency Problems | Dirty Read | Incorrect Summary | Lost Update | Phantom Read
Preview 04:56
play
Write-Read Conflict or Dirty Read Problem | Database Management System
Preview 08:23
play
Lec-73: Read-Write Conflict or Unrepeatable Read Problem | Database Management System
Preview 07:43
play
Lec-74: Irrecoverable Vs Recoverable Schedules in Transactions | DBMS
Preview 06:08
play
Lec-75: Cascading vs Cascadeless Schedule with Example | Recoverability | DBMS
Preview 11:32
play
Lec-76: Introduction to Serializability | Transactions Concurrency and Control | DBMS
Preview 09:16
play
Lec-77: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS
Preview 07:20
play
Lec-77: Conflict Equivalent Schedules with Example | Transaction concurrency and Control | DBMS
Preview 12:17
play
Lec-79: Why View Serializability is Used | Introduction to View Serializability | DBMS
Preview 11:23
play
Lec-80:Shared Exclusive Locking Protocol with Example in Hindi | Concurrency Control | DBMS | Part-1
Preview 06:43
play
Lec-81: Drawbacks in Shared/Exclusive Locking Protocol with Example | Concurrency Control Part-2
Preview 10:59
play
Lec-82: 2 Phase Locking(2PL) Protocol in Transaction Concurrency Control | DBMS
Preview 09:52
play
Lec-83: Drawbacks in 2 Phase Locking(2PL) Protocol with examples | Concurrency Control | DBMS
Preview 10:48
play
Lec-84: Strict 2PL, Rigorous 2PL and Conservative 2PLSchedule | 2 Phase Locking in DBMS
Preview 11:29
play
Lec-85: Basic Timestamp Ordering Protocol with Example in Hindi | Concurrency Control | DBMS
Preview 15:10
play
Lec-86: How to Solve Question on Timestamp Ordering Protocol | Concurrency Control | DBMS
Preview 12:37
play
Lec-87: Why Indexing is used | Indexing Beginning | DBMS
Preview 10:19
play
Lec-88: Numerical Example on I/O Cost in Indexing | Part 1 | DBMS
Preview 12:26
play
Lec-89: Numerical Example on I/O Cost in Indexing | Part 2 | DBMS
Preview 11:44
play
Lec-90: Types Of Indexes | Most Important Video on Indexing
Preview 04:37
play
Lec-91: Primary Index With Example | GATE, PSU and UGC NET | DBMS
Preview 07:55
play
Lec-92: Clustered Index in Database with Example
Preview 06:45
play
Lec-93: Secondary Index in Database with Example | Multilevel Indexing
Preview 13:03
img
No Discussion Found

0.0

0 Reviews

5
0
4
0
3
0
2
0
1
0
Meet Your Instructor

Instructor
0.0 Rating
0 Students
Author Level 1
17 Courses
About Instructor

Gate Smashers is India's no 1 Free education platform for those aspirants who want to just smash the entrance exam like GATE,UGC NET,KVS,NVS,HTET,CTET etc in Computer Science but they are lagging behind due to lack of proper guidance. This channel is a brainchild of Varun Singla and Naina Wadhwa Singla,they have added smartwork into the long journey of hardwork of students.

video

Free

  • Course Duration
    4 h 48 m 46 s
  • Course Level
    beginner
  • Student Enrolled
    0
  • Language
    Hindi

Gift this course

Send this course as a gift to your friends

This Course Includes
  • 4 h 48 m 46 s Video Lectures
  • 0 Quizzes
  • 0 Assignments
  • 0 Downloadable Resources
  • Full Lifetime Access
  • Certificate of Completion