|
Обратите внимание, что наш сайт не размещает какие-либо файлы из списка. Вы не можете скачать
эти файлы или скачать torrent-файл.
|
| 01_01-Welcome.mp4 |
8.76Мб |
| 01_02-Using the exercise files.mp4 |
1.09Мб |
| 01_03-Trusting the exercise files.mp4 |
4.49Мб |
| 01_04-Explaining the challenges.mp4 |
384.61Кб |
| 02_01-The H Sport database.mp4 |
16.34Мб |
| 02_02-Understand queries.mp4 |
14.70Мб |
| 02_03-Create a query with the wizard.mp4 |
15.58Мб |
| 02_04-Modify a query with the design interface.mp4 |
22.32Мб |
| 03_01-Define query criteria.mp4 |
22.34Мб |
| 03_02-Understand comparison operators.mp4 |
11.16Мб |
| 03_03-Use wildcards in criteria.mp4 |
8.41Мб |
| 03_04-Rename the column headers.mp4 |
8.05Мб |
| 03_05-Explore the property sheet.mp4 |
19.77Мб |
| 03_06-Work with joins.mp4 |
17.85Мб |
| 03_07-Challenge Create a select query.mp4 |
1.70Мб |
| 03_08-Solution Create a select query.mp4 |
7.87Мб |
| 04_01-Understand parameter queries.mp4 |
15.88Мб |
| 04_02-Obtain parameters from forms.mp4 |
21.60Мб |
| 04_03-Use a combo box to select criteria.mp4 |
14.47Мб |
| 04_04-Challenge Gather employee emails based on department.mp4 |
1.93Мб |
| 04_05-Solution Gather employee emails based on department.mp4 |
17.54Мб |
| 05_01-Explore the Expression Builder interface.mp4 |
11.41Мб |
| 05_02-Use mathematical operators.mp4 |
17.81Мб |
| 05_03-Apply functions to text.mp4 |
22.64Мб |
| 05_04-Challenge Convert US dollars to Canadian dollars.mp4 |
1.54Мб |
| 05_05-Solution Convert US dollars to Canadian dollars.mp4 |
6.95Мб |
| 06_01-Summarize data with aggregate functions.mp4 |
11.35Мб |
| 06_02-Understand the Totals field.mp4 |
15.86Мб |
| 06_03-Use the WHERE clause.mp4 |
4.94Мб |
| 07_01-Dates as serial numbers.mp4 |
12.61Мб |
| 07_02-Select a range of dates or times.mp4 |
8.13Мб |
| 07_03-Date and time functions.mp4 |
12.32Мб |
| 07_04-Format dates.mp4 |
13.56Мб |
| 07_05-Sort dates chronologically.mp4 |
14.65Мб |
| 07_06-Obtain todays date.mp4 |
5.62Мб |
| 07_07-Calculate elapsed time with DateDiff.mp4 |
12.55Мб |
| 07_08-Calculate time intervals with DateAdd.mp4 |
10.55Мб |
| 07_09-Challenge Expand order details.mp4 |
1.74Мб |
| 07_10-Solution Expand order details.mp4 |
12.84Мб |
| 08_01-IIf conditional statement.mp4 |
5.36Мб |
| 08_02-Create an IIf function.mp4 |
15.94Мб |
| 08_03-Use the Switch function.mp4 |
16.65Мб |
| 08_04-Challenge Calculate sales price for a product line.mp4 |
1.48Мб |
| 08_05-Solution Calculate sales price for a product line.mp4 |
13.30Мб |
| 09_01-Find duplicate records.mp4 |
10.78Мб |
| 09_02-Identify unmatched records.mp4 |
9.25Мб |
| 09_03-Create an unmatched records query.mp4 |
6.96Мб |
| 09_04-Make a crosstab query.mp4 |
6.44Мб |
| 09_05-Add information to a crosstab query.mp4 |
15.41Мб |
| 09_06-Create a backup of the database.mp4 |
4.25Мб |
| 09_07-Update data with a query.mp4 |
13.29Мб |
| 09_08-Make table, delete, and append queries.mp4 |
18.94Мб |
| 10_01-Explore the basics of SQL.mp4 |
15.35Мб |
| 10_02-Create a union query to join tables.mp4 |
10.42Мб |
| 10_03-Nest SQL code in other queries.mp4 |
11.69Мб |
| 11_01-Pull random records from the database.mp4 |
7.82Мб |
| 11_02-Return records above or below the average.mp4 |
11.73Мб |
| 11_03-Process a column of values with domain functions.mp4 |
16.15Мб |
| 11_04-Challenge Identify the highest and lowest pricing markup.mp4 |
1.49Мб |
| 11_05-Solution Identify the highest and lowest pricing markup.mp4 |
9.89Мб |
| 12_01-Next steps.mp4 |
2.27Мб |
| Ex_Files_Ac2016_QueriesID.zip |
32.03Мб |