John Snape

John Snape

Introduction to Databases

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


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


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

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

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!

Introduction to Databases

  • An entity is the smallest unit of information in a database
  • A Table is used to hold one type of data and can be related to other tables
  • A column in a table holds one piece of data type shared by all records, also called an “attribute”
  • A row holds all data related to one entity, also called a “record”
  • A relational database defines how data relate to each other
  • A domain constrains a column to a specific data type, i.e. int or string
  • A primary key is unique within a table and uniquely identifies a record
  • A foreign key is a primary key from another table
  • Stored Procedures are methods stored directly in the database that work on data in the database
    • They allow you to enforce business rules within your database
  • Cardinality defines the type of relationship between a table and a foreign key: One-to-One, One-to-Many or Many-to-Many
  • Optionality tells whether the relationship is mandatory or optional
  • Referential Integrity makes sure changes in one table don’t negatively affect another table
  • Database normalization allow you to optimize your database by minimizing redundancy and dependency
  • Structured Query Language (SQL) is a special-purpose programming language designed for querying and manipulating databases
  • The Microsoft version is called T-SQL
  • There are two types of queries you can make:
    • Data Definition Language (DDL) which defines and updates the structure of the data
    • Data Manipulation Language (DML) which allows you to create, modify or delete data using four keywords:
      • CREATE e.g. CREATE TABLE Employee
      • SELECT e.g. SELECT * FROM Customers
      • SET e.g. SET ZipCode = “00000” WHERE…
      • DELETE e.g. DELETE * FROM Customers WHERE…
  • The ACID test defines a valid database transaction
    • Atomicity - Each transaction is “all or nothing”
    • Consistency – Any transaction should bring the database from one valid state to another
    • Isolation – Concurrent transactions are the same as serial transactions
    • Durability – Once a transaction is committed, it stays committed
  • Standard database design follows the following steps:
    • Determine entities involved and create a table for each type
    • Determine Primary Key for each table
    • Determine non-key attributes
    • Determine relationships between tables

    Please sign in to participate in this lecture discussion.

    Resetting Your Password?

    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.