Microsoft SQL Server 2008 Development
by Mark Long
Start the free chapterMicrosoft SQL Server 2008 relational database management server is the heart of a comprehensive data platform that provides access and managment of the business critcal data that powers business. In this course, Microsoft Certified Trainer Mark Long introduces you to the basics of SQL Server 2008 Database Development. Work files are included. To begin learning today, simply click on the movie links.
Course content
Introduction7 lessons
Getting Set Up10 lessons
- Hardware Requirements3:481 credit or ad
- SQL Server Instances4:271 credit or ad
- SQL Server Components4:111 credit or ad
- Service Accounts5:241 credit or ad
- Installing SQL Server 2008 pt. 15:371 credit or ad
- Installing SQL Server 2008 pt. 23:561 credit or ad
- Installing SQL Server 2008 pt. 34:061 credit or ad
- SQL Authentication Modes4:491 credit or ad
- Installing Sample Databases pt. 15:461 credit or ad
- Installing Sample Databases pt. 23:351 credit or ad
Database Design6 lessons
Tables & Views15 lessons
- Table Basics4:401 credit or ad
- Creating a Table pt. 13:411 credit or ad
- Creating a Table pt. 26:531 credit or ad
- Creating a Table pt. 35:061 credit or ad
- Data Types5:111 credit or ad
- Unicode Basics5:271 credit or ad
- New Data Types In 20084:161 credit or ad
- Character Types5:461 credit or ad
- Exact Numerics5:281 credit or ad
- Approximate Numeric Types2:501 credit or ad
- Date & Time5:081 credit or ad
- Null or Not Null5:151 credit or ad
- Primary Key4:321 credit or ad
- Foreign Key4:351 credit or ad
- Candidate Key3:221 credit or ad
Retrieving Data6 lessons
Modifying Data5 lessons
Managing Transactions3 lessons
Programming Objects10 lessons
- Understanding Views5:251 credit or ad
- Indexed Views4:461 credit or ad
- Understanding Stored Procs5:531 credit or ad
- Creating Stored Procs5:041 credit or ad
- Using Parameters5:511 credit or ad
- Temporary Tables5:411 credit or ad
- Common Table Expressions5:341 credit or ad
- Table Variables5:321 credit or ad
- Temp Common or Table5:521 credit or ad
- Dynamic SQL4:531 credit or ad