Kris Wenzel
@sqlkris
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.
You might like
Is taking the 70-461 freaking you out? Check out my study guide and be sure to signup for more! bit.ly/1Slxuo9
Learn three ways to concatenate text in SQL. And why CONCAT_WS is superior over + and CONCAT for handling NULL.
What is a Relational Database Conceptual Model? youtu.be/vsak_iYU-V4 via @YouTube
youtube.com
YouTube
What is a Relational Database Conceptual Model? | Essential SQL
There are several alternatives to bulk insert to use when inserting multiple rows into SQL Server. Let's review there here.
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.
Learn to calculate a moving median in SQL. We'll use window functions and derived tables to make this happen.
Surprisingly there isn't a SQL MEDIAN() function. In this article I'll show you how you can calculate a Median using SQL Server.
Avoid SQL divide by zero errors using CASE WHEN or NULLIF functions to substitute zero for another value in our expression.
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.
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.
Use the REPLACE function to replace all occurrences of a substring with another. Use REPLACE with MySQL, PostgreSQL, and SQL Server.
Design a database is four steps. Follow along as I build the PizzaDB sample database. Learn my practical approach to designing databases.
The SQL CREATE TABLE statement is used to create a database table in SQLServer. Use it to add columns, datatypes and constraints.
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.
How to calculate 30 days into the Future using SQL SERVER. Also learn how to use it to calculate a date in the past.
An impossible join uses STRING_SPLIT() to break up column values into individual words which you can then join to another table.
Learn five ways to know when a column contains in SQL another value. We'll explore STRING_SPLIT, CHARINDEX, and other popular methods.
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.
A SQL trigger ensure actions, such as updating an audit file, are completed regardless of which program update a database table.
Use SQL HAVING to filter summary results from a GROUP BY. It specifies the search condition for the group or aggregate.
United States Trends
- 1. Epstein 692K posts
- 2. Steam Machine 34.1K posts
- 3. Bradley Beal 3,087 posts
- 4. Valve 24K posts
- 5. Boebert 23.9K posts
- 6. Virginia Giuffre 39.7K posts
- 7. Xbox 60.3K posts
- 8. Anthony Joshua 1,900 posts
- 9. Scott Boras N/A
- 10. #BLACKROCK_NXXT N/A
- 11. GabeCube 2,251 posts
- 12. Rosalina 64.8K posts
- 13. Clinton 100K posts
- 14. Mel Tucker N/A
- 15. H-1B 94.8K posts
- 16. Zverev 3,222 posts
- 17. Jordan Humphrey N/A
- 18. Michael Wolff 17.1K posts
- 19. #NASDAQ_NXXT N/A
- 20. Jameis 8,957 posts
You might like
-
SQLServerCentral
@SQLServerCentrl -
Steve Stedman
@SqlEmt -
Kevin Kline
@kekline -
Wayne Sheffield
@DBAWayne -
Benjamin Nevarez
@BenjaminNevarez -
Arcane Code
@arcanecode -
K. Brian Kelley
@kbriankelley -
Tim Radney
@tradney -
Database Health
@DatabaseHealth -
Niko Neugebauer
@NikoNeugebauer -
SQL Shack
@SQLShack -
AndyLeonard
@AndyLeonard -
way0utwest 🎙️ (He/Him/His)
@way0utwest
Something went wrong.
Something went wrong.