SQL DBA Chapter 1

Structured collection of information stored according to a defined model and accessible through standard or proprietary database communications languages.

Defines the way data is stored

Stored in a single container, data redundacy, higher costs, CPU, and easier

SELECT dbo.Sales.ProductID, dbo.Sales.ProductName, Dbo.Sales.OrderID, dbo.Sales.Quantity, dbo.Sales.Price FROM dbo.Products;

SELECT dbo.Products.ProductsID, dbo.Products.ProductName, dbo.Sales.OrderiID FROM dbo.Products INNER JOIN dbo.Sales ON dbo.Products.ProductID = dbo.Sales.ProductID;

Online Analytical Processing: performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.

Online transaction processing, or OLTP, is a class of information systems that facilitate and manage transaction-oriented applications, typically for data entry and retrieval transaction processing.

Process used to ensure that relational data is stored in a manner that removes or reduces anomalies in data modifications. The process also results in a reduction in redundancy within the data store.

Store information in separate containers called tables

Indexed, optimized more efficiently, consume less space, handle more users, more scalable.

Local use for 3-5 users. Do not scale well. can use Microsoft Access to build forms, queries, and reports against a backend SQL Server database as well. can be used as a frontend for local SQL Server 2012 Express databases, although you will probably have to design the database in SQL Server Management Studio Express 2012.

Data availability, integrity, and security.

Data appropriately stored, backed up and protect from catastrophic failures, and available when users want it.

Data is could be what it should be, accuracy, no malicious changes, and not corrupted.

Collection of data and reference information used to locate records more quickly in a table.