The Ultimate SQL Bootcamp Certification Bundle

7 Reviews
1063 Enrolled
6 Courses & 19 Hours
$21.00$1,200.00
You save 98% -

What's Included

Intro to SQLite Databases for Python Programming
  • Certification included
  • Experience level required: Beginner
  • Access 23 lectures & 1 hour of content 24/7
  • Length of time users can access this course: Lifetime

Course Curriculum

23 Lessons (1h)

  • Intro To SQLite Databases for Python Programming
    Introduction3:32
    Install python3:27
    Install sublime and git bash4:43
    Create Connectionb5:44
    Create Table10:32
    Insert Into3:11
    Insert Many3:14
    Query and Fetchall2:20
    Format Results7:34
    Primary Key3:12
    Where3:24
    Update Records5:22
    Delete1:42
    Order By3:10
    And Or3:17
    Limit2:28
    Drop Table1:46
    Our App Show All5:00
    Our App 2 Add Record3:33
    Our App 3 Delete Record3:30
    Our App 4 Add Many3:32
    Our App 5 where4:20
    Conclusion5:11

Intro to SQLite Databases for Python Programming

JE
John Elder

Instructor

John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly-traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.

Description

SQLite is one of the most popular databases and is a great database for just about all your needs. In this course, you'll learn the basics of using SQLite with Python, one of the most popular and powerful programming languages today. You'll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more. This course may require a very basic knowledge of Python programming.

  • Access 23 lectures & 1 hour of content 24/7
  • Understand how to use SQLite Databases w/ Python
  • Install Python, SQLite, Git Bash & Sublime Text
  • Learn how to explore what's in the database whenever you want
  • Create a database table & learn how to update and delete data from the database

Specs

Important Details

  • Length of time users can access this course: lifetime
  • Access options: web & mobile streaming
  • Certification of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Basic understanding of Python programming

Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.