Mastering the SQL WHERE Clause: A Free 20-Minute Guide to Filtering Data
When working with SQL, one of the most fundamental things you’ll need to do is filter data from your database. Filtering allows you to retrieve...
Your First SQL Query: Using SELECT to Retrieve Data from a Table
Writing your first SQL query can feel like a big leap, but trust me, it’s much simpler than it seems once you get used to...
Easiest Way to Copy File Names from Folder to Excel
I recently had a situation where I needed to copy file names from a folder to Excel worksheet. I thought this would cause a headache...
How To Merge CSV Files into Single File
If you have multiple CSV files and want to combine them into one, you know it’s not easy to merge them manually, one by one....
Microsoft SQL Server Installation Guide: Step-By-Step Guide to Installing SQL Server on Windows.
Introduction Welcome to the second part of my SQL tutorial series! Last time I talked about what is SQL and what is it used for....