Start learning with our library of video tutorials taught by experts. Get started

SQL Essential Training (2009)
Illustration by Richard Downs

SQL Essential Training (2009)

with Bill Weinman
Expand all | Collapse all
  1. 35m 49s
    1. Introduction
      1m 36s
    2. What is SQL?
      1m 26s
    3. Understanding the terminology
      3m 37s
    4. About the examples
      2m 27s
    5. Setting up the test environment on a PC
      8m 28s
    6. Setting up the example data on a PC
      3m 33s
    7. Setting up the test environment on a Mac
      10m 46s
    8. Setting up the example data on a Mac
      3m 56s
  2. 14m 31s
    1. Quick-start introduction
      40s
    2. Using the basic SELECT statement
      1m 34s
    3. Selecting columns
      5m 54s
    4. Selecting rows
      2m 35s
    5. Counting things
      3m 48s
  3. 35m 32s
    1. Organization: Databases and tables
      1m 24s
    2. SQL syntax overview
      2m 8s
    3. Formatting SQL
      3m 18s
    4. Creating a database and tables
      5m 24s
    5. Inserting data
      2m 22s
    6. Reading tables with JOIN
      5m 18s
    7. Filtering data with WHERE, LIKE, and IN
      5m 52s
    8. Removing duplicates with DISTINCT
      1m 34s
    9. Sorting with ORDER BY
      4m 9s
    10. Updating data
      1m 48s
    11. Deleting data
      2m 15s
  4. 6m 17s
    1. Creating relationships between tables
      1m 6s
    2. Accessing related tables with JOIN
      4m 0s
    3. About indexes
      1m 11s
  5. 8m 47s
    1. About the string functions
      2m 48s
    2. Finding the length of a string
      1m 12s
    3. Finding part of a string
      1m 34s
    4. Removing spaces with TRIM
      2m 22s
    5. Making strings UPPERCASE and lowercase
      51s
  6. 9m 13s
    1. When to use numeric functions
      1m 41s
    2. Finding the absolute value
      1m 28s
    3. Rounding numbers
      1m 56s
    4. Integer division and remainders
      4m 8s
  7. 4m 8s
    1. Dates and times
      1m 52s
    2. Date- and time-related functions
      2m 16s
  8. 7m 13s
    1. How aggregates work
      3m 38s
    2. Removing duplicates with DISTINCT
      59s
    3. Using aggregate functions
      2m 36s
  9. 20m 40s
    1. About the CRUD application
      7m 48s
    2. The SELECT functions
      5m 46s
    3. The INSERT functions
      1m 47s
    4. The UPDATE functions
      2m 17s
    5. The DELETE functions
      3m 2s
  10. 32s
    1. Goodbye
      32s

Video: Introduction

I find databases terribly interesting, whatever the application. Calendar, email, websites, bookkeeping, sales, inventory, even the lowly to-do list, it's all about the data and that usually means some sort of database. (Music playing.) Hi, I'm Bill Weinman and welcome to SQL Essential Training. I have been working with databases since the early 80s, when I started working with George Tate on dBase II, the first relational database system available to the general public.

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
Please wait...
SQL Essential Training (2009)
2h 22m Beginner Apr 08, 2009

Viewers: in countries Watching now:

Whatever a database is being used for—web sites, bookkeeping, sales and inventory, or even the lowly to-do list—it's all about the data. SQL Essential Training is designed to help users understand the most common language for database wrangling—SQL. Beginning with a brief introduction, instructor Bill Weinman teaches the major features of SQL; he offers a solid working knowledge of the language, and how to retrieve and manage data efficiently. He also works through a real-world example of building a CRUD (Create, Read, Update, and Delete) application using SQL. Exercise files accompany the course.

Topics include:
  • Understanding SQL terminology and syntax
  • Writing basic SQL queries
  • Sorting and filtering
  • Inserting and updating data
  • Writing string and numeric functions
  • Finding and deleting duplicate data
Subjects:
Developer Databases
Software:
SQL
Author:
Bill Weinman

Introduction

I find databases terribly interesting, whatever the application. Calendar, email, websites, bookkeeping, sales, inventory, even the lowly to-do list, it's all about the data and that usually means some sort of database. (Music playing.) Hi, I'm Bill Weinman and welcome to SQL Essential Training. I have been working with databases since the early 80s, when I started working with George Tate on dBase II, the first relational database system available to the general public.

Most computer applications are about data on some level and database technology holds the key to making them work well. SQL is the language you need to use to talk to most database systems today, and 90% of all SQL uses a few simple variations of a few simple statements and that's a scientific fact. This course aims to give you the knowledge you need to perform these basic functions, so you can read most of the SQL you see and even write your own SQL for the most common uses. You will also get guidance in designing for flexibility in your databases, so that you can get the most out of your data after your application is designed and deployed.

Finally, you will gain skills in designing and planning the most common form of a database application called CRUD. CRUD stands for Create, Read, Update, and Delete, the four basic functions of a database application. The CRUD application is by far the most common type of database application and that's another scientific fact. Now, let's get started with SQL Essential Training.

Find answers to the most frequently asked questions about SQL Essential Training (2009).


Expand all | Collapse all
Please wait...
Q: I've followed the instructions precisely and I still can't get  XAMPP to run properly.
A: In some cases you will need to turn off any virus protection in order to install XAMPP. First, uninstall XAMPP if you have installed it already. Then turn off your virus protection and re-install XAMPP. Finally, don't forget to turn your virus protection back on again.
Q: In the Chapter 1 video "Setting up the test environment on a PC," the author says to?select the Latin1 character set when importing the SQL data. However, I have XAMPP version 1.7.7, and it doesn't offer Latin1 in the drop-down list. What do I choose?
A: Choose the equivalent, iso-8859-1.
Q: Which SQL software should I download or buy in order to be able to do your exercise, extract data, program data, transform and loading processes?
A: In order to follow along with the exercises you need to install the exact same version of XAMPP used in the lessons. Please see this page for more information, and for downloads: http://bw.org/ldcsql
Q: I can't connect to Apache during my XAMP/MAMP installation. How do I fix this?
A: If you have troubling connecting to Apache during the XAMP or MAMP install, please make sure any software running on port 80 (such as Skype) is closed. Apache uses port 80 to connect.
Share a link to this course
Please wait... Please wait...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

join now

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.


Mark all as unwatched Cancel

Congratulations

You have completed SQL Essential Training (2009).

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked