26 Part I EXAM PREPARATION WARNING Northwind Configuration
26 Part I EXAM PREPARATION WARNING Northwind Configuration The Northwind database is a poor example of the options to use in a live database. Don t use it as a measure for the options you need for your own database. Before selecting any option, know the impact of the option on the database and client connections as well as any applications- required settings. Northwind The Northwind database is the second example database. It is preferred by many Microsoft Access users who are new to SQL Server because it is the same sample database that was provided for Microsoft Access. Contents of a Database There are certain objects that are present within a database after it has been created. Many database objects are necessary for a database to function. For example, a table object is the basic object needed to store data; without a table, your database wouldn t get very far. An outline of the different database objects that you can use follows: Table. A table is the first thing you create in the database so that data may be stored. Tables may have many fields and records. A table is a data structure that may contain information of interest to users, table creator, or company. Tables, like spreadsheets, are made up of rows and columns. View. A view is an object used in displaying a subset of data from a table in different formats. This can be used to ensure security or reduce data redundancy. A view is a stored SQL query. You can assign permissions to a view to enable an administrator to forgo more granular permission assignments at the column level of a table. User-Defined Function. A user-defined function is a group of T-SQL statements that may be reused. It is similar to predefined functions, such as ABS(), which returns the absolute value of a number specified. User-defined functions can be created by a database developer and stored as database objects. Functions are subroutines used to encapsulate frequently performed logic. Any code that must perform the logic incorporated in a function can call the function rather than having to repeat all the function logic. Stored Procedure. Stored procedures are collections of T-SQL statements that execute as a single unit. Stored procedures are stored on the server and can execute faster than queries at the client, without any extra overhead. Triggers. A trigger is a stored procedure that automatically executes at the invocation of an INSERT, DELETE, or UPDATE.
For high quality website hosting services please check cheap web hosting website.