John Snape

John Snape

UPDATE & DELETE Statements

Slide Duration:

Table of Contents

Section 1: Introduction
Introduction Hello World

46m 9s

Declaring Variables

50m 5s

Accepting Input

14m 11s

Operators, Expressions & Statements

35m 5s

Program Flow Control

36m 35s

Iterations & Looping

19m 4s

Working with Strings

49m 40s

Formatting Strings for Output

23m 15s

Helper Methods

23m 57s

Enumerations & Structures

17m 26s

Commenting & Documenting Code

6m 46s

Arrays, Stacks, Queues & Dictionaries

34m 16s

Generic Lists & Collections

16m 30s

Variable Scope

9m 6s

Reading & Writing Files

23m 10s

Dates & Times

14m 37s

Random Numbers

7m

Handling Exceptions

22m 19s

The My Namespace

18m 49s

Environment Variables

8m 17s

Command Line Arguments

13m 4s

The CD Inventory Program So Far

31m 57s

Section 2: Object Oriented Programming
Introduction to Object Oriented Programming

56m 56s

Understanding & Creating Classes

33m 17s

Understanding Interfaces & Abstract Classes

18m 22s

Static vs. Instance Members

12m 45s

Understanding Inheritance

34m 55s

Understanding Polymorphism

13m 39s

Understanding Delegates

26m 9s

Reading & Understanding Code

37m 23s

Creating a Data Type

40m 42s

Unified Modeling Language & Class Diagrams

22m 24s

Upgraded CD Inventory Program

22m 15s

Section 3: GUI Programming
Introduction to GUI Programming

38m 58s

All About Forms

43m 36s

Handling Form Events

17m

Informational Controls

30m 36s

Command Controls

38m 6s

Grouping Controls

1h 9m 59s

Text Editing Controls

35m 23s

List Selection Controls

42m 23s

Setting Options Controls

25m 58s

Dialog Controls

24m 41s

Graphic Display Controls

32m 45s

Date Setting Controls

18m 29s

Other Controls

13m 28s

Using the Clipboard

9m 31s

Sending Email

22m 30s

Some Sample Programs, Part 1

23m 2s

Some Sample Programs, Part 2

14m 9s

InputBox & Message Box

11m 4s

CD Inventory Program Upgraded with Forms

14m 44s

Section 4: Databases
Introduction to Databases

34m 7s

SQL Server Management Studio & Northwind Database

8m 11s

SELECT Statement

31m 24s

UPDATE & DELETE Statements

16m 56s

INSERT Statement

11m 48s

Creating a Database from Scratch

44m 54s

Querying Lists with LINQ

15m 7s

Using Databound Controls

17m 29s

CD Inventory Program Updated with a Database

15m 29s

Section 5: Conclusion
Where to Go from Here

17m 50s

Loading...
This is a quick preview of the lesson. For full access, please Log In or Sign up.
For more information, please see full course syllabus of Visual Basic
Bookmark & Share Embed

Share this knowledge with your friends!

Copy & Paste this embed code into your website’s HTML

Please ensure that your website editor is in text mode when you paste the code.
(In Wordpress, the mode button is on the top right corner.)
  ×
  • - Allow users to view the embedded video in full-size.
Since this lesson is not free, only the preview will appear on your website.
  • Discussion

  • Study Guides

  • Table of Contents

Start Learning Now

Our free lessons will get you started (Adobe Flash® required).
Get immediate access to our entire library.

Sign up for Educator.com

Membership Overview

  • Unlimited access to our entire library of courses.
  • Search and jump to exactly what you want to learn.
  • *Ask questions and get answers from the community and our teachers!
  • Practice questions with step-by-step solutions.
  • Download lesson files for programming and software training practice.
  • Track your course viewing progress.
  • Download lecture slides for taking notes.
  • Learn at your own pace... anytime, anywhere!

UPDATE & DELETE Statements

  • Make sure to ALWAYS, ALWAYS, ALWAYS have a WHERE clause when using UPDATE and DELETE! Not using a WHERE clause will affect every single record in your database, which is usually NOT what you want!
    • Fortunately, most people only make this mistake once in their life
  • The standard form of the UPDATE command is:
    • UPDATE [table] SET [column] = [value] WHERE [criteria]
  • The standard form of the DELETE command is:
    • DELETE FROM [table] WHERE [criteria]
    Educator®

    Please sign in to participate in this lecture discussion.

    Resetting Your Password?
    OR

    Start Learning Now

    Our free lessons will get you started (Adobe Flash® required).
    Get immediate access to our entire library.

    Membership Overview

    • Available 24/7. Unlimited Access to Our Entire Library.
    • Search and jump to exactly what you want to learn.
    • *Ask questions and get answers from the community and our teachers!
    • Practice questions with step-by-step solutions.
    • Download lecture slides for taking notes.
    • Track your course viewing progress.
    • Accessible anytime, anywhere with our Android and iOS apps.