Mel Haynes
Mel Haynes (MCP, MS, MCTS) has been delivering technical training since 1994 across the USA, Canada, Germany and the UK. He first taught computer science while completing his Masters in Computer Science at Bradley University. He began teaching Visual Basic as an MCT, and later moved on to ASP, C#.net, VB.Net, Java, various web related developer topics, as well as SQL Server and Windows administration. Mel has developed and delivered Master Data Management (MDM) training and is currently focused on SQL Server 2008. He is a gifted and experienced IT professional and communicator, able to make complex concepts clear and easy to understand.
Mel Haynes has written 11 posts for TrainSignal Training
New Training Release: Advanced SQL Server 2008 Database Administration
By Mel Haynes ⋅ March 2, 2010 ⋅ 2 comments
Hello Train Signal blog readers! This is Mel, and I just finished my Advanced SQL Server 2008 Database Administration Training and wanted to take a minute here to tell you a little bit about it. I will also give you a brief outline of the different SQL Server certification paths and levels and point you [...]
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.