Modifying Data with SQL

Focused View

Andrew Chalkley

33:03

178 View

1 Adding Data to a Database

S1V1-Introduction to CRUD.mp4

02:04

S1V2-Adding a Row to a Table.mp4

07:27

S1V3-Adding Multiple Rows to a Table.mp4

01:50

S1V4-Review and Practice.mp4

01:21

2 Updating Data in a Database

S2V1- Updating All Rows in a Table.mp4

03:01

S2V2-Updating Specific Rows.mp4

04:42

S2V3-Review and Practice.mp4

00:55

3 Deleting Data From a Database

S3V1-Removing Data from All Rows in a Table.mp4

01:27

S3V2- Removing Specific Rows.mp4

03:17

TH-CRUD-S3V3-Review and Practice.mp4

00:57

4 Handling Errors When Manipulating Data

S4V1-Introduction to Transactions.mp4

03:14

TH-CRUD-S4V2-Rolling Back from Transactions.mp4

01:15

TH-CRUD-S4V3-Databases with Frameworks.mp4

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

SQL

Andrew Chalkley

Instructor's Courses

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.