Your search for SQL training is over, I'm here to help. Stick around, I'll tweet to you great introductory tips to search databases using SQL.
Joined December 2013
- Tweets 8,040
- Following 40
- Followers 3,352
- Likes 686
182 Photos and videos
Pinned Tweet
30 Dec 2015
Is taking the 70-461 freaking you out? Check out my study guide and be sure to signup for more! bit.ly/1Slxuo9
1
1
10
4 Oct 2022
Learn three ways to concatenate text in SQL. And why CONCAT_WS is superior over and CONCAT for handling NULL.
9 Aug 2022
There are several alternatives to bulk insert to use when inserting multiple rows into SQL Server. Let's review there here.
14 May 2022
Rounding up to the nearest integer is easier that you think in SQL. Learn how to use a common built-in function to do so.
1
10 May 2022
Learn to calculate a moving median in SQL. We'll use window functions and derived tables to make this happen.
1
1
2 May 2022
Surprisingly there isn't a SQL MEDIAN() function. In this article I'll show you how you can calculate a Median using SQL Server.
1
22 Apr 2022
Avoid SQL divide by zero errors using CASE WHEN or NULLIF functions to substitute zero for another value in our expression.
1
1
8 Apr 2022
If you would like to subtract 30 days for a date in SQL you can easily do so using either SQL Server, PostgreSQL, or MySQL.
1
6 Apr 2022
There are several way to find the week number in SQL. Let's though the standard ways to do so using PostgreSQL, MySQL, and SQL Server.
1
2 Apr 2022
Use the REPLACE function to replace all occurrences of a substring with another. Use REPLACE with MySQL, PostgreSQL, and SQL Server.
21 Mar 2022
Design a database is four steps. Follow along as I build the PizzaDB sample database. Learn my practical approach to designing databases.
6 Mar 2022
The SQL CREATE TABLE statement is used to create a database table in SQLServer. Use it to add columns, datatypes and constraints.
2
1
1
27 Feb 2022
Use GETDATE() to in conjunction with CAST to return today's date. GETDATE() returns data and time, so cast is necessary just get the date.
27 Feb 2022
How to calculate 30 days into the Future using SQL SERVER. Also learn how to use it to calculate a date in the past.
23 Feb 2022
An impossible join uses STRING_SPLIT() to break up column values into individual words which you can then join to another table.
9 Feb 2022
Learn five ways to know when a column contains in SQL another value. We'll explore STRING_SPLIT, CHARINDEX, and other popular methods.
10 Jan 2022
There is more to being a Junior DBA than knowing SQL. The DBA works at the intersection of the database, server, operations group, and developers.
2
10 Jan 2022
A SQL trigger ensure actions, such as updating an audit file, are completed regardless of which program update a database table.
1
4 Jan 2022
Use SQL HAVING to filter summary results from a GROUP BY. It specifies the search condition for the group or aggregate.