- Course
SQL Server Fundamentals
Using T-SQL, the CLR, XML, managing SQL Server operations and security in SQL Server
Beginner
- Course
SQL Server Fundamentals
Using T-SQL, the CLR, XML, managing SQL Server operations and security in SQL Server
Beginner
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
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.
SQL Server Fundamentals
Beginner
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
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.