Interview Preparation
SQL or Python: Navigating Your Career Growth in 2023
Delve into an in-depth analysis of SQL and Python's strengths and applications to make an informed decision on the right language for your career growth in 2023.
data management
14 articles about data management — tutorials, explainers and interview questions, newest first.
Tag · 14 articles
Latest in data management
Shell/Bash Scripting
File and Directory Operations: Comprehensive Guide to Reading, Writing, and Management
Explore fundamental operations for file and directory management, including reading and writing files, creating and deleting directories, and setting permissions. Practical examples provided for better understanding.
Programming
Working with SQL and NoSQL Databases: A Comprehensive Guide to SQLite and MongoDB
Explore the intricacies of working with SQL and NoSQL databases, focusing on widely used systems like SQLite and MongoDB. This guide provides a detailed overview of creating, querying, and managing databases, showcasing their unique characteristics and differences.
PHP
Database Integration Guide: Mastering SQL and NoSQL Interactions with MySQL and MongoDB
Explore the comprehensive guide to database integration, focusing on SQL databases like MySQL and NoSQL solutions such as MongoDB. Learn how to connect, query, and modify data to build scalable applications.
NodeJS
Working with Databases: A Guide to SQL and NoSQL (MySQL & MongoDB)
Explore the fundamentals of working with SQL and NoSQL databases in this comprehensive guide. Learn how to interact with popular databases like MySQL for SQL and MongoDB for NoSQL, and understand the key differences, use cases, and considerations for both.
NodeJS
Building a CRUD Web Application with Express.js: A Step-by-Step Guide
Learn how to build a CRUD web application using Express.js. This step-by-step guide provides practical insights into creating, reading, updating, and deleting data, offering a foundational understanding for developers of all levels.
JavaScript
Browser Storage and Cookies: A Comprehensive Guide to Local Storage, Session Storage, and Persistent Data Management
Explore the essential browser storage mechanisms like Local Storage, Session Storage, and Cookies. Learn how to leverage these tools for efficient data management in web applications, with examples, usage scenarios, and security considerations.
PHP
Working with Databases using PHP: A Comprehensive Guide for Interview Preparation
Understand the essential techniques of interacting with databases using PHP, including SQL queries, PHP Data Objects (PDO), and connecting to databases. This guide will equip you for discussing and demonstrating your database proficiency in interviews.
NodeJS
Interview Preparation: Working with Databases - Proficiency in Sequelize for SQL and Mongoose for MongoDB
Discover how to work with databases using Sequelize for SQL databases and Mongoose for MongoDB. A comprehensive guide for those preparing for interviews or seeking to enhance their database management skills in software development.
Relational Databases
Data Integrity and Constraints: Enforcing Integrity with Primary Keys, Foreign Keys, Unique Constraints
Explore the principles of data integrity in databases and learn how to enforce it using constraints such as primary keys, foreign keys, and unique constraints. This guide delves into maintaining accuracy, consistency, and reliability in data management.
Relational Databases
Relational Database Management Systems (RDBMS): Features and Capabilities of MySQL PostgreSQL SQL Server
Explore the features and capabilities of popular Relational Database Management Systems (RDBMS) such as MySQL, PostgreSQL, and SQL Server. Understand their distinct characteristics, comparison, and how they cater to different data management needs.
Database Management
Managing Data Growth and Archiving: Strategies for Handling Increasing Data Volumes and Historical Data Archiving
Explore strategies to manage the rapid growth of data in modern organizations, including archiving techniques for historical data. Learn about tools, best practices, and the benefits of efficient data growth management and archiving.