Movie ReelIn a previous post, I encouraged you to consider an older video series focussed on learning SQL Server 2005 Express. In this post, I’d like to highlight a different video series focused on SQL Server 2008 Express: SQL Server 2008 Express How-To-Guide Series. Here is how I would suggest getting the most out of these videos.

First, the installation video shows installing an older version of SQL Server 2008. So I would instead use the installation video from our “Learning SQL Server” video series here: How to Install SQL Server 2008 R2 Express. Then, if you are using the Express edition to learn, I would recommend watching the following videos in the following order:

2. SQL Server 2008 Express: How do I import data from another source (Excel, Access, XML, MySQL, …) into a SQL Server Database?
3. SQL Server 2008 Express: How do I insert data into a database?
4. SQL Server 2008 Express: How do I query data in a database?
5. SQL Server 2008 Express: How do I update data in a database?
6. SQL Server 2008 Express: How do I delete data in a database?
7. SQL Server 2008 Express: How do I join data in a database?
8. SQL Server 2008 Express: How do I sort, group, etc. queries?
9. SQL Server 2008 Express: How do I create sub queries?
10. SQL Server 2008 Express: How do I execute multiple SQL statements in one transaction?
11. SQL Server 2008 Express: How can I increase the speed of a SQL query (CREATE INDEX)?
12. SQL Server 2008 Express: SQL Server Express Troubleshooting
13. SQL Server 2008 Express: How do I secure a SQL Server by assigning dedicated permissions to different users?
14. SQL Server 2008 Express: How do I backup a SQL Express database?
15. SQL Server 2008 Express: How do I backup a remote SQL Express database?
16. SQL Server 2008 Express: How do I restore a SQL Express database?
17. SQL Server 2008 Express: How do I update a Live SQL Server Database (when the Development Database has changed)?
18. SQL Server 2008 Express: How do I upsize SQL Server Express 2005 to SQL Server 2008 R2?

If you’re using a paid edition of SQL Server, then you could also consider watching the video on integration services and the one on profiling queries.

You might know that  I’m working on a new video series for Learning SQL Server. There will be unique information in this video series, and there will be some overlap with other resources like this. But hopefully, the combination of older and newer video resources, presented in different ways, will aid your overall learning.

For other resources like this, see the post:

How to Learn SQL Server Online (Advice & Resources)

About these ads