PDA

View Full Version : A Few Resources



blazonQC
09-13-2007, 06:14 PM
I just wanted to post a few good resources that have helped me out a lot:

http://www.sqlcourse.com - A great place to learn about SQL queries (TSQL) . Each lesson will teach you a little bit about setting up queries and allows you to submit a query of your own with an actual SQL db.

http://www.sqlcourse2.com - Once you have completed the first course you can continue to part 2 with more advanced SQL topics.


http://msdn2.microsoft.com/en-us/library/ms678086.aspx - MSDN ADO API Reference - The common link between VBA and SQL is ADO, and where better to learn, than from the people that developed it. This is the most complete reference on ADO around with working examples and in-depth explanations of all the Members and Objects of the library.


I hope these resources can help someone else. I am really excited about this new addition to the forums and hope to learn a lot!

Thanks,
Chad

Bob Phillips
09-14-2007, 03:46 AM
Very useful. The first two are definitely a saver for passing on.

stanl
09-19-2007, 10:54 AM
This is a sample chapter dealing with Access/Jet4 SQL - I especially like their coverage of SELECT....INTO Stan

http://www.developershandbook.com/Downloads/2370ch05.pdf

stanl
09-22-2007, 05:33 AM
and another free chapter of ADO/OLEDB

http://www.informit.com/content/images/0789729520/samplechapter/CH30_0789729520.pdf

malik641
10-14-2007, 08:13 AM
For learning SQL Server, here are some videos:

http://msdn2.microsoft.com/en-us/express/aa718391.aspx#5

Excellent for the visual people.


The videos are mapped out as follows:

Introduction

Learning Video 1: What is a database?Designing Tables

Learning Video 2: Understanding Database Tables and Records
Learning Video 3: More about Column Data Types and Other Properties
Learning Video 4: Designing Relational Database TablesDatabase Functions

Learning Video 5: Manipulating Database Data
Learning Video 6: More Structured Query Language
Learning Video 12: Creating and Using Stored Procedures
Learning Video 13: Enabling Full-Text Search in your Text DataCreating and Using Reports

Learning Video 10: Getting Started with Reporting Services
Learning Video 11: Embedding, Packaging and Deploying SQL Server Express Reporting ServicesDatabase Security

Learning Video 7: Understanding Security and Network ConnectivityDatabase Management

Learning Video 9: Using SQL Server Management Studio ExpressPublishing to the Web

Learning Video 8: Connecting your Web Application to SQL Server 2005 Express Edition

malik641
02-22-2008, 10:41 AM
Another resource for Transact-SQL. It says it covers Sybase's implementation for Transact-SQL, but at a glimpse I find it compatible with SQL Server T-SQL. It's worth a look, it's a free book.

http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookView

Lihualee
09-29-2008, 10:33 AM
Thanks! Bump!