Database Star: Home
open-menu closeme
Home
Start Here
About
Contact
Shop
youtube twitter linkedin github
  • SQL Decimal: Guide and Examples

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

    The SQL DECIMAL data type is useful for storing numbers with decimal places. Learn all about it, including which databases support it, and how to work with it, in this guide.


    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 Create a Database in MySQL

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

    If you want to create a new database in MySQL, you can either use an SQL command or follow the steps in an IDE such as MySQL Workbench. Learn how to do it in both ways in this guide. MySQL Create Database Command To create a new database in MySQL, you can use the CREATE DATABASE command. The simple version looks like …


    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
  • How to Install Postgres on Mac

    calendar Oct 1, 2022 · 6 min read  ·
    Share on: twitter facebook linkedin copy

    If you want to install a PostgreSQL database on macOS, you can follow the steps in this guide.


    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
  • SQL Cheat Sheet

    calendar Sep 28, 2022 · 7 min read  ·
    Share on: twitter facebook linkedin copy

    Get a reference for many of the common SQL commands and features on this SQL Cheat Sheet page.


    Read More
  • OTN Appreciation Day

    calendar Sep 27, 2022 · 6 min read  ·
    Share on: twitter facebook linkedin copy

    As part of the ThanksOTN (or ThanksODC) idea started by Tim Hall on Twitter, I've written about a few things I appreciate over the years.


    Read More
  • MySQL Privileges The Ultimate Guide

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

    Learn what MySQL privileges are and how they work.


    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
    • ««
    • «
    • 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