- Databases
- Beginner
About this Course
At the heart of a dynamic application is a database. Whether the application is an eCommerce, sports team, social network, or productivity app on your phone, the data needs to change over time.
In this course, we'll take a look at the underpinning SQL statements that are needed for every dynamic application.
What you'll learn
- Inserting rows of data
- Updating data for specific entries
- Removing data from any table
- Understanding transactions for data integrity
Adding Data to a Database
Databases aren't just for reading the information it contains, they're also for storing information. In this stage, we'll add data to a database table.
6 stepsUpdating Data in a Database
With dynamic applications, things change all the time. For example, the stock counts of products or the scores in a live soccer match. We need a way to update the data. In this stage we'll discover how to do just that.
5 stepsDeleting Data From a Database
There will come a time where you don't need certain data anymore. In this stage we'll look at removing all of the data from a table and how to remove specific rows too.
5 stepsHandling Errors When Manipulating Data
Sometimes you need to do multiple CRUD operations in a single go. This is where errors can occur. We'll tackle this with something called transactions.
5 stepsTeacher
-
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 family and when I get chance, sticking opponents in Halo 4.