Video:
Pt. 3 - Changing Table Design and Properties; Using the Query Designer in SSMS
-
Skill level:
300 (Intermediate)
-
Run Time:
13:30
-
Instructor:
Scott Whigham
Description:
This wonderfully designed video hosts part 3 of the 4 part section of videos about SQL SERVER MANAGEMENT STUDIO (SSMS). This video will amaze you with extensive amount of informative material enclosed within its binds and is no exception to the wonderful and easy teaching style. Not only does this video detail out the pros and cons of working with the SSMS when designing or working with tables, writing queries within the AdventureWorks database but also contains information on the following items:
- Launching SSMS from the Windows Start Menu
- Intro Pinning Windows in SSMS
- Intro to Tabbed Environment
- Common Errors in SSMS and rectifying those errors
- Object Explorer Right Click Options
- Intro Properties window
- Explanation of SAVE ME Asterisks
- Detailed Explanation of column properties
- Intro to Identity Columns in column properties
- Generate Change Script Option
- Intro to SQL SERVER AGENT
- Creating and scheduling a SQL SERVER AGENT TASK
- Common Real World Errors within SQL SERVER AGENT TASKS
- Rectifying Common Errors within SQL SERVER AGENT TASKS
- Benefits of the Change Scripts
- Schema Change Definition
- Inserting Values into TABLES via the Query Designer Graphic User Interface (GUI) in SSMS
- Dangers of Inserting Values into TABLES via the Query Designer Graphic User Interface (GUI) in SSMS
- TSQL INSERT STATEMENT vs. OPEN TABLE Query Designer Graphic User Interface (GUI) in SSMS Comparison
- Intro to Transactions, Rollback and Commit
The trainer in this video does a wonderful job of continuing the introduction to to SSMS. This video does a fantastic job of combining real world environments, common error probabilities and realistic tasks together in an easy to follow training course.
NOTE: This video was reviewed and this 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: