Links: Database related

Root Reference Development Database related

Sub Categories:

Database design

MySQL

SQL Server

Links:

1st key data's SQL section

Whether you are a beginner seeking SQL help, or a data warehousing veteran looking for a SQL refresher, you have come to the right place. This SQL tutorial site lists commonly-used SQL commands, and is divided into the following sections: * SQL Commands: How SQL statements are used to store, retrieve, and manipulate data in the relational database. * Table Manipulation: How SQL statements are used to manage tables inside the database. * SQL Syntax: A single page that lists the syntax for all the SQL commands in this tutorial. For each command, the SQL syntax will first be presented and explained, followed by an example. By the end of this brief tutorial, you should have a good general understanding of the SQL syntax. In addition, you should be able to write SQL statements using the correct syntax to perform basic queries. My experience is that understanding the basics of SQL is much easier than mastering all the intricacies of this computer language, and I hope you will reach the same conclusion as well.  

Clicked: 413 Added: 2003-11-23 22:47:42 - Bad URL? Report it

1st SQL Street

Coding Standards (1,100 lines) Data Conversion (2,498 lines) Data Warehouses (502 lines) Date/ Time (2,047 lines) Debugging and Error Handling (82 lines) Design/ Modeling (432 lines) Maintainence/ Optimization (8,148 lines) Miscellaneous (8,389 lines) Monitoring (1,954 lines) Numeric Manipulation (719 lines) Querying (5,113 lines) Replication (319 lines) Security (3,178 lines) Space Management (3,155 lines) SQLDMO/ SQLOLE (1,265 lines) Stats (582 lines) Stored Procedures (8,152 lines) String Manipulation (4,761 lines) Transactions (646 lines) Triggers (362 lines) Tuning Performance (1,704 lines) XML (271 lines)  

Clicked: 263 Added: 2002-12-28 15:41:11 - Bad URL? Report it

Advanced Online SQL Training

Welcome to SQLCourse2.com! This unique SQL Tutorial is the "sequel" to the highly successful SQLCourse.com site and will provide you with more advanced easy-to-follow SQL Instruction and the ability to practice what you learn on-line with immediate feedback! You will receive immediate results on a web page after submitting your SQL Commands. This continuation course will provide you with critical need-to-know advanced features and clauses of the SELECT statement that weren't supported in the previous SQLCourse.com site. Everything you learn here will be ANSI SQL compliant and should work with most SQL databases such as Oracle, SQL Server, mySQL, MS Access, Informix, Sybase, or any other ANSI SQL compliant database. If you're already familar with the basics of SQL, you can still use this as a refresher, and practice some SQL statements. 

Clicked: 334 Added: 2002-11-30 15:19:56 - Bad URL? Report it

Data Security: Stop SQL Injection Attacks Before They Stop You

This article discusses: * How SQL injection attacks work * Testing for vulnerabilities * Validating user input * Using .NET features to prevent attacks * Importance of handling exceptions. Good SQL Gone Bad Equal Opportunity Hacks All Input is Evil Avoid Dynamic SQL Execute with Least Privilege Store Secrets Securely Failing Gracefully Conclusion 

Clicked: 28 Added: 2006-01-04 22:41:10 - Bad URL? Report it

DB Forums

Clicked: 247 Added: 2003-01-06 21:03:29 - Bad URL? Report it

Face-off: Oracle vs. SQL Server

Can a SQL Server fan be converted to the Oracle DBMS? Not easily. The loyalty that database administrators feel for their chosen vendor borders on the fanatical. It's a love-hate relationship, where only those using Oracle, for example, are allowed to complain about Oracle. If you choose to use the less costly, simpler SQL Server, then you had better not hurl insults at Oracle, or its DBAs will be, to put it mildly, "vocal" in its defense. Then again, SQL Server users are just as devoted and are looking forward to Yukon trouncing the competition. Two SearchDatabase.com site editors debate the merits of both systems here. 

Clicked: 22 Added: 2005-03-14 17:36:23 - Bad URL? Report it

Interactive Online SQL Training for beginners

This unique introductory SQL tutorial not only provides easy-to-understand SQL instructions, but it allows you to practice what you learn using the on-line SQL interpreter. You will receive immediate results after submitting your SQL commands. You will be able to create your own unique tables as well as perform selects, inserts, updates, deletes, and drops on your tables. This SQL tutorial currently supports a subset of ANSI SQL. The basics of each SQL command will be covered in this introductory tutorial. Unless otherwise stated, the interpreter will support everything covered in this course. If you're already familar with the basics of SQL, you can still use this as a refresher, and practice some SQL statements. 

Clicked: 293 Added: 2002-11-30 15:18:46 - Bad URL? Report it

1| 2| 3| Next >>
Total number of links: 602 in 81 (sub)categories - Suggest a link