Skip to content

Latest commit

 

History

History

07-Introduction-to-DBMS

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 

DBMS

Notes

001 - Introduction to DBMS
002 - Need for DBMS
003 - Data Models
004 - Schemas
005 - Schema Architecture
006 - Advanced Concepts
007 - Relational Model
008 - Keys
009 - Integrity Rules And Constraints
010 - Relational Algebra
011 - MySQL Install Linux
012 - MySQL Install MacOS
013 - MySQL Install Windows
014 - SQL Quick Summary
015 - SQL Datatypes Summary
016 - SQL Commands Summary
017 - Filtering And Sorting Data
018 - Grouping Data Summary
019 - Queries Tables Constraints
020 - Modifying Data
021 - Joining Tables
022 - Set Operations
023 - SubQuery And Types
024 - SubQuery Examples
025 - Joins Vs Subqueries
026 - Transaction Statement
027 - Import Export
028 - Functional Dependency
029 - Anomalies
030 - Normalisation - 1
031 - Normalisation - 2
032 - Transaction ACID Properties
033 - Transaction States
034 - Indexing - 1
035 - Indexing - 2
036 - Advantages Disadvantages NoSQL
037 - Key Value NoSQL DB
038 - Columnar NoSQL DB
039 - Document NoSQL DB
040 - Graph Based NoSQL DB
041 - Relational Database
042 - Object Oriented Database
043 - Hierarchical Database
044 - Network Database
045 - Concurrency Control
046 - Clustering
047 - Partitioning Sharding
048 - Imp Functions And Commands


Problems

001 - Introduction to dbms
002 - Data Models
003 - ER Model
004 - Relational Models
005 - Intro To SQL
006 - SQL Datatypes
007 - SQL Commands
008 - Filtering And Sorting Data
009 - Grouping Data
010 - Query Table And Constraints
011 - Modifying Data
012 - Joining Tables
013 - Set Operations
014 - Sub Queries
015 - Managing Databases
016 - Transaction Statement
017 - Import Export
018 - Normalization
019 - Transaction
020 - Indexing
021 - NOSQL
022 - Database Types
023 - Database Optimization
024 - SQL Query Assessment