Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Beginner Level 1    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
SQL Server Course Ideas
Tony Godfrey 
     
3 months ago
Here are five things I think beginners would really want to see:
1.  SQL Server as a new tool. Big-picture explanation, how it compares to Access, and when it makes sense to move to it.
2.Getting SQL Server up and running
Installing it, setting it up correctly, and understanding the basic tools without getting overwhelmed.
3.Core SQL skills that actually matter
Writing queries, joins, filtering, grouping—enough to be productive without assuming prior experience.
4.How people really use SQL Server in the real world
Common patterns, basic security concepts, and how data is typically organized and maintained.
5.Working with other tools (especially Access)
How SQL Server fits into an existing setup and how people commonly use it as a backend.

I think a beginner-friendly, practical approach would be really valuable, especially for people coming from Access or small-business environments.
Raymond Spornhauer  @Reply  
          
3 months ago
Good comments from Tony.

I would ask for the following:

1. Using SQL Server with direct link to Access
2. Using SQL Server with ODBC or other connection methods. (using pass-thru queries)
3. Setting up Read/Write permissions to tables or queries
4. Using SQL Server to create 'Views' then connecting that to your Access Database.
5. Left or Right Join Queries with more than 1 Table on SQL Server

-Raymond
Richard Rost  @Reply  
          
3 months ago
All excellent stuff, both of you. Most of this is on my list already, but it's good to see you guys know what you want to learn.
Joe Holland  @Reply  
      
3 months ago
Nice to see your comments in the forums again Raymond . You are a real asset to this community.
Richard Rost  @Reply  
          
3 months ago
Joe agreed!
Sam Domino  @Reply  
      
2 months ago
Richard I would like to see how to transition current Access dbs from a local or BE setup, to use on a SQL Server.  As a SQL Server Noob, my first thoughts are how to get "stuff" from where it is now to SQL Server.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Beginner Level 1.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/29/2026 10:17:18 PM. PLT: 1s