4 Apr 2017 Aldo Zelen 5 Books That Will Grow Your SQL Skills Updated on: April 18, 2024 Looking to take your database skills up a notch? I've spent some time digging into various resources, and I want to share five advanced SQL books that really stood out. These texts are not just about learning the basics: they're about mastering the intricacies of SQL and truly enhancing your database management prowess. Whether you're troubleshooting complex queries or optimizing performance, these books provide insights that are both practical and transformative. Read more 16 Feb 2017 Aldo Zelen A Day in the Life of a SQL Developer What is a SQL developer? And what does a SQL developer do? Describing a “typical” day for a SQL developer is not easy. When your daily work is using various technologies to create interesting database-oriented products, very few days are alike! Each day brings a new and intriguing challenge. Nevertheless, I’ll have a go at explaining what everyday things a SQL developer might do. Morning: Arrive at Work What does a SQL developer do after arriving at the office? Read more 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 undergo your SQL training! But we then come to a new roadblock. Where to begin? How will we know which option is best for our budget, skill level, and schedule? 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 Updated on: July 19, 2024 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 » »»