SQL Server Essentials for Oracle DBAs: (01) Database and Instance

Posted: Dec 28, 2012 at 9:07 AM

By: JeffKoch

(1)

8,309 Views

7 Comments

Video format

Option selected may change based on video formats available and browser capability.

Auto

Use our suggested format for this video.

Smooth Streaming

Adaptive bitrate streaming - little buffering but lower video quality at times of low bandwidth. Silverlight 5 required

Progressive

Traditional buffered video format. Silverlight 5 required

HTML5

For browsers that support H.264 MP4 or WebM video playback such as:
IE9+, Firefox 4+, Chrome 5+, or Safari 4+.

Flash

For browsers that have the Adobe Flash Player plugin installed.

Module 1 provides an understanding of the two major components of a database system. The database constitutes the files that store data, and the instance is the collection of server resources that provide a powerful, high performance interface to the data. It also illustrates how the two interact to provide data requested by the clients. Viewing the database and the instance as two separate interactive components of the RDBMS helps us to divide-and-conquer the vast set of topics covered in this workshop.

[05:47] - SQL Server Instance Environment
[15:14] - Client interaction with Database and Instance
[24:51] - Database capacities

Full course outline:

Mod 01: Database and Instance
Mod 02: Database Architecture
Mod 03a: Instance Architecture Part 1
Mod 03b: Instance Architecture Part 2
Mod 04: Data Objects
Mod 05: Data Access
Mod 06: Data Protection
Mod 07: Basic Administration
Mod 08: Server Management
Mod 09: Schema Management
Mod 10: Database Security
Mod 11: Data Movement
Mod 12: Backup and Recovery
Mod 13: Performance Tuning
Mod 14: Scalability and High Availability
Mod 15: Monitoring

Follow the Discussion

Oops, something didn't work.

Try again?

Getting "follow" information

Stop following these comments

Start following these comments

Removing your "follow"

Setting up your "follow"

Subscribe to this comments

Follow
Oops, something didn't work.

Try again?

Sign In to be begin to follow these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in. You need to be signed in to Channel 9 to use this feature.

Getting "follow" information

Stop following these comments

Start following these comments

What does this mean?
Following an item on Channel 9 allows you to watch for new content and comments that you are interested in and view them all on your notifications page.

Removing your "follow"

Setting up your "follow"

Did you know you can
sign up for email notifications?
- Subscribe to this comments

Steve Ramp

Jan 11, 2013 at 5:16 AM

Poor resolution on screen delivery of content
Amir Said

Jan 22, 2013 at 5:34 PM

Can not see the screen, very poor resolution on screen delivery of content
Bonatti

Jan 23, 2013 at 5:14 AM

Very poor resolution on screen!
if I install IE10 will be better or not?
Bonatti

Jan 23, 2013 at 5:21 AM

I'm sorry!
I clicked on "High Quality MP4" link and the resolution screen is very good!
Tks!
Luiz

Jan 27, 2013 at 3:46 PM

Esse curso é somente em inglês??
Eric

Feb 04, 2013 at 7:32 AM

Closed captioning/subtitling pretty please? I can't hear a thing and never will.
Thomas

Mar 12, 2013 at 7:22 AM

High Quality WMV would fit, too.