Advertisement
Latest Posts
  • Code
    Articles
    Nettuts+ Quiz #11: Do You Know SQL?Quiz
    In 2012, we plan to take our quizzes to a whole new level with ones aimed at all languages and catering to all competencies and tastes. This month, we're covering a little SQL. With more frameworks being bundled with an ORM, SQL is quickly becoming a lost art and is mostly relegated to the nerdiest of our clan -- those pesky database people. Why not take today's quiz and see whether you DB-chops have really gone the way of the dodo?Read More…
  • Code
    WordPress
    Quick Tip: "Popular Posts By Comment Count" SQL Query in WordPress200x200
    You might have noticed that the Tuts+ sites have a section on the home page where we list the most popular posts of the month, according to comment count. While there are numerous plugins available, it's always best to write the code yourself if you can. Too much abstraction is never a good thing! Luckily, once we learn how to query WordPress' database, tasks like this become a cinch! Read More…
  • Code
    Databases
    SQL for Beginners Part 2Preview
    It is important for every web developer to be familiar with database interactions. In part two of the series, we will continue exploring the SQL language and apply what we've learned on a MySQL database. We will learn about Indexes, Data Types and more complex query structures.Read More…
  • Code
    Databases
    SQL for BeginnersPreview
    Most modern web applications today interact with databases, usually with a language called SQL. Lucky for us, this language is quite easy to learn. In this article, we are going to start with some basic SQL queries and use them to interact with a MySQL database.Read More…
  • Code
    Other
    10 Essential SQL Tips for Developers200x200
    SQL is yet another essential language for developers wishing to create data-driven websites. However, many developers are unfamiliar with various aspects of SQL; so in this article, we'll analyze ten essential tips. Read More…
Advertisement