Database Star: Home
open-menu closeme
Home
Start Here
About
Contact
Shop
youtube twitter linkedin github

  • How to Remove Duplicate Records in SQL

    calendar Sep 10, 2021 · 18 min read · sql  ·
    Share on: twitter facebook linkedin copy

    Learn how to remove duplicate rows from a table using SQL.


    Read More

  • SQL Indexes - The Definitive Guide

    calendar Feb 17, 2021 · 34 min read · sql  ·
    Share on: twitter facebook linkedin copy

    Learn all about SQL indexes in this guide.


    Read More

  • SQL Constraints: The Complete Guide

    calendar Jan 17, 2021 · 30 min read · sql  ·
    Share on: twitter facebook linkedin copy

    SQL constraints are a feature that allow you to create rules that improve the quality of your data. Learn all about them in this guide.


    Read More

  • How to Install Oracle Express on Your PC

    calendar Jan 2, 2021 · 5 min read · sql  ·
    Share on: twitter facebook linkedin copy

    In this post, I'll explain how to download, install, and set up an Oracle Express Database on your own computer.


    Read More

  • How to Install Oracle on a Mac (2020)

    calendar May 10, 2020 · 11 min read · sql  ·
    Share on: twitter facebook linkedin copy

    In this post, you're going to learn the exact steps to take to install Oracle on your Mac computer.


    Read More

  • The Ultimate Guide to Database Version Control, CI/CD, and Deployment

    calendar Feb 1, 2020 · 40 min read · sql  ·
    Share on: twitter facebook linkedin copy

    In this guide, I'll explain that there's a better way to handle changes to your database and how to get it under version control, tested, and deployed along with application code.


    Read More

  • Why Use PostgreSQL?

    calendar Dec 30, 2019 · 9 min read · sql  ·
    Share on: twitter facebook linkedin copy

    Some reasons why you should use PostgreSQL.


    Read More

  • A Guide to SQL NULL (and SQL NOT NULL)

    calendar Dec 23, 2019 · 12 min read · sql sql-functions  ·
    Share on: twitter facebook linkedin copy

    In this article, you'll learn all about NULL, what it is, why it's different, how you can check for it in different databases, and many examples.


    Read More

  • 19 Best Database Books

    calendar Dec 12, 2019 · 11 min read · sql  ·
    Share on: twitter facebook linkedin copy

    A list of the best database books.


    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
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • 5
    • »
    • »»

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