SQL and databases · page 2
123 articles. SQL queries, MySQL, PostgreSQL, MongoDB and database design with examples. Showing 101–123.
SQL and databases articles (101–123)
- MySQL vs SQLite: When to Use EachMySQL vs SQLite — server vs embedded databases, concurrency, use cases from mobile apps to production analytics, and when each is right.
- MySQL Window Functions Tutorial (OVER, PARTITION BY)Learn MySQL window functions — OVER, PARTITION BY, ROW_NUMBER, RANK, LAG, LEAD and running totals for advanced analytical queries in MySQL 8.
- MySQL with Excel: Import Database Data into SpreadsheetsConnect Excel to MySQL with ODBC or Power Query: a read-only user, a summary view, one-click refresh, and fixes for driver, login and row-limit…
- MySQL with Pandas: Analyze Database Data in PythonLoad MySQL data into pandas DataFrames with read_sql and SQLAlchemy — query, analyse, visualise, and write results back to MySQL.
- MySQL Workbench Tutorial for BeginnersLearn MySQL Workbench — connect to databases, run SQL queries, design ER diagrams, import data, and use the visual tools every data analyst needs.
- 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…
- Primary Key vs Foreign Key in MySQL: Key DifferencesPrimary key vs foreign key in MySQL: a difference table, real errors 1062, 1452 and 1451, CASCADE and RESTRICT demos, orphan checks and how to…
- 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.
- Recursive CTEs in MySQL: Hierarchies and SequencesMaster recursive CTEs in MySQL — WITH RECURSIVE syntax, traversing org charts and category trees, generating number and date series.
- 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 Query Interview Questions for Data Analyst RolesEight SQL practice questions for data analyst interviews, with tested MySQL answers: second highest, anti-joins, top per group, running totals and…
- SQL Skills You Need for Data Scientist JobsSQL skills data scientist roles demand — complex joins, window functions, feature extraction, query optimisation, and SQL in ML pipelines.
- SQL vs NoSQL Databases: Complete ComparisonSQL vs NoSQL databases — structure, scalability, consistency, use cases, and how data scientists choose between relational and non-relational stores.
- SQL vs NoSQL: Differences, Advantages and Use CasesWhen it comes to working with databases, one of the most common questions developers, students, and professionals face is: Should I use SQL or NoSQL?
- Temporary Tables in MySQL: Usage and ExamplesMySQL temporary tables with real output: creating them, the Can't reopen table error and the CTE fix, name shadowing, pooled connections and…
- 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 MySQLMySQL features and advantages with runnable examples: InnoDB transactions, JSON, window functions, replication, security, plus its honest limitations.
- Top MySQL Interview Questions for Freshers (2026)Most-asked MySQL interview questions for freshers — keys, joins, constraints, DELETE vs TRUNCATE, GROUP BY and how to answer with confidence.
- 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…
- UNION vs UNION ALL in MySQL: Differences and ExamplesUNION vs UNION ALL in MySQL with real output: how duplicates are handled, the performance cost shown in EXPLAIN, column rules, ordering and common…
- What is MySQL? A Complete Beginner's GuideLearn what MySQL is, how this popular open-source relational database works, and why MySQL skills are essential for every data analytics career.
- WHERE vs HAVING in MySQL: What's the Difference?WHERE vs HAVING in MySQL — WHERE filters rows before grouping, HAVING filters groups after aggregation. Learn the difference with clear examples.
Browse by topic
All topics- C and C++ programming135 articles · C and C++ programs, pointers, arrays, storage classes and language concepts with code.
- Python programming99 articles · Python programs, syntax, libraries and beginner projects with examples.
- Java programming20 articles · Core Java, OOP, collections, Spring and Java programs explained step by step.
- Data structures and algorithms108 articles · Arrays, linked lists, trees, graphs, sorting, searching and problem solving.
- Web and app development140 articles · HTML, CSS, JavaScript, React, Node, PHP, full stack and mobile app guides.
- Data science and machine learning129 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 BI80 articles · Excel, Power BI, Tableau, dashboards and business analytics guides.
- SQL and databases123 articles · SQL queries, MySQL, PostgreSQL, MongoDB and database design with examples.
- Software testing and automation46 articles · Manual testing, Selenium, Playwright, API testing and QA practices.
- Cloud computing and DevOps35 articles · AWS, Azure, Docker, Kubernetes, Git, Jenkins, CI/CD and Linux.
- Cyber security and networking51 articles · Ethical hacking, network security, threats and networking basics.
- Digital marketing and SEO31 articles · SEO, social media, ads, content and email marketing guides.
- UI/UX and graphic design17 articles · UI/UX design, Figma, graphic design tools and portfolios.
- Business, management and finance19 articles · Management, HR, CRM, SAP, project management, accounting and finance.
- Careers, courses and job switches405 articles · Career roadmaps, salaries, course fees, city guides and career switch plans.
- Interview preparation and resumes104 articles · Interview questions, resume tips and how to get job ready.
- Programming basics and technology158 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.