SQL Server School (17 Hours): Sql Server Connection, Sql Server Stored Procedure, Sql Server Profiler, Trusted Sql Server, Sql Query Analyzer, and More
"I tried to learn .NET by taking boot camp classes that cost me $6,000. After taking the classes, I discovered tons of free (and very cheap) videos on the internet created by experts in the field. I found the videos to be much better than the classrooms. The videos were presented by Microsoft presenters that knew the material backwards and forwards, and they were much cheaper and better than the classroom teachers. I have spent the last three years organizing and hunting down the videos for my own use and decided that all could benefit by sharing what I found." - Wade Harvey
Click Here for Free 24 hour pass to lynda.com.
I AM VERY EXCITED ABOUT THIS AMAZING NEW DISCOVERY
Over 40,000 Top-Notch Video Tutorials (or 3,452 hours) on Lynda.com
I had stumbled across Lynda.com many times before, but never stopped to try it out. I recently took the plunge and started using Lynda.com to help me improve my javascript skills (See Javascript Essential Training 2007 by Dori Smith). It has revolutionized my understanding of the language! I love the fact that the exercise files allow you to follow along in real time with what the instructor is saying. Learning by doing is an extremely powerful technique. I have to give the site an A+ for both quality and content.
I am planning on using Lynda Videos to help me improve in:
Looking for premium .NET Training Videos? The best premium .NET Videos that I have found are at Learn Visual Studio. Those videos are only about 50 cents per hour, as compared to $25 per hour that other sites charge!
LearnVisualStudio is currently having a 25% off sale ($50 savings) and giving away a free membership to TrainingSpot ($60 value) when LVS Lifetime Membership is purchased.
Limited Time Offer: Free Lifetime Membership to Progress Monitor ($24.95 value) when you purchase any membership at Learn Visual Studio, Lynda Videos or any hosting account at DiscountASP - just forward order confirmation to harvey007@sbcglobal.net
I had stumbled across Lynda.com many times before, but never stopped to try it out. I recently took the plunge and started using Lynda.com to help me improve my javascript skills (See Javascript Essential Training 2007 by Dori Smith). It has revolutionized my understanding of the language! I love the fact that the exercise files allow you to follow along in real time with what the instructor is saying. Learning by doing is an extremely powerful technique. I have to give the site an A+ for both quality and content.
I am planning on using Lynda Videos to help me improve in:
- HTML
- CSS
- Classic ASP
- .NET (included in ASP section)
- AJAX
- Silverlight (in Microsoft Section)
- SharePoint (in Microsoft Section)
- Web Design
- Blogging
- SEO
- and much more
Looking for premium .NET Training Videos? The best premium .NET Videos that I have found are at Learn Visual Studio. Those videos are only about 50 cents per hour, as compared to $25 per hour that other sites charge!
LearnVisualStudio is currently having a 25% off sale ($50 savings) and giving away a free membership to TrainingSpot ($60 value) when LVS Lifetime Membership is purchased.
Limited Time Offer: Free Lifetime Membership to Progress Monitor ($24.95 value) when you purchase any membership at Learn Visual Studio, Lynda Videos or any hosting account at DiscountASP - just forward order confirmation to harvey007@sbcglobal.net
These 17 hours of video tutorials from the SQL Server School cover the following topics: sql server connection, sql server stored procedure, sql server profiler, trusted sql server, sql query analyzer. Brian Knight and his cohorts give very a concise explanation of many fundamental Sql Server concepts. Very practical information. Each video is just a couple of minutes long.
photo credit: pvera
SQL Server School
| Num | Series | Title | Date | Presenter | Min |
|---|---|---|---|---|---|
| 1 | Administration(2) | Detaching Databases | 8/14/2008 | Brian Knight | 2 |
| 2 | Administration(2) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 3 | Adventure Works (1) | Installing Sample 2008 Databases | 2/3/2009 | Brian Knight | 4 |
| 4 | Aggregate Transform (1) | Using the Aggregate Transform | 12/4/2008 | Brian Knight | 3 |
| 5 | Aggregates(1) | Summarizing Data with Aggregate Queries | 8/28/2008 | Kathi Kellenberger | 12 |
| 6 | Analysis Services(6) | Viewing Analysis Services Data in Excel 2007 | 8/7/2008 | Brian Knight | 6 |
| 7 | Analysis Services(6) | Showing OLAP Data in SSRS | 10/14/2008 | Brian Knight | 6 |
| 8 | Analysis Services(6) | Writing a Basic MDX Query Pt.2 | 12/11/2008 | Brian Knight | 8 |
| 9 | Analysis Services(6) | Creating Mining Structure | 2/17/2009 | Brian Knight | 6 |
| 10 | Analysis Services(6) | Running A Basic DMX Query | 2/9/2009 | Brian Knight | 6 |
| 11 | Analysis Services(6) | Formatting SSAS Measures | 3/5/2009 | Brian Knight | 5 |
| 12 | Auditing(2) | Basic Auditing | 3/10/2009 | Andy Warren | 4 |
| 13 | Auditing(2) | Removing Audit History | 3/12/2009 | Andy Warren | 2 |
| 14 | Backup / Restore(3) | Detaching Databases | 8/14/2008 | Brian Knight | 2 |
| 15 | Backup / Restore(3) | Creating a Full Backup in SSMS | 9/18/2008 | Brian Knight | 3 |
| 16 | Backup / Restore(3) | Restoring a Full Database in SSMS | 10/28/2008 | Brian Knight | 3 |
| 17 | Backup and Recovery(2) | Creating Mirrored Backups | 12/2/2008 | Andy Warren | 2 |
| 18 | Backup and Recovery(2) | Creating Striped Backups | 3/19/2009 | Andy Warren | 2 |
| 19 | Checksum(1) | Using the CheckSum Function | 12/18/2008 | Brian Knight | 3 |
| 20 | Configuration(1) | SQL Server Options to Avoid | 1/6/2009 | Brian Knight | 6 |
| 21 | Data Corruption(1) | Surviving Database Corruption – From Detection to Resolution | 11/7/2008 | Paul Randal | 80 |
| 22 | Data Mining(9) | Creating Lift Charts | 8/21/2008 | Brian Knight | 7 |
| 23 | Data Mining(9) | Creating a Data Mining Reporting Services Report | 9/4/2008 | Brian Knight | 5 |
| 24 | Data Mining(9) | Mining Model Viewers | 2/5/2009 | Brian Knight | 8 |
| 25 | Data Mining(9) | Data Mining in Excel 2007 Pt.1 | 2/10/2009 | Brian Knight | 8 |
| 26 | Data Mining(9) | Data Mining in Excel 2007 Pt.2 | 2/12/2009 | Brian Knight | 7 |
| 27 | Data Mining(9) | Creating Mining Structure | 2/17/2009 | Brian Knight | 6 |
| 28 | Data Mining(9) | Installing & Congfiguring DM Add-in for Excel | 2/19/2009 | Brian Knight | 6 |
| 29 | Data Mining(9) | Running Singleton Queries Against a DMX Data Mining Model | 2/24/2009 | Brian Knight | 4 |
| 30 | Data Mining(9) | Running A Basic DMX Query | 2/26/2009 | Brian Knight | 6 |
| 31 | Data Profiling Task(1) | Viewing the Data Profiling Task Data | 1/27/2009 | Brian Knight | 3 |
| 32 | Data Types(1) | Using the Timestamp Data Type | 1/29/2009 | Brian Knight | 3 |
| 33 | Database Diagram(1) | Creating a Database Diagram in SSMS | 10/2/2008 | Brian Knight | 6 |
| 34 | Database Mail(1) | Setting Up Database Mail | 4/28/2009 | Andy Warren | 2 |
| 35 | DBCC(1) | Surviving Database Corruption – From Detection to Resolution | 11/7/2008 | Paul Randal | 80 |
| 36 | Excel(3) | Data Mining in Excel 2007 Pt.1 | 2/10/2009 | Brian Knight | 8 |
| 37 | Excel(3) | Data Mining in Excel 2007 Pt.2 | 2/12/2009 | Brian Knight | 7 |
| 38 | Excel(3) | Installing & Congfiguring DM Add-in for Excel | 2/19/2009 | Brian Knight | 6 |
| 39 | Indexing(1) | Disabling Indexes | 1/13/2009 | Andy Warren | 4 |
| 40 | Integration Services(14) | Adding a timestamp to files in SSIS | 9/16/2008 | Brian Knight | 6 |
| 41 | Integration Services(14) | Execute an SSIS Package in SSMS | 9/23/2008 | Brian Knight | 7 |
| 42 | Integration Services(14) | Making SSIS Connections Dynamic | 9/25/2008 | Brian Knight | 3 |
| 43 | Integration Services(14) | Scheduling SSIS Packages | 10/9/2008 | Brian Knight | 4 |
| 44 | Integration Services(14) | Row Count Transform | 10/16/2008 | Brian Knight | 4 |
| 45 | Integration Services(14) | Parameterizing an Execute SQL Task | 10/23/2008 | Brian Knight | 5 |
| 46 | Integration Services(14) | SSIS Configuration Files | 10/30/2008 | Brian Knight | 4 |
| 47 | Integration Services(14) | Using Break Points in SSIS | 11/4/2008 | Brian Knight | 4 |
| 48 | Integration Services(14) | Using the File System Task | 11/13/2008 | Brian Knight | 4 |
| 49 | Integration Services(14) | Using Script Component as a Transformation | 11/20/2008 | Brian Knight | 5 |
| 50 | Integration Services(14) | Using the Sort Transform | 11/25/2008 | Brian Knight | 3 |
| 51 | Integration Services(14) | Using SSIS Precedence Constraints | 11/27/2008 | Brian Knight | 6 |
| 52 | Integration Services(14) | Using the Aggregate Transform | 12/4/2008 | Brian Knight | 3 |
| 53 | Integration Services(14) | Viewing the Data Profiling Task Data | 1/27/2009 | Brian Knight | 3 |
| 54 | Intersect(1) | Using Intersect | 3/17/2009 | Andy Warren | 2 |
| 55 | Jobs(1) | Creating One-Time Jobs | 12/23/2008 | Andy Warren | 2 |
| 56 | Linked Server(1) | Creating a Linked Server | 4/7/2009 | Andy Warren | 5 |
| 57 | Main(1) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 58 | Maintenance Plans(1) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 59 | Management Studio(6) | Scripting Table Management | 8/26/2008 | Brian Knight | 5 |
| 60 | Management Studio(6) | Execute an SSIS Package in SSMS | 9/23/2008 | Brian Knight | 7 |
| 61 | Management Studio(6) | Creating a Database Diagram in SSMS | 10/2/2008 | Brian Knight | 6 |
| 62 | Management Studio(6) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 63 | Management Studio(6) | SQL Server Management Studio for Beginners | 1/1/2009 | Brian Knight | 6 |
| 64 | Management Studio(6) | Creating and Modifying Tables in SSMS | 3/3/2009 | Brian Knight | 6 |
| 65 | MDX(2) | Writing a Basic MDX Query Pt.1 | 12/9/2008 | Brian Knight | 5 |
| 66 | MDX(2) | Writing a Basic MDX Query Pt.2 | 12/11/2008 | Brian Knight | 8 |
| 67 | Measures(1) | Formatting SSAS Measures | 3/5/2009 | Brian Knight | 5 |
| 68 | Moving Databases(1) | Moving TempDB | 12/30/2008 | Brian Knight | 2 |
| 69 | OpenDataSource(1) | Using OpenDataSource | 4/9/2009 | Andy Warren | 4 |
| 70 | OpenRowSet | Using OpenRowSet | 3/31/2009 | Andy Warren | 2 |
| 71 | PBM(1) | Creating a Basic Policy in SSMS | 11/18/2009 | Brian Knight | 5 |
| 72 | Policy Based Management(1) | Creating a Basic Policy in SSMS | 11/18/2009 | Brian Knight | 5 |
| 73 | Presedence Constraints(1) | Using SSIS Precedence Constraints | 11/27/2008 | Brian Knight | 6 |
| 74 | Profiler(9) | Using Profiler | 9/2/2008 | Brian Knight | 9 |
| 75 | Profiler(9) | Mastering SQL Server Profiler | 4/30/2009 | Brad McGehee | 69 |
| 76 | Profiler(9) | Introduction | 4/30/2009 | Brad McGehee | 7 |
| 77 | Profiler(9) | Part 1: Introduction to Profiler Concepts | 5/5/2009 | Brad McGehee | 8 |
| 78 | Profiler(9) | Part 2: Profiler Architecture | 5/7/2009 | Brad McGehee | 5 |
| 79 | Profiler(9) | Part 3: Getting Started | 5/12/2009 | Brad McGehee | 11 |
| 80 | Profiler(9) | Part 4: Profiler Events | 5/14/2009 | Brad McGehee | 12 |
| 81 | Profiler(9) | Part 5: Data Columns | 5/19/2009 | Brad McGehee | 10 |
| 82 | Profiler(9) | Part 6: Creating Custom Traces | 5/21/2009 | Brad McGehee | 16 |
| 83 | Publication(1) | Creating a Publication | 4/23/2009 | Andy Warren | 3 |
| 84 | Publisher(1) | Setting Up a Publisher | 4/16/2009 | Andy Warren | 3 |
| 85 | RANDOM(1) | Generating Random Results | 1/15/2009 | Andy Warren | 1 |
| 86 | Replication(3) | Setting Up a Publisher | 4/16/2009 | Andy Warren | 3 |
| 87 | Replication(3) | Creating a Subscription | 4/21/2009 | Andy Warren | 3 |
| 88 | Replication(3) | Creating a Publication | 4/23/2009 | Andy Warren | 3 |
| 89 | Reporting Services(6) | Creating a Data Mining Reporting Services Report | 9/4/2008 | Brian Knight | 5 |
| 90 | Reporting Services(6) | Creating a Matrix Report | 9/9/2008 | Brian Knight | 4 |
| 91 | Reporting Services(6) | Creating a Tabular Report | 9/11/2008 | Brian Knight | 4 |
| 92 | Reporting Services(6) | Parameterizing SSRS Reports | 10/7/2008 | Brian Knight | 2 |
| 93 | Reporting Services(6) | Showing OLAP Data in SSRS | 10/14/2008 | Brian Knight | 6 |
| 94 | Reporting Services(6) | Multi Select Parameters in SSRS | 10/21/2008 | Brian Knight | 2 |
| 95 | Sample Databases(1) | Installing Sample 2008 Databases | 2/3/2009 | Brian Knight | 4 |
| 96 | Scheduling(1) | Creating One-Time Jobs | 12/23/2008 | Andy Warren | 2 |
| 97 | Script Component(1) | Using Script Component as a Transformation | 11/20/2009 | Brian Knight | 5 |
| 98 | Sort Transformation(1) | Using the Sort Transform | 11/25/2008 | Brian Knight | 3 |
| 99 | sp_MSForEachDB(1) | Using SP_MSForEachDB and SP_MSForEachTable | 3/26/2009 | Andy Warren | 2 |
| 100 | SQL Agent(1) | Creating One-Time Jobs | 12/23/2008 | Andy Warren | 2 |
| 101 | SQL Server 2008(4) | Installing SQL Server 2008 | 8/5/2008 | Brad McGehee | 7 |
| 102 | SQL Server 2008(4) | Creating a Basic Policy in SSMS | 11/18/2008 | Brian Knight | 5 |
| 103 | SQL Server 2008(4) | Post SQL Server 2008 Upgrade | 1/8/2009 | Brian Knight | 5 |
| 104 | SQL Server 2008(4) | Installing Sample 2008 Databases | 2/3/2009 | Brian Knight | 4 |
| 105 | SQL Skills(1) | Surviving Database Corruption – From Detection to Resolution | 11/7/2008 | Paul Randal | 80 |
| 106 | SASS(3) | Showing OLAP Data in SSRS | 10/14/2008 | Brian Knight | 6 |
| 107 | SASS(3) | Running A Basic DMX Query | 2/26/2009 | Brian Knight | 6 |
| 108 | SASS(3) | Formatting SSAS Measures | 3/5/2009 | Brian Knight | 5 |
| 109 | SSIS(13) | Execute an SSIS Package in SSMS | 9/23/2008 | Brian Knight | 7 |
| 110 | SSIS(13) | Making SSIS Connections Dynamic | 9/25/2008 | Brian Knight | 3 |
| 111 | SSIS(13) | Scheduling SSIS Packages | 10/9/2008 | Brian Knight | 4 |
| 112 | SSIS(13) | Row Count Transform | 10/16/2008 | Brian Knight | 4 |
| 113 | SSIS(13) | Parameterizing an Execute SQL Task | 10/23/2008 | Brian Knight | 5 |
| 114 | SSIS(13) | SSIS Configuration Files | 10/30/2008 | Brian Knight | 4 |
| 115 | SSIS(13) | Using Break Points in SSIS | 11/4/2008 | Brian Knight | 4 |
| 116 | SSIS(13) | Using the File System Task | 11/13/2008 | Brian Knight | 4 |
| 117 | SSIS(13) | Using Script Component as a Transformation | 11/20/2008 | Brian Knight | 5 |
| 118 | SSIS(13) | Using SSIS Precedence Constraints | 11/27/2008 | Brian Knight | 6 |
| 119 | SSIS(13) | Using the Aggregate Transform | 12/4/2008 | Brian Knight | 3 |
| 120 | SSIS(13) | Viewing the Data Profiling Task Data | 1/27/2009 | Brian Knight | 3 |
| 121 | SSIS(13) | Viewing the Data Profiling Task Data | 1/27/2009 | Brian Knight | 3 |
| 122 | SSMS(5) | Creating a Database Diagram in SSMS | 10/2/2008 | Brian Knight | 6 |
| 123 | SSMS(5) | Restoring a Full Database in SSMS | 10/28/2008 | Brian Knight | 3 |
| 124 | SSMS(5) | Creating a Maintenance Plan in SSMS | 11/11/2008 | Brian Knight | 6 |
| 125 | SSMS(5) | SQL Server Management Studio for Beginners | 1/1/2009 | Brian Knight | 7 |
| 126 | SSMS(5) | Creating and Modifying Tables in SSMS | 3/3/2009 | Brian Knight | 7 |
| 127 | SSRS(3) | Parameterizing SSRS Reports | 10/7/2008 | Brian Knight | 2 |
| 128 | SSRS(3) | Showing OLAP Data in SSRS | 10/14/2008 | Brian Knight | 6 |
| 129 | SSRS(3) | Multi Select Parameters in SSRS | 10/21/2008 | Brian Knight | 2 |
| 130 | Stored Procedures(1) | Creating Stored Procedures | 7/29/2008 | Brian Knight | 4 |
| 131 | Striped Backups(1) | Creating Striped Backups | 3/19/2009 | Brian Knight | 2 |
| 132 | Subscriptions(1) | Creating a Subscription | 4/21/2009 | Andy Warren | 3 |
| 133 | Synonyms(2) | Creating a Synonym for a Table | 1/20/2009 | Andy Warren | 2 |
| 134 | Synonyms(2) | Using Views and Synonyms for Abstraction | 1/22/2009 | Brian Knight | 3 |
| 135 | System Databases(1) | Moving TempDB | 12/30/2009 | Andy Warren | 2 |
| 136 | System Development Lifecycle(1) | Object Dependencies in SQL Server | 1/2/2008 | Randy Dyess | 11 |
| 137 | Tables(1) | Creating and Modifying Tables in SSMS | 3/3/2009 | Andy Warren | 6 |
| 138 | TempDB(1) | Moving TempDB | 12/30/2009 | Andy Warren | 2 |
| 139 | Timestamp(1) | Using the Timestamp Data Type | 1/29/2009 | Brian Knight | 3 |
| 140 | Triggers(1) | Bypassing a Trigger | 12/16/2008 | Andy Warren | 3 |
| 141 | T-SQL(8) | Summarizing Data with Aggregate Queries | 8/28/2008 | Kathi Kellenberger | 12 |
| 142 | T-SQL(8) | Modifying Data | 9/30/2008 | Kathi Kellenberger | 15 |
| 143 | T-SQL(8) | Bypassing a Trigger | 12/16/2008 | Andy Warren | 3 |
| 144 | T-SQL(8) | Using the CheckSum Function | 12/18/2008 | Brian Knight | 3 |
| 145 | T-SQL(8) | Generating Random Results | 1/15/2009 | Andy Warren | 1 |
| 146 | T-SQL(8) | Using Views and Synonyms for Abstraction | 1/22/2009 | Brian Knight | 3 |
| 147 | T-SQL(8) | Using Intersect | 3/17/2009 | Andy Warren | 2 |
| 148 | T-SQL(8) | Using the Union Statement | 3/24/2009 | Andy Warren | 2 |
| 149 | UNION(1) | Using the Union Statement | 3/24/2009 | Andy Warren | 2 |
| 150 | Upgrade(1) | Post SQL Server 2008 Upgrade | 1/8/2009 | Brian Knight | 5 |
| 151 | Views(2) | Creating Views | 7/31/2008 | Brian Knight | 4 |
| 152 | Views(2) | Using Views and Synonyms for Abstraction | 1/22/2009 | Brian Knight | 3 |
| Total | 1019 |
Related posts:
- SQL Server 2005:(10 Hours) Backup SQL Server 2005, SQL Server Insert, SQL Server Training, SQL Server Profiler, Download SQL Server 2005, SQL Server Script, SQL Server Tutorial 10 Free One-Hour Videos From Microsoft Expert, Bryan Von Axelson....
- 24 Hours of SQL Server 2008 – A Video Tutorial presented by Microsoft Experts 24 hours of free video tutorials on using SQL Server...
- SQL Server 2005 Express Tutorial: (13 Videos) Database mirroring, backup sql server 2005, sql server 2005 replication, sql server standard edition, download sql server 2005, compare sql server, sql server instance Excellent SQL Server 2005 Express series of 13 free videos...
- VB.NET: Sql Stored Procedure Source Code Example VB.NET Sql Stored Procedure Source Code Example...
- C#: Sql Stored Procedure Source Code Example C# Sql Stored Procedure source code example with SqlDataReader...
Related posts brought to you by Yet Another Related Posts Plugin.