Sams teach yourself Microsoft SQL Server 2005 Express in 24 hours /

Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level. You will learn all of the basic tasks nec...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Balter, Alison
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [Indianapolis, Ind.] : Sams Pub., [2006]
Colección:Sams teach yourself.
Temas:
SQL server.
SQL server
Relational databases.
Client/server computing.
Bases de données relationnelles.
Architecture client-serveur (Informatique)
Client/server computing
Relational databases
Engineering & Applied Sciences.
Computer Science.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • TOC36;Table of Contents
  • Introduction
  • Part I58; Introduction to SQL Server
  • CH36;HOUR 158; Basic Relational Database Design
  • Database Basics
  • System Versus User Objects
  • Table Basics
  • Relational Database Design Concepts
  • Database Diagram Basics
  • View Basics
  • Stored Procedure Basics
  • User45;Defined Function Basics
  • Trigger Basics
  • SQL Server Stored Procedures Versus Transact45;SQL Statements Stored on Local Computers
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • CH36;HOUR 258; SQL Server Basics
  • Versions of SQL Server 2005 Available
  • Installing SQL Server Express
  • Getting Started with the SQL Server Management Studio Express
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • CH36;HOUR 358; Getting to Know the SQL Server Management Studio
  • Microsoft SQL Server Management Studio Express
  • Creating a SQL Server Database
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • Part II58; Working with Tables44; Views44; and Stored Procedures
  • CH36;HOUR 458; SQL Server Tables
  • Creating SQL Server Tables
  • Working with Constraints
  • Identity Columns
  • Working with Computed Columns
  • Working with User45;Defined Data Types
  • Adding and Modifying Indexes
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • CH36;HOUR 558; Working with Table Relationships
  • An Introduction to Relationships
  • Working with Database Diagrams
  • Working with Table Relationships
  • How to Designate Table and Column Specifications
  • How to Add a Relationship Name and Description
  • How to Determine when Foreign Key Relationships Constrain the Data Entered in a Column
  • Designating Insert and Update Specifications
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • CH36;HOUR 658; Getting to Know the SELECT Statement
  • Introducing T45;SQL
  • Working with the SELECT Statement
  • Adding on the FROM Clause
  • Including the WHERE Clause
  • Using the ORDER BY Clause
  • Adding the DISTINCT Keyword
  • Working with the FOR XML Clause
  • Creating Top Values Queries
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • CH36;HOUR 758; Building SQL Statements Based on Multiple Tables
  • Working with Join Types
  • Working with the GROUP BY Clause
  • Including Aggregate Functions in Your SQL Statements
  • Taking Advantage of the HAVING Clause
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • CH36;HOUR 858; Modifying Data with Action Queries
  • Modifying Data with Action Queries
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • CH36;HOUR 958; Getting to Know the T45;SQL Functions
  • Working with Numeric Functions
  • Taking Advantage of String Functions
  • Exploring the Date47;Time Functions
  • Working with Nulls
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • CH36;HOUR 1058; Working with SQL Server Views
  • An Introduction to Views
  • Using T45;SQL to Create or Modify a View
  • Summary
  • Q38;A
  • Workshop
  • Activities
  • CH36;HOUR 1158; Creating Complex Views
  • Creating Views Based on Data in Multiple Tables
  • Views and Subqueries
  • Views and Outer Joins
  • Views and Top Values
  • Sorting View Results
  • Views and Functions
  • Views and Built45;in Functions
  • Using Views to Secur.

Ejemplares similares