17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - SQL For Microsoft Access
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
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?
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~Get Your Files Here !/01 - Introduction/001 Introduction.mp4
26.3 MB
~Get Your Files Here !/01 - Introduction/001 Introduction_en.vtt
2.1 KB
~Get Your Files Here !/01 - Introduction/002 Welcome to Udemy.html
886 B
~Get Your Files Here !/01 - Introduction/003 Introduction to Udemy.mp4
9.8 MB
~Get Your Files Here !/01 - Introduction/003 Introduction to Udemy_en.vtt
3.5 KB
~Get Your Files Here !/01 - Introduction/003 Introduction to Udemy_es.vtt
3.6 KB
~Get Your Files Here !/01 - Introduction/004 Do you want auto-translated subtitles in more languages_.html
2.2 KB
~Get Your Files Here !/01 - Introduction/005 Creating our demonstration database.mp4
12.9 MB
~Get Your Files Here !/01 - Introduction/005 Creating our demonstration database_en.vtt
5.9 KB
~Get Your Files Here !/01 - Introduction/006 Why learn SQL_.mp4
8.6 MB
~Get Your Files Here !/01 - Introduction/006 Why learn SQL__en.vtt
4.5 KB
~Get Your Files Here !/02 - Let's start with SQL/001 A basic SELECT statement, using the SELECT and FROM clauses.mp4
58.3 MB
~Get Your Files Here !/02 - Let's start with SQL/001 A basic SELECT statement, using the SELECT and FROM clauses_en.vtt
9.9 KB
~Get Your Files Here !/02 - Let's start with SQL/002 Adding a WHERE clause.mp4
63.4 MB
~Get Your Files Here !/02 - Let's start with SQL/002 Adding a WHERE clause_en.vtt
9.2 KB
~Get Your Files Here !/02 - Let's start with SQL/003 Summarising data with a GROUP BY clause.mp4
33.9 MB
~Get Your Files Here !/02 - Let's start with SQL/003 Summarising data with a GROUP BY clause_en.vtt
8.7 KB
~Get Your Files Here !/02 - Let's start with SQL/004 Adding a HAVING clause.mp4
43.2 MB
~Get Your Files Here !/02 - Let's start with SQL/004 Adding a HAVING clause_en.vtt
7.5 KB
~Get Your Files Here !/02 - Let's start with SQL/005 Adding some order - using the ORDER BY clause.mp4
52.3 MB
~Get Your Files Here !/02 - Let's start with SQL/005 Adding some order - using the ORDER BY clause_en.vtt
8.2 KB
~Get Your Files Here !/03 - Adding Functions and Formulas/001 GROUP BY - Adding Aggregating functions.mp4
15.3 MB
~Get Your Files Here !/03 - Adding Functions and Formulas/001 GROUP BY - Adding Aggregating functions_en.vtt
4.3 KB
~Get Your Files Here !/03 - Adding Functions and Formulas/002 Using Aliases.mp4
27.8 MB
~Get Your Files Here !/03 - Adding Functions and Formulas/002 Using Aliases_en.vtt
8.6 KB
~Get Your Files Here !/03 - Adding Functions and Formulas/003 Using WHERE on Text fields.mp4
44.7 MB
~Get Your Files Here !/03 - Adding Functions and Formulas/003 Using WHERE on Text fields_en.vtt
6.2 KB
~Get Your Files Here !/03 - Adding Functions and Formulas/004 Using WHERE on NULLs.mp4
27.7 MB
~Get Your Files Here !/03 - Adding Functions and Formulas/004 Using WHERE on NULLs_en.vtt
5.7 KB
~Get Your Files Here !/03 - Adding Functions and Formulas/005 Using WHERE on Date fields.mp4
63.2 MB
~Get Your Files Here !/03 - Adding Functions and Formulas/005 Using WHERE on Date fields_en.vtt
8.1 KB
~Get Your Files Here !/03 - Adding Functions and Formulas/006 Date_Time Functions.mp4
38.2 MB
~Get Your Files Here !/03 - Adding Functions and Formulas/006 Date_Time Functions_en.vtt
5.4 KB
~Get Your Files Here !/03 - Adding Functions and Formulas/007 Maths and Text Functions.mp4
19.8 MB
~Get Your Files Here !/03 - Adding Functions and Formulas/007 Maths and Text Functions_en.vtt
3.4 KB
~Get Your Files Here !/03 - Adding Functions and Formulas/008 Conditional functions.mp4
47 MB
~Get Your Files Here !/03 - Adding Functions and Formulas/008 Conditional functions_en.vtt
7.1 KB
~Get Your Files Here !/04 - Adding additional tables/001 Where can you use SQL statements_.mp4
67.8 MB
~Get Your Files Here !/04 - Adding additional tables/001 Where can you use SQL statements__en.vtt
7.2 KB
~Get Your Files Here !/04 - Adding additional tables/002 Adding a second table.mp4
69.8 MB
~Get Your Files Here !/04 - Adding additional tables/002 Adding a second table_en.vtt
8 KB
~Get Your Files Here !/04 - Adding additional tables/003 Different types of JOINs.mp4
54.7 MB
~Get Your Files Here !/04 - Adding additional tables/003 Different types of JOINs_en.vtt
6.9 KB
~Get Your Files Here !/04 - Adding additional tables/004 Writing a JOIN query.mp4
47 MB
~Get Your Files Here !/04 - Adding additional tables/004 Writing a JOIN query_en.vtt
5.6 KB
~Get Your Files Here !/04 - Adding additional tables/005 Inequality Joins.mp4
49.5 MB
~Get Your Files Here !/04 - Adding additional tables/005 Inequality Joins_en.vtt
9.1 KB
~Get Your Files Here !/04 - Adding additional tables/006 Adding a third table.mp4
44.1 MB
~Get Your Files Here !/04 - Adding additional tables/006 Adding a third table_en.vtt
6.8 KB
~Get Your Files Here !/04 - Adding additional tables/007 Do I need complicated JOINs - subforms and subreports.mp4
64.5 MB
~Get Your Files Here !/04 - Adding additional tables/007 Do I need complicated JOINs - subforms and subreports_en.vtt
7.6 KB
~Get Your Files Here !/05 - Find missing data, and delete and update data/001 Missing data.mp4
43.5 MB
~Get Your Files Here !/05 - Find missing data, and delete and update data/001 Missing data_en.vtt
5.6 KB
~Get Your Files Here !/05 - Find missing data, and delete and update data/002 Creating a Make Table query.mp4
28.4 MB
~Get Your Files Here !/05 - Find missing data, and delete and update data/002 Creating a Make Table query_en.vtt
4.9 KB
~Get Your Files Here !/05 - Find missing data, and delete and update data/003 Inserting data.mp4
28.8 MB
~Get Your Files Here !/05 - Find missing data, and delete and update data/003 Inserting data_en.vtt
4.6 KB
~Get Your Files Here !/05 - Find missing data, and delete and update data/004 Deleting data.mp4
38.8 MB
~Get Your Files Here !/05 - Find missing data, and delete and update data/004 Deleting data_en.vtt
5 KB
~Get Your Files Here !/05 - Find missing data, and delete and update data/005 Updating data.mp4
87.7 MB
~Get Your Files Here !/05 - Find missing data, and delete and update data/005 Updating data_en.vtt
11 KB
~Get Your Files Here !/06 - More advanced queries/001 Adding DISTINCT into the SELECT clause.mp4
17.6 MB
~Get Your Files Here !/06 - More advanced queries/001 Adding DISTINCT into the SELECT clause_en.vtt
3.5 KB
~Get Your Files Here !/06 - More advanced queries/002 Adding TOP into the SELECT clause.mp4
15.6 MB
~Get Your Files Here !/06 - More advanced queries/002 Adding TOP into the SELECT clause_en.vtt
3.3 KB
~Get Your Files Here !/06 - More advanced queries/003 Adding derived tables in the FROM clause.mp4
29.7 MB
~Get Your Files Here !/06 - More advanced queries/003 Adding derived tables in the FROM clause_en.vtt
4.5 KB
~Get Your Files Here !/06 - More advanced queries/004 Adding subqueries in the WHERE clause.mp4
10.7 MB
~Get Your Files Here !/06 - More advanced queries/004 Adding subqueries in the WHERE clause_en.vtt
3 KB
~Get Your Files Here !/06 - More advanced queries/005 Adding correlated queries.mp4
34.1 MB
~Get Your Files Here !/06 - More advanced queries/005 Adding correlated queries_en.vtt
5.3 KB
~Get Your Files Here !/06 - More advanced queries/006 Creating a cross-query.mp4
42.2 MB
~Get Your Files Here !/06 - More advanced queries/006 Creating a cross-query_en.vtt
6.3 KB
~Get Your Files Here !/06 - More advanced queries/007 Adding parameters.mp4
66.5 MB
~Get Your Files Here !/06 - More advanced queries/007 Adding parameters_en.vtt
12.4 KB
~Get Your Files Here !/06 - More advanced queries/008 UNION and UNION ALL.mp4
38.9 MB
~Get Your Files Here !/06 - More advanced queries/008 UNION and UNION ALL_en.vtt
5.8 KB
~Get Your Files Here !/06 - More advanced queries/009 What is a Data Definition query_.mp4
7.3 MB
~Get Your Files Here !/06 - More advanced queries/009 What is a Data Definition query__en.vtt
2 KB
~Get Your Files Here !/07 - Importing Data from SQL Server/001 Importing or Linking data - Tables.mp4
65.8 MB
~Get Your Files Here !/07 - Importing Data from SQL Server/001 Importing or Linking data - Tables_en.vtt
8.2 KB
~Get Your Files Here !/07 - Importing Data from SQL Server/002 Creating a Pass-Through query.mp4
22.2 MB
~Get Your Files Here !/07 - Importing Data from SQL Server/002 Creating a Pass-Through query_en.vtt
4.1 KB
~Get Your Files Here !/08 - Conclusion/001 Thank you for joining me on this course.mp4
23.2 MB
~Get Your Files Here !/08 - Conclusion/001 Thank you for joining me on this course_en.vtt
1.4 KB
~Get Your Files Here !/08 - Conclusion/002 Bonus Lecture.mp4
12.4 MB
~Get Your Files Here !/08 - Conclusion/002 Bonus Lecture_en.vtt
