DB_knowledge
Welcome to the channel, your go-to destination for in-depth knowledge and insights on popular database technologies including MySQL, Oracle, PostgreSQL, and MSSQL.
My mission is to provide you with comprehensive tutorials, hands-on demonstrations, and expert insights to help you master database technologies and unlock their full potential. I believe that a strong foundation in databases is crucial for anyone working with data-driven applications or pursuing a career in the IT industry.
Whether you're a student, a software developer, a database administrator, or simply a curious learner passionate about databases, I invite you to subscribe to my channel and embark on this educational journey with me.
Default ports for Databases
How to Drop a collection in MongoDb.
MongoDb : Network error (Not able to connect to Atlas Cluster)
Oracle Database - Lec -29: Handling services Oracle RAC
Oracle Database: - Lec -11: Architecture: - Background processes: System monitor process (SMON)
Oracle Database: - Lec -6: Architecture: - Shared Pool Buffer
Oracle Database: - Lec -5: Architecture: - Redo log buffer
Oracle Database: - Lec -4: Architecture: - Database Buffer Cache
Oracle Database: - Lec -3: Architecture: - System Global Area
Oracle Database: - Lec -2: Architecture: - PGA & UGA
Oracle Database: - Lec -1: Architecture: - Introduction
PostgreSQL: Lec-50 -Vacuum: Part 5- Disable AutoVacuum for a table
PostgreSQL: Lec-49 -Vacuum: Part 4 - AutoVacuum Parameters
PostgreSQL: Lec -53 - Vacuum: Part 8 - pg repack utility
PostgreSQL: Lec 52- Vacuum: Part 7- LAB Vacuum Test
PostgreSQL - Lec-46 -Vacuum - Part 1 - Introduction
Oracle Database - Lec -55 -Oracle - DataPump
Oracle Database - Lec -50 -Backup & Restore - 1. Introduction
Oracle Database - Lec -57 - Bonus - Oracle Smartwork - Access local database scripts from a server
Oracle Database - Lec -49 -Trace Files - 8. ADRCI - LAB
Oracle Database - Lec -46 -Trace files - 5. Location & Enable-Disable trace
Oracle Database - Lec -45 -Trace files - 4. Types
Oracle Database - Lec -28 -Handling services - Oracle
Oracle Database - Lec -23 -Account lock instead of dropping the user
Oracle Database - Lec -25 -Clear screen in Oracle
Oracle Database - Lec -24 -Error dropping a user: ORA-28014: cannot drop administrative user or role
Oracle Database - Lec -27:- Getting error while inserting records in a table.
PostgreSQL| Lec-45 | Streaming Replication | Monitor Streaming replication | LAB
PostgreSQL| Lec-44 | Streaming Replication | Setting up Streaming replication | LAB
PostgreSQL| Lec-43 | Streaming Replication | Parameters required on Master server.