Video:
Pt. 1 - An Introduction to SQL Server Management Studio (SSMS)
-
Skill level:
200 (Beginner - Intermediate)
-
Run Time:
9:45
-
Instructor:
Scott Whigham
Description:
Scott Whigham does a phenomenal job of introducing you to the new SQL SERVER MANAGEMENT STUDIO (SSMS).This solid introduction begins with the most common uses of SSMS. This lesson does utilize the SP2 version of SQL 2005 however does not require the student to have this installed. This video is filled with a wealth of knowledge and information waiting to be absorbed. This is a fantastic video for the new and old programmers alike. If you are unfamiliar with any of the following than this video is for you:
- SQL SERVER 2005 terminology.
- Just in Time terminology and explanation (JIT)
- JIT Compiling explanation of usage within SQL Server Management Studio
- SSMS Terminology
- Pertinent and important options available within SSMS
- Introduction to working with PINUPS within the WINDOWS Start menu.
- OBJECT Explorer in SSMS (Closest replacement for Enterprise Manager/Object Browser)
- Proper usage of the OBJECT Explorer
- SQL SERVER 2005 Version Number (Version 9)
- Introduction to beginning troubleshooting with SQL SERVER CONFIGURATION MANAGER
- Connecting to Reporting Services, Integration Services and Database Engines.
- Introduction to scripting within SSMS.
- Non MODAL Windows in SSMS 2005 vs. MODAL Windows in SQL 2000
This video is a must see for all beginners and anyone looking to further their basic knowledge about SSMS. If you are not familiar with SSMS you will be very pleased with how easy this video is to follow & absorb and how quickly Scott makes use of your valuable time in properly teaching the correct way to enter the world of SQL SERVER MANAGEMENT STUDIO.
NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!
Download
and watch this video
NOTE: You will need the TSCC codec
installed to view video
Scott Whigham
Scott Whigham is the founder of LearnItFirst.com, one of the web's most extensive
video training libraries focusing on technical training. Scott is also an experienced
consultant, trainer, and author with more than a decade of hands-on experience working
with SQL Server databases, writing and debugging applications using Visual Studio,
and performance tuning. Scott designed the architecture (websites, class libraries,
and database) for the LearnItFirst.com websites and, most
re...
(Scott's full bio can be found here)
|
Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys
|
200
|
Download
|
|
Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs
|
300
|
Download
|
|
Creating Database Diagrams in SQL Server Management Studio
|
200
|
Download
|
|
When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause
|
300
|
Download
|
|
JOINs - An Overview of the Five Types of JOINs (Cross, Outer, and Inner)
|
200
|
Download
|
NOTE: This video is part of our
SQL Server Programming (SQL Server 2005/2000): Transact SQL course.
This video is from Chapter
1:
The Development Environment - Tools, Code Generation, and More
Jump to a specific chapter: