Database Star: Home
open-menu closeme
Home
Start Here
About
Contact
Shop
youtube twitter linkedin github
  • SQL Stored Procedures: The Complete Guide (Oracle, SQL Server, MySQL, PostgreSQL)

    calendar Jul 12, 2018 · 22 min read · sql  ·
    Share on: twitter facebook linkedin copy

    Do you want to know what a stored procedure is, how it can help your SQL, and how to create one? Find out in this guide.


    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
  • SQL Merge: The Complete Guide

    calendar May 22, 2018 · 12 min read · sql  ·
    Share on: twitter facebook linkedin copy

    Learn how to use the MERGE command in SQL.


    Read More
  • SQL Joins: The Complete Guide

    calendar May 14, 2018 · 31 min read · sql  ·
    Share on: twitter facebook linkedin copy

    Let's take a look at what SQL joins are, how to use them, and see some examples.


    Read More
  • 50 SQL Experts Reveal Their Top 3 Tools for SQL Development and Administration

    calendar May 2, 2018 · 34 min read · tools  ·
    Share on: twitter facebook linkedin copy

    There are a large number of tools available for Oracle SQL developers and DBAs to use. It’s hard to know which tools are useful, will help you get the job done, and are widely used so you can get support easily.


    Read More
  • Oracle 18c Guide and FAQ

    calendar Feb 20, 2018 · 11 min read · sql  ·
    Share on: twitter facebook linkedin copy

    A guide to the Oracle 18c database.


    Read More
  • Complete List of Oracle Conferences

    calendar Feb 12, 2018 · 20 min read · sql  ·
    Share on: twitter facebook linkedin copy

    A list of Oracle conferences


    Read More
  • How to Become a Database Developer: The Definitive Guide

    calendar Jan 9, 2018 · 14 min read · career-plan  ·
    Share on: twitter facebook linkedin copy

    Learn how to become a database developer in this guide.


    Read More
  • SQL UPPER, LOWER, and INITCAP Function Guide, FAQ & Examples

    calendar Jan 6, 2018 · 8 min read · sql-functions  ·
    Share on: twitter facebook linkedin copy

    Changing the case of text in SQL is a common task when comparing strings or validating data. Learn how to do it with the UPPER, LOWER, and INITCAP functions in this article.


    Read More
  • Oracle Interval Functions Guide, FAQ & Examples

    calendar Jan 5, 2018 · 10 min read · sql-functions  ·
    Share on: twitter facebook linkedin copy

    Oracle’s two INTERVAL data types are used to store a period of time. Learn how to use them and see some examples in this article.


    Read More
    • ««
    • «
    • 17
    • 18
    • 19
    • 20
    • 21
    • »
    • »»

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