T-SQL in one hour a day

Description

1 Database Basics 5 -- What Is a Database? 5 -- What Is a Table? 5 -- What Is a Database Diagram? 6 -- What Is a View? 7 -- What Is a Stored Procedure? 8 -- What is a User-Defined Function? 9 -- What Is a Trigger? 10 -- 2 SQL Server Basics 13 -- Versions of SQL Server 2014 Available 13 -- SQL Server Components 16 -- Introduction to Microsoft SQL Server Management Studio 19 -- Connecting to a Database Server 25 -- Installing the Sample Files 27 -- 3 Creating a SQL Server Database 33 -- Creating the Database 33 -- Defining Database Options 36 -- Transaction Log 39 -- Attaching to an Existing Database 40 -- 4 Working with SQL Server Tables 45 -- Creating SQL Server Tables 45 -- Adding Fields to the Tables You Create 46 -- Working with Constraints 50 -- Creating an Identity Specification 56 -- Adding Computed Columns 57 -- Working with User-Defined Data Types 58 -- Adding and Modifying Indexes 60 -- Saving Your Table 64 -- 5 Working with Table Relationships 67 -- An Introduction to Relationships 67 -- Creating and Working with Database Diagrams 70 -- Working with Table Relationships 77 -- Designating Table and Column Specifications 79 -- Adding a Relationship Name and Description 81 -- Determining When Foreign Key Relationships Constrain the Data Entered in a Column 81 -- Designating Insert and Update Specifications 84 -- 6 Getting to Know the SELECT Statement 89 -- Introducing T-SQL 89 -- Working with the SELECT Statement 90 -- Adding on the FROM Clause 92 -- Including the WHERE Clause 93 -- Using the ORDER BY Clause 101 -- 7 Taking the SELECT Statement to the Next Level 105 -- Adding the DISTINCT Keyword 105 -- Working with the FOR XML Clause 107 -- Working with the GROUP BY Clause 109 -- Including Aggregate Functions in Your SQL Statements 110 -- Taking Advantage of the HAVING Clause 117 -- Creating Top Values Queries 118 -- 8 Building SQL Statements Based on Multiple Tables 121 -- Working with Join Types 121 -- 9 Powerful Join Techniques 129 -- Utilizing Full Joins 129 -- Taking Advantage of Self-Joins 130 -- Exploring the Power of Union Queries 133 -- Working with Subqueries 136 -- Using the INTERSECT Operator 137 -- Working with the EXCEPT Operator 138 -- 10 Modifying Data with Action Queries 141 -- UPDATE Statement 141 -- INSERT Statement 143 -- SELECT INTO Statement 145 -- DELETE Statement 146 -- TRUNCATE Statement 147 -- 11 Getting to Know the T-SQL Functions 149 -- Working with Numeric Functions 149 -- Taking Advantage of String Functions 151 -- Exploring the Date/Time Functions 163 -- Working with Nulls 170 -- 12 Working with SQL Server Views 177 -- An Introduction to Views 177 -- Using T-SQL to Create or Modify a View 185 -- 13 Using T-SQL to Design SQL Server Stored -- Procedures 191 -- Basics of Working with Stored Procedures 192 -- Declaring and Working with Variables 198 -- Controlling the Flow 200 -- 14 Stored Procedure Techniques Every Developer Should Know 215 -- SET NOCOUNT Statement 215 -- Using the @@ Functions 216 -- Working with Parameters 221 -- Errors and Error Handling 227 -- 15 Power Stored Procedure Techniques 233 -- Modifying Data with Stored Procedures 233 -- Stored Procedures and Transactions 237 -- 16 Stored Procedure Special Topics 243 -- Stored Procedures and Temporary Tables 243 -- Stored Procedures and Cursors 245 -- Stored Procedures and Security 250 -- 17 Building and Working with User-Defined Functions 253 -- Scalar Functions 253 -- 18 Creating and Working with Triggers 263 -- Creating Triggers 263 -- Creating an Insert Trigger 266 -- Creating an Update Trigger 269 -- Creating a Delete Trigger 272 -- Downsides of Triggers 274 -- 19 Authentication 277 -- Basics of Security 277 -- Types of Authentication 278 -- Creating Logins 280 -- Creating Roles 285 -- 20 SQL Server Permissions Validation 299 -- Types of Permissions 299 -- Getting to Know Table Permissions 309 -- Getting to Know View Permissions 312 -- Getting to Know Stored Procedure Permissions 314 -- Getting to Know Function Permissions 315 -- Implementing Column-Level Security 315 -- 21 Configuring, Maintaining, and Tuning SQL Server 321 -- Selecting and Tuning Hardware 321 -- Configuring and Tuning SQL Server 324 -- 22 Maintaining the Databases You Build 335 -- Backing Up Your Databases 335 -- Restoring a Database 338 -- Database Engine Tuning Advisor 341 -- Creating and Working with Database Maintenance Plans 344 -- 23 Performance Monitoring 355 -- Executing Queries in SQL Server Management Studio 355 -- Displaying and Analyzing the Estimated Execution Plan 358 -- Adding Indexes to Allow Queries to Execute More Efficiently 362 -- Setting Query Options 364 -- SQL Server Profiler 367 -- 24 Installing and Upgrading SQL Server 377 -- Installing SQL Server 2014 Enterprise Edition 377 -- Installing SQL Server Management Studio 385.