Project Files\Resources\Ch1CustomerFeed.txt |
22,010 |
6E245E0B |
Project Files\Resources\Ch1SalesInvoiceDetailFeed.txt |
147,088 |
00E9A1D6 |
Project Files\Resources\Ch1SalesInvoiceFeed.txt |
109,379 |
B7109B0B |
Project Files\Resources\Ch1StateListFeed.txt |
1,866 |
E34C2CB4 |
Project Files\Resources\ch1MovieFeed.txt |
131 |
DF47AC1E |
prodev-joessql2a.iso |
4,666,638,336 |
47A59554 |
prodev-joessql2b.iso |
4,649,555,968 |
80734B18 |
Project Files\BugCatcher\SQLQueriesBugCatcher01.pps |
243,712 |
8A483FD8 |
Project Files\BugCatcher\SQLQueriesBugCatcher02.pps |
357,376 |
110E1091 |
Project Files\BugCatcher\SQLQueriesBugCatcher03.pps |
282,624 |
CB992961 |
Project Files\BugCatcher\SQLQueriesBugCatcher04.pps |
277,504 |
B93CA96A |
Project Files\BugCatcher\SQLQueriesBugCatcher05.pps |
252,928 |
A5E2C5FD |
Project Files\BugCatcher\SQLQueriesBugCatcher06.pps |
249,344 |
E761F0FE |
Project Files\BugCatcher\SQLQueriesBugCatcher07.pps |
315,392 |
1B4567AF |
Project Files\BugCatcher\SQLQueriesBugCatcher08.pps |
177,152 |
1ECA4AEC |
Project Files\BugCatcher\SQLQueriesBugCatcher09.pps |
208,384 |
931978B8 |
Project Files\BugCatcher\SQLQueriesBugCatcher10.pps |
221,184 |
717CF816 |
Project Files\BugCatcher\SQLQueriesBugCatcher12.pps |
214,016 |
D22B1BEA |
Project Files\BugCatcher\SQLQueriesBugCatcher13.pps |
240,640 |
E507BCD7 |
Project Files\BugCatcher\SQLQueriesBugCatcher14.pps |
171,520 |
12ABAD49 |
Project Files\BugCatcher\SQLQueriesBugCatcher15.pps |
228,352 |
8D1732A8 |
Project Files\BugCatcher\SQLQueriesBugCatcher11.ppt |
237,568 |
49D2C378 |
Project Files\AnswerScripts\Lab01.1_BasicQueries.sql |
436 |
BCF808CA |
Project Files\AnswerScripts\Lab01.2_JoiningTables.sql |
479 |
D259E681 |
Project Files\AnswerScripts\Lab01.3_BCP.sql |
505 |
71D0F46A |
Project Files\AnswerScripts\Lab01.4_CreatingAndPopulatingTables.sql |
1,179 |
1E3046AE |
Project Files\AnswerScripts\Lab02.1_SortingData.sql |
650 |
68B19F07 |
Project Files\AnswerScripts\Lab02.2_TheThreeTableQuery.sql |
379 |
CEDD61D9 |
Project Files\AnswerScripts\Lab02.3_Many-to-Many_Relationships.sql |
636 |
A83F7CAB |
Project Files\AnswerScripts\Lab03.1_WorkingWithNulls.sql |
565 |
63F718E5 |
Project Files\AnswerScripts\Lab03.2_ExpressionFields.sql |
1,064 |
73427EF8 |
Project Files\AnswerScripts\Lab03.3_IdentityFields.sql |
448 |
7DF65C17 |
Project Files\AnswerScripts\Lab04.1_UsingGroupBy.sql |
921 |
F1FF890D |
Project Files\AnswerScripts\Lab04.2_FilteringAggregatedResults.sql |
474 |
942F291F |
Project Files\AnswerScripts\Lab04.3_AggregationInStoredProcedures.sql |
490 |
0DA2893E |
Project Files\AnswerScripts\Lab05.1_FindingDuplicates.sql |
511 |
74E7E129 |
Project Files\AnswerScripts\Lab05.2_TheOVER_Clause.sql |
907 |
285424A2 |
Project Files\AnswerScripts\Lab06.1_Top_n_Queries.sql |
533 |
6F21F8B1 |
Project Files\AnswerScripts\Lab06.2_Top_n_Tricks.sql |
430 |
CBD1A77F |
Project Files\AnswerScripts\Lab07.1_Rank&DenseRank.sql |
1,090 |
33B5A66A |
Project Files\AnswerScripts\Lab07.2_Row_Number.sql |
363 |
5B975493 |
Project Files\AnswerScripts\Lab07.3_NTILE.sql |
266 |
22A5AD4F |
Project Files\AnswerScripts\Lab08.1_UnionAndUnionAll.sql |
374 |
A36AA24F |
Project Files\AnswerScripts\Lab08.2_IntersectAndExcept.sql |
275 |
77294CCF |
Project Files\AnswerScripts\Lab09.1_CommonTableExpressions.sql |
550 |
5B61F845 |
Project Files\AnswerScripts\Lab09.2_AdvancedClauseCombinations.sql |
425 |
C2F74A34 |
Project Files\AnswerScripts\Lab10.1_SelfJoins.sql |
333 |
007A73A2 |
Project Files\AnswerScripts\Lab10.2_RangeHierarchies.sql |
601 |
AA775FD6 |
Project Files\AnswerScripts\Lab10.3_RecursiveQueries.sql |
581 |
3E240FCD |
Project Files\AnswerScripts\Lab11.1_BasicSubqueries.sql |
527 |
ED22BCBB |
Project Files\AnswerScripts\Lab11.2_CorrelatedSubqueries.sql |
556 |
1738A7B5 |
Project Files\AnswerScripts\Lab11.3_SubqueryExtensions.sql |
462 |
515D422A |
Project Files\AnswerScripts\Lab12.1_TruncatingData.sql |
389 |
8B485425 |
Project Files\AnswerScripts\Lab12.2_CrossApply.sql |
713 |
18C46BA6 |
Project Files\AnswerScripts\Lab12.3_OuterApply.sql |
798 |
BB7B592C |
Project Files\AnswerScripts\Lab13.1_UsingMerge.sql |
2,272 |
196ECE9B |
Project Files\AnswerScripts\Lab13.2_MergeUpdateOptions.sql |
732 |
A408D914 |
Project Files\AnswerScripts\Lab14.1_UsingOutput.sql |
939 |
FE66C159 |
Project Files\AnswerScripts\Lab14.2_OutputCodeCombinations.sql |
2,802 |
728DA42E |
Project Files\AnswerScripts\Lab15.1_StringFunctions.sql |
670 |
72F2FB8E |
Project Files\AnswerScripts\Lab15.2_TimeFunctions.sql |
781 |
D225840E |
Project Files\AnswerScripts\Lab15.3_MetadataFunctions.sql |
357 |
0DA32A71 |
Project Files\LabSetupfiles\SQLQueriesChapter01.0Setup.sql |
67,725 |
33364129 |
Project Files\LabSetupfiles\SQLQueriesChapter01.1Setup.sql |
67,631 |
BC3E9CFA |
Project Files\LabSetupfiles\SQLQueriesChapter01.2Setup.sql |
67,625 |
2B943BEE |
Project Files\LabSetupfiles\SQLQueriesChapter01.3Setup.sql |
67,833 |
079A496E |
Project Files\LabSetupfiles\SQLQueriesChapter01.4Setup.sql |
274,783 |
566D7CE1 |
Project Files\LabSetupfiles\SQLQueriesChapter02.0Setup.sql |
682,052 |
185C55D6 |
Project Files\LabSetupfiles\SQLQueriesChapter02.1Setup.sql |
682,054 |
23760F8D |
Project Files\LabSetupfiles\SQLQueriesChapter02.2Setup.sql |
682,054 |
23760F8D |
Project Files\LabSetupfiles\SQLQueriesChapter02.3Setup.sql |
682,003 |
CDE036DF |
Project Files\LabSetupfiles\SQLQueriesChapter03.0Setup.sql |
681,977 |
4796BF80 |
Project Files\LabSetupfiles\SQLQueriesChapter03.1Setup.sql |
682,375 |
02EA2EA7 |
Project Files\LabSetupfiles\SQLQueriesChapter03.2Setup.sql |
682,459 |
CD23BD8A |
Project Files\LabSetupfiles\SQLQueriesChapter03.3Setup.sql |
682,459 |
5A4AB3B5 |
Project Files\LabSetupfiles\SQLQueriesChapter04.0Setup.sql |
683,450 |
D4211A5B |
Project Files\LabSetupfiles\SQLQueriesChapter04.1Setup.sql |
681,439 |
8D6E95BF |
Project Files\LabSetupfiles\SQLQueriesChapter04.2Setup.sql |
681,441 |
ED1F9914 |
Project Files\LabSetupfiles\SQLQueriesChapter04.3Setup.sql |
681,439 |
5B9CC955 |
Project Files\LabSetupfiles\SQLQueriesChapter05.0Setup.sql |
681,794 |
493E25E0 |
Project Files\LabSetupfiles\SQLQueriesChapter05.1Setup.sql |
682,267 |
B067F365 |
Project Files\LabSetupfiles\SQLQueriesChapter05.2Setup.sql |
682,261 |
205D56D4 |
Project Files\LabSetupfiles\SQLQueriesChapter06.0Setup.sql |
682,260 |
8E5923A0 |
Project Files\LabSetupfiles\SQLQueriesChapter06.1Setup.sql |
682,261 |
205D56D4 |
Project Files\LabSetupfiles\SQLQueriesChapter06.2Setup.sql |
682,263 |
73FE512B |
Project Files\LabSetupfiles\SQLQueriesChapter07.0Setup.sql |
682,261 |
205D56D4 |
Project Files\LabSetupfiles\SQLQueriesChapter07.1Setup.sql |
682,257 |
8CE09C71 |
Project Files\LabSetupfiles\SQLQueriesChapter07.2Setup.sql |
682,259 |
A34D7D6D |
Project Files\LabSetupfiles\SQLQueriesChapter07.3Setup.sql |
682,507 |
AAEEDA33 |
Project Files\LabSetupfiles\SQLQueriesChapter08.0Setup.sql |
682,637 |
A72B0086 |
Project Files\LabSetupfiles\SQLQueriesChapter08.1Setup.sql |
682,637 |
4BBB5147 |
Project Files\LabSetupfiles\SQLQueriesChapter08.2Setup.sql |
682,641 |
B75BEAA1 |
Project Files\LabSetupfiles\SQLQueriesChapter09.0Setup.sql |
682,509 |
F6957A9E |
Project Files\LabSetupfiles\SQLQueriesChapter09.1Setup.sql |
682,511 |
61E57BA3 |
Project Files\LabSetupfiles\SQLQueriesChapter09.2Setup.sql |
682,591 |
7BE6ACFC |
Project Files\LabSetupfiles\SQLQueriesChapter10.0Setup.sql |
683,065 |
4DEDBE51 |
Project Files\LabSetupfiles\SQLQueriesChapter10.1Setup.sql |
683,134 |
31440643 |
Project Files\LabSetupfiles\SQLQueriesChapter10.2Setup.sql |
683,140 |
C88662DC |
Project Files\LabSetupfiles\SQLQueriesChapter10.3Setup.sql |
683,859 |
8B8C6AF9 |
Project Files\LabSetupfiles\SQLQueriesChapter11.0Setup.sql |
683,855 |
6B8AFF82 |
Project Files\LabSetupfiles\SQLQueriesChapter11.1Setup.sql |
683,859 |
8B8C6AF9 |
Project Files\LabSetupfiles\SQLQueriesChapter11.2Setup.sql |
683,857 |
AF26F5BC |
Project Files\LabSetupfiles\SQLQueriesChapter11.3Setup.sql |
685,743 |
81DD8436 |
Project Files\LabSetupfiles\SQLQueriesChapter12.0Setup.sql |
685,779 |
6C10EE07 |
Project Files\LabSetupfiles\SQLQueriesChapter12.1Setup.sql |
685,751 |
DA8FE7A7 |
Project Files\LabSetupfiles\SQLQueriesChapter12.2Setup.sql |
685,824 |
4ED6B276 |
Project Files\LabSetupfiles\SQLQueriesChapter12.3Setup.sql |
688,675 |
CB0F6E91 |
Project Files\LabSetupfiles\SQLQueriesChapter13.0Setup.sql |
688,268 |
3F8B1724 |
Project Files\LabSetupfiles\SQLQueriesChapter13.1Setup.sql |
689,696 |
41F478BE |
Project Files\LabSetupfiles\SQLQueriesChapter13.2Setup.sql |
692,093 |
1D6B6E4E |
Project Files\LabSetupfiles\SQLQueriesChapter14.0Setup.sql |
696,905 |
D2824003 |
Project Files\LabSetupfiles\SQLQueriesChapter14.1Setup.sql |
696,905 |
D2824003 |
Project Files\LabSetupfiles\SQLQueriesChapter14.2Setup.sql |
698,433 |
5781628B |
Project Files\AnswerScripts\SQLQueriesChapter15.0Setup.sql |
697,712 |
447296F2 |
Project Files\LabSetupfiles\SQLQueriesChapter15.0Setup.sql |
699,252 |
EC0DC273 |
Project Files\LabSetupfiles\SQLQueriesChapter15.1Setup.sql |
699,228 |
F61526AF |
Project Files\LabSetupfiles\SQLQueriesChapter15.2Setup.sql |
699,256 |
A8DC466D |
Project Files\LabSetupfiles\SQLQueriesChapter15.3Setup.sql |
699,247 |
D1B2C81C |
Project Files\AnswerScripts |
0 |
00000000 |
Project Files\BugCatcher |
0 |
00000000 |
Project Files\LabSetupfiles |
0 |
00000000 |
Project Files\Resources |
0 |
00000000 |
Project Files |
0 |
00000000 |
|
Total size: |
9,355,702,188 |
|