Microsoft Access SQL SQL from Absolute Beginners To Expert
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
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 InternetLearn from an expert who has a passion for trainingThe 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 levelOnce 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 SQL2) Filtering the Records – Using WHERE clause in SQL3) Sorting Records – Using ORDER BY clause4) Limiting the result of the result – Using TOP keyword5) Grouping data – using GROUP BY clause6) complete guide with examples of all the Functions – All aggregate functions covered7) Creating simple and advanced Tables – with constraints and without constraints8) Keys, Index – PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX9) Inserting records(loading) – with INSERT Statement10) Updating the records of a Table – Using UPDATE statement11) Combining multiple tables – Using UNIONS12) Joining multiple columns of different tables – Using JOINs13) Modify table properties – ALTER statement14) Deleting records from the table – DELETE statement15) Removing tables from the database permanently – DROP statementNote: 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.
Overview
Section 1: Introduction
Lecture 1 Welcome and What you will learn?
Lecture 2 Prepare Sample Database
Section 2: How to select Records from a Table
Lecture 3 Simple SELECT Statement
Lecture 4 Selecting Unique Records
Lecture 5 Switch With SELECT
Lecture 6 All SQL Queries used in this Section
Section 3: Filter the Records of the Table
Lecture 7 Simple WHERE clause
Lecture 8 Comparison operators
Lecture 9 Arithmetic operators
Lecture 10 Logical operators
Lecture 11 Concatenation operators
Lecture 12 How to check for NULL values
Lecture 13 Check records within a fixed range
Lecture 14 Check records within a fixed set of values
Lecture 15 All SQL Queries used in this section
Section 4: LIKE/Wild Cards
Lecture 16 Match characters – Part 1
Lecture 17 Match characters – Part 2
Lecture 18 Match characters – Part 3
Lecture 19 Match characters – Part 4
Lecture 20 Match characters – Part 5
Lecture 21 All SQL Queries used in this section
Section 5: Sort and Limit the Result
Lecture 22 Sort based on Column names
Lecture 23 Sort based on column number
Lecture 24 Limit the Result
Lecture 25 All SQL Queries used in this Section
Section 6: Group Records and Aggregate Functions
Lecture 26 GROUP BY – Part 1
Lecture 27 GROUP BY – Part 2
Lecture 28 Let us understand about String Functions
Lecture 29 Change the case of a string and select from left or right
Lecture 30 Trim Records
Lecture 31 Compare Strings, Find lengths and Replace strings
Lecture 32 Let us understand about Numerical Functions
Lecture 33 Examples of Numerical Functions
Lecture 34 Date Function
Lecture 35 Function to add Dates
Lecture 36 Function to subtract Dates
Lecture 37 Extract part of Date
Lecture 38 Day Function
Lecture 39 Function related to hour, minute and second
Lecture 40 Now and Time Functions
Lecture 41 Month and Year Functions
Lecture 42 Datevalue Function
Lecture 43 Format Function
Lecture 44 isDate Function
Lecture 45 isNull Function
Lecture 46 isNumeric Function
Lecture 47 CurrentUser Function
Lecture 48 HAVING clause
Lecture 49 All SQL Queries used in this Section
Section 7: Data type and Naming Convention
Lecture 50 Data Types in MS Access
Lecture 51 Naming convention in MS Access
Section 8: Create Table
Lecture 52 Create Simple Table
Lecture 53 Create table with constraints
Lecture 54 NOT NULL constraint
Lecture 55 UNIQUE Constraint
Lecture 56 Primary Key
Lecture 57 Foreign Keys – Part 1
Lecture 58 Foreign Keys – Part 2
Lecture 59 Foreign Keys – Part 3
Lecture 60 UNIQUE INDEX – Part 1
Lecture 61 UNIQUE INDEX – Part 2
Lecture 62 INDEX
Lecture 63 All Queries used in this Section
Section 9: Insert Records and update records
Lecture 64 Inserting Records – Part 1
Lecture 65 Inserting Records – Part 2
Lecture 66 Inserting Records – Part 3
Lecture 67 Change an existing Record
Lecture 68 All SQL Queries used in this section
Section 10: Sub Queries
Lecture 69 Sub Queries – Part 1
Lecture 70 Sub Queries – Part 2
Lecture 71 All SQL Queries Used in this Section
Section 11: Joining or Combining columns of different Tables
Lecture 72 What is UNION and UNION ALL?
Lecture 73 Example of UNION
Lecture 74 Example of UNION ALL
Lecture 75 Implicit Joins
Lecture 76 Inner Joins
Lecture 77 Left outer join – part 1
Lecture 78 Left outer join – part 2
Lecture 79 Right outer join – part 1
Lecture 80 Right outer join – part 2
Lecture 81 Full outer join
Lecture 82 Cross Join
Lecture 83 All SQL Queries Used in this Section
Section 12: Virtual Tables
Lecture 84 Views
Lecture 85 Delete a view
Lecture 86 All SQL Queries used in this section
Section 13: Modify structure, delete Records and Remove table
Lecture 87 Assignment – Create these 4 tables
Lecture 88 Solution to the assignment – Execute these 4 SQL queries to create 4 tables
Lecture 89 Explaining all the tables which will be used to master ALTER Statement
Lecture 90 ALTER – Part 1
Lecture 91 ALTER – Part 2
Lecture 92 ALTER – Part 3
Lecture 93 Delete Records from table and drop the table
Lecture 94 All SQL Queries used in this Section
Lecture 95 Bonus Lesson : Let us stay connected
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
Course Information:
Udemy | English | 6h 9m | 2.43 GB
Created by: Sandeep Kumar
You Can See More Courses in the Developer >> Greetings from CourseDown.com