Learn how to use transactions to improve the performance of a long string of database write operations.
- [Instructor] Transactions are commonly used…to increase performance if a long list of inserts…or updates are performed as a unit…they can be performed much faster.…Let's take a look at an example of this.…I'm gonna use the test database here,…and I'm gonna start by creating a very simple table.…So here we have a very simple table with two columns,…an ID column and a data column, which is text.…And now I'm going to insert some data into the table.…And I'll create an insert statement here,…insert into test.…
And I'm simply inserting one value in the data column…with some text in it.…This is a good size line of text.…Now I'm gonna copy and paste this 10 times.…Copy, paste, two, three, four, five,…six, seven, eight, nine, ten.…And I'm gonna take all of those…and copy and paste them 10 times.…One, two, three, four, five,…six, seven, eight, nine, ten.…Now I should have 100.…And I'm gonna copy and paste that 10 times.…One, two, three, four, five,…six, seven, eight, nine, ten.…Now I should have 1,000 rows.…
And I'm just going to say, select count…
- Understanding SQL terminology and syntax
- Creating new tables
- Inserting and updating data
- Writing basic SQL queries
- Sorting and filtering
- Accessing related tables with JOIN
- Working with strings
- Understanding numeric types
- Using aggregate functions and transactions
- Automating data with triggers
- Creating views
- Defining functions in PHP
Skill Level Beginner
2. SQL Overview
3. Fundamental Concepts
7. Dates and Times
Dates and times1m 52s
11. Views and Subselects
12. Defined Functions
13. A Simple CRUD Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.