Microsoft Access SQL: SQL from Absolute Beginners To Expert
SQL Using Microsoft Access 2019 but applicable to MySQL, Oracle SQL, Microsoft SQL Server, PostgreSQL, SQLite and DB2
4.66 (258 reviews)
1,481
students
6 hours
content
Oct 2021
last update
$99.99
regular price
What you will 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
Screenshots
Related Topics
1691820
udemy ID
5/14/2018
course created date
5/22/2020
course indexed date
Bot
course submited by