» » LinuxCBT SQLite Edition Training

Information of news
  • Author: Alexandr
  • Date: 26-05-2015, 11:42
26-05-2015, 11:42

LinuxCBT SQLite Edition Training

Category: Tutorials

LinuxCBT SQLite Edition Training

LinuxCBT SQLite Edition Training
English | .MOV | aac, 44100 Hz, mono | h264, yuv420p, 1358x766, 5.00 fps | 543 Mb
Genre: eLearning

Intro to SQLite - RDBMS - Usage - Administration

Introduction - SQLite - Features
Discuss features and benefits
Identify installation footprint
Contrast SQLite with Client | Server RDBMSs
Discuss pros and cons of facility
Explore environment

SQLite Terminal Monitor Client
Pinpoint key invocation options
Enter SQLite Terminal Monitor
Contrast with MySQL Terminal Monitor
Expose RDBMS structure
Explore default schema
Create sample DBs with sample Table structures
Use various terminal features accordingly
Evaluate results

Data Types | Manifest Typing
Discuss features and benefits
Implement various Redirects
Trace behavior in appropriate logs
Contrast Redirects and other forms of URL Handling

Data Transportation
Highlight useful features
Consider transportation scenarios
Export data to a variety of formats
Import data from various sources
Ensure target DBMS configuration
Dump to MySQL and evaluate
Import from MySQL accordingly
Consider implications of pure SQL transports

SQLite - Bits and Bobs - Miscellany
Examine cross-platform operability
Compounded Queries
Table auto-incrementation considerations
Alter Table support
Table populations via $SHELL
File System space reclamation with SQL VACUUM
Witness SQL VIEWS support
Attach | Detach databases
Perform appropriate queries against sources

BASH $SHELL - SQLite Support
Discuss applicabilitiy
Generate DB and Table-space
Test manual data-captures
Author script with appropriate trappings
Alter Table space accordingly to reflect hypothetical shifts
Parse useful system data
Automate procedure

Python - SQLite - Integration
Consider features
Discuss sample usage scenarios
Review Python Interactive Mode
Generate sample connection string blocks
Test Python-SQLite connectivity
Automate data collection with Python | SQLite
Debug as needed
Evaluate results
(Buy premium account for maximum speed and resumming ability)



Site BBcode/HTML Code:
Dear visitor, you went to the site as unregistered user.
We recommend you Sign up or Login to website under your name.
Would you like to leave your comment? Please Login to your account to leave comments. Don't have an account? You can create a free account now.

Tag Cloud

archive of news

free html hit counter