by | Released October 2014 | ISBN: 0133994627

OverviewLearn T-SQL from the world's #1 SQL Server developer and author, Alison Balter! Gain deep mastery in just six hours… just watch! DescriptionIn just six hours, you'll gain the in-depth practical understanding of T-SQL you need to create superior solutions with SQL Server. Your video instructor, Alison Balter, has spent nearly 25 years building Microsoft database solutions for top organizations… she's the world's #1 Microsoft database author. Now, Balter guides you step-by-step through every skill you'll need, from simple SELECT statements to powerful query and view techniques… flexible stored procedures, triggers, and UDFs… even query analysis and optimization. Whether you're a DBA, database or web developer, or power user, these LiveLessons deliver practical knowledge for writing high-quality T-SQL code—fast! About the InstructorAlison Balterhas 24 years of real-life experience developing Access and SQL Server applications with T-SQL and related technologies. Her clients include USC, MIT, Southern California Edison, Cisco Systems, the Drug Enforcement Administration, and many other corporate and government entities. She has written 15 books and authored more than 300 computer training videos on Access and SQL Server development: work that has earned exceptionally high ratings at Amazon.com and elsewhere.Skill LevelIntermediateAdvanced What You Will LearnDatabase fundamentals every T-SQL developer needs to knowHow to make the most of common T-SQL statements, keywords, clauses, and functionsHow to write powerful queries using joins, subqueries, and other techniquesHow to take full advantage of Views to display, modify, index, and secure dataHow to design and improve SQL Server stored proceduresHow to create and work with triggers and User-Defined Functions (UDFs)How to analyze query performance Who Should Take This CourseSQL Server database administrators (DBAs) who need to efficiently create tables, views, stored procedures, functions, and triggersDatabase developers who cannot rely on DBAs and must perform all T-SQL-related tasks on their own.NET, web, and client/server developers whose responsibilities include data/database accessMicrosoft Access power users seeking to deepen their skills in creating new solutionsMicrosoft Access developers moving to SQL Server Course RequirementsExperience with either the SQL Server or Access databases as a DBA, developer, or intermediate-to-advanced user Table of ContentsLesson 1. Introduction to Databases1.1. What is a Database?1.2. What Field Types are Available?1.3. What is a Relationship?1.4. Creating a Database1.5. Creating a TableLesson 2. T-SQL Basics2.1. Introduction to T-SQL2.2. The SELECT Statement2.3. The FROM Keyword2.4. The WHERE Clause2.5. IN and BETWEEN2.6. The ORDER BY ClauseLesson 3. T-SQL - Beyond the Basics3.1. The DISTINCT Keyword3.2. The GROUP BY Clause3.3. Aggregate Functions3.4. The HAVING Clause3.5. Combining Conditions3.6. Top Values Queries3.7. Working with Aliases3.8. Working with Null3.9. The COMPUTE ClauseLesson 4. Join Types4.1. Inner Joins4.2. Outer Joins4.3. Full Joins4.4. Self-JoinsLesson 5. Specialized T-SQL Queries5.1. Union Queries5.2. SubqueriesLesson 6. Modifying Data with Action Queries6.1. The UPDATE Statement6.2. The INSERT Statement6.3. The SELECT INTO Statement6.4. The DELETE Statement6.5. The TRUNCATE StatementLesson 7. T-SQL Functions7.1. Numeric Functions7.2. String Functions7.3. Date/Time Functions7.4. Working with NullsLesson 8. Working With SQL Server Views8.1. Using T-SQL to Create or Modify a View8.2. Creating Views Based on Data in Multiple Tables8.3. Views and Subqueries8.4. Views and Outer Joins8.5. Sorting View Results8.6. Views and Top Values8.7. Views and Functions8.8. Using Views to Secure Data8.9. Modifying Data in a View8.10. Indexed Views8.11. Optimizing the Views that You BuildLesson 9. Designing SQL Server Stored Procedures9.1. Stored Procedure Basics9.2. Declaring and Working with Variables9.3. Controlling the Flow9.4. The SET NOCOUNT Statement9.5. Using the @@Functions9.6. Working with ParametersLesson 10. Enhancing the Stored Procedures that You Build10.1. Working with Cursors10.2. Errors and Error Handling10.3. Modifying Data with Stored Procedures10.4. Stored Procedures and Transactions10.5. Stored Procedures and Temporary Tables10.6. Stored Procedures and Cursors10.7. Stored Procedures and Security10.8. Debugging the Stored Procedures that You BuildLesson 11. Building and Working with User-Defined Functions11.1. User-defined Functions Explained11.2. Scalar Functions11.3. Inline Table-Valued Functions11.4. Multi-Statement Table-Valued Functions11.5. Functions, Views, and Stored ProceduresLesson 12. Creating and Working with Triggers12.1. Triggers Explained12.2. Creating Triggers12.3. INSTEAD OF TriggersLesson 13. Analyzing Performance13.1. Determining the Query Execution Plan13.2. Viewing Query Statistics13.3. Using the SQL ProfilerAbout LiveLessons Video TrainingLiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons Show and hide more

1. Introduction
   • T-SQL Fundamentals LiveLessons: Introduction 00:03:23
2. Lesson 1: Introduction to Databases
   • Learning Objectives 00:00:28
   • 1.1 What is a Database? 00:04:44
   • 1.2 Creating a Database 00:03:37
   • 1.3 Creating a Table 00:07:22
   • 1.4 Creating Check Constraints 00:05:52
   • 1.5 Establishing Relationships between Tables 00:05:46
3. Lesson 2: T-SQL Basics
   • Learning Objectives 00:00:28
   • 2.1 The SELECT Statement 00:03:40
   • 2.2 The FROM Keyword 00:01:36
   • 2.3 The WHERE Clause 00:03:40
   • 2.4 IN and BETWEEN 00:03:57
   • 2.5 The ORDER BY Clause 00:02:21
4. Lesson 3: TSQL - Beyond the Basics
   • Learning Objectives 00:00:33
   • 3.1 The DISTINCT Keyword 00:02:01
   • 3.2 The GROUP BY Clause 00:01:31
   • 3.3 Aggregate Functions 00:04:26
   • 3.4 The HAVING Clause 00:01:26
   • 3.5 Combining Conditions 00:06:39
   • 3.6 Top Values Queries 00:04:03
   • 3.7 Working with Aliases 00:02:04
   • 3.8 Working with Null 00:02:23
5. Lesson 4: Join Types
   • Learning Objectives 00:00:22
   • 4.1 Inner Joins 00:01:55
   • 4.2 Outer Joins 00:02:04
   • 4.3 Full Joins 00:01:37
   • 4.4 Self Joins 00:05:15
6. Lesson 5: Specialized T-SQL Queries
   • Learning Objectives 00:00:37
   • 5.1 Union Queries 00:05:59
   • 5.2 Subqueries 00:02:00
7. Lesson 6: Modifying Data with Action Queries
   • Learning Objectives 00:00:25
   • 6.1 The UPDATE Statement 00:03:35
   • 6.2 The INSTER Statement 00:02:50
   • 6.3 The SELECT INTO Statement 00:01:23
   • 6.4 The DELETE Statement 00:01:30
   • 6.5 The TRUNCATE Statement 00:00:56
8. Lesson 7: T-SQL Functions
   • Learning Objectives 00:00:36
   • 7.1 Numeric Functions 00:03:02
   • 7.2 String Functions 00:04:26
   • 7.3 Date/Time Functions 00:05:52
   • 7.4 Working with Nulls 00:04:21
9. Lesson 8: Working with SQL Server Views
   • Learning Objectives 00:00:29
   • 8.1 Creating a Simple View 00:05:31
   • 8.2 Creating Views Based on Data in Multiple Tables 00:04:06
   • 8.3 Views and Subqueries 00:02:22
   • 8.4 Views and Outer Joins 00:03:00
   • 8.5 Sorting View Results 00:03:15
   • 8.6 Views and Top Values 00:03:37
   • 8.7 Views and Functions 00:02:53
   • 8.8 Using Views to Secure Data 00:00:58
   • 8.9 Modifying Data in a View 00:02:48
10. Lesson 9: Designing SQL Server Stored Procedures
    • Learning Objectives 00:00:37
    • 9.1 Stored Procedures Basics 00:04:19
    • 9.2 Declaring and Working with Variables 00:04:03
    • 9.3 Controlling the Flow 00:10:44
    • 9.4 The SET NOCOUNT Statement 00:00:46
    • 9.5 Using the @@ Functions 00:05:26
    • 9.6 Working with Paramaters 00:06:15
11. Lesson 10: Enhancing the Stored Procedures that You Build
    • Learning Objectives 00:00:36
    • 10.1 Working with Cursors 00:04:18
    • 10.2 Errors and Error Handling 00:08:43
    • 10.3 Modifying Data with Stored Procedures 00:03:39
    • 10.4 Stored Procedures and Transactions 00:03:19
    • 10.5 Stored Procedures and Temporary Tables 00:02:55
    • 10.6 Stored Procedures and Cursors 00:01:06
    • 10.7 Stored Procedures and Security 00:06:29
12. Lesson 11: Building and Working with User-Defined Functions
    • Learning Objectives 00:00:29
    • 11.1 User-defined Functions Explained 00:06:47
    • 11.2 Scalar Functions 00:03:13
    • 11.3 Inline Table-Valued Functions 00:02:14
    • 11.4 Multi-Statement Table-Valued Functions 00:01:58
13. Lesson 12: Creating and Working with Triggers
    • Learning Objectives 00:00:26
    • 12.1 Triggers Explained 00:00:34
    • 12.2 Creating Triggers 00:06:09
14. Lesson 13: Analyzing Performance
    • Learning Objectives 00:00:29
    • 13.1 Determining the Query Execution Plan 00:02:48
    • 13.2 Viewing the Query Statistics 00:01:02
    • 13.3 Using the SQL Profiler 00:04:23
15. Summary
    • T-SQL Fundamentals LiveLessons: Summary 00:01:04
Show and hide more



9780133994629.t.sql.fundamentals.livelessons.OR.part1.rar

9780133994629.t.sql.fundamentals.livelessons.OR.part2.rar