-
A Few Resources
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
-
Very useful. The first two are definitely a saver for passing on.
-
This is a sample chapter dealing with Access/Jet4 SQL - I especially like their coverage of SELECT....INTO Stan
http://www.developershandbook.com/Do...s/2370ch05.pdf
-
-
For learning SQL Server, here are some videos:
http://msdn2.microsoft.com/en-us/exp...a718391.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 Tables
Database 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 Data
Creating and Using Reports
- Learning Video 10: Getting Started with Reporting Services
- Learning Video 11: Embedding, Packaging and Deploying SQL Server Express Reporting Services
Database Security
- Learning Video 7: Understanding Security and Network Connectivity
Database Management
- Learning Video 9: Using SQL Server Management Studio Express
Publishing to the Web
- Learning Video 8: Connecting your Web Application to SQL Server 2005 Express Edition
-
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/onlinebook...eric__BookView
-
friend