Microsoft Access SQL: SQL for Non-Programmers
4.8 (99 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,630 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Access SQL: SQL for Non-Programmers to your Wishlist.

Add to Wishlist

Microsoft Access SQL: SQL for Non-Programmers

Tell the Query Design Window, "Good-bye", Start Scripting SQL, and Boost Your Earning Potential While You're At It.
Bestselling
4.8 (99 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,630 students enrolled
Created by IsáBel Harrison
Last updated 4/2017
English
Current price: $10 Original price: $175 Discount: 94% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 14 Articles
  • 21 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Download the Northwind database to follow along. This is covered in lecture 2.
Description

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

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 Harrison'

               

Who is the target audience?
  • This SQL course is for Microsoft Access users who are not yet familiar with SQL syntax. No prior programming knowledge is needed, but familiarity with Access databases is. This course is probably not for you is you are looking to learn super advanced queries.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 87 Lectures Collapse All 87 Lectures 04:07:41
+
Latest SQL for Non-Programmers Quick Tip
1 Lecture 00:10

Get the latest Quick Tips from Microsoft Access: SQL for Non-Programmers

Preview 00:10
+
Introduction to Scripting SQL with Microsoft Access
3 Lectures 04:35

Welcome to this Microsoft Access SQL course on Udemy.com

Preview 01:46

In this course you will be able to follow along using the Northwind database. This database can be downloaded from within Microsoft Access.

Preview 02:49

Make the most out of this course. Follow these steps for a successful course experience, and as always, feel free to message me or post a discussion.

Preview 1 page
+
SQL: SELECT
5 Lectures 16:52

Learn the structure of the SELECT statement, used to retrieve data from your database.

Preview 02:11

Multiple examples will walk you through the core of scripting SQL - the SELECT statement.

Preview 10:32

Learn to use aliases to temporarily rename a column heading

Preview 03:55

The SQL used in this section.

Section SQL - SELECT
00:14

Exercises to reinforce the SQL you learned in this section of the course - SELECT

Preview 2 pages
+
SQL: WHERE
7 Lectures 26:38

The WHERE clause is in SQL used to filter records

The WHERE Syntax
01:22

In SQL, wildcard characters are used with the LIKE operator, and can be used to substitute any character(s) in a string.

Understanding LIKE, *, and [ ]
04:46

Learn additional ways to filter records in SQL

Understanding NOT, !, BETWEEN...AND, IN, NULL, NOT NULL
04:24

Examples of how you can use WHERE to filter records in SQL

WHERE Part I
08:07

More examples of how you can use WHERE to filter records in SQL

WHERE Part II
07:27

The SQL used in this section.

Section SQL - WHERE
00:32

Exercises to reinforce the SQL you learned in this section of the course - WHERE

Exercise: Lesson Lab
2 pages
+
SQL: ORDER BY
4 Lectures 09:01

In SQL, ORDER BY is used to sort the result set

The ORDER BY Syntax
01:08

Examples of how you can use ORDER BY in SQL to sort records in your Access databases

ORDER BY
07:40

The SQL used in this section.

Section SQL - ORDER BY
00:13

Exercises to reinforce the SQL you learned in this section of the course - ORDER BY

Exercise: Lesson Lab
2 pages
+
Introduction to Aggregate Functions in SQL
7 Lectures 19:19

In SQL, use aggregate functions to return one value, calculated from multiple values in a column

Intro to Aggregate Functions
01:48

Examples of the SQL SUM function

SUM
07:03

Examples of the SQL AVERAGE function

AVERAGE
01:16

Examples of the SQL COUNT function

COUNT
04:47

Examples of the SQL MIN and MAX functions

MIN and MAX
03:41

The SQL used in this section.

Section SQL - Aggregate Functions
00:44

Exercises to reinforce the SQL you learned in this section of the course - Aggregate functions

Exercise: Lesson Lab
2 pages
+
SQL: Date Functions
11 Lectures 15:53

Examples of the SQL DATE function

Date
00:45

Example of the SQL NOW function

Now
00:18

Example of the SQL DAY function

Day
00:37

Example of the SQL MonthName function

MonthName
00:58

Examples of the SQL DatePart function

DatePart
03:39

Examples of the SQL DateAdd function

DateAdd
02:31

Examples of the SQL DateDiff function

DateDiff
02:02

Examples of the SQL DateValue function

DateValues
01:42

Learn how to format dates using SQL in your Microsoft Access databases

Formatting Dates
02:58

The SQL used in this section.

Section SQL - Date Functions
00:23

Exercises to reinforce the SQL you learned in this section of the course - Date Functions

Exercise: Lesson Lab
2 pages
+
SQL: String Functions
9 Lectures 12:45

Learn how to bring fields together using SQL

Using CONCATENATE
01:52

Use SQL to convert the value of a field to lowercase or uppercase

LCase and UCase
01:21

Extract characters from the left or right side of a character string in SQL

Left and Right
01:45

Extract characters from a character string in SQL

Mid
01:44

In SQL, find the length of a value in a string

Len
00:43

Remove blank characters from the beginning and/or end of a character string in SQL

Trim, LTrim, and RTrim
01:13

Replace characters with other characters

Replace
03:54

The SQL used in this section.

Section SQL - String Functions
00:13

Exercises to reinforce the SQL you learned in this section of the course - String Functions

Exercise: Lesson Lab
2 pages
+
Updating and Deleting Records Using SQL
7 Lectures 19:20

In SQL, use UPDATE to update existing records in a table

The UPDATE Syntax
01:55

Examples of how you can use UPDATE in SQL to update existing records in your Access databases

UPDATE
09:41

In SQL, use DELETE to delete existing records in a table

The DELETE Syntax
02:22

Examples of how you can use DELETE in SQL to delete existing records in your Access databases

DELETE
05:03

The SQL used in this section.

Section SQL - Updating and Deleting Records
00:19

Exercises to reinforce the SQL you learned in this section of the course - Updating and Deleting Records

Exercise: Lesson Lab
2 pages

If you are enjoying this Microsoft Access SQL course, please leave a positive comment, and a rating, which you can do at the top right hand corner of the Course Dashboard.

It takes less than a minute and it is a huge help to other students, and to me too.

How Are You Enjoying the Course?
1 page
+
SQL: Subqueries
4 Lectures 08:00

In SQL, a subquery is a query that is nested inside a SELECT, INSERT, UPDATE, or DELETE statement, or inside of another subquery

Subqueries
07:49

Learn to use EXISTS

Using EXISTS with Subqueries
1 page

The SQL used in this section.

Section SQL - Subqueries
00:11

Exercises to reinforce the SQL you learned in this section of the course - Subqueries

Exercise: Lesson Lab
2 pages
4 More Sections
About the Instructor
IsáBel Harrison
4.6 Average rating
791 Reviews
14,547 Students
16 Courses
Computer Training Specialist Since 1999.

Inspiring and Empowering People to Achieve Their Goals through Learning.


Sharing the strategies, and tips you need to regain control at work, and optimize productivity.

IsaBel has been serving students since 1999. Successfully self-employed, she is a trusted consultant for businesses large and small. She is a publisher, and author of several highly-rated eBooks.

IsaBel has been certified many times over as a Database Administrator, IT Professional, Developer, Network Administrator, and even Certified Ethical Hacker. Even with a technical background, she is a down to earth half-marathoner, who enjoys her family, good food, and sports.

IsaBel grew up around teachers, so education was always important to her.

All her life she has seen how gaining even a little more knowledge can make such a big difference in everything from the way you speak, to the way you cook, the way you parent, to the way you fix a leaky faucet, the speed in which you perfect your spreadsheets, to the upgrade your resume can get by learning SQL.

She was taught the importance of always learning, and works hard daily to help others, like you, meet your goals.

Enroll Now, because Change Matters, Growth Matters.