Business Rules  «Prev  Next»

Lesson 3 Business Rules Course Requirements
Objective Learn what you need to take this course.

SQL-Server Business Rules Course Requirements

What is the function of the SQL-Server Database Object

A SQL Server database is a collection of related data that is used to store and retrieve data in an organized and efficient manner. It is a fundamental object in SQL Server and is the basic unit of data storage and organization. The SQL Server Database Engine uses a database as the basic unit of data storage and organization. Each database is stored as a set of files on the server's file system and is made up of one or more tables, views, stored procedures, functions, and other objects.
The SQL Server database object contains various sub-objects like tables, views, stored procedures, functions, triggers, and indexes, which are used to store and manage data in an organized and efficient manner. The database object is used to create, alter, and drop databases and tables, to perform CRUD (Create, Read, Update, and Delete) operations on data, and to manage the security and integrity of the data stored in the database.
Some of the main functions of the SQL Server database object include data storage, data retrieval, data manipulation, data validation, data security, and data integrity. It also provides the ability to back up and restore the data, to replicate the data between servers, and to manage access to the data by different users and applications.

SQL-Server Database Object

The database is effectively the highest-level object that you can refer to within a given SQL Server. Technically speaking, the server itself can be considered to be an object, but not from any real programming perspective. Most, but not all, other objects in SQL Server are children of the database object. A database is typically a group of constructs that include at least a set of table objects and, more often than not, other objects, such as
  1. stored procedures and
  2. views
that pertain to the particular grouping of data stored in the database's tables. What types of tables do you store in just one database, and what goes in a separate database? I will discuss that in some detail later in the course, but for now I will take the simple approach of saying that any data that is generally thought of as belonging to just one system, or is signifi cantly related, will be stored in a single database. An RDBMS, such as SQL Server, may have multiple databases on just one server, or it may have only one. The number of databases that reside on an individual SQL Server depends on such factors as capacity (CPU power, disk I/O limitations, memory, and so on), autonomy (you want one person to have management rights to the server this system is running on, and someone else to have admin rights to a different server), and just how many databases your company or client has. Some servers have only one production database; others have many. Also, any version of SQL Server that you are likely to find in production these days has multiple instances of SQL Server's complete with separate logins and management rights all on the same physical server. (SQL Server 2016 was already fi ve years old by the time it was replaced, so I will assume most shops have that or higher.)

Platform support and Software

You can take this course on Windows, Macintosh, or UNIX platforms.
It is optional for you to have a copy of SQL Server 2012. If you do not currently own SQL Server 2012, you can order an evaluation copy from Microsoft SQL Server SQL Server requires either Windows 2000/20003 or Windows XP operating System.
In the next lesson, the course resources will be discussed.