PinnedSai kumaresh🚀inBeyondXBasic Linux CommandsLinux CLI, 50 Most Used Linux Commands, Tips and TricksNov 10, 2020Nov 10, 2020
Sai kumaresh🚀SQL: Subqueries, Views, and Advanced FunctionsFROM, WHERE, and SELECT clauses, correlated subqueries, views, window functions, and conditional expressions.2d ago2d ago
Sai kumaresh🚀SQL Transactions: A Comprehensive Guide to Concurrency, ACID Properties, and Isolation LevelsSQL Transactions — ACID properties, concurrency control, isolation levels, phantom reads, dirty reads, and deadlocks3d ago3d ago
Sai kumaresh🚀All about SQL JoinsSQL JOINS — Left, Right, Full, Inner, Cross & Self4d ago4d ago
Sai kumaresh🚀Mastering SQL: Data Types, CRUD Operations, and Best PracticesSQL, Data Types, CRUD Operations, Best Practices5d ago5d ago
Sai kumaresh🚀Unlocking the Power of SQL Indexing: A Comprehensive GuideSQL Indexing — Why, How and Common mistakes to be avoided6d ago6d ago
Sai kumaresh🚀SQL: Essential Commands, Aggregations, and Built-in FunctionsEssential SQL commands, aggregation functions, and built-in functions, providing explanations and practical examples.6d ago6d ago
Sai kumaresh🚀A Comprehensive Guide to Schema Design in SQL: Principles, Best Practices, and a Practical Use…Topics: Schema design, Cardinality, Keys, Normalization rules, Naming conventions, Handling Sparse relations. Design a schema for Netflix.Jul 31Jul 31
Sai kumaresh🚀Understanding Database Normalization: Principles, Examples, and Best Practices1NF, 2NF and 3NF — Explanation and Examples.Jul 26Jul 26