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

Created by: Sandeep Kumar
Founder of a Training company. IT Consultant, Coach, Mentor

What Will I 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

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.

Target audience

• 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