| 1. SQLite in Five Minutes | |||
| 01 - A brief overview of SQLite.en.srt | 3.28 KB | ||
| 01 - A brief overview of SQLite.mp4 | 6.65 MB | ||
| 02 - Strengths of SQLite.en.srt | 2.1 KB | ||
| 02 - Strengths of SQLite.mp4 | 4.45 MB | ||
| 03 - Weaknesses of SQLite.en.srt | 1.98 KB | ||
| 03 - Weaknesses of SQLite.mp4 | 4.32 MB | ||
| 2. Create a Database | |||
| 01 - Database creation.en.srt | 4.41 KB | ||
| 01 - Database creation.mp4 | 15.61 MB | ||
| 02 - Overview of solution.en.srt | 2.56 KB | ||
| 02 - Overview of solution.mp4 | 4.12 MB | ||
| 03 - SQLite import with Firefox.en.srt | 8.25 KB | ||
| 03 - SQLite import with Firefox.mp4 | 16.59 MB | ||
| 04 - SQLite import with DB Browser for SQLite.en.srt | 4.48 KB | ||
| 04 - SQLite import with DB Browser for SQLite.mp4 | 9.2 MB | ||
| 05 - SQLite import with SQLite3 command line tool.en.srt | 17.3 KB | ||
| 05 - SQLite import with SQLite3 command line tool.mp4 | 31.97 MB | ||
| 3. Join Two Datasets | |||
| 01 - Join datasets.en.srt | 4.42 KB | ||
| 01 - Join datasets.mp4 | 10.61 MB | ||
| 02 - Overview of solution.en.srt | 5.13 KB | ||
| 02 - Overview of solution.mp4 | 7.68 MB | ||
| 03 - Import the accidents data using Python.en.srt | 10.68 KB | ||
| 03 - Import the accidents data using Python.mp4 | 23.25 MB | ||
| 04 - Import the vehicles data using Python.en.srt | 6.98 KB | ||
| 04 - Import the vehicles data using Python.mp4 | 14.93 MB | ||
| 05 - Import Excel files using Python.en.srt | 7.21 KB | ||
| 05 - Import Excel files using Python.mp4 | 14.7 MB | ||
| 06 - Calculations with SQLite and Python.en.srt | 6.92 KB | ||
| 06 - Calculations with SQLite and Python.mp4 | 14.03 MB | ||
| 07 - Code review for R.en.srt | 9.47 KB | ||
| 07 - Code review for R.mp4 | 21.44 MB | ||
| 4. Search a Database | |||
| 01 - Search a database.en.srt | 3.16 KB | ||
| 01 - Search a database.mp4 | 10.47 MB | ||
| 02 - Overview of solution.en.srt | 1.69 KB | ||
| 02 - Overview of solution.mp4 | 3.36 MB | ||
| 03 - Correct information, wrong format.en.srt | 5.89 KB | ||
| 03 - Correct information, wrong format.mp4 | 10.03 MB | ||
| 04 - Subqueries and queries in SQLite.en.srt | 11.23 KB | ||
| 04 - Subqueries and queries in SQLite.mp4 | 16.31 MB | ||
| 5. Create, Read, Update, and Delete Operations | |||
| 01 - CRUD operations.en.srt | 3.97 KB | ||
| 01 - CRUD operations.mp4 | 12.25 MB | ||
| 02 - Overview of solution.en.srt | 2.15 KB | ||
| 02 - Overview of solution.mp4 | 3.5 MB | ||
| 03 - Create records in SQLite with Python.en.srt | 9.21 KB | ||
| 03 - Create records in SQLite with Python.mp4 | 18.99 MB | ||
| 04 - Update records in SQLite with Python.en.srt | 4.86 KB | ||
| 04 - Update records in SQLite with Python.mp4 | 10.66 MB | ||
| 05 - Delete records in SQLite with Python.en.srt | 2.8 KB | ||
| 05 - Delete records in SQLite with Python.mp4 | 5.45 MB | ||
| 06 - Read records in SQLite with Python.en.srt | 2.88 KB | ||
| 06 - Read records in SQLite with Python.mp4 | 7.66 MB | ||
| 07 - CRUD operations in SQLite with R.en.srt | 7.74 KB | ||
| 07 - CRUD operations in SQLite with R.mp4 | 18.98 MB | ||
| 6. Averages and Calculations | |||
| 01 - Calculations.en.srt | 3.09 KB | ||
| 01 - Calculations.mp4 | 8.67 MB | ||
| 02 - Overview of solution.en.srt | 5.85 KB | ||
| 02 - Overview of solution.mp4 | 9.44 MB | ||
| 03 - Create a demographic split table.en.srt | 7.21 KB | ||
| 03 - Create a demographic split table.mp4 | 11.99 MB | ||
| 04 - Create a forecast.en.srt | 6.38 KB | ||
| 04 - Create a forecast.mp4 | 13.96 MB | ||
| 05 - Insights on this problem.en.srt | 3.54 KB | ||
| 05 - Insights on this problem.mp4 | 4.04 MB | ||
| Conclusion | |||
| 01 - Next steps.en.srt | 1.6 KB | ||
| 01 - Next steps.mp4 | 2.63 MB | ||
| Ex_Files_Database_Clinic_SQLite.zip | 217.93 KB | ||
| Introduction | |||
| 01 - Welcome.en.srt | 1.84 KB | ||
| 01 - Welcome.mp4 | 6.54 MB | ||
| 02 - The Database Clinic series.en.srt | 2.46 KB | ||
| 02 - The Database Clinic series.mp4 | 9.16 MB | ||
| 03 - What you should know.en.srt | 1.72 KB | ||
| 03 - What you should know.mp4 | 6.62 MB | ||
| 04 - Use the exercise files.en.srt | 1.14 KB | ||
| 04 - Use the exercise files.mp4 | 5.15 MB |
Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)
Database Clinic: SQLite
Год выпуска: 13/10/2017
Производитель: Lynda
Сайт производителя: lynda.com/SQLite-tutorials/Database-Clinic-SQLite/588032-2.html
Автор: Mark Niemann-Ross
Продолжительность: 2h 10m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: SQLite is a powerful embedded database engine that's a core storage technology in Android and iOS applications. In this installment of the Database Clinic series—in which experts and their databases of choice are pitted against a series of the same challenges— Mark Niemann-Ross demonstrates how to leverage SQLite to solve common database problems. After providing a brief overview of the strengths and weaknesses of SQLite, Mark explains how to create a database and populate it using a public dataset. He also shows how to use a SQLite database with programming languages such as Python and R, handle subqueries and queries in SQLite, and more.
Topics include:
Strengths and weaknesses of SQLite
Creating a database
Joining data sets
Calculations with SQLite and Python
Searching a database
Subqueries and queries in SQLite
CRUD operations in SQLite with R
SQLite - мощный встроенный механизм баз данных, который является основной технологией хранения данных в приложениях Android и iOS. В этом выпуске серии «Клиника базы данных», в котором эксперты и их базы данных по выбору выступают против ряда тех же задач, Марк Ниманн-Росс демонстрирует, как использовать SQLite для решения общих проблем с базой данных.
[spoiler="Содержание"]
Introduction
1. SQLite in Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
Conclusion
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG-4 1280x720 16:9 30 fps 768 kbps
Аудио: AAC 48000 Hz 160 kbps Стерео
[spoiler="Скриншоты"]
![]()
[/spoiler]
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 363.79 MB | Alex Mill | 8 years | 5 | 0 | |
| 373.37 MB | Alex Mill | 8 years | 6 | 1 |
All Comments