Consulting

Results 1 to 7 of 7

Thread: A Few Resources

  1. #1
    VBAX Regular
    Joined
    Jul 2007
    Posts
    19
    Location

    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
    Office Version: 2000/2003
    Experience(Office): Amatuer
    Experience(VB): Veteran (Pre-VB6)
    Weakness: Formulae & New Object Properties
    Strengths: VB Syntax & Obscure Problem Solving

    "Als slechts ik Nederlands was, zou ik kunnen begrijpen wat ik zei! Kunt u me helpen?"
    "Koekje iedereen?"

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master xld's Avatar
    Joined
    Apr 2005
    Posts
    25,095
    Location
    Very useful. The first two are definitely a saver for passing on.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Master stanl's Avatar
    Joined
    Jan 2005
    Posts
    1,141
    Location
    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

  4. #4
    VBAX Master stanl's Avatar
    Joined
    Jan 2005
    Posts
    1,141
    Location
    and another free chapter of ADO/OLEDB

    http://www.informit.com/content/imag...0789729520.pdf

  5. #5
    Administrator
    2nd VP-Knowledge Base
    VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    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




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  6. #6
    Administrator
    2nd VP-Knowledge Base VBAX Master malik641's Avatar
    Joined
    Jul 2005
    Location
    Florida baby!
    Posts
    1,533
    Location
    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




    New to the forum? Check out our Introductions section to get to know some of the members here. Feel free to tell us a little about yourself as well.

  7. #7

    Exclamation friend

    Thanks! Bump!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •