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.
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
- stored procedures and
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.)