Database Articles

Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio

Database Articles are submitted by our contributors and cover database topics including ADO.NET, MySQL, and SQL Server.

Database Articles

• Building Reports in SQL Server 2005 - learn to use the SQL Server Report Wizard and to write reports from scratch.

• Data Mining with SQL Server 2005 - learn how to mine your data for information with SQL Server 2005.

• DataViews and Data Binding - learn to use the ADO.NET controls—DataView, DataViewManager.

• In-Process Data Access in SQL Server 2005 - learn that the .NET Framework 2.0 version of SqlClient contains code to encapsulate differences when you’re programming inside SQL Server and how to optimize the in-server programming environment.

• Introducing LINQ - learn to use the new, .NET, general purpose, query capability called LINQ—Language-Integrated Query.

• Notification Services - learn to use SQL Server 2005 Notification Services—a programming framework based on T-SQL and XML.

• Relational Databases 101 - learn the fundamentals of Relational Database Management Systems (RDBMS).

• Reporting Services Architecture - find out what's new in SQL Server Reporting Services (SSRS) 2005 and take a quick look at its architecure in SQL Server 2005.

• Working with Data - learn SQL, data binding, ADO.NET Datasets, and how to connect to SQL Server and Microsoft Access databases. Also, learn to build your own SQL Query program that works with Access databases.

• XML and ADO.NET - learn to leverage the XML features built into SQL Server and examine the new XML data type in SQL Server 2005.