Learn Databases & SQL

Discover how to use databases to manage and manipulate data effectively. Learn the fundamentals of SQL and database design in these tutorials.
  1. Visual Database Creation with MySQL Workbench

    Visual Database Creation with MySQL Workbench

    Tutorial Beginner

    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,...

  2. SQL for Beginners Part 2

    SQL for Beginners Part 2

    Tutorial Beginner

    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...

  3. Top 20+ MySQL Best Practices

    Top 20+ MySQL Best Practices

    Tutorial Intermediate

    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...

  4. CRUD With Prepared Statements

    CRUD With Prepared Statements

    Tutorial Intermediate

    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...

  5. How to Build a Login System for a Simple Website

    How to Build a Login System for a Simple Website

    Tutorial Beginner

    In today's video tutorial, we'll be building a login system with PHP and MYSQL. Many, many features will be covered; including MySqli, Prepared Statements,...

  6. Building the Back-End of a Photo Site

    Building the Back-End of a Photo Site

    Tutorial Beginner

    For those of you who have been following the last few screencasts, you must have noticed that each tutorial has been centered around a "photo site" theme....