Start learning with our library of video tutorials taught by experts. Get started
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.
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.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
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.