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.
Learn the Basics of XML for SQL 2012
By Jillian Pandav ⋅ January 3, 2013 ⋅ 9:15 ⋅ Post a comment
Perplexed by XML documents? Learn the fundamental concepts of how XML is used to format data in text files in this training clip from our SQL Server 2012 training.
How to Create SQL Views
By Jillian Pandav ⋅ November 15, 2012 ⋅ 5:16 ⋅ Post a comment
Every SQL admin should know what views are and how to create them. In this scenario, you’ll learn how to work with SQL views using combining data from different tables.
How to Configure SQL Server Authentication Modes
By Jillian Pandav ⋅ November 15, 2012 ⋅ 5:59 ⋅ Post a comment
This video shows you how to use the GUI in SQL Server to configure authentication modes, which, believe it or not, is easier than trying to do the same with with T-SQL.
How to Use SQL Server & PowerShell to Manage Tasks Better
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.
SQL Server 2012 Query Functions for Date & Time
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.
How to Use Bulk Copy Program (BCP) in SQL 2012
By Chris Magiet ⋅ November 1, 2012 ⋅ 12:42 ⋅ Post a comment
Learn how to use the Bulk Copy Program (BCP) in SQL Server to convert data into text files and vice versa in this SQL 2012 admin essentials video.
Free SQL 101 Training Part 10: Database Setup
By Mel Haynes ⋅ August 6, 2009 ⋅ 5 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 ⋅ 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.
Free SQL 101 Training Part 2: Database Concepts
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.
Free SQL 101 Training Part 1: Intro to SQL Server
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.
-
More Free Computer Training Videos
- Free CCNA Training Videos
- Free Citrix Training Videos
- Free Home Server Training Videos
- Free IT Webinars
- Free ITIL Training Videos
- Free Linux Training Videos
- Free Microsoft Office Training Videos
- Free Networking Training Videos
- Free PC Technician Training Videos
- Free Security Training Videos
- Free Server 2008 Training Videos
- Free SQL Training Videos
- Free VMware Training Videos
- Free Windows 7 Training Videos
- Free Windows 8 Training Videos
- Free Windows Server 2012 Videos
Categories
Featured
Tags
Apple Application Virtualization Backup and Storage Bring Your Own Device CEH Cisco Citrix Cloud Computing CompTIA A+ Training David Davis Ethical Hacking Exchange 2010 Free IT Training Google Hyper-V IT Certifications ITIL ® IT Jobs IT Training Linux Microsoft Mobile Networking Office 2010 PowerShell Productivity Project Management Resume Tips Security Server 2008 Server 2008 R2 SharePoint SQL Server System Center TechEd Tech Events Tips & Tricks TrainSignal Troubleshooting Virtualization VMware VMworld vSphere 5 Webinar Windows Windows 7 Windows 8 Windows Server 2012 Windows Vista Wireless Networking
