Microsoft Access SQL: SQL for Non-Programmers

Access SQL: Easy to Follow Lectures and SQL Examples. Boost Your Resume and Earning Potential. You Can Learn SQL Today!
4.5 (56 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,139 students enrolled
$175
Take This Course
  • Lectures 86
  • Contents Video: 3.5 hours
    Other: 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

Course Description

  • Lesson Lab Exercises and Course Quiz
  • Easy to Use SQL Source File for Each Section
  • 30 Day Money Back Guarantee


What if you could learn to start scripting SQL this week?

What would your work day look like a month from now, a year from now?

Would you work with your Access databases in a faster, more efficient way?

Would you be more confident in your work?

Would your paycheck reflect your new knowledge?


Start TODAY and you will be able to create SQL QUERIES that select, sort, and filter the records in your Access databases.

By TOMORROW you will have experience using FUNCTIONS in your SQL queries.

And at the end of THIS WEEK you will be able to UPDATE records, create SUBQUERIES, TABLES, and JOIN tables.

___________________________________________________

As a data administrator, when you think about working with your Access databases, there are some challenges you face ...

Some are spending too much time creating queries

Some want to go beyond the basic Query Wizard or Design window

Some struggle with finding information on SQL with Access


Microsoft Access SQL: SQL for Non-Programmers will jump start your SQL journey.

You can start learning SQL, step by step, and improve your skills.

So Click The Take This Course Button On The Right & I'll See You In Class!

What are the requirements?

  • Download the Northwind database to follow along. This is covered in lecture 2.

What am I going to get from this course?

  • 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

What 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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Latest SQL for Non-Programmers Quick Tip
Article

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

Section 2: Introduction to Scripting SQL with Microsoft Access
01:46

Welcome to this Microsoft Access SQL course on Udemy.com

02:49

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

1 page

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.

Section 3: SQL: SELECT
02:11

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

10:32

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

03:55

Learn to use aliases to temporarily rename a column heading

Article

The SQL used in this section.

2 pages

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

Section 4: SQL: WHERE
01:22

The WHERE clause is in SQL used to filter records

04:46

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

04:24

Learn additional ways to filter records in SQL

08:07

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

07:27

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

Article

The SQL used in this section.

2 pages

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

Section 5: SQL: ORDER BY
01:08

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

07:40

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

Article

The SQL used in this section.

2 pages

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

Section 6: Introduction to Aggregate Functions in SQL
01:48

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

07:03

Examples of the SQL SUM function

01:16

Examples of the SQL AVERAGE function

04:47

Examples of the SQL COUNT function

03:41

Examples of the SQL MIN and MAX functions

Article

The SQL used in this section.

2 pages

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

Section 7: SQL: Date Functions
00:45

Examples of the SQL DATE function

00:18

Example of the SQL NOW function

00:37

Example of the SQL DAY function

00:58

Example of the SQL MonthName function

03:39

Examples of the SQL DatePart function

02:31

Examples of the SQL DateAdd function

02:02

Examples of the SQL DateDiff function

01:42

Examples of the SQL DateValue function

02:58

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

Article

The SQL used in this section.

2 pages

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

Section 8: SQL: String Functions
01:52

Learn how to bring fields together using SQL

01:21

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

01:45

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

01:44

Extract characters from a character string in SQL

00:43

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

01:13

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

03:54

Replace characters with other characters

Article

The SQL used in this section.

2 pages

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

Section 9: Updating and Deleting Records Using SQL
01:55

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

09:41

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

02:22

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

05:03

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

Article

The SQL used in this section.

2 pages

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

1 page

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.

Section 10: SQL: Subqueries
07:49

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

1 page

Learn to use EXISTS

Article

The SQL used in this section.

2 pages

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

Section 11: Joining Tables Using SQL
03:42

The PRIMARY KEY uniquely identifies each record in a table. A FOREIGN KEY in one table is the PRIMARY KEY in another table.

05:12

Learn about INNER JOINS and OUTER JOINS

05:08

Learn the SQL syntax for creating Joins

12:47

Examples of how to Join tables in your Access database using SQL

3 pages

Examples of joining 3 or more tables in the Northwind database.

03:28

Learn to use aliases to temporarily rename tables

2 pages

Now that you know how to create a Subquery, and how to create a Join, which one should you use?

Article

The SQL used in this section.

3 pages

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

Section 12: SQL: Tables
01:58

Learn how to create tables using SQL in your Microsoft Access databases

2 pages

Get familiar with different data types

03:23

Example of how to use SQL to create tables in your Microsoft Access databases

02:27

Example of how to use SQL to create tables in your Microsoft Access databases

03:01

Now that your table has been created, learn how to insert data into those tables using SQL

02:03

Examples of how to insert data into those tables using SQL

03:05

In SQL, use ALTER TABLE to add, delete, or modify columns in an existing table.

Article

The SQL used in this section.

2 pages

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

Section 13: Other SQL Clauses & Functions
08:55

Learn how to create Crosstab Queries in SQL by using TRANSFORM and PIVOT

02:13

In SQL, use DISTINCT to return only distinct values.

06:57

In SQL, use TOP to specify the number of records to return.

05:43

Learn how to combine like SELECT queries with UNION.

Article

The SQL used in this section.

Section 14: Test Your SQL Skills
5 pages

Put what you have learned in Microsoft Access: SQL for Non-Programmers to the test with this 5 page resource

4 pages

The answers to the 5 page Test Your Skills questions for Microsoft Access: SQL for Non-Programmers

01:12

Thanks for being a part of this Udemy.com course. I hope that it has helped to further your understanding of SQL in Microsoft Access. if you have any questions, please let me know. I look forward to feedback.

1 page

What can you do, now that the course is complete, to help you with scripting SQL in Microsoft Access databases?

Here are your next steps.

Bonus Lecture: $15 Deals Are Back!!- UPDATED
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

IsáBel Harrison, Teaches 12 Courses on Udemy.com

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 in 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.


Ready to start learning?
Take This Course