Microsoft Access SQL: SQL for Non-Programmers

Learn How You Can Use SQL in Microsoft Access with the Tips, Tools, and Exercises in This Best-Selling Course.

4.60 (785 reviews)
Udemy
platform
English
language
Databases
category
instructor
7,035
students
4 hours
content
Feb 2024
last update
$69.99
regular price

What you will learn

Files & SQL Script Included!

WRITE SQL Queries in Your Microsoft Access Databases

CREATE Select Queries

FILTER with the WHERE Clause

SORT Your Access Records

GROUP Your Records

USE Aggregate Functions

LEARN About Date Function

GET Familiar with Functions You Can Use with Strings

LEARN How to Join Tables

CREATE Tables Using SQL

INSERT Records Into Your Tables

Use Action Queries Like:

- UPDATE

- DELETE

CREATE SubQueries

... and more

Description

SQL Is One Of The Most Sought-After Skills By Employers.

If there was an easy, step-by-step method for learning a little bit of SQL EVERY SINGLE DAY without the confusion, tech

overwhelm , or "What the heck do I do next?" syndrome, would you finally feel confident enough to make learning SQL your priority?


You Can Quickly Learning How To Query Your Microsoft Access Databases with SQL

If you are already familiar with Microsoft Access databases, and would like to:

  •  Have more employable skills

  •   Learn an in-demand programming language

  •   Get the answers that you want, when you want them from your database

  •   Break free of the Query Design window, or Query Wizards


Then this course will enable you to discover how you can use SQL to query your Access databases. There is enormous value in knowing the basics and being efficient in SQL.

You can start using SQL today.
Here's your first example,

SELECT [SQL Course]
FROM Udemy
WHERE Instructor = 'IsáBel.'

               


The Tools You Need to Tell the Query Design Window "Good-bye",

Content

Latest SQL for Non-Programmers Quick Tip

Quick Tip: Getting Only What You Need

Introduction to Scripting SQL with Microsoft Access

Welcome
Using the Exercise Database
Steps for a Successful Course

SQL: SELECT

The SELECT Syntax
SELECT Statements
Aliasing Columns
Section SQL - SELECT
Exercise: Lesson Lab

SQL: WHERE

The WHERE Syntax
Understanding LIKE, *, and [ ]
Understanding NOT, !, BETWEEN...AND, IN, NULL, NOT NULL
WHERE Part I
WHERE Part II
Section SQL - WHERE
Exercise: Lesson Lab

SQL: ORDER BY

The ORDER BY Syntax
ORDER BY
Section SQL - ORDER BY
Exercise: Lesson Lab

Introduction to Aggregate Functions in SQL

Intro to Aggregate Functions
SUM
AVERAGE
COUNT
MIN and MAX
Section SQL - Aggregate Functions
Exercise: Lesson Lab

SQL: Date Functions

Date
Now
Day
MonthName
DatePart
DateAdd
DateDiff
DateValues
Formatting Dates
Section SQL - Date Functions
Exercise: Lesson Lab

SQL: String Functions

Using CONCATENATE
LCase and UCase
Left and Right
Mid
Len
Trim, LTrim, and RTrim
Replace
Section SQL - String Functions
Exercise: Lesson Lab

Updating and Deleting Records Using SQL

The UPDATE Syntax
UPDATE
The DELETE Syntax
DELETE
Section SQL - Updating and Deleting Records
Exercise: Lesson Lab
How Are You Enjoying the Course?

SQL: Subqueries

Subqueries
Using EXISTS with Subqueries
Section SQL - Subqueries
Exercise: Lesson Lab

Joining Tables Using SQL

Primary Key and Foreign Key
Common Types of Joins
The JOIN Syntax
JOIN
More Examples of Three Table Joins
Aliasing Tables in Joins
Subqueries vs. Joins
Section SQL - Joins
Exercise: Lesson Lab

SQL: Tables

The CREATE TABLE Syntax
Data Types
CREATE TABLE I
CREATE TABLE II
The INSERT INTO Syntax
INSERT INTO
ALTER TABLE
Section SQL - Tables
Exercise: Lesson Lab

Other SQL Clauses & Functions

Using TRANSFORM and PIVOT to Create Crosstabs
Using DISTINCT
Using TOP
UNION Queries
Formatting Numbers
Section SQL - Other Clauses & Functions

Test Your SQL Skills

Test Your Skills Questions
Test Your Skills Answers
Thank you!
Next Steps for Success
[BONUS LECTURE] February Course Coupon

Screenshots

Microsoft Access SQL: SQL for Non-Programmers - Screenshot_01Microsoft Access SQL: SQL for Non-Programmers - Screenshot_02Microsoft Access SQL: SQL for Non-Programmers - Screenshot_03Microsoft Access SQL: SQL for Non-Programmers - Screenshot_04

Reviews

Ricardo
September 3, 2023
Até este ponto está sendo muito proveitoso para eu desenvolver o meu projeto no meu trabalho. Era o que eu esperava do curso o qual me ajudará nos outros cursos que estou fazendo relacionado a Access e tabelas do Excel mais VBA.
Ciaran
March 12, 2023
Well explained course with excellent examples. Isabel has put together an engaging course that covers all the basics of SQL, which will be easily transferrable from access to other SQL platforms. It's a good introduction to SQL for those familiar with Microsoft Products
Nate
January 30, 2023
Great course! I liked the labs at the end of each section. I did get a bit lost on Section 11 though. That one could use some simpler examples.
Roberto
August 28, 2022
I wish there were more resources (pdf) available. Yes I can go and browse the internet and access the material but most of the best Udemy courses provide more material than this one does
Dave
August 27, 2022
This was a very good and comprehensive introduction to Access SQL. The videos and printed materials were clear and helpful. Of particular value were the questions at the end of each section. Mid-way through the course the materials did become a little more difficult - and these are the sections I will have to revisit. All in all, highly recommended!
Gül
August 12, 2022
I had ne idea about SQL but this sofware is so imfortant for my future jobs. I am learning basic things with that course and after that I will improve myself. So of course I recommended this course...
Lisa
April 22, 2022
I had never used SQL at all, previous to taking this course. As a total beginner, I found what I learned in this course to be mostly helpful and informative. However, it seems that the instructor no longer monitors the Q&A on this particular course. None of my posted questions were answered. I had to seek outside resources to find all of the answers to my questions. I feel like the instructor also left out some key explanations here and there. Overall, I feel like I now have a very basic understanding of SQL for Access, but still have tons of questions.
Kelvin
April 20, 2022
I really enjoy this course. The instructor speaks and demonstrates very clearly every aspect. The information provided will definitely assist me in my day-to-day function on my job. Thank you.
Thandokazi
April 12, 2022
It is quite a good course, even though I already know most of the staff you're teaching. Easy to understand
Saravanan
April 6, 2022
This is the best Access SQL Course. I never realised how simple SQL is. The step-by-step explanation and examples is clear and wonderful. Thank you.
Laila
March 16, 2022
I like the video because it is easy to find the topic in SQL. It is an easy reference for me. Highly recommended. I
Marion
December 31, 2021
I can already see how this is going to help me in my job. I've learned things here that I am anxious to implement
Hilaire
December 29, 2021
Le cours est bien structuré, l'apprentissage est progressif, la formatrice est méthodique avec une voix facilitant l'apprentissage ...
Wietze
June 15, 2018
Easy to follow, clear examples. In the end I have to say that SQL is not difficult. The course explaines how to use the different SQL commands. It would be fantastic when an Access database is build from scratch using the combination of Tables, Queries, Forms, Reports and SQL/Macros/VBA . Then it is possible to see and experience when to use what method to resolve a specific Access issue while building the database. I hav enjoyed this course.
Usman
May 15, 2018
I work in SQl but dont have formal education in it . the course so far has provided me some information i didn't know about.

Charts

Price

Microsoft Access SQL: SQL for Non-Programmers - Price chart

Rating

Microsoft Access SQL: SQL for Non-Programmers - Ratings chart

Enrollment distribution

Microsoft Access SQL: SQL for Non-Programmers - Distribution chart
501438
udemy ID
5/14/2015
course created date
8/6/2019
course indexed date
Bot
course submited by