Subscribe to the TST RSS Feed
Free SQL 101 Training — Part 7: Basic Programming Logic
Welcome to Part 7 of my free SQL 101 training series designed to help you learn the essentials of SQL.
Today you will learn basic programming logic for SQL Server. I’ll explain conditional expressions and using a nested query as an example, I’ll demonstrate how basic programming logic works in SQL Server.
In case you haven’t downloaded them yet, all student files are available for you here. Enjoy today’s video and let me know what you think!
Free SQL 101 Training Part 7: Basic Programming Logic
Free SQL 101 Training: Learn the Basics of Structured Query Language
|
SQL 101 Part 1: Intro to SQL Server • What is SQL? • Flat Files • Relational Databases • Vender Variations |
||||
|
SQL 101 Part 2: Database Concepts • Key Terms and Concepts • Multiple Values Per Field • Repeating Fields • The Ultimate Solution • Primary Keys • Foreign Keys • Our Database Schema • Table Relationships |
||||
|
SQL 101 Part 3: Introduction to Structured Query Language • SELECT Statement • SELECT WHERE Statement • SELECT ORDER BY Statement • SELECT – Multi Table Statement |
||||
|
SQL 101 Part 4: The INSERT Statement • INSERT Statement Definition • INSERT Statement Demo |
||||
|
SQL 101 Part 5: The UPDATE Statement • UPDATE Statement Definition • Updates Based on a Value • Nested Statements • Updating All Rows |
||||
|
SQL 101 Part 6: The DELETE Statement • DELETE – With Job Security • DELETE Statement Demo |
||||
|
SQL 101 Part 7: Basic Programming Logic • Conditional Expressions • Nested Statement • CASE Statement • Adjusting Results Column Names |
||||
|
SQL 101 Part 8: Data Definition Language • DML vs. DDL • CREATE and DROP Statements • Creating a New Table in a Database |
||||
|
SQL 101 Part 9: Data Control Language • CREATE LOGIN Statement • CREATE USER Statement • Creating a Login • Creating a User • Deleting Login Account |
||||
|
SQL 101 Part 10: Database Backup • Setup your own database |
||||
Go Beyond the Basics — Master SQL Server Administration and Development
SQL Server 2008 Administration Training
This training is designed to help you develop hands-on experience and in-depth knowledge of Server 2008 Administration.
In over 10 hours of video training, Mel shares his years of database experience while getting you on the road to becoming a DBA yourself.
As you learn about SQL, you will also be preparing for the 70-432 exam so you can earn your MCTS Certification.
Learn More about SQL Server 2008 Administration Training
SQL Server 2008 Database Development Training
Learn how to design SQL databases, applications and build functionality that will best support users and businesses in a customized and unique way.
Get over 10 hours of in-depth video training and complete 70-432 exam coverage.
Database development is one of the few jobs that is in constant demand — as you prepare for an interesting career in development you will also be ensuing job security for your future.
Learn More about SQL Server 2008 Database Development Training
Related Posts:
- Free SQL 101 Training — Part 8: Data Definition Language
- Free SQL 101 Training — Part 6: The DELETE Statement
- Free SQL 101 Training — Part 9: Data Control Language
- Free SQL 101 Training — Part 4: The INSERT Statement
- Free SLQ 101 Training — Part 5: The UPDATE Statement
- Free SQL 101 Training — Part 3: Structured Query Language
- Free SQL 101 Training — Part 1: Intro to SQL Server
3 Responses to “Free SQL 101 Training — Part 7: Basic Programming Logic”
Leave A Comment:
Subscribe To Our eNewsletter
Rebe Says:
July 18th, 2009 at 12:41 pm
very good and very detailed thanks
Mac Says:
November 13th, 2009 at 1:04 pm
Mel,
I’m enjoying your videos and have made a decision to learn SQL. I plan to go thru your free SQL 101 videos then purchase the SQL 2008 AT. I have loaded the Veronica database and followed 1-6 videos with no issues. Now video 7 is a different story. I tried to use the LoadClientMatch.sql with no luck. I keep getting the follow error “Msg 208, Level 16, State 82, Line 3 Invalid object name ‘ClientFlowerMatch’.
Ex…
SE [veronicas]
GO
BULK
INSERT ClientFlowerMatch
FROM ‘c:\TrainSignal\SQL101\ClientFlowerMatch.csv’
WITH
(
FIELDTERMINATOR = ‘,’,
ROWTERMINATOR = ‘\n’
)
GO
I’m sure it’s something really stupid on my part. Can you give me a quick helping hand so I can continue practicing along with the videos?
Mac Says:
November 13th, 2009 at 1:46 pm
WOOT! I understand now. I just needed to watch the next video. Thank You!