SQLConfiguration 





Business Rules  «Prev  Next»
Lesson 2 Business Rules Course Prerequisites
Objective Verify that you have the right background for this course.

Business Rules Course Prerequisites

Server Cloud is the cloud version of Microsoft's SQL Server.. It does require the following, however:
  1. Experience using the Microsoft Windows 2008 Server network operating system
  2. Familiarity with the definition, theory, and underlying function of relational databases
  3. Completion of Introduction to SQL, Parts 1 and 2, or equivalent understanding of basic ANSI SQL statements
  4. Completion of Creating a Database, the first course in this series, or equivalent understanding of relational concepts, basic Transact-SQL statements, and how to create databases and tables
  5. Completion of Queries, Cursors, and Views, the second course in this series, or equivalent understanding of query statements, inner and outer joins, subqueries, views, and cursors
In the next lesson, the requirements for this course will be discussed.



An Overview of Database Objects

An instance of an RDBMS such as SQL Server contains many objects. Object purists out there may quibble with whether Microsoft's choice of what to (and what not to) call an object actually meets the normal defi nition of an object, but, for SQL Server's purposes, the list of some of the more important database objects can be said to contain such things as:
  1. The database itself
  2. The transaction log
  3. Tables
  4. Indexes
  5. Filegroups
  6. Diagrams
  7. Views
  8. Stored procedures
  9. User-defined functions
  10. Sequences
  11. Users
  12. Roles
  13. Assemblies
  14. Reports
  15. Full-text catalogs
  16. User-defined data types