Udemy

SQL for Microsoft Access

Name: SQL for Microsoft Access
Price: 69.99 USD
Availability: InStock
Rating: 4.6 (417 reviews)

4.6(417)2k studentsALL LEVELS

Korshub's take

Write SQL that works everywhere, not just Access

If you've outgrown point-and-click Access but feared SQL's syntax, this course bridges that exact gap. You'll learn to write portable SQL that works both in Access and SQL Server—future-proofing your database work. The curriculum spans the full SQL toolkit: SELECT clauses, functions, complex joins (the ones the GUI cannot handle), action queries, subqueries, and derived tables. One student—a complete beginner—went from basic Access to understanding SQL structure deeply. Another with some experience praised the course for being 'logically structured'—a rare quality that makes concepts stick. The course doesn't assume prior SQL knowledge; it assumes you want to unlock functionality the graphical interface simply cannot touch. By the end, you'll write queries that make your databases genuinely powerful, not just functional.

About this course

Do you want to learn how to write more advanced queries in Access. And do you want your queries to be portable into SQL Server and Access?

Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.

What do people just like you think of this course?

"This is an excellent course, very well organized, structured, explained and paced. In addition, the course is content rich, provides a very good context and helpful tips! This is exactly what I was looking for. Thank you very much!" - Dmitry Tlusten

"I am a 51 year old complete beginner and just wanted to learn access to create my own database for a side business. I first took an MS Access course and then this SQL for Access course which allowed me to understand access better and to add some useful functionality to my database. Really enjoyed it, felt like a great introduction to SQL." - Mark Nugent

"If I were to name single biggest advantage of this course I would say that it is very logically structured. In my opinion essential to master any subject. Before the course I had some vague idea of SQL, but after it I feel quite solid." - Bartomiej Kurzeja

In this course learn how to:

Write SQL code, using the six SELECT clauses.
Use functions and formulas in your SELECT statements.
Create joins between tables, including more complex joins which cannot be evaluated using the graphical interface.
Write action queries and cross-queries.
Using derived tables in the FROM clause, and subqueries in the WHERE clause.
Creating correlated queries and cross-queries.
Using UNION and UNION ALL, and
Importing or Linking data and creating Pass-Through queries from other databases.

Hopefully, by the end of this course, you will also feel "quite solid" in Access SQL, and be able to use the extra functionality allowed only when using Access SQL to build even better databases.