Pt. 5 - Using SQL Server Management Studio (SSMS) Express - view details
This is part 5 of a 5 part video section about installation and usage of the Express Editions of SQL Server 2005. The renowned trainer, Scott Whigham, provides us with his superior knowledge
while training us in non-technical terms in this beginner video for SQL Server. Amongst the very easy to understand detailed explanation of the introduction and configuration of the
SQL Server Management Studio Express (SSMS), connecting to a database and the major differences between starting SQL Express and SQL Enterprise you will also find the following excellent training
material:This is the icing on the cake; a wonderful end to a phenomenal section of videos that is sure to boost your knowledge up to the top along with everyone else. In less time than it takes to install SQL Server Express Editions and add-ons you can have all of the knowledge so you know what to do and what not to do. This video and video section is perfect for all beginners and intermediate users alike. If you need to know about it within the Express Editions, chances are very good it has been covered somewhere in this video section.
- Intro to authentication in SQL Server
- Real world errors when logging into SQL Express
- How to identify and read what version of SQL Server you are currently using
- Connecting to other SQL Instances
- Connecting to an alias
- Connecting to Object Explorer
- Creation of a new database and tables
- Navigation of Table Column Properties
- Create Primary Keys
- Working with the table properties
- In depth discussion on adding data to tables via SSMS
- Primary key error example
- HOW TO properly backup a database
- Discussion of lack of maintenance jobs within SQL Express
- HOW TO properly restore a database from a backup
- SQL Express vs Enterprise Edition security comparison
NOTE: This description was provided by one of our members, Wayne Leiser. Thanks, Wayne!
- Source: http://www.learnitfirst.com/Course/152/Video/698/Using-SQL-Management-Studio-SSMS-Express.aspx
- Course: http://www.learnitfirst.com/Course/152/SQL-Server-2005-DBA.aspx
- Skill Level: 200 (Beginner - Intermediate)
- Length: 15:17 (10.5MB)
- Full Details
To download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: ssms, enterprise manager, query analyzer
This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.
