SQL and databases
59 articles. SQL queries, MySQL, PostgreSQL, MongoDB and database design with examples.
SQL and databases articles
- Understanding Serializability in DBMS: TypesSerializability in a Database Management System (DBMS) refers to a property that ensures the operations performed by different processes on shared…
- Learn SQL in One Week Step-by-Step Tutorial for Absolute BeginnersAs the cornerstone of any data management practice, SQL (Structured Query Language) allows using its functions to communicate with the databases…
- JDBC Full Form and Role in Java Database ConnectivityDiscover the full form of JDBC—Java Database Connectivity—and its pivotal role in enabling seamless database interactions within Java applications.
- Great Free SQL Courses for Data AnalysisSQL (Structured Query Language) is a key skill if you want to work in analytics, business intelligence, or data science today. Tools like Python…
- Blind Writes in DBMS: Speed vs Data Consistency ChallengesBlind writing, as the name suggests, means writing data into a database without checking or verifying the existing data.
- Top 10 SQL Projects for Data Analyst Job ReadinessSQL is the foundation of the modern data-driven economy, and therefore, one of the most popular skills among would-be data analysts. Data SQL is…
- Explain Attributes and The Different Types of Attributes in DBMS 2026What is DBMS? In a database management system (DBMS), attributes refer to the characteristics or properties of an entity or object in a database.
- SQL Joins Explained with Real ExamplesWhen working with databases, it’s very rare that all the information you need is sitting neatly in one single table. In real-world applications…
- Introduction to MongoDB for Full Stack LearnersIn our fast-paced digital landscape, web applications are constantly creating and handling enormous amounts of data every single second. Whether…
- Top SQL Commands You Must Know as a Data AnalystSQL (Structured Query Language) is an essential tool for data analysts to work with databases efficiently. The primary role of a data analyst is…
- CRUD Operations Using Node and MongoDBWhen you start building backend applications, the term CRUD pops up often. CRUD stands for Create, Read, Update, and Delete, which are the four…
- How to Learn SQL Step by Step as a Complete BeginnerIn today’s data driven world, every click, purchase, and interaction generates valuable information. Behind the scenes, there is a powerful…
- MongoDB vs SQL: Which Database Is More Suitable for Developers“Discover the key differences between MongoDB and SQL. Dive into our detailed guide to explore which database excels in flexibility, scalability.
- Learn ER Diagrams for Database DesignWhen it comes to database design, one of the most important tools you’ll come across is the Entity-Relationship Diagram (ER Diagram). Whether…
- Understanding the Difference Between DBMS and RDBMSIn today’s data-driven world, managing and organizing data efficiently is a crucial aspect of every business and application.
- What Is a Database Index? Use and ImportanceWhen working with large datasets, speed and efficiency become crucial. Imagine you’re looking for a single book in a massive library without an…
- Beginner’s Guide to SQL for Data Analysts in 2026SQL or Structured Query Language is one skill that has withstood the test of time in the fast changing landscape of data with the ever-increasing…
- Top 10 SQL Projects for Analysts with Code ExamplesStructured Query Language, commonly known as SQL, remains one of the most essential skills for data analysts today. While many new tools and…
- Excel, SQL, Power BI for Gig Workers: Where to StartExcel, SQL, and Power BI — which should gig workers learn first? A practical guide for beginners on where to start and what to learn for a data…
- Tips to master SQL queries for data analysisIn today’s data-driven world, SQL (Structured Query Language) is the master key to unlocking valuable insights. Whether you’re just starting your…
- Advanced MySQL Interview Questions and AnswersAdvanced MySQL interview questions — indexing internals, window functions, transactions and isolation levels, query optimisation and replication.
- Clustered vs Non-Clustered Index in MySQL (InnoDB)Clustered vs non-clustered indexes in MySQL InnoDB — how the primary key stores the table, secondary index lookups, and design implications.
- COMMIT and ROLLBACK in MySQL: Transaction ControlMaster COMMIT and ROLLBACK in MySQL — saving or undoing changes, autocommit mode, SAVEPOINT for partial rollbacks, and safe data-update workflows.
- Common Table Expressions (CTE) in MySQL: WITH Clause GuideLearn CTEs in MySQL — the WITH clause for readable step-by-step queries, multiple CTEs, and how they compare to subqueries and temp tables.
- Database Normalization: What It Is, Why It Matters & Normal Forms ExplainedWhen working with databases, one of the most important concepts you’ll come across is normalization. If you’re new to databases, the term might…
- DDL, DML, DCL and TCL Commands in MySQL ExplainedLearn the difference between DDL, DML, DCL and TCL commands in MySQL with examples — CREATE, INSERT, GRANT, COMMIT and where each category is used.
- Difference Between SQL and NoSQL ExplainedIntroduction When it comes to storing, managing, and analyzing data, two major players dominate the conversation: SQL (Structured Query Language)…
- ETL Process with MySQL: Extract, Transform, LoadUnderstand ETL with MySQL — extracting source data, transforming with SQL, loading into warehouse tables, and scheduling reliable pipelines.
- Exploratory Data Analysis (EDA) with SQL in MySQLDo exploratory data analysis with SQL — profiling tables, checking distributions, finding NULLs, duplicates and outliers directly in MySQL.
- How to Connect MySQL with Power BI for DashboardsConnect MySQL to Power BI — install the MySQL connector, import vs DirectQuery, build dashboards on live database data, and refresh schedules.
- How to Connect MySQL with Tableau (Complete Guide)Connect MySQL to Tableau — MySQL ODBC/JDBC driver setup, live vs extract connections, custom SQL, and building visualizations on MySQL data.
- How to Connect Python with MySQL (Step-by-Step)Connect Python to MySQL using mysql-connector-python — install, connect, run queries, fetch results, and use parameterised queries safely.
- How to Create and Use Views in SQLWhen you start working with databases, you’ll often face situations where you don’t want to expose the entire table directly, but still need to…
- How to Install MySQL on Ubuntu Linux (Terminal Guide)Install MySQL Server on Ubuntu Linux using apt — installation commands, mysql_secure_installation, creating users, and enabling remote access.
- How to Learn MySQL Step by Step: Beginner RoadmapA step-by-step MySQL learning roadmap — from installation and basic SELECT to joins, window functions and projects, with a realistic timeline.
- How to Use SQL Joins for Data Analysis in Real ProjectsData has become the new oil, and every business today relies on data-driven decisions. But raw data stored in databases is usually scattered…
- INSERT, UPDATE and DELETE in MySQL with ExamplesLearn MySQL DML — INSERT single and multiple rows, UPDATE with WHERE, DELETE safely, and INSERT … ON DUPLICATE KEY UPDATE for upserts.
- JOIN vs Subquery in MySQL: Which Performs Better?JOIN vs subquery performance in MySQL — how the optimiser treats each, when JOINs win, when subqueries are cleaner, and how to benchmark with EXPLAIN.
- MongoDB vs MySQL: Choose the Right DBMSChoosing between MongoDB and MySQL is like choosing between a flexible artist and a rule-abiding architect. Both are powerful in their own right…
- MySQL Architecture Explained: Layers, Engine and Query FlowUnderstand MySQL architecture — connection layer, SQL layer, storage engine layer, and how a query flows through parsing, optimisation and execution.
- MySQL Backup and Restore with mysqldumpBack up and restore MySQL databases with mysqldump — full and single-database dumps, restoring from SQL files, and automation best practices.
- MySQL Best Practices Every Developer Should FollowMySQL best practices — naming conventions, schema design, safe migrations, parameterised queries, indexing discipline and backup habits.
- MySQL Career Opportunities: Roles That Need SQLCareer paths built on MySQL skills — data analyst, data scientist, analytics engineer, backend developer, DBA — with growth routes for each.
- MySQL CASE Statement: Conditional Logic in QueriesUse the MySQL CASE statement for if-else logic in SELECT — categorising values, conditional aggregation, pivoting data, and custom sort orders.
- MySQL Certification Guide: Is It Worth It?MySQL certifications explained — Oracle MySQL certification tracks, costs, preparation strategy, and whether certificates or projects matter more.
- MySQL Commands Cheat Sheet: Most-Used SQL CommandsQuick MySQL commands cheat sheet — database, table, and data commands every analyst uses daily: SELECT, INSERT, UPDATE, DELETE, SHOW, DESCRIBE and…
- MySQL for Data Science: The Data Layer of ML ProjectsMySQL in data science — extracting training data, feature engineering in SQL, integrating with Python, and why data scientists need database skills.
- MySQL JOINs Explained: INNER, LEFT, RIGHT and FULLMaster MySQL JOINs — INNER JOIN, LEFT JOIN, RIGHT JOIN and simulating FULL OUTER JOIN, with examples showing how to combine data across tables.
- MySQL Stored Procedures Tutorial with ExamplesLearn MySQL stored procedures — CREATE PROCEDURE, IN/OUT parameters, variables, control flow, and automating repeatable database logic.
- MySQL String Functions with ExamplesLearn MySQL string functions — CONCAT, SUBSTRING, REPLACE, TRIM, UPPER, LOWER, LENGTH and more for cleaning and transforming text data.
- MySQL vs Oracle Database: Full ComparisonMySQL vs Oracle Database — cost, features, PL/SQL vs stored procedures, scalability, and where each fits in enterprise data work.
- Normalization vs Denormalization in MySQLNormalization vs denormalization in MySQL — data integrity vs read speed, OLTP vs analytics workloads, and when to deliberately duplicate data.
- PostgreSQL vs MySQL: 10 Critical Differences You Should KnowWhen it comes to selecting a relational database management system (RDBMS) for your application, two of the most popular options are PostgreSQL…
- RANK vs DENSE_RANK vs ROW_NUMBER in MySQLRANK vs DENSE_RANK vs ROW_NUMBER in MySQL — how each handles ties, with examples for top-N per group and leaderboard queries.
- Self JOIN in MySQL: Use Cases and ExamplesLearn self JOIN in MySQL — join a table to itself to model hierarchies, find employee-manager pairs, and compare rows within the same table.
- SQL vs NoSQL: Differences, Advantages, Use Cases & Examples ExplainedWhen it comes to working with databases, one of the most common questions developers, students, and professionals face is: Should I use SQL or NoSQL?
- The Power of Database Schemas: Exploring Types“Without a solid foundation, even the grandest of structures will crumble.” – This wisdom holds true not just in architecture but also in databases.
- Top Features and Advantages of MySQLExplore the key features and advantages of MySQL — performance, scalability, security, replication, and why businesses choose MySQL for data…
- Understanding Database Schema: Types, SQL SchemaA database is the backbone of many modern applications, systems, and websites. It stores data in an organized way, making it easily accessible…
Browse by topic
All topics- C and C++ programming190 articles · C and C++ programs, pointers, arrays, storage classes and language concepts with code.
- Python programming113 articles · Python programs, syntax, libraries and beginner projects with examples.
- Java programming22 articles · Core Java, OOP, collections, Spring and Java programs explained step by step.
- Data structures and algorithms129 articles · Arrays, linked lists, trees, graphs, sorting, searching and problem solving.
- Web and app development149 articles · HTML, CSS, JavaScript, React, Node, PHP, full stack and mobile app guides.
- Data science and machine learning127 articles · Statistics, Pandas, NumPy, machine learning, deep learning and big data.
- Artificial intelligence and generative AI371 articles · AI concepts, LLMs, prompt engineering, NLP, AI agents and AI tools.
- Data analytics, Excel and Power BI67 articles · Excel, Power BI, Tableau, dashboards and business analytics guides.
- SQL and databases59 articles · SQL queries, MySQL, PostgreSQL, MongoDB and database design with examples.
- Software testing and automation48 articles · Manual testing, Selenium, Playwright, API testing and QA practices.
- Cloud computing and DevOps38 articles · AWS, Azure, Docker, Kubernetes, Git, Jenkins, CI/CD and Linux.
- Cyber security and networking37 articles · Ethical hacking, network security, threats and networking basics.
- Digital marketing and SEO28 articles · SEO, social media, ads, content and email marketing guides.
- UI/UX and graphic design18 articles · UI/UX design, Figma, graphic design tools and portfolios.
- Business, management and finance18 articles · Management, HR, CRM, SAP, project management, accounting and finance.
- Careers, courses and job switches516 articles · Career roadmaps, salaries, course fees, city guides and career switch plans.
- Interview preparation and resumes100 articles · Interview questions, resume tips and how to get job ready.
- Programming basics and technology154 articles · Programming concepts, computer basics, new technology and tech trends.
Learn it with a trainer, not just a blog
Join a free 2-hour live demo class at Uncodemy, classroom or online from Noida. No payment, no commitment.