Start learning with our library of video tutorials taught by experts. Get started
In SQL Server 2008 Essential Training, Simon Allardice explores all the major features of SQL Server 2008 R2, beginning with core concepts: installing, planning, and building a first database. Explore how Transact-SQL is used to retrieve, update, and insert information, and gain insight into how to effectively administer databases. The course also covers features outside SQL Server's database engine, including technologies that have grown up around it: SQL Server Reporting Services and Integration Services. Exercise files are included with the course.
Hi! I am Simon Allardice and welcome to SQL Server 2008 Essential Training. In the next few hours, we'll cover the core features found in SQL Server 2008 R2, the latest version of Microsoft's flagship database management system. In this course we'll begin by choosing the right edition of SQL Server from the many available options. We'll see how to install it properly and explore the different tools and applications for working with SQL Server. We'll move on to designing and creating databases and tables and see how to use Transact-SQL, the language of SQL Server, to retrieve, insert, and manipulate data.
We'll perform core database administration tasks, like working with indexing to improve performance, see how to secure your data, and how to work with Backup and Restore. We'll even have an introduction to some of the more advanced features of this product, things like SQL Server reporting services and integration services. If you've been working with SQL Server already, you may soon find that you've only scratched the surface of what it can really do, and if you're just beginning to use SQL Server, this is the perfect place to start.
So welcome to SQL Server 2008 Essential Training.
Find answers to the most frequently asked questions about SQL Server 2008 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.