| 001 A basic SELECT statement, using the SELECT and FROM clauses.mp4 | 58.3 MB | ||
| 001 A basic SELECT statement, using the SELECT and FROM clauses_en.vtt | 9.9 KB | ||
| 001 Adding DISTINCT into the SELECT clause.mp4 | 17.6 MB | ||
| 001 Adding DISTINCT into the SELECT clause_en.vtt | 3.5 KB | ||
| 001 GROUP BY - Adding Aggregating functions.mp4 | 15.3 MB | ||
| 001 GROUP BY - Adding Aggregating functions_en.vtt | 4.3 KB | ||
| 001 Importing or Linking data - Tables.mp4 | 65.8 MB | ||
| 001 Importing or Linking data - Tables_en.vtt | 8.2 KB | ||
| 001 Introduction.mp4 | 26.3 MB | ||
| 001 Introduction_en.vtt | 2.1 KB | ||
| 001 Missing data.mp4 | 43.5 MB | ||
| 001 Missing data_en.vtt | 5.6 KB | ||
| 001 Thank you for joining me on this course.mp4 | 23.2 MB | ||
| 001 Thank you for joining me on this course_en.vtt | 1.4 KB | ||
| 001 Where can you use SQL statements_.mp4 | 67.8 MB | ||
| 001 Where can you use SQL statements__en.vtt | 7.2 KB | ||
| 002 Adding TOP into the SELECT clause.mp4 | 15.6 MB | ||
| 002 Adding TOP into the SELECT clause_en.vtt | 3.3 KB | ||
| 002 Adding a WHERE clause.mp4 | 63.4 MB | ||
| 002 Adding a WHERE clause_en.vtt | 9.2 KB | ||
| 002 Adding a second table.mp4 | 69.8 MB | ||
| 002 Adding a second table_en.vtt | 8 KB | ||
| 002 Bonus Lecture.mp4 | 12.4 MB | ||
| 002 Bonus Lecture_en.vtt | 4.9 KB | ||
| 002 Creating a Make Table query.mp4 | 28.4 MB | ||
| 002 Creating a Make Table query_en.vtt | 4.9 KB | ||
| 002 Creating a Pass-Through query.mp4 | 22.2 MB | ||
| 002 Creating a Pass-Through query_en.vtt | 4.1 KB | ||
| 002 Using Aliases.mp4 | 27.8 MB | ||
| 002 Using Aliases_en.vtt | 8.6 KB | ||
| 002 Welcome to Udemy.html | 921.6 B | ||
| 003 Adding derived tables in the FROM clause.mp4 | 29.7 MB | ||
| 003 Adding derived tables in the FROM clause_en.vtt | 4.5 KB | ||
| 003 Different types of JOINs.mp4 | 54.7 MB | ||
| 003 Different types of JOINs_en.vtt | 6.9 KB | ||
| 003 Inserting data.mp4 | 28.8 MB | ||
| 003 Inserting data_en.vtt | 4.6 KB | ||
| 003 Introduction to Udemy.mp4 | 9.8 MB | ||
| 003 Introduction to Udemy_en.vtt | 3.5 KB | ||
| 003 Introduction to Udemy_es.vtt | 3.6 KB | ||
| 003 Summarising data with a GROUP BY clause.mp4 | 33.9 MB | ||
| 003 Summarising data with a GROUP BY clause_en.vtt | 8.7 KB | ||
| 003 Using WHERE on Text fields.mp4 | 44.7 MB | ||
| 003 Using WHERE on Text fields_en.vtt | 6.2 KB | ||
| 004 Adding a HAVING clause.mp4 | 43.2 MB | ||
| 004 Adding a HAVING clause_en.vtt | 7.5 KB | ||
| 004 Adding subqueries in the WHERE clause.mp4 | 10.7 MB | ||
| 004 Adding subqueries in the WHERE clause_en.vtt | 3 KB | ||
| 004 Deleting data.mp4 | 38.8 MB | ||
| 004 Deleting data_en.vtt | 5 KB | ||
| 004 Do you want auto-translated subtitles in more languages_.html | 2.2 KB | ||
| 004 Using WHERE on NULLs.mp4 | 27.7 MB | ||
| 004 Using WHERE on NULLs_en.vtt | 5.7 KB | ||
| 004 Writing a JOIN query.mp4 | 47 MB | ||
| 004 Writing a JOIN query_en.vtt | 5.6 KB | ||
| 005 Adding correlated queries.mp4 | 34.1 MB | ||
| 005 Adding correlated queries_en.vtt | 5.3 KB | ||
| 005 Adding some order - using the ORDER BY clause.mp4 | 52.3 MB | ||
| 005 Adding some order - using the ORDER BY clause_en.vtt | 8.2 KB | ||
| 005 Creating our demonstration database.mp4 | 12.9 MB | ||
| 005 Creating our demonstration database_en.vtt | 5.9 KB | ||
| 005 Inequality Joins.mp4 | 49.5 MB | ||
| 005 Inequality Joins_en.vtt | 9.1 KB | ||
| 005 Updating data.mp4 | 87.7 MB | ||
| 005 Updating data_en.vtt | 11 KB | ||
| 005 Using WHERE on Date fields.mp4 | 63.2 MB | ||
| 005 Using WHERE on Date fields_en.vtt | 8.1 KB | ||
| 006 Adding a third table.mp4 | 44.1 MB | ||
| 006 Adding a third table_en.vtt | 6.8 KB | ||
| 006 Creating a cross-query.mp4 | 42.2 MB | ||
| 006 Creating a cross-query_en.vtt | 6.3 KB | ||
| 006 Date_Time Functions.mp4 | 38.2 MB | ||
| 006 Date_Time Functions_en.vtt | 5.4 KB | ||
| 006 Why learn SQL_.mp4 | 8.6 MB | ||
| 006 Why learn SQL__en.vtt | 4.5 KB | ||
| 007 Adding parameters.mp4 | 66.5 MB | ||
| 007 Adding parameters_en.vtt | 12.4 KB | ||
| 007 Do I need complicated JOINs - subforms and subreports.mp4 | 64.5 MB | ||
| 007 Do I need complicated JOINs - subforms and subreports_en.vtt | 7.6 KB | ||
| 007 Maths and Text Functions.mp4 | 19.8 MB | ||
| 007 Maths and Text Functions_en.vtt | 3.4 KB | ||
| 008 Conditional functions.mp4 | 47 MB | ||
| 008 Conditional functions_en.vtt | 7.1 KB | ||
| 008 UNION and UNION ALL.mp4 | 38.9 MB | ||
| 008 UNION and UNION ALL_en.vtt | 5.8 KB | ||
| 009 What is a Data Definition query_.mp4 | 7.3 MB | ||
| 009 What is a Data Definition query__en.vtt | 2 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 89 total files | |||
SQL for Microsoft Access
https://DevCourseWeb.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.56 GB | Duration: 4h 27m
Learn how to write SQL code in Microsoft Access, so you can create more advanced Access queries
What you'll learn
Know all 6 clauses of the SELECT statement, and in which order.
Add functions and formulas into your code.
Do basic and advanced JOINs, some of which cannot be done in the graphical interface.
Create UNION queries, which also cannot be done in the graphical interface.
Requirements
You need to know how to use a computer, and hopefully know how to use a spreadsheet.
You need to know the basics of how to use Microsoft Access.
You should have MS Access 2007, 2010, 2013, 2016 or 365 installed on your computer.
Description
Do you want to learn how to write more advanced queries in Access. And do you want your queries to be portable into SQL Server and Access?
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3.8 GB | freecoursewb | 3 weeks | 23 | 3 | |
| 1.7 GB | freecoursewb | 1 month | 16 | 1 | |
| 3.3 GB | freecoursewb | 2 months | 0 | 0 | |
| 799.5 MB | freecoursewb | 2 months | 11 | 0 | |
| 2 GB | freecoursewb | 3 months | 3 | 1 |
All Comments