Introducing SQL Server. (2015)

• Record Type: Book
• Further Information: Note: Mike McQuillan.
• Authors: McQuillan, Mike
• 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.
• Publisher Details: Berlin : Apress
• Publication Date: 2015
• Extent: 1 online resource (xxiii, 388 pages)
• Subjects: 005.75/85; Computer science; COMPUTERS -- Data Processing; Database management; Computers -- Database Management -- General; Databases; Electronic books
• Languages: English
• ISBNs: 9781484214190; 1484214196
• Related ISBNs: 9781484214206
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.