SQL Essential Training for Databases

with Bill Weinman
please wait ...
SQL Essential Training
Video duration: 0s 3h 27m Beginner

Viewers:

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 IT
Software:
SQL
Author:

Welcome

- [Voiceover] 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.

please wait ...