Introducing SQL Server
Introducing SQL Server is a fast and easy introduction to SQL Server and the world of relational databases. You’ll learn how databases work and how to use the T-SQL language by practicing on one of the most widely-used and powerful database engines in the corporate world: Microsoft SQL Server. Do yo...
Autor principal: | |
---|---|
Formato: | Libro electrónico |
Idioma: | Inglés |
Publicado: |
Berkeley, CA :
Apress
2015.
|
Edición: | 1st ed. 2015. |
Colección: | The expert's voice in SQL server
|
Materias: | |
Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629796506719 |
Tabla de Contenidos:
- Contents at a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Chapter 1: What Is SQL Server?; A Quick History of SQL Server ; SQL Server Services; Business Intelligence Services ; Editions of SQL Server ; SQL Server Tools and Utilities ; Time to Kick Off ; Chapter 2: Obtaining and Installing SQL Server; Downloading SQL Server Express ; Beginning Installation ; Installation Wizard Steps ; Updates and Features; Instance Features; Shared Features ; Database Instances; Default Instances; Named Instances ; The Instance Configuration Page
- Service Accounts Collation ; Database Engine Configuration; Server Configuration ; Data Directories ; User Instances ; FILESTREAM ; Reporting Services Configuration ; Installing ; A Very Quick SSMS Overview ; Summary; Chapter 3: Database Basics; What Is a Database?; Types of Databases; System Databases; User Databases; Creating a Database Using SSMS ; Dropping a Database Using SSMS; Creating a Database Using T-SQL; Dropping A Database Using T-SQL; Advanced Database Scripting; Creating Scripts Automatically; Database Properties ; Summary; Chapter 4: Tables; Table Basics
- A Starting Point Naming Tables; Types Of Table; Columns and Table Data Types ; Primary Keys; Clustered and Nonclustered Keys ; Foreign Keys and Relationships; IDENTITY Columns ; Summary; Chapter 5: Putting Good Tables Together; Database Normalization; First Normal Form; Multiple-Column Repeating Groups; Second Normal Form; Third Normal Form; Further Analysis; Looking Things Over; A Second Enhancement; Summary; Chapter 6: Automating Deployment with SQLCMD; What Is SQLCMD?; Why We Need a SQLCMD Script; Rollback Scripts; Creating the SQLCMD Rollback Script
- Creating the SQLCMD Apply Script Summary; Chapter 7: NULLs and Table Constraints; NULL Constraints; Constraints; Default Constraints; Creating a Default Constraint; Table Constraints Part 1-Check Constraints; Creating a Table Constraint; Creating a Column Constraint; Table Constraints Part 2- Unique Constraints ; Some Constraints Are Really Indexes ; Summary; Chapter 8: DML (or Inserts, Updates, and Deletes); Reference Data vs. Real Data ; Inserting Data; More Inserts ; The UPDATE Statement ; Deleting Records; Summary; Chapter 9: Bulk Inserting Data
- The BULK INSERT Statement Preparing the Data File; Importing the Data File ; More Bulk Insert Escapades; Truncating Tables; Summary; Chapter 10: Creating Data Import Scripts; Purpose of the Import Script ; Starting the Script with Variables ; Reference Data Lookups; Inserting the Contact Record ; Adding Subrecords ; Displaying the Outcome ; The Rollback Script ; Summary; Chapter 11: The SELECT Statement; What Is the SELECT Statement For? ; The Simple SELECT Statement ; The WHERE Clause; The AND Operator ; The OR Operator ; The IN Operator ; Mixing Operators
- Ordering Data