SQL Server Essentials for Oracle DBAs: (04) Data Objects
- Posted: Dec 28, 2012 at 9:09AM
- 10,659 views
Right click “Save as…”
Module 4 examines in greater detail the schema objects introduced in Module 2. While all schema objects are mentioned, of particular interest are tables, the type of data they can hold, and their storage layout. A proper understanding of data types and storage architecture of tables and indexes is useful in many aspects of database design and administration, such as fragmentation, capacity planning, etc. A mapping of the native data types from Oracle to SQL Server provides the student with a very good reference on what data types are compatible and what are not.
Full course outline: