A Beginner’s Guide to SQL Cursors (In Many Databases)
Cursors are a feature in many SQL databases that allow you to work with data.
They exist in SQL Server, Oracle, MySQL, PostgreSQL, and likely many other databases.
But what are they and how do you use them?
Let’s learn all about them in this guide.
SQL INT Data Types in Different Databases
INT is short for integer, and is a group of data types in many databases that store numbers. There are many INT data types in the major SQL databases.
In this guide, you’ll see all of these INT data types, see their restrictions, and how they compare between databases.
Let’s take a look.
SQL Server CHARINDEX Function Guide with Examples
Are you looking to find a string within another string in SQL Server? You can do that with the CHARINDEX function, which is SQL Server’s version of an INSTR function.
Learn how to use the function and see some examples in this article.
Clustered and Non-Clustered Index in SQL Server
What is a clustered index? What is a non-clustered index? And how are they different?
They are two types of indexes in SQL Server.
Learn what they are and see some examples in this guide.
How to Convert DATETIME to DATE in SQL Server
Do you have a DATETIME value in SQL Server that you want to convert to a DATE, or only get the DATE component?
You can do that in SQL Server. There are several ways to do it. I’ll show you how in this article.
How to Resolve Column count doesn’t match value count at row 1
Are you getting the error “Column count doesn’t match value count at row 1” in MySQL?
In this article, I’ll show you how to resolve this error, as well as what it means, and some examples.
Let’s take a look.
How to Start MySQL Server on Mac, Windows, and Linux
Do you want to know how to start, stop, and restart the MySQL server? Learn how you can do that on each operating system in this article.
How to Fix The “Every derived table must have its own alias” Error in MySQL
Are you writing a query in MySQL and getting an error of “1248: Every derived table must have its own alias”? If so, it’s a simple error to fix.
SQL vs MySQL vs SQL Server: What’s the Difference?
If you’re learning software development you might have heard of the terms SQL and MySQL. And you might be wondering, what’s the difference? Also, what does SQL Server mean and is it the same thing?
Introduction to SQL Server
Do you want to learn SQL?
You’ve come to the right place.
On this page, you’ll find videos, links, and information for the Introduction to SQL Server course. It covers the beginner level topics in my SQL Roadmap.
So, keep reading to see what you’ll learn and watch the videos in this course. (more…)
