8 Achievements

Manipulating Schema with SQL

Manipulating Schema with SQL

As we update the structure of the database, you'll see that the schema is not set in stone. You can update table names, columns and data types, as well as remove tables, columns and even entire databases.

SQL Calculating, Aggregating and Other Functions

SQL Calculating, Aggregating and Other Functions

SQL has various functions to perform arithmetic operations similar to what you would see in a spreadsheet application. Other functions help to group data together in more meaningful ways, while others help you do more complex filtering of your information.

Securing and Maintaining a MySQL Database

Securing and Maintaining a MySQL Database

Learn how to make your queries faster by creating indexes. Making and restoring backups of your database ensures you're prepared for a catastrophic failure, such as a hard drive crash or data corruption. We’ll cover that and some security considerations you should be aware of when setting up a database.

Instructor

  • Andrew Chalkley

    I'm an alien, I'm a legal alien, I'm an Englishman in Portland. All of my professional life I've worked with computers online. I'm a polyglot programmer and like using the right tools for the job. In my spare time I enjoy spending time with my young family and when I get chance, sticking opponents in Halo 4. You can find me in most places @chalkers.

Download videos

You have to sign up for Treehouse in order to download course videos.

Sign up

Release Date

This course will be available in DATE.