Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Access SQL: SQL from Absolute Beginners To Expert

Name: Microsoft Access SQL: SQL from Absolute Beginners To Expert
Rating: 4.5 (296 reviews)

SQL Using Microsoft Access 2019 but applicable to MySQL, Oracle SQL, Microsoft SQL Server, PostgreSQL, SQLite and DB2

Created bySandeep Kumar

Last updated 10/2021

English

What you'll learn

Accelerate your career by mastering all the SQL statements in Microsoft Access
Queries and Files Included
Master different ways of SELECT statements
How to select Unique Records?
Filter the result using WHERE clause
Master all the Operators that can be used with WHERE clause
Different ways to SORT the Result
How to LIMIT the result
GROUP BY clause
Execute all aggregate Functions
Create table with all the constraints
Advanced ways to join Table
Merge columns from multiple columns
Create Primary key and Foreign key
Code INDEX to Table
Add UNIQUE INDEX to Table
INSERT Records to a Table
How to modify Existing Records
Complete Sub-Queries
UNION and UNION ALL
How to create virtual Table
Different ways to Alter the structure of the TABLE
DELETE Records from Table
DROP a Table
....and much more
These SQL queries can also be used with Oracle, MySQL, Microsoft SQL Server(SQL Server), PostgreSQL and DB2

Course content

13 sections • 95 lectures • 6h 9m total length

Welcome and What you will learn?2:44
Prepare Sample Database5:06

Simple WHERE clause2:14
Comparison operators6:15
Arithmetic operators5:28
Explore how to apply arithmetic operators in Microsoft Access SQL, including plus, minus, multiplication, and division, within select statements and workloads, using reorder level and target level as examples.
Logical operators7:29
Concatenation operators5:40
Learn how to use the concatenation operator to join strings with ampersand or plus, add spaces between names, and understand how null values affect results.
How to check for NULL values3:40
Check records within a fixed range7:19
Learn how to use the between and not between operators in Microsoft Access SQL to filter records within a date range, handle timestamp values, and ensure inclusive ranges in queries.
Check records within a fixed set of values4:37
Master sql 'in' and 'not in' operators to filter records by a fixed value set, using invoices and orders examples to select ships to Las Vegas, New York, or Portland.
All SQL Queries used in this section1:09
Quiz - filter the records from the table

Match characters - Part 14:30
Learn to use the like operator in Microsoft Access SQL to filter records by patterns with wildcards, such as starting with s, containing sales, or ending with manager.
Match characters - Part 23:06
Match characters - Part 35:26
Match characters - Part 42:48
Use the negation character inside square brackets with an exclamation mark to exclude letters in a like pattern. For example, filter suppliers not starting with certain letters.
Match characters - Part 52:24
All SQL Queries used in this section0:27
Quiz on LIKE/Wild Cards

GROUP BY - Part 15:25
GROUP BY - Part 25:41
Let us understand about String Functions2:33
Change the case of a string and select from left or right2:30
Trim Records4:57
Learn to remove leading, trailing, and both-side spaces with ltrim, rtrim, and trim in Access sql, and convert numeric ids to strings with the str function.
Compare Strings, Find lengths and Replace strings6:17
Let us understand about Numerical Functions1:24
Examples of Numerical Functions9:01
Explore numerical aggregate functions in Microsoft Access SQL, including average, max, min, and count, with group by and order by using shipping fee examples.
Date Function0:49
Use the date function in Microsoft Access SQL to fetch the current system date, with examples in select, insert, delete, update, and procedure, and alias as current system date.
Function to add Dates6:06
Function to subtract Dates4:46
learn to subtract dates in microsoft access sql using the date diff function to measure differences in years, quarters, or months.
Extract part of Date3:33
Learn to extract parts of a date in Microsoft Access SQL using the date part function, returning integers for year, month, week, hour, minutes, seconds, and quarters.
Day Function0:48
Extract day from a date field with the day function in Access SQL. Use Day([order date]) or DatePart on the orders table and run the query to view the day.
Function related to hour, minute and second2:55
Now and Time Functions1:14
Month and Year Functions1:47
Datevalue Function2:31
Learn how the date value function in Microsoft Access SQL extracts a date from strings and converts formats like 921 and 21/9/2020 into date values.
Format Function3:36
isDate Function2:48
isNull Function3:10
isNumeric Function4:28
CurrentUser Function0:31
HAVING clause7:33
All SQL Queries used in this Section2:11

Create Simple Table5:54
Create a simple table in Microsoft Access using the create table statement with columns like store id (auto number), store name, phone, email, address, city, state, and zipcode.
Create table with constraints1:49
Learn to create a table with constraints to enforce data validity and accuracy, applying normal, unique, primary key, and foreign key rules at column or table level using standard syntax.
NOT NULL constraint2:15
UNIQUE Constraint3:08
Discover how the unique constraint enforces unique values in a column, with create table syntax, column definitions, and named constraints such as store uk.
Primary Key9:13
Foreign Keys - Part 11:29
Foreign Keys - Part 26:30
Foreign Keys - Part 38:01
UNIQUE INDEX - Part 12:12
Discover how a unique index enforces no duplicate values in a column, and learn the syntax to create one on a table using a specified index name and columns.
UNIQUE INDEX - Part 21:08
INDEX1:51
All Queries used in this Section0:35

Inserting Records - Part 19:21
Inserting Records - Part 24:36
Inserting Records - Part 38:58
Insert the parent items record first to satisfy the foreign key constraint. Then insert the corresponding product details record, allowing Access to auto-assign the product id.
Change an existing Record5:04
Learn to update an existing record in Microsoft Access SQL using the update statement, set clauses, and optional where conditions; update specific rows or all records across tables.
All SQL Queries used in this section0:28

Requirements

No knowledge of SQL required for this course
Students should have Microsoft Access ( Any version i.e. 2007, 2010, 2013, 2016 or 2019) installed in their PC
No Knowledge of MS Access. No knowledge of Oracle, MySql, PostgreSQL, DB2, Microsoft SQL Server, etc.

Description

'This Course covers Microsoft Access SQL with real-time examples and Project which is a real-world application' but you can apply these SQL queries in Oracle, MySql, PostgreSQL, Microsoft SQL Server, SQLite, and DB2'.

"Welcome to the Most In-Depth and Quality Course on Microsoft Access SQL (MS Access SQL) from an Expert"

The Course is full of quality content which you will not find anywhere on the Internet
Learn from an expert who has a passion for training
The Course covers Real Training with the aim to provide knowledge that is similar to corporate training.

======================================================================================

Join this course which is the best "Microsoft Access SQL" course. I will show all the syntax of SQL with multiple examples along the way!!!

Want to master the SQL with no previous coding experience and are confused about joining which course on SQL to understand from the basics to an advanced level?

You have come to the right place. This is the most complete and in-depth Course on SQL in UDEMY. If you do not believe me, Please have a look at the Course content carefully and ask a few questions from yourself?

Is the Course taught by a real-time expert? I have more than 15 years of experience as an Instructor and more than 10 years of experience in SQL. I firmly believe that if an Instructor does not have a good experience, he/she will flood the course with poor content.
Is the Course content clear and Precise? I bet you will not get a better Course content than this. Please have a look at all the courses and choose wisely.
Will the Course be In-depth? The Course covers In-Depth knowledge of SQL). The amount of Knowledge which is covered in this course is great.
How is the quality of the Content? In MS Access SQL(Microsoft Access SQL), there is a lot of low-quality content that is spread throughout the internet. Be wise in choosing the course which has the best content which is presented in a good way to provide maximum output.
The course assumes no prior knowledge on MS Access SQL(Microsoft Access SQL) and teaches you from scratch to advanced level
Once you Enroll for this Course, you get lifetime access to this course and you will get all the future updates. you also get a Certification of Completion once you complete the Course.
It helps to learn T-SQL also.
This will also help you to get Microsoft certification.
This Course is not for DBA(Database Administration) but certainly, helps you to become better.
If you plan to work with Microsoft SQL, it will be extremely helpful.
In short, using this course you can be an expert in any SQL database for beginners to Expert.
This course is useful for Database design as well. I have covered the Naming convention as well.
PHP uses MySQL mostly while Python uses PostgreSQL most of the time. Startups and small organizations might use Microsoft Access SQL.
Microsoft Access is the cheapest database management tool and you will gain mastery in SQL queries using MS Access 2019.
The SQL queries presented in this course can be used with any database with little changes here and there.
If you are a data scientist or willing to become a data scientist, then SQL is a must and this course helps in data analytics.

Do you want to start on SQL but have no experience with SQL?
If you have some prior knowledge on SQL or if you are a complete fresher, you are at the right place. The Course teaches you to complete SQL right from Scratch to Advanced level.

There’s no risk involved in taking this Course!
This course comes with a 30-day money-back guarantee. I am sure that this is the best course on SQL and you can compare the content which is provided in this course against any SQL Course and I guarantee you that you will not get such good structured content anywhere. Still, if you are not completely satisfied with the course, please let us know and we will provide a refund without asking any question.

What if you are stuck?

I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.

Are you getting updated content?

Yes, I keep updating the content always to make sure, I provide all the information to my students.

Once you enroll for this course-

1) Selecting Records from Table - SELECT statement in SQL

2) Filtering the Records - Using WHERE clause in SQL

3) Sorting Records - Using ORDER BY clause

4) Limiting the result of the result - Using TOP keyword
5) Grouping data - using GROUP BY clause

6) complete guide with examples of all the Functions - All aggregate functions covered

7) Creating simple and advanced Tables - with constraints and without constraints

8) Keys, Index - PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX

9) Inserting records(loading) - with INSERT Statement

10) Updating the records of a Table - Using UPDATE statement

11) Combining multiple tables - Using UNIONS

12) Joining multiple columns of different tables - Using JOINs

13) Modify table properties - ALTER statement

14) Deleting records from the table - DELETE statement

15) Removing tables from the database permanently - DROP statement

Note: This course helps to master SQL using Microsoft Access but it will also help to master SQL if you want to learn Oracle SQL, MySql, Microsoft SQL Server, PostgreSQL, SQLite, DB2, etc.

Who this course is for:

Absolute beginners who have never used SQL on Microsoft Access SQL
Students who has basic SQL knowledge
Professionals who has basic knowledge of SQL but wish to master SQL on Microsoft Access
Beginners who want to start learning SQL easily without downloading any any tools like Oracle, MySQL, etc
Students who wishes to learn SQL using Microsoft Access(MS Access) can enroll this course. This will also help in learning SQL for Oracle, MySql, Microsoft SQL Server, PostgreSQL
The SQL commands learned using MS Access will work similarly on other tools like Oracle, MySql, Ms Sql server, postgresql, sqlite, etc

Microsoft Access SQL: SQL from Absolute Beginners To Expert

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 8min

How to select Records from a Table4 lectures • 22min

Filter the Records of the Table9 lectures • 44min

LIKE/Wild Cards6 lectures • 19min

Sort and Limit the Result4 lectures • 16min

Group Records and Aggregate Functions24 lectures • 1hr 27min

Data type and Naming Convention2 lectures • 11min

Create Table12 lectures • 44min

Insert Records and update records5 lectures • 28min

Sub Queries3 lectures • 7min

Requirements

Description

Who this course is for: