- Course
- Data
SQL Server Fundamentals
Using T-SQL, the CLR, XML, managing SQL Server operations and security in SQL Server
What you'll learn
This course is primarily for C# developers who use SQL Server in their applications. T-SQL developers and Database Administrators will also find it useful.
Table of contents
- Overview | 54s
- What is SQL Server | 55s
- Application | 3m 22s
- Using SSMS | 2m 47s
- Drop a Database | 23s
- Add a Database | 4m 35s
- Using T-SQL | 5m 25s
- sqlcmd | 7m 20s
- sqlps | 4m 42s
- T-SQL Language | 3m 2s
- Metadata | 3m 52s
- T-SQL Example | 8m
- Scripting Objects | 1m 52s
- Linq To Sql | 3m 32s
- Linq to Sql Example | 5m 20s
- SMO | 3m 31s
- Analysis and Reporting | 5m 33s
- SSAS | 2m 1s
- SSIS | 1m 40s
- SSRS | 1m 34s
- Summary | 3m 9s
- References | 1m
About the author
Dan is an independent consultant, author, and speaker. He likes data; pointy data, rectangular data, even data just lying around on the floor. He is a co-author of the book "A Developers Guide to SQL Server 2005". His articles have been published in MSDN Magazine and SQL Server Magazine and he has spoken at WinDev, Microsoft events, as well as to various developer groups.