3 Jan 2017 Aldo Zelen How to Recognize SQL Text Data Type How can you store textual information in database tables? Thanks to this post, you’ll learn the characteristics of every text data type in SQL Note: This post is intended for readers familiar with SQL data definition language (DDL) and the DDL CREATE statement. To learn more about DDL, check out LearnSQL.com. Most data types are classified as NUMERIC, CHARACTER, or DATE. In this post, we’re going to focus on each CHARACTER or text data type in SQL. Read more 28 Dec 2016 Aldo Zelen Refine Results with SQL Set Operators Using UNION, UNION ALL, EXCEPT, and INTERSECT to manage SQL query results. The function of SQL set operators is pretty simple; they allow us to combine results from different SQL queries into one result set. The best way to understand how set operators work is to use visual methods like the Venn diagram. For those of you not familiar with Venn diagrams, they are two circles that represent items or collections of items. Read more 13 Dec 2016 Aldo Zelen How to Learn SQL: 6 Ideas for Newbies Learning a new skill can be a daunting task, especially in programming. SQL is not immune to this. Luckily, with the Internet and the explosion of programming-related information out there, there are a lot of options you can use to learn SQL online, offering the convenience and flexibility to learn at your own pace and in your own environment! But we then come to a new roadblock. Where to begin? Read more 6 Dec 2016 Aldo Zelen SQL Errors: Five Common SQL Mistakes As you learn SQL, watch out for these common coding mistakes You’ve written some SQL code and you’re ready to query your database. You input the code and …. no data is returned. Instead, you get an error message. Don’t despair! Coding errors are common in any programming language, and SQL is no exception. In this article, we’ll discuss five common mistakes people make when writing SQL. The best way to prevent mistakes in SQL is practice. Read more 6 Dec 2016 Aldo Zelen Five Common SQL Syntax Errors SQL is a powerful language for managing databases, but even small syntax errors can lead to big headaches. As you work with SQL, understanding and avoiding common mistakes can save you time and frustration. In this article, we'll highlight five frequent SQL syntax errors You've written your SQL code and you're ready to query your database. You input the code, but instead of getting the data you expected, you get an error message. Read more «« « 1 2 3 » »»