Video icon 64
Learn to Code. Start your free trial today.
Advertisement

Databases

  • Databases
    Quick Tip: A Fast Overview of Querious (MySQL Manager)200x200
    In today's video quick tip, we'll have a quick (not sponsored) overview of a Mac database manager for MySQL that I came across yesterday, called Querious. As I mention in the screencast, I particularly like this one, because it just works -- without being too complicated or overwhelming in the way that PHPMyAdmin might be for some. Read More…
  • Databases
    Introduction to MySQL Triggers200x200
    23 shares
    Chances are, you know what a database trigger is, at least in conceptual terms. Chances are even greater that you know that MySQL supports triggers and has supported them for quite some time. I would guess, even armed with this knowledge, that a good many of you are not taking advantage of triggers with MySQL. They're one of those things which should absolutely be in your development toolbox, as they can really change the way that you look at your data.Read More…
  • Databases
    Visual Database Creation with MySQL WorkbenchWorkbenchstart
    42 shares
    In today's tutorial, you'll learn how to use a visual database modeling utility to draw a database diagram and automatically generate SQL. Specifically, we'll review how to use MySQL Workbench, a cross-platform, visual database design tool.Read More…
  • Databases
    SQL for Beginners: Part 3 - Database RelationshipsPreview
    27 shares
    Today, we continue our journey into the world of SQL and relational database systems. In this part three of the series, we'll learn how to work with multiple tables that have relationships with each other. First, we will go over some core concepts, and then will begin working with JOIN queries in SQL.Read More…
  • Databases
    SQL for Beginners Part 2Preview
    4 shares
    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…
  • Databases
    SQL for BeginnersPreview
    22 shares
    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…
  • Databases
    Top 20+ MySQL Best PracticesPreview
    238 shares
    Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. Here are some MySQL optimization techniques for programmers.Read More…
  • Databases
    CRUD With Prepared StatementsCode
    1 shares
    Even now, I constantly see developers using the ancient “mysql_connect” methods to connect to their databases. How come, when there are so many better solutions? In today’s 40-minute screencast, we’ll learn how to create, read, update, and delete records using MySQL improved and prepared statements.Read More…
Advertisement
Suggested Tuts+ Course
Getting Started With Sequel$15
Advertisement