SQL1: SQLite for Beginners

Learn how to create, import, manage & maintain SQL data using free SQLite tools!
3.5 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
770 students enrolled
$19
$35
46% off
Take This Course
  • Lectures 19
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2016 English

Course Description

Learning how to collect data has never been easier! 

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 are the 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.

What am I going to get from this course?

  • 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!

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Part One: Installing & Using SQL in SQLite
10:48
  • Start learning how to use SQL by downloading & installing the free SQLite tools.
  • Review the difference between “textual” and “binary” file types. 
  • Understand how SQL fits into the data storage options.
03:40
  • Navigate to the SQLite website.
  • Use File Manager and DOS to locate & manage files.
  • Learn how to download & install SQLite on Microsoft Windows.
  • Practice starting & stopping the SQLite database interface.
  • Learn how to create an in-memory database.
06:57
  • Review the key advantages of using SQLite.
  • Discover the SQL trade-offs available to ensure responsive SQLite access.
  • Discover the basic data types, maximum sizes, as well as data type mapping.
  • Understand the “good / bad news” of SQLite source-code modification.
04:34
  • Learn how to start SQLite so as to create a database.
  • Practice creating a table using the SQLite3 console application.
  • Discover how to use SQLite comments, as well as other basic punctuation.
  • Learn how to backup an entire SQLite database.
08:27
  • Review the key advantage of using SQL.
  • Understand why proper primart-key management is important.
  • Review the “Classic 3” “Pick Two” trade-offs for SQL data collection.
07:41
  • Understand how Relational Databases relate to a Spreadsheet metaphor.
  • Understand the advantages of data normalization & using primary keys.
  • Review how the use of column constraints can slow-down database access.
02:48
  • Complete a hands-on activity using the SQLite Console Application.
  • Create a “MyFriends” table as discussed in the SQL Strategies section.
  • Practice SQLite table creation, dot commands & using SQL insertions
09:32
  • Discover “Railroad Diagrams” are.
  • Review the “Create Table” SQLite support diagram.
  • Understand what “BNF Syntax” is.
  • Discover how to manage “Foreign Keys” to insure “Referential Integrity.”
  • Understand when to stop normalizing data, and why it is important to do so.
  • Learn how to increase database speed by using memory databases & keys.
08:53
  • Complete a hands-on exercise designed to allow SQLite to manage row identification.
  • Prove & provide data relationships designed to test table constraints.
  • Understand how to use NULL values to activate primary key constraint.
  • Learn how to use SQLite to create the fastest table definitions.
  • Discover the proper syntax for SQLite dot commands & SQL Expressions.
Section 2: Business Operations
07:03
  • Review the real-world requirement to import data from external sources.
  • Review the 4 steps required to analyze & import foreign data.
  • Understand the importance of premeditating inbound data / workflow operations.
11:08
  • Complete a hands-on example to import & analyze over 500 quotations.
  • Review the built-in operation that allows us to quickly tally table content.
  • Use the SQL SELECT command to review all, or a subset, of table data.
  • Learn how to sort, as well as to filter, database records.
  • Discover how to create distinct “dictionaries” of column values.
14:38
  • Learn how to modify database table once they have been created.
  • Discover the limitations of table alteration using SQLite.
  • Learn how to apply default values to table & fields.
  • Understand how to modify tables without breaking legacy code.
  • Complete a hands-on exercise to import & add a unique lookup table.
  • Discover how to limit the number of rows returned from a database query.
11:33
  • Review the Quote : Author key relationship.
  • Underhand how to imbed workflow management into a single database table.
  • Review the concepts of “database confidence” and “data traceability.”
  • Learn how to use the SQL UPDATE command.
  • Complete a real world, hands-on, data migration exercise.
  • Discover the dangers, and blessings, of using SQL's DROP TABLE command.
  • Understand how to clean-up & shrink overall database size.
08:30
  • Discover how to UPDATE and DELETE data using the WHERE clause.
  • Discover how to have SQLite provide primary key values for us.
  • Understand how SQLite manages primary keys.
  • Learn how to reset & override the primary keys for your data in SQLite.
06:03
  • Delve deeper into the SQL world by learning how speak SQL Professionally.
  • Explore the data-management pattern understood by all software developers.
  • Understand the 5 command & statement types defined by the SQL Standard.
  • Learn which type of command & statements are supported by SQLite.
09:02
  • Understand the importance of allowing vendors to extend the SQL Standard.
  • Learn how to use the SQL PRAGMA so as to manage SQLite limitations & constraints.
  • Learn how to backup and restore an SQLite database in binary format.
05:57
  • Learn how to use the SQLite Console Application to support QA & R&D activities.
  • Discover how to take database snapshots, clone databases, as well as re-direct session output to an external file.
06:49
  • Learn how to easily create reports in popular file formats.
09:50
  • Review more handy “dot commands” supported by SQLite.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Mr. Randall Nagy, Consultant, Principal Engineer & Principal Trainer

I've over 30 years of experience.

"Mr. Nagy presently earns his keep in the world by providing technology mentoring, training, hands-on consulting / software development, & customized content creation services.

Mr. Nagy has served as both a Principal Trainer & Principal Software Development Engineer. His "Linked In" recommendations testify to a 30+ year track record of excellent personal communication skills, design & analysis abilities, as well as superior consulting & training results.

Though tenured, Mr. Nagy is most often described as being extremely technical, yet very personable & easy to get along with.

The author of over 26 Open-Source Projects, Mr. Nagy's hands-on experience includes topics such as C/C++, Python, SO / SOA, Security, Testing, UML, Java/JEE, .NET (C# and VB.NET), LAMP, Hadoop, jQuery, HTML 5, Android, and more. Maintaining techniques in embedded engineering, Mr. Nagy has experience creating custom training for such expert-level, high-performance technologies as IBM Rhapsody.

Technically speaking, "... from the best Service-Oriented practices to embedded engineering, I maintain an extensive hands-on skill set. From Java and C/ C++, C#, PHP, Python, Ruby, HTML 5 and Web 2.0, I have both designed and implemented architectures from the UI / RIA to the server, well into the RFC Layer. …

I also have over 150 successful training / mentoring, publication, and speaking engagements to my credit. Recent experience includes such state-of-the art technologies as Hadoop, Android, WSO2, and TFS."

Ready to start learning?
Take This Course