Database Star: Home
open-menu closeme
Home
Start Here
About
Contact
Shop
youtube twitter linkedin github
  • I Surveyed 483 SQL Users About Their Tools

    calendar Aug 14, 2024 · 12 min read  ·
    Share on: twitter facebook linkedin copy

    I surveyed 483 database users about which databases and editors they use.


    Read More
  • How to Delete a Row in SQL

    calendar Aug 16, 2023 · 3 min read  ·
    Share on: twitter facebook linkedin copy

    In this post, you’ll learn how to delete a row in SQL and how to delete all rows in a table.


    Read More
  • How to Count Distinct Values in SQL

    calendar Aug 15, 2023 · 2 min read  ·
    Share on: twitter facebook linkedin copy

    In this article, you’ll learn how to count the number of unique values in a column.


    Read More
  • Aqua Data Studio vs DBeaver: A Comparison

    calendar Apr 24, 2023 · 35 min read  ·
    Share on: twitter facebook linkedin copy

    In this post, I'll compare the major features of both Aqua Data Studio and DBeaver.


    Read More
  • On Delete Cascade in SQL

    calendar Oct 11, 2022 · 5 min read  ·
    Share on: twitter facebook linkedin copy

    In this article, you'll learn what the ON DELETE CASCADE keyword means and what it does.


    Read More
  • How to Use Multiple Inner Joins in SQL

    calendar Oct 4, 2022 · 8 min read  ·
    Share on: twitter facebook linkedin copy

    In this guide, you'll learn how to use multiple inner joins in SQL, why you may want to do this, and see some examples.


    Read More
  • How to Split a String in SQL: Guide & Examples

    calendar Oct 3, 2022 · 11 min read  ·
    Share on: twitter facebook linkedin copy

    To split a string in SQL you can use a built-in function. The exact function depends on which database you're using.


    Read More
  • SQL IN and SQL NOT IN - Guide & Examples

    calendar Sep 30, 2022 · 9 min read  ·
    Share on: twitter facebook linkedin copy

    The SQL IN and SQL NOT IN keywords allow you to compare against a list of values, instead of a single value. Learn all about how to use them and see some examples in this guide.


    Read More
  • How to Handle Database Timezones

    calendar Dec 12, 2021 · 12 min read  ·
    Share on: twitter facebook linkedin copy

    Learn what timezones are and how to work with them in a database.


    Read More
  • SQL Describe Table (In Different Vendors)

    calendar Sep 13, 2021 · 6 min read  ·
    Share on: twitter facebook linkedin copy

    Learn how to describe a table in SQL.


    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