¿Aún no tienes una cuenta? Crea una ahora y accede a tus listas favoritas, tu histórico de cuentas y muchas más cosas...
Pedidos y atención al cliente
TLF: 963 392 051 / FAX: 963 615 480
Prepare to pass the MCDBA/MCSE SQL Server 7 Database Design exam while gaining practical Knowledge of Microsoft´s relation database technology for on the job success. Built on the proven training methodology of Global Knowledge, this complete study guide and CD-ROM package offers actual classroom techniques used by more than 200,000 It professionals each year. This book including how to: Group data into entities by applying normalization rules. Choose the foreign key that will enforce a relationship between entities and will ensure referential integrity. Access the potential impact of the logical design on performance, maintainability, extensibility, scalbility, availability, and security. Create and manage explicit, implicit, and distributed transactions to ensure data consistency and recoverability. Write INSERT, DELETE, UPDATE, and SELECT statements that retrieve and modify data. Create scripts using Transact SQL. Programming elements include control of flow methods, local and global variables, functions, and errorhandling methods. Create result sets that provide summary data. Query tupes include TOP n PERCENT and GROUP BY, specifically HAVING, CUBE, and ROLLUP. Create and manage files, file groups, and transaction logs that define a database. Populate the database with data from an external data source.