SQL Server tutorials

SQL Server Tutorials Install SQL Server 7.0, Enterprise Edition on Microsoft Cluster Server This document provides step-by-step instructions for installing Microsoft SQL Server 7.0, Enterprise Edition on Microsoft Cluster Server. Installing Microsoft SQL Server 7.0 Microsoft SQL Server 7.0 is the latest version of the SQL Server relational database product. With SQL Server 7.0, the Setup program has been changed from earlier versions of SQL Server Setup. This document is intended to provide information on the installation of Microsoft SQL Server 7.0. Microsoft SQL Server 7.0 Performance Tuning Guide Provides database administrators and developers with valuable information on Microsoft® SQL Server™ 7.0 index selection, disk I/O subsystem tuning, and SQL Server 7.0 performance tuning tools. Migrating Your Access Database to Microsoft SQL Server 7.0 This article describes the process and discusses the tools you can use to migrate your Access database to SQL Server. Questions, Answers, and Tips About SQL Server Simultaneously manage SQL Server 6.5 and SQL Server 7.0, determine whether you can pipe output from Query Analyzer into a text file, and discover how to remove decimal points from entries in a character column. Running SQL 7.0 on Windows 95/98 Discusses compatability details when running SQL 7.0 on Windows 95 or Windows 98. Added: 08/09/2002, Hits: 278, Rating: 0, Votes: 0  Add To Favorites  |   Add Rating SQL 7.0 Accessing Remote Data This tutorial discusses how to enable access to remote data in Microsoft SQL Server 7.0. SQL 7.0 ANSI-92 Compatibility This tutorial discusses ANSI-92 compatibility in Microsoft SQL Server 7.0 SQL 7.0 Backup & Restore Types This tutorial discusses the various backup types in Microsoft SQL Server 7.0 SQL 7.0 Data Loading This tutorial discusses the Methods of Loading Data in Microsoft SQL Server 7.0. Examples are listed as the INSERT statement, the SELECT INTO statement,``the bcp utility, Data Transformation Services (DTS), and the BULK INSERT``statement. SQL 7.0 Database Files This tutorial discusses database files and the creation and altering of a database in Microsoft SQL Server 7.0 SQL 7.0 Full-Text Indexing One of the great new features of SQL 7 is that it now has the ability to do full-text indexing, thanks to integration with Microsoft Index Server technologies. SQL 7.0 Rebuild Utilities How to rebuild the registry and master database in SQL Server 7.0. Added: 08/09/2002, Hits: 252, Rating: 0, Votes: 0  Add To Favorites  |   Add Rating SQL 7.0 Replication This tutorial describes replication in Microsoft SQL Server 7.0. SQL 7.0 Requirements Lists the installation requirements for SQL Server 7.0. SQL Server 7.0 Roles In addition to user defined roles that you create to ease administration of permissions, there are also two categories of fixed, or pre-defined, roles. They are Database Roles and Server Roles. The table below summarizes these Fixed Roles. These are summarized in this tutorial. SQL Server 6.5 Tutorials (9) Backing up and Restoring your MySQL Database This article shows you how to backup and restore data in your MySQL database. This process can also be used if you have to move your data to a new server. Installing MySql on Vista A step by step tutorial that will make installing and configuring MySql on Windows Vista very easy. MySQL FAQs - Server Daemon mysqld Administration A collection of 12 FAQs on MySQL server mysqld administration. Clear answers are provided with tutorial exercises on starting and shuting down the server; turning on server log files; viewing binary log files; running server on different port numbers. MySQL FAQs - SQL SELECT Query Statements with GROUP BY A collection of 20 FAQs on MySQL SELECT query statements and basic features. Clear answers are provided with tutorial exercises on selecting rows and columns from tables and views; sorting and counting query outputs; grouping outputs and applying group functions. MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statements A collection of 17 FAQs on Oracle SQL DML statements. Clear answers are provided with tutorial exercises on inserting and updating data rows; inserting and updating with subqueries; deleting data rows. PHP Script Tips - Working with MySQL Database A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs. Retrieving Data in MySQL In this tutorial, you'll learn how to use the SELECT statement to retrieve one or more columns of data from a table. Sorting Retrieved Data The retrieved data is not displayed in a mere random order. If unsorted, data is typically displayed in the order in which it appears in the underlying tables. This could be the order in which the data was added to the tables initially. However, if data was subsequently updated or deleted, the order is affected by how MySQL reuses reclaimed storage space. The end result is that you cannot (and should not) rely on the sort order if you do not explicitly control it. SQL Tutorials by Herong This free book is an excellent tutorial book for beginners. It is a collection of notes and sample codes written by the author while he was learning SQL himself. Topics include CREATE, cursor, data type, DATE, DBD, DBI, DELETE, deadlock, export, FETCH, HAVING, import, INDEX, INSERT, isolation, GROUP BY, language, load data, lock, mSQL, MySQL, online, ORDER BY, Perl, query, RDBMS, SELECT, SQL, SQL-92, TIME, stored procedure, TIMESTAMP, transaction, UPDATE, WHERE, Windows, XML.