Modifying Data with SQL

Focused View

Andrew Chalkley

33:03

72 View

01. Adding Data to a Database

01. Introduction to CRUD.webm

02:04

02. Adding a Row to a Table.webm

07:27

03. Adding Multiple Rows to a Table.webm

01:50

04. Review and Practice.webm

01:21

02. Updating Data in a Database

01. Update All Rows or Columns in a Table.webm

03:01

02. Updating Specific Rows.webm

04:42

03. Review and Practice.webm

00:55

03. Deleting Data From a Database

01. Removing Data from All Rows in a Table.webm

01:27

02. Removing Specific Rows.webm

03:17

03. Review and Practice.webm

00:57

04. Handling Errors When Manipulating Data

01. Introduction to Transactions.webm

03:14

02. Rolling Back from Transactions.webm

01:15

03. Databases with Frameworks.webm

01:33

Description

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

More details

User Reviews

Rating

average 0

Total votes0

Focused display

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.

Treehouse

View courses Treehouse

Treehouse or is an online technology school that offers beginner to advanced courses in web design, web development, mobile development and game development. Its courses are aimed at beginners looking to learn computer coding skills for a career in the tech industry.