Skip to content
all things sql website logo

All Things SQL

All Things Related To SQL, Databases & Cloud Based Solutions

  • Home
  • What is SQL?
  • Contact
  • About
  • Privacy Policy / Disclaimer
SQL Functions 

SQL Substring – Selecting Specific Field Data

sql query substring, sql substring, sql substring function, substring function in sql, substring sql, substring sql query

We can write a SQL query using the substring function to select the exact pieces of information needed in a

Read more
SQL Functions 

SQL – Converting Strings to Upper & Lower-Case

lower upper sql, sql lower upper, sql upper lower, upper lower sql

In order to convert character or string columns in SQL to UPPER or LOWER case we need to know the

Read more
All Things SQL 

SQL LENGTH – Finding Max & Min String Width

max length sql, min length sql, select max length of column in sql, select max length sql, sql max length, sql min length, sql string max length

We can use a combination of the MAX and MIN functions in conjunction with the SQL length function to get

Read more
SQL Functions 

SQL String Length – Finding Column Width

length of a string in sql, sql string function, sql string length, sql string width, string function sql, string length sql, string width sql

To find the string length (or width) in a field we can use the sql length function. The specific syntax

Read more
SQL Functions 

SQL TRIM Functions – Remove Blanks & Whitespace

remove blanks in sql, removing blanks in sql, removing whitespace in sql, sql remove blanks, sql remove whitespace, sql removing blanks, sql removing whitespace, sql trim all spaces, sql trim function, sql trim whitespace, trim function sql, trim spaces in sql

Often times, data is not cleansed appropriately when pulling data from files or other database tables. As a result, this

Read more
SQL Functions 

SQL CAST & CONVERT Function – Modifying Data Types

cast function sql, cast int to varchar sql, cast varchar to int sql, convert vs cast sql, sql cast function, sql cast int to varchar, sql cast varchar to int, sql cast vs convert

There are a few ways (depending on the database) where we can convert a column data type. The main two

Read more
All Things SQL 

SQL Concatenate – Combining Columns in a Table

combine columns in sql, combining columns in sql, combining two columns in sql, concat 2 columns in sql, concat two columns in sql, sql combine columns, sql combining two columns, sql concat 2 columns, sql concat two columns

We can combine multiple columns together into one in SQL using concatenation. Many databases have their own versions of combining

Read more
All Things SQL 

SQL INSERT – Using SELECT Statement

insert into table values select, insert into values select sql, insert using select sql, sql insert into values select, sql insert using select

We can write standard insert queries using hard-coded values. Similarly, we can write inserts and instead use a SELECT query

Read more
All Things SQL 

SQL INSERT Statement – Inserting Table Records

insert columns in sql, insert statement sql, sql insert statement

We are able to insert records into a database table using a SQL INSERT statement. Alternatively, we can utilize the

Read more
All Things SQL 

SQL UPDATE Statement – Modifying Table Records

sql update multiple columns, sql update statement, update multiple columns in sql, update statement sql

We can manipulate, modify or update records in a database table using a SQL UPDATE statement. Specifying a WHERE clause

Read more
  • ← Previous
  • Next →

Start Learning SQL

  • SELECT – Start Here
  • DISTINCT and COUNT – The Basics
  • WHERE – Using Filters
  • AND Versus OR Operators
  • Parentheses – Order of Operations
  • JOIN – Inner Join and Aliases
  • WHERE – Joining Tables
  • JOIN – Left, Right, and Full Outer
  • GROUP BY – Count, Sum, and More
  • HAVING – Filtering Aggregates
  • ORDER BY – Sorting Results
  • UNION ALL – Combining Datasets
  • MINUS – Subtracting Datasets

Advanced SQL

  • CAST & CONVERT – Modifying Data Types
  • CONCAT – Combining Multiple Columns
  • INSERT – Using SELECT Statement
  • CASE Statement – Replacing If-Else
  • LEAD() Function – Getting Next Values
  • LAG() Function – Getting Previous Values

DML & DDL Examples

  • DDL vs DML – A Comparison
  • CREATE TABLE – Examples
  • ALTER TABLE – Add, Drop, & Modify Columns
  • TRUNCATE vs DELETE – Erasing Tables
  • DROP – Tables, Views, Etc. – Deleting Objects

Common SQL Problems

  • Finding Duplicates
  • Getting Today’s Date

Data Warehousing

  • Fact Tables vs Dimension Tables
  • Slowly Changing Dimensions
  • OLAP vs OLTP Databases
Copyright © 2023 All Things SQL. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.