Udemy Microsoft Access SQL for Non Programmers | 8AFAD42906A1858E0BA5D4AC892F47A0383565C4

Udemy Microsoft Access SQL for Non Programmers

Name	Udemy - Microsoft Access - SQL for Non-Programmers	DOWNLOAD Copy Link
Total Size	512.4 MB
Total Files	70
Hash	8AFAD42906A1858E0BA5D4AC892F47A0383565C4

/01_-_Introduction_to_Scripting_SQL_with_Microsoft_Access/
01_-_Welcome.mp4	2.4 MB
02_-_Using_the_Exercise_Database.mp4	9.5 MB
/02_-_SELECT/
03_-_The_SELECT_Syntax.mp4	3.4 MB
3.1_-_SQL_Clauses.pdf	220.6 KB
04_-_SELECT_Statements.mp4	37.5 MB
05_-_Aliasing_Columns.mp4	9.9 MB
06_-_Lesson_Lab.pdf	447.1 KB
/03_-_WHERE/
07_-_The_WHERE_Syntax.mp4	2.3 MB
08_-_Understanding_LIKE_and_.mp4	11.2 MB
8.1_-_Wildcard_Characters_.pdf	288.6 KB
09_-_Understanding_NOT_BETWEEN...AND_IN_NULL_NOT_NULL.mp4	9.6 MB
10_-_WHERE_Part_I.mp4	26.1 MB
11_-_WHERE_Part_II.mp4	19.8 MB
12_-_Lesson_Lab.pdf	546.8 KB
/04_-_ORDER_BY/
13_-_The_ORDER_BY_Syntax.mp4	2.0 MB
14_-_ORDER_BY.mp4	22.3 MB
15_-_Lesson_Lab.pdf	374.9 KB
/05_-_Introduction_to_Aggregate_Functions/
16_-_Intro_to_Aggregate_Functions.mp4	6.4 MB
17_-_SUM.mp4	21.5 MB
18_-_AVERAGE.mp4	2.7 MB
19_-_COUNT.mp4	13.8 MB
20_-_MIN_and_MAX.mp4	9.3 MB
21_-_Lesson_Lab.pdf	536.5 KB
/06_-_Date_Functions/
22_-_Date.mp4	1.7 MB
23_-_Now.mp4	710.5 KB
24_-_Day.mp4	1.6 MB
25_-_MonthName.mp4	2.4 MB
26.1_-_Date_Part_.pdf	374.1 KB
26_-_DatePart.mp4	7.8 MB
27.1_-_Date_Add_.pdf	250.4 KB
27_-_DateAdd.mp4	5.8 MB
28.1_-_Date_Diff_.pdf	377.6 KB
28_-_DateDiff.mp4	4.1 MB
29_-_DateValues.mp4	4.2 MB
30_-_Formatting_Dates.mp4	8.8 MB
31_-_Lesson_Lab.pdf	446.1 KB
/07_-_String_Functions/
32_-_Using_CONCATENATE.mp4	4.2 MB
33_-_LCase_and_UCase.mp4	3.3 MB
34_-_Left_and_Right.mp4	3.8 MB
35_-_Mid.mp4	4.1 MB
36_-_Len.mp4	1.6 MB
37_-_Trim_LTrim_and_RTrim.mp4	2.7 MB
38_-_Replace.mp4	8.7 MB
39_-_Lesson_Lab.pdf	466.1 KB
/08_-_Updating_and_Deleting_Records/
40_-_The_UPDATE_Syntax.mp4	2.7 MB
41_-_UPDATE.mp4	32.0 MB
42_-_The_DELETE_Syntax.mp4	2.7 MB
43_-_DELETE.mp4	18.2 MB
44_-_Lesson_Lab.pdf	471.2 KB
/09_-_Subqueries/
45_-_Subqueries.mp4	23.2 MB
46_-_Lesson_Lab.pdf	369.9 KB
/10_-_Joins/
47_-_Primary_Key_and_Foreign_Key.mp4	14.0 MB
48_-_Common_Types_of_Joins.mp4	15.8 MB
49_-_The_JOIN_Syntax.mp4	7.1 MB
50_-_JOIN.mp4	42.1 MB
51_-_Aliasing_Tables_in_Joins.mp4	7.5 MB
52_-_Lesson_Lab.pdf	378.1 KB
/11_-_Tables/
53_-_The_CREATE_TABLE_Syntax.mp4	2.9 MB
54_-_Data_Types.pdf	239.4 KB
55_-_CREATE_TABLE_I.mp4	10.5 MB
56_-_CREATE_TABLE_II.mp4	6.0 MB
57_-_The_INSERT_INTO_Syntax.mp4	3.9 MB
58_-_INSERT_INTO.mp4	5.6 MB
59_-_ALTER_TABLE.mp4	7.0 MB
60_-_Lesson_Lab.pdf	464.9 KB
/12_-_Other_Clauses_and_Functions/
61_-_Using_DISTINCT.mp4	9.2 MB
62_-_USING_TOP.mp4	18.1 MB
/13_-_Test_Your_Skills/
63_-_Test_Your_Skills_Questions.pdf	342.8 KB
64_-_Test_Your_Skills_Answers.pdf	351.2 KB
65_-_Conclusion.mp4	1.7 MB
Total files 70