SQL1: SQLite for Beginners
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.
773 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL1: SQLite for Beginners to your Wishlist.

Add to Wishlist

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.
773 students enrolled
Created by Mr. Randall Nagy
Last updated 7/2016
English
Current price: $10 Original price: $40 Discount: 75% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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!
View Curriculum
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.
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!


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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 19 Lectures Collapse All 19 Lectures 02:33:53
+
Part One: Installing & Using SQL in SQLite
9 Lectures 01:03:20
  • 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.
Preview 10:48

  • 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.
Preview 03:40

  • 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.
Preview 06:57

  • 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.
1030 - The SQLite Console
04:34

  • 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.
1040A - Database Trade-Offs, Planning & Workflow
08:27

  • 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.
1040B - Basic Database Concepts
07:41

  • 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
1050 - Creating Rows & Records
02:48

  • 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.
1060 - Normalization, Keys & Diagrams
09:32

  • 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.
1070B - Dot-Commands, SQL Expressions & Speed
08:53
+
Business Operations
10 Lectures 01:30:33
  • 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.
1500 - Real World Workflows
07:03

  • 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.
1510B - Importing & Analyzing Data
11:08

  • 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.
1520B - Database Updates & Real-World Strategies
14:38

  • 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.
1530B - Database Confidence, Migration & Optomization
11:33

  • 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.
1540B - Updates, Clauses & Primary Keys
08:30

  • 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.
1550 - SME Speak - Official Database Lingo!
06:03

  • 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.
1570 - PRAGMA & Database Management
09:02

  • 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.
1580 - Database Clones, Snapshots & Output Redirection
05:57

  • Learn how to easily create reports in popular file formats.
1590 - Report Creation
06:49

  • Review more handy “dot commands” supported by SQLite.
1599 - Additional Commands
09:50
About the Instructor
Mr. Randall Nagy
3.5 Average rating
100 Reviews
4,853 Students
12 Courses
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."