Database Star: Home
open-menu closeme
Home
Start Here
About
Contact
Shop
youtube twitter linkedin github
  • Ultimate Guide to Data Warehouses

    calendar Jan 6, 2020 · 14 min read · database-design  ·
    Share on: twitter facebook linkedin copy

    Learn all about data warehouses in this guide.


    Read More
  • Sample Database: University Rankings (ERD and SQL)

    calendar Dec 17, 2019 · 5 min read · database-design  ·
    Share on: twitter facebook linkedin copy

    Details on the sample university database


    Read More
  • Sample Database: Olympic Games (ERD and SQL)

    calendar Dec 9, 2019 · 6 min read · database-design sql  ·
    Share on: twitter facebook linkedin copy

    Details of the sample Olympics database.


    Read More
  • A Guide to the Entity Relationship Diagram (ERD)

    calendar Jul 30, 2019 · 9 min read · database-design  ·
    Share on: twitter facebook linkedin copy

    Learn all about Entity Relationship Diagrams (ERDs), what they are used for, how to understand them, how to create them, and more in this guide.


    Read More
  • 24 Database Design Mistakes and How to Avoid Them

    calendar Aug 17, 2018 · 27 min read · database-design  ·
    Share on: twitter facebook linkedin copy

    In this article, I’ve listed 24 different database design mistakes that you should try to avoid.


    Read More
  • Database Keys: The Complete Guide (Surrogate, Natural, Composite & More)

    calendar Jul 10, 2018 · 17 min read · database-design  ·
    Share on: twitter facebook linkedin copy

    In this article, you’ll learn what these terms are, so you can communicate better with other developers and understand other online tutorials that use these terms.


    Read More
  • Database Normalization: A Step-By-Step-Guide With Examples

    calendar Sep 30, 2017 · 28 min read · database-design  ·
    Share on: twitter facebook linkedin copy

    In this article, I’ll explain what normalisation in a DBMS is and how to do it, in simple terms.


    Read More
  • Singular vs Plural and Other Database Table Naming Conventions

    calendar Jan 2, 2017 · 11 min read · database-design  ·
    Share on: twitter facebook linkedin copy

    Are you wondering if you should name your SQL database tables in the singular form or plural form? Learn what the preferred convention is and some reasoning behind it, as well as other database table naming conventions, in this article.


    Read More
  • 6 Easy And Actionable Steps On How To Design A Database

    calendar Apr 21, 2014 · 9 min read · database-design  ·
    Share on: twitter facebook linkedin copy

    Whether it's for your workplace or home project, learning how to design a database is a valuable skill. Let's take a look at six easy steps on how to design a database.


    Read More

Ben Brumm

Improve your database and SQL skills.
Read More

Recent Posts

  • dbForge SQL Complete 7.0 Just Released
  • I Surveyed 483 SQL Users About Their Tools
  • How to Delete a Row in SQL
  • How to Count Distinct Values in SQL
  • How to Install Postgres on Mac Using Homebrew
  • Solution for Homebrew PostgreSQL Service Not Starting
  • How to Install MySQL on Windows
  • How to Install Postgres on Windows

Categories

ALLVENDORS 78 ORACLE 67 MYSQL 11 SQLDEVELOPER 9 SQLSERVER 5 POSTGRES 3 NOBANNER 1

Tags

SQL 63 SQL-FUNCTIONS 56 SQL-ERRORS 22 SQL-SERVER 14 MYSQL 12 ORACLE 12 POSTGRESQL 12 WORK-PERFORMANCE 11 DATABASE-DESIGN 9 CAREER-PLAN 5 PROGRAMMING 5 JOB-SEARCH 3 TOOLS 2
Database Star: Home

Copyright  DATABASE STAR: HOME. All Rights Reserved

to-top