<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet href="/pages/css/rss.css" type="text/css"?>
<rss xmlns:ps="http://trailfire.com" version="2.0"><channel><title>"Learn SQL Server" by frank</title><link>http://trailfire.com/frank/trails/16193</link><category>frank/trails</category><ttl>60</ttl><item><title>Downloading and Installing SQL Server 2005 Express Edition</title><link>http://trailfire.com/frank/marks/111755</link><description><![CDATA[The first thing you need to do is to download and install the SQL Server 2005 Express Edition. It&#39;s free. This page guides you to do this quickly.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:16:36 -0700</pubDate><guid isPermalink="false">trailfire:markId:111755</guid></item><item><title>Getting Started with Transact-SQL Statements</title><link>http://trailfire.com/frank/marks/111759</link><description><![CDATA[This page offers some simple tutorials to get you started quickly with the tools and SQL statements.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:16:28 -0700</pubDate><guid isPermalink="false">trailfire:markId:111759</guid></item><item><title>Creating and Managing Databases and Physical Files</title><link>http://trailfire.com/frank/marks/111761</link><description><![CDATA[Database is a container to host tables and other data objects. This page provides you 16 simple tutorials to help you understand and manage databases.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:16:18 -0700</pubDate><guid isPermalink="false">trailfire:markId:111761</guid></item><item><title>Creating/Managing Tables and Adding/Altering/Deleting Columns</title><link>http://trailfire.com/frank/marks/111764</link><description><![CDATA[Tables are data objects used to store data in rows and columns. This page offers 16 tutorials on how to create tables, define columns, modify columns...]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:16:07 -0700</pubDate><guid isPermalink="false">trailfire:markId:111764</guid></item><item><title>Understanding INSERT, UPDATE and DELETE Statements</title><link>http://trailfire.com/frank/marks/111774</link><description><![CDATA[Now you are ready to insert data to tables, delete data from tables, or update data. This page shows you how to do these task with SQL statements.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:15:53 -0700</pubDate><guid isPermalink="false">trailfire:markId:111774</guid></item><item><title>Understanding SELECT Statements with Joins and Subqueries</title><link>http://trailfire.com/frank/marks/111777</link><description><![CDATA[The real power of database is not storing data. It is retrieving information out of database selectively to perform different analysis. This page helps you to understand the basics of the SELECT statement.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:15:38 -0700</pubDate><guid isPermalink="false">trailfire:markId:111777</guid></item><item><title>Understanding SELECT Statements and GROUP BY Clauses</title><link>http://trailfire.com/frank/marks/111779</link><description><![CDATA[This page offers 20 tutorials to show you some advanced topics about SELECT statements, like aggregation functions.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:15:15 -0700</pubDate><guid isPermalink="false">trailfire:markId:111779</guid></item><item><title>Introduction To Transact-SQL Language Basics and Data Types</title><link>http://trailfire.com/frank/marks/111780</link><description><![CDATA[This page starts part II of this trail - Microsoft Transact-SQL language to operate SQL Server more efficiently.<BR><BR>This page offers 19 tutorials on basics of Transact-SQL to get you started.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:19:37 -0700</pubDate><guid isPermalink="false">trailfire:markId:111780</guid></item><item><title>Transact-SQL Constants/Literals and Value Ranges</title><link>http://trailfire.com/frank/marks/111781</link><description><![CDATA[Like any other computer languages, Transact-SQL organize data into different types. Data values must be entered in specific formats depending their types. Follow this page to learn more.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:22:35 -0700</pubDate><guid isPermalink="false">trailfire:markId:111781</guid></item><item><title>Transact-SQL Numeric Expressions and Functions</title><link>http://trailfire.com/frank/marks/111783</link><description><![CDATA[This page offers 14 tutorials on how to handle numeric values with arithmetical operations and built-in functions.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:24:53 -0700</pubDate><guid isPermalink="false">trailfire:markId:111783</guid></item><item><title>Transact-SQL Managing Character Strings and Binary Strings</title><link>http://trailfire.com/frank/marks/111787</link><description><![CDATA[This page offers 14 tutorials on how to handle character strings with different character sets and built-in functions]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:26:23 -0700</pubDate><guid isPermalink="false">trailfire:markId:111787</guid></item><item><title>Transact-SQL Date and Time Operations and Functions</title><link>http://trailfire.com/frank/marks/111789</link><description><![CDATA[This page offers 18 tutorials on how to handle date and time values with built-in functions. For example, how to display time difference in days, hours and minutes.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:28:53 -0700</pubDate><guid isPermalink="false">trailfire:markId:111789</guid></item><item><title>Transact-SQL Boolean Values and Logical Operations</title><link>http://trailfire.com/frank/marks/111790</link><description><![CDATA[This page offers 14 tutorials on how to handle Boolean values and logical operations.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:32:32 -0700</pubDate><guid isPermalink="false">trailfire:markId:111790</guid></item><item><title>Transact-SQL Conditional Statements and Loops</title><link>http://trailfire.com/frank/marks/111792</link><description><![CDATA[Conditional statements help you to create complex execution paths like selections and loops. Follow this page to learn more.]]></description><category>Learn SQL Server</category><author>frank</author><pubDate>Sat, 16 Jun 2007 18:35:15 -0700</pubDate><guid isPermalink="false">trailfire:markId:111792</guid></item></channel></rss>
