Microsoft Access SQL- SQL for Non-Programmers

Microsoft Access SQL: SQL for Non-Programmers, available at $69.99, has an average rating of 4.6, with 87 lectures, based on 792 reviews, and has 7051 subscribers.

You will learn about 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 This course is ideal for individuals who are 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. It is particularly useful for 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.

Enroll now: Microsoft Access SQL: SQL for Non-Programmers

Summary

Title: Microsoft Access SQL: SQL for Non-Programmers

Price: $69.99

Average Rating: 4.6

Number of Lectures: 87

Number of Published Lectures: 87

Number of Curriculum Items: 87

Number of Published Curriculum Objects: 87

Original Price: $199.99

Quality Status: approved

Status: Live

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

Who Should Attend

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.

Target Audiences

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.

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]
FROMUdemy
WHERE Instructor = ‘IsáBel.’

               

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

Course Curriculum

Chapter 1: Latest SQL for Non-Programmers Quick Tip

Lecture 1: Quick Tip: Getting Only What You Need

Chapter 2: Introduction to Scripting SQL with Microsoft Access

Lecture 1: Welcome

Lecture 2: Using the Exercise Database

Lecture 3: Steps for a Successful Course

Chapter 3: SQL: SELECT

Lecture 1: The SELECT Syntax

Lecture 2: SELECT Statements

Lecture 3: Aliasing Columns

Lecture 4: Section SQL – SELECT

Lecture 5: Exercise: Lesson Lab

Chapter 4: SQL: WHERE

Lecture 1: The WHERE Syntax

Lecture 2: Understanding LIKE, *, and [ ]

Lecture 3: Understanding NOT, !, BETWEENAND, IN, NULL, NOT NULL

Lecture 4: WHERE Part I

Lecture 5: WHERE Part II

Lecture 6: Section SQL – WHERE

Lecture 7: Exercise: Lesson Lab

Chapter 5: SQL: ORDER BY

Lecture 1: The ORDER BY Syntax

Lecture 2: ORDER BY

Lecture 3: Section SQL – ORDER BY

Lecture 4: Exercise: Lesson Lab

Chapter 6: Introduction to Aggregate Functions in SQL

Lecture 1: Intro to Aggregate Functions

Lecture 2: SUM

Lecture 3: AVERAGE

Lecture 4: COUNT

Lecture 5: MIN and MAX

Lecture 6: Section SQL – Aggregate Functions

Lecture 7: Exercise: Lesson Lab

Chapter 7: SQL: Date Functions

Lecture 1: Date

Lecture 2: Now

Lecture 3: Day

Lecture 4: MonthName

Lecture 5: DatePart

Lecture 6: DateAdd

Lecture 7: DateDiff

Lecture 8: DateValues

Lecture 9: Formatting Dates

Lecture 10: Section SQL – Date Functions

Lecture 11: Exercise: Lesson Lab

Chapter 8: SQL: String Functions

Lecture 1: Using CONCATENATE

Lecture 2: LCase and UCase

Lecture 3: Left and Right

Lecture 4: Mid

Lecture 5: Len

Lecture 6: Trim, LTrim, and RTrim

Lecture 7: Replace

Lecture 8: Section SQL – String Functions

Lecture 9: Exercise: Lesson Lab

Chapter 9: Updating and Deleting Records Using SQL

Lecture 1: The UPDATE Syntax

Lecture 2: UPDATE

Lecture 3: The DELETE Syntax

Lecture 4: DELETE

Lecture 5: Section SQL – Updating and Deleting Records

Lecture 6: Exercise: Lesson Lab

Lecture 7: How Are You Enjoying the Course?

Chapter 10: SQL: Subqueries

Lecture 1: Subqueries

Lecture 2: Using EXISTS with Subqueries

Lecture 3: Section SQL – Subqueries

Lecture 4: Exercise: Lesson Lab

Chapter 11: Joining Tables Using SQL

Lecture 1: Primary Key and Foreign Key

Lecture 2: Common Types of Joins

Lecture 3: The JOIN Syntax

Lecture 4: JOIN

Lecture 5: More Examples of Three Table Joins

Lecture 6: Aliasing Tables in Joins

Lecture 7: Subqueries vs. Joins

Lecture 8: Section SQL – Joins

Lecture 9: Exercise: Lesson Lab

Chapter 12: SQL: Tables

Lecture 1: The CREATE TABLE Syntax

Lecture 2: Data Types

Lecture 3: CREATE TABLE I

Lecture 4: CREATE TABLE II

Lecture 5: The INSERT INTO Syntax

Lecture 6: INSERT INTO

Lecture 7: ALTER TABLE

Lecture 8: Section SQL – Tables

Lecture 9: Exercise: Lesson Lab

Chapter 13: Other SQL Clauses & Functions

Lecture 1: Using TRANSFORM and PIVOT to Create Crosstabs

Lecture 2: Using DISTINCT

Lecture 3: Using TOP

Lecture 4: UNION Queries

Lecture 5: Formatting Numbers

Lecture 6: Section SQL – Other Clauses & Functions

Chapter 14: Test Your SQL Skills

Lecture 1: Test Your Skills Questions

Lecture 2: Test Your Skills Answers

Lecture 3: Thank you!

Lecture 4: Next Steps for Success

Instructors

IsáBel .
Microsoft Certified IT Professional. Trainer of 21 Years

Rating Distribution

1 stars: 3 votes

2 stars: 5 votes

3 stars: 54 votes

4 stars: 250 votes

5 stars: 480 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!