Where IT pros go for news, tips, certification info, videos and more.
Free SQL Training Videos 16 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.
By Jillian Pandav ⋅ November 8, 2012 ⋅ 4:14 ⋅ Post a comment
There are so many things you can do with PowerShell, and this video only cracks the surface. Here Sean McCown shares a few PowerShell tricks that will make managing tasks in SQL Server so much easier for.
By Jillian Pandav ⋅ November 8, 2012 ⋅ 6:47 ⋅ Post a comment
In this SQL Server training clip, Christopher Harrison will show you how to use various date and time functions, such as GETDATE and DATEPART, and how you can use various ones for reporting and other tasks.
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.
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.
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.
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.
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.
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.
By Mel Haynes ⋅ June 18, 2009 ⋅ 9 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.
By Mel Haynes ⋅ June 11, 2009 ⋅ 5 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.
By Mel Haynes ⋅ May 28, 2009 ⋅ 13 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.