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

SQL Essential Training
Illustration by Don Barnett

SQL Essential Training

with Bill Weinman

Video: Welcome

Hi, I'm Bill Weinman, and welcome to SQL Essential Training.
Expand all | Collapse all
  1. 41m 24s
    1. Welcome
      1m 4s
    2. Using the exercise files
      1m 43s
    3. Course overview
      4m 4s
    4. Installing the test environment on a Mac
      12m 47s
    5. Installing the test environment on a PC
      17m 4s
    6. What is SQL?
      4m 42s
  2. 21m 46s
    1. Quick-start introduction
      1m 15s
    2. Using the basic SELECT statement
      4m 41s
    3. Selecting rows
      2m 24s
    4. Selecting columns
      2m 56s
    5. Counting rows
      1m 46s
    6. Inserting data
      4m 15s
    7. Updating data
      2m 31s
    8. Deleting data
      1m 58s
  3. 53m 17s
    1. Databases and tables
      1m 29s
    2. SQL syntax overview
      4m 44s
    3. Formatting SQL
      1m 32s
    4. Creating tables
      2m 33s
    5. Deleting a table with DROP TABLE
      2m 16s
    6. Inserting rows into a table
      3m 45s
    7. Deleting rows from a table
      2m 4s
    8. Understanding NULL
      4m 23s
    9. Controlling column behaviors with constraints
      3m 44s
    10. Changing a schema with ALTER
      2m 49s
    11. Creating an ID column
      3m 2s
    12. Filtering data with WHERE, LIKE, and IN
      8m 3s
    13. Removing duplicates with SELECT DISTINCT
      6m 6s
    14. Sorting with ORDER BY
      3m 35s
    15. Conditional expressions with CASE
      3m 12s
  4. 11m 40s
    1. Understanding joins
      2m 23s
    2. Accessing related tables with JOIN
      4m 20s
    3. Using multiple related tables
      4m 57s
  5. 11m 6s
    1. About SQL strings
      1m 24s
    2. Finding the length of a string
      1m 14s
    3. Selecting part of a string
      2m 57s
    4. Removing spaces with TRIM
      3m 9s
    5. Making strings uppercase and lowercase
      2m 22s
  6. 8m 42s
    1. About numeric types
      2m 23s
    2. Finding the type of a value
      2m 38s
    3. Integer division and remainders
      2m 27s
    4. Rounding numbers
      1m 14s
  7. 4m 45s
    1. Dates and times
      1m 59s
    2. Date- and time-related functions
      2m 46s
  8. 9m 32s
    1. How aggregates work
      4m 52s
    2. Using aggregate functions
      2m 24s
    3. Aggregating DISTINCT values
      2m 16s
  9. 8m 0s
    1. Why use transactions?
      1m 55s
    2. Using transactions
      6m 5s
  10. 11m 5s
    1. Updating a table with a trigger
      4m 8s
    2. Preventing automatic updates with a trigger
      4m 18s
    3. Automating timestamps with a trigger
      2m 39s
  11. 11m 54s
    1. Creating a simple subselect
      3m 49s
    2. Searching within a result set
      3m 15s
    3. Creating a view
      2m 36s
    4. Creating a joined view
      2m 14s
  12. 13m 25s
    1. Touring the CRUD application
      5m 10s
    2. The SELECT functions
      5m 37s
    3. The INSERT, UPDATE, and DELETE functions
      2m 38s
  13. 54s
    1. Goodbye
      54s

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
3h 27m Beginner Mar 13, 2014

Viewers: in countries Watching now:

Whatever a database is being used for—websites, bookkeeping, sales and inventory, or even the lowly to-do list—it's still all about the data. Completely updated for 2014, SQL Essential Training is designed to help users understand the most common language for database wrangling, SQL. Beginning with a quick start introduction for those who want to start working with data immediately, instructor Bill Weinman teaches all the major features of SQL: creating tables; defining relationships; manipulating strings, numbers, and dates; using triggers to automate actions; and working with subselects and views. He offers a solid working knowledge of the language, and shows how to retrieve and manage data efficiently. The final chapter includes a real-world example of building a simple CRUD (Create, Read, Update, and Delete) application using SQL.

Topics include:
  • Understanding SQL terminology and syntax
  • Creating new tables and records
  • Inserting and updating data
  • Writing basic SQL queries
  • Sorting and filtering
  • Accessing related tables with JOIN
  • Working with strings
  • Finding the numeric type of a value
  • Using aggregate functions and transactions
  • Updating a table with triggers
  • Creating views
Subjects:
Developer Databases
Software:
SQL
Author:
Bill Weinman

Welcome

Hi, I'm Bill Weinman, and welcome to SQL Essential Training. The goal of this course is to provide you with the basic knowledge that you need to use SQL effectively in any database environment. We'll start with the basics. How databases are organized, and in particular, how relational databases work. I'll explain how to use the select statement, how to create, update, and delete data from your tables. How to effectively format your code, and how the basic structure of SQL works.

I'll cover data types, aggregate queries, transactions, and other features of this powerful database language. Finally, I'll show you a full working CRUD application. CRUD is an acronym for the four basic functions of any database application, create, read, update, and delete. Understanding SQL will serve you well in coding and managing relational databases and your database applications. So let's get started with SQL Essential Training.

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


Expand all | Collapse all
please wait ...
Q: For Mac OS X: When I try to start the Apache Web Server from the XAMPP control panel, it doesn't start, and when I open "localhost" in my web browser, I see a white screen that says "It Works!" instead of the XAMPP page.
A: This usually means that you have the Apple version of the Apache Web Server already running.
 
Apple provides a version of the Apache Web Server with OS X. I chose to use XAMPP because it includes PHP and the MySQL server all in one package.
 
You cannot install XAMPP with Apache already running on your Mac. If you see "It works!" when you open your browser and type "localhost" into the address bar, this means that the Apple version of Apache is already running. You cannot run two instances of a web server at once, so the Apple Apache must be stopped before you can install XAMPP.
 
In OSX 10.7 and earlier, you could start and stop the Apache Web Server in Control Panel, by choosing "Sharing" and then unchecking the "Web Sharing" checkbox. As of 10.8 this option is no longer in the control panel.
 
To disable Apple's version of Apache in current versions of OS X, open a Terminal window and type this command:
 
sudo apachectl stop
 
You will need to type your system password when prompted, then you should be able to start the XAMPP version of Apache.
Q: I'm on a Mac, and I get an error in SID that says "attempt to write a read only database." How can I fix this?

A: This usually means that the database folder does not have sufficient permissions for writing by the web user. This can happen if you create the SQL folder new, rather than copying it from the Exercise Files. Here's how to fix this: 

  1. Open a Finder window and Navigate to /Applications/XAMPP/htdocs/SQL
  2. Control-click on the SQL folder and select "Get Info" from the context menu. 
  3. Under "Sharing and Permissions" (you may need to open the disclosure triangle), in the "everyone" row, select "Read & Write."Then you can close the Info window. 
  4. Now repeat the process for the three *.db files inside the folder. 

 

 
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

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 Upgrade 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.

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
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.

Are you sure you want to delete this note?

No

Notes cannot be added for locked videos.

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
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.