- Using T-SQL (Transact-SQL)
- Managing databases with SQL Server Management Studio
- Understanding database normalization
- Using SELECT statements
- Building indexes
- Monitoring database size and integrity
- Backing up and restoring databases
- Creating functions and stored procedures
- Managing database permissions
- Creating and formatting reports
- Adding charts to reports
- Creating and executing a simple SSIS package
Skill Level Beginner
(upbeat music) - Hi, I'm 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 Back Up 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.
1. Getting Started
2. Installing SQL Server 2008 R2
3. Tools and System Databases
SQL Server system databases2m 22s
4. Creating Databases
5. Importing Existing Data
6. Retrieving Data with SQL
7. Inserting and Updating Data
8. SQL Functions
9. Stored Procedures and Transactions
10. Core Administration Tasks
11. Backing Up and Restoring
12. Security Features
13. Reporting Services
14. Integration Services
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.