Udemy, 2016. Video MP4 (AVC: 1280x720, Audio AAC 44KHz 2ch). — Duration 2 Parts: 2.5 Hours. — Lec: 19.
Genre: eLearning
Learn how to create, import, manage & maintain SQL data using free SQLite tools! No matter if you are a casual data-collector or professional software developer, you will enjoy the fast and free features of SQLite.
In this training, you will learn not only how to install & run SQLite, but also how to create databases. -Data-laden single-files that you can use to save all types of information.
From collecting the names, birthdates, and email addresses of your friends, to capturing more detailed friend-contact events, our training will help you learn how to create professional databases & queries.
Students interested in learning how to use SQL - or the Structured Query Language - will also enjoy this training!
What Will I Learn?Learn everything you need to know to create your OWN database programs!
Understand how to create, read, update, and delete databases & database records
Discover how to use SQL - The Standard Query Language used by ALL large corporations!
Enjoy learning SQLite by working with hundreds of freely-available quotations
Learn what SQLite is, as well as what makes it one of the most popular technologies in our solar system
Understand how to use Windows commands to locate files
Learn what an "Environment Variable" is, as well how to manage them on Microsoft Windows
Learn how to backup & restoure databases
Discover how to share data using database exports & imports
Understand the terms that professional database developers use... from a professional database developer & trainer!
Requirements
You mush know how to use your computer to download software.
While OS X and Linux can be used, this training uses Microsoft Windows.
Who is the target audience?
Beginners who are interested in learning how to use SQL in a real-world context
Those who want to learn SQL, as well as the concepts professional database professionals need to know
People who want to learn SQLite effectively.