Abstract: Query Analyzer or Management Studio? DB Artisan or Notepad? Profiler or SQL Trace? Whatever your choice of editor, there are bound to be videos on customizing it, tweaking it, and general tips and tricks. Also covered are handy tips on other tools and SQL concepts like Aliases.
Number of Videos: 12
Total Run Time: 2 hours and 0 minutes
|
Abstract: SQL Server's Transact SQL language is a complex and robust implementation of the ANSI/ISO SQL standard. If you're a newbie to SQL, start here. Even you "old salts" may find a few tips and tricks in here.
Number of Videos: 16
Total Run Time: 3 hours and 29 minutes
|
Abstract: The more you understand the fundamentals of SQL, the better programmer you will be. This chapter of videos focuses on learning the ins-and-outs of table design including in-depth discussions of datatypes, constraints and even talks about identity column usage and normalization/denormalization.
Number of Videos: 21
Total Run Time: 3 hours and 58 minutes
|
Abstract: An expanded chapter of videos featuring the tips and tricks for each of the DML statements.
Number of Videos: 27
Total Run Time: 4 hours and 36 minutes
|
Abstract: People pay you a lot of money if you can write analytical queries - let's just be frank. The more you can "do" with data, the more valuable you are to an organization. This chapter of videos focuses on helping you get the full spectrum of analytical queries and aggregates including a main focus: Understanding the core concepts behind the aggregations so that you can go on to bigger and better things!
Number of Videos: 3
Total Run Time: 28 minutes
|
Abstract: If you had to guess, what percentage of the queries you write/maintain are JOINs? If you are working in a Transactional system, the answer is probably 50%, 60%, 70%, or higher. Those of you working with Data Warehouses might have a smaller number such as 10-40%. The point is that you need to know the inner working of JOINs and UNIONs to be successful!
Number of Videos: 5
Total Run Time: 1 hour and 12 minutes
|
Abstract: This chapter is sort of a "catch-all" for commonly used features in SQL such as the IF statement, CASE, EXISTS, and working with global variables among other things. Put it this way: if you're a SQL programmer, you work with these every day so you might as well learn about them here!
Number of Videos: 17
Total Run Time: 3 hours and 29 minutes
|
Abstract: If performance matters to you, then you need to know what's happening "under the hood" of SQL Server. You need to need whether or not your statistics are up to date, whether your queries are using your indexes and what tweaks, if any, you can use to work with large tables. Check out these tutorials for your speed fix.
Number of Videos: 8
Total Run Time: 1 hour and 48 minutes
|
Abstract: Advanced SQL topics such as subqueries and derived tables deserve their own chapter and this is it. The videos in this chapter are not for the "faint of heart" - you should have a solid foundation in JOINs, UNIONs, Plan guides, Execution Plans and a solid understanding of SQL before tackling this section.
Number of Videos: 6
Total Run Time: 1 hour and 22 minutes
|
Abstract: Every application of any decent size today makes use of server-side storage although how they do it will vary widely with each. Temporary tables are "old school" but, due to scoping, often the easiest way to solve your temporary storage needs. Table variables are the "new thing" but they can't do it all. What about cursors? They are the "lost child" of the modern SQL world but, yes, they are still viable programming constructs. The videos in this chapter are meant to help you understand the when and where to use these objects but also try to help you think of alternatives.
Number of Videos: 2
Total Run Time: 32 minutes
|
Abstract: Modern-day programming demands security and secure coding. If you are embedding your SQL inside the application (i.e., writing a SELECT/INSERT in the form itself) then the argument is often made that you are not writing secure or reusable code - both terrible things in today's environment. Check out these videos for more information on SQL Server stored procedure programming.
Number of Videos: 12
Total Run Time: 2 hours and 33 minutes
|
Abstract: Views are omnipresent in SQL Server systems today and with good reason: we can control security through them, optimize our queries, and generally provide a "layer of abstraction" using them. Learn all about views including indexed views in this chapter.
Number of Videos: 5
Total Run Time: 48 minutes
|
Abstract: UDFs were a programmer's favorite when they were introduced in SQL Server 2000 and continue to be so in today's SQL Server. Scalar, Table-Value, Inline, Multi-Statement - pick your flavor. These are all wonderful ways to solve common SQL needs. The videos in this chapter try to help you make sense of the options and help with Best Practices and performance tuning.
Number of Videos: 9
Total Run Time: 1 hour and 51 minutes
|
Abstract: Did you know that you can write a Transact-SQL SELECT statement against an Oracle instance or even an Excel spreadsheet? You certainly can and many more data sources are also available. This chapter focuses on external data queries and features some pretty interesting ideas.
Number of Videos: 2
Total Run Time: 24 minutes
|
Abstract: XML support in SQL Server began in SQL Server 7.0 and has continued to grow in both expansiveness and popularity. This chapter focuses on using XML in SQL Server - when is it appropriate, how to use it, et al - and offers several practical examples of using XML.
Number of Videos: 8
Total Run Time: 1 hour and 57 minutes
|
Abstract: Simplify your life by working from patterns in SQL. Although most people think of object-oriented languages when they hear of design patterns, SQL has its own design patterns although many are not classicly categorized as such.
Number of Videos: 10
Total Run Time: 1 hour and 53 minutes
|
Abstract: The title says it all...
Number of Videos: 26
Total Run Time: 4 hours and 33 minutes
|