Free SQL Training Videos 10 posts

These free SQL training videos will give you a solid foundation for the world of databases. SQL 101 Training begins with an introduction to SQL & general database concepts, moves through structured query language and programming logic, and concludes with a how-to guide to database setup.

Free SQL 101 Training Part 10: Database Setup

By Mel Haynes ⋅ August 6, 2009 ⋅ 2 comments

Learn how to setup your own database in SQL Server 2008. In this video you’ll see a demonstration of setting up a database so you can follow along and setup your own SQL database to practice and learn on.

Free SQL 101 Training Part 9: Data Control Language

By Mel Haynes ⋅ July 30, 2009 ⋅ Post a comment

In this video from our free SQL 101 training we’ll cover Data Control Language, also known as DCL. We’ll go over the CREATE LOGIN statement, CREATE USER statement and the actual process of creating a new login and user. Finally, you’ll learn how to delete a login account.

Free SQL 101 Training Part 8: Data Definition Language

By Mel Haynes ⋅ July 23, 2009 ⋅ Post a comment

This video from our free SQL 101 training focuses on Data Definition Language, also known in the SQL world as DDL. We’ll take a look at how DDL is different from DML, or Data Manipulation Language, along with the CREATE and DROP statements in SQL. Finally, we’ll go over creating a new table in your SQL database.

Free SQL 101 Training Part 7: Basic Programming Logic

By Mel Haynes ⋅ July 16, 2009 ⋅ 3 comments

This video from our free SQL 101 training covers basic programming logic, including conditional expressions, the nested statement, CASE statement, and adjusting results column names in SQL.

Free SQL 101 Training Part 6: The DELETE Statement

By Mel Haynes ⋅ July 9, 2009 ⋅ One comment

In this video from our free SQL 101 training, you’ll learn about the DELETE statement and how to use it with job security. What I mean by deleting with job security is deleting data in your database using the UPDATE statement so that if you ever need to recover the deleted data you cab easily do it.

Free SLQ 101 Training Part 5: The UPDATE Statement

By Mel Haynes ⋅ July 2, 2009 ⋅ One comment

This video, from our free SQL 101 training focuses on he UPDATE statement which is used to update records in your SQL database. See how the UPDATE statement is used, what updates based on values are as well as nested statements and updating all rows in your SQL Server database.

Free SQL 101 Training Part 4: The INSERT Statement

By Mel Haynes ⋅ June 25, 2009 ⋅ 5 comments

This video, from our free SQL 101 training focuses on he INSERT statement in SQL which is used to add new data to your SQL database. See how the INSERT statement is used and watch a demo of it in an actual SQL Server database.

Free SQL 101 Training Part 3: Structured Query Language

By Mel Haynes ⋅ June 18, 2009 ⋅ 7 comments

Get started with SQL Server by learning about Structured Query Language. This free video, part of our SQL 101 training series, covers the SELECT Statement, SELECT WHERE Statement, SELECT ORDER BY Statement and SELECT – Multi Table Statement.

Free SQL 101 Training Part 2: Database Concepts

By Mel Haynes ⋅ June 11, 2009 ⋅ 4 comments

In part 2 of our free SQL 101 training you’ll learn some key database terms and concepts that every DBA needs to be familiar with. You’ll also learn about multiple values per field, repeating fields, primary keys, foreign keys and table relationships. The video will also include a section on database schema and the ultimate solution.

Free SQL 101 Training Part 1: Intro to SQL Server

By Mel Haynes ⋅ May 28, 2009 ⋅ 8 comments

In this free SQL 101 video you’ll learn what SQL is, what flat files in SQL are, the definition of relational databases and about SQL vender variations. If you’re interested in learning about SQL then this is the perfect place to start.

Free SQL Training Videos 10 posts

More Free Computer Training Videos

Categories

Featured Products

Tags