Get $1 credit for every $25 spent!

The Complete SQL Database in Python Bundle

Ending In:
Add to Cart - $19
Add to Cart ($19)
$1,000
98% off
wishlist
(15)
Courses
5
Lessons
129
Enrolled
150

What's Included

Product Details

Access
Lifetime
Content
1 hours
Lessons
23

Intro to PostgreSQL Databases with PgAdmin for Beginners

Understand SQL & PostgreSQL to Create Databases and Write SQL Queries Using PostgreSQL's PgAdmin 4 Interface

By John Elder | in Online Courses

Learn how to set up and use PostgreSQL databases with the PgAdmin 4 interface in just an hour. PostgreSQL is constantly ranked as a top database for everything, from data analytics to basic web development. Postgres is pretty easy to use and you'll be amazed at how quick and easy it is to dive in and get started. With 23 lectures, you'll learn how to install pgAdmin & PostgreSQL, understand what a database is, get a pgAdmin overview, create table columns, add data to a table, learn PostgreSQL tools, and more.

  • Access 23 lectures & 1 hour of content 24/7
  • Understand how to use PostgreSQL Database w/ PgAdmin 4
  • Learn how to put data in & take data out using PgAdmin
  • Know SQL Commands such as select, where, and, or, not, order by, insert into, & more
  • Understand the basics of what a Database can do
  • Learn how to create basic reports w/ the data from your database

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.

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
  • Experience level required: basic

System Requirements

  • PC or Mac
  • Internet access required

Course Outline

  • Intro To PostgreSQL Databases With PgAdmin For Beginners
    • Introduction - 2:22
    • Install pgAdmin - 8:48
    • What Is A Database - 6:17
    • PGAdmin Overview - 5:50
    • Create Table Columns - 6:25
    • Add Data To Table - 7:02
    • Select Statements - 3:30
    • Where Clause - 3:56
    • Wildcards - 3:49
    • AND OR NOT - 2:52
    • Order By - 2:40
    • Insert Into - 2:49
    • Update - 3:05
    • Delete - 2:30
    • Limit - 3:27
    • PGAdmin Menu Explained - 5:39
    • Foreign Keys - 8:50
    • Inner Join - 7:10
    • Join Where Hack - 3:49
    • Delete Table - 2:20
    • Import Export Tables - 4:32
    • Backup Restore Entire Database - 4:48
    • Conclusion Bonus - 4:40

View Full Curriculum


Access
Lifetime
Content
2 hours
Lessons
24

Using MySQL Databases with Python

Learn MySQL Database with Python the Fast & Easy Way

By John Elder | in Online Courses

MySQL 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 MySQL 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 24 lectures & 2 hours of content 24/7
  • Understand how to use MySQL Databases w/ Python
  • Install Python, MySQL, Git Bash & MySQL Connector
  • 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

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.

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
  • Experience level required: basic

System Requirements

  • PC or Mac
  • Internet access required

Course Outline

  • Using MySQL Databases With Python
    • Introduction - 2:34
    • What Is A Database - 5:14
    • Install Python - 4:53
    • Install Git Bash - 4:20
    • Download Mysql - 4:11
    • Install Mysql and Workbench - 7:48
    • Install MySQL Connector - 4:16
    • Connect To Database In Python - 5:38
    • MySQL Workbench - 7:34
    • Create Database - 7:13
    • Create Table - 8:54
    • Insert One Record - 5:39
    • Insert Many Records - 5:39
    • Data Types - 4:51
    • Select Data From Table - 5:18
    • Formatting Results - 7:29
    • Where Clause - 4:06
    • Like and Wildcards - 2:50
    • And Or - 3:40
    • Update Records - 5:23
    • Limit and Ordering - 4:37
    • Delete Records - 2:44
    • Delete Drop Table and Backups - 5:57
    • Conclusion - 5:16

View Full Curriculum


Access
Lifetime
Content
1 hours
Lessons
33

Learn SQL with Microsoft SQL Server

Know How to Install & Use Microsoft SQL Server & Use SQL with Databases

By John Elder | in Online Courses

This course will teach you structured query language (SQL) the fast and easy way. You'll be downloading and using the free trial version of Microsoft SQL Server and learn exactly how to use it like a pro. This 33-lecture course will start with fundamental database concepts and then go with setting up and using Microsoft SQL Server. By the end of this course, you'll learn SQL, from the basic concepts to the more advanced ones.

  • Access 33 lectures & 1 hour of content 24/7
  • Download & use the free trial version of Microsoft SQL Server
  • Learn fundamental database concepts including tables, rows, columns & data types
  • Understand & use SQL w/ databases
  • 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.

    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
    • Experience level required: basic

    System Requirements

    • PC or Mac
    • Internet access required

    Course Outline

    • Learn SQL with Microsoft SQL Server
      • Introduction - 2:10
      • Database Concepts - 4:33
      • Data Types - 4:47
      • Download Install SQL Server - 3:42
      • Download Install SSMS - 3:05
      • Connect To Server - 3:36
      • System Databases - 3:16
      • Creating A Database and Table - 4:45
      • Adding Data To Table - 3:08
      • Intro To SQL - 3:25
      • Select Statements - 3:27
      • Where - 3:21
      • And or not - 3:30
      • Order By - 3:08
      • Group By - 2:52
      • Having Clause - 1:41
      • Top Clause - 2:03
      • Select Distinct - 2:29
      • Union - 3:23
      • Functions - 3:28
      • Insert Statement - 4:02
      • Update Statement - 2:58
      • Delete Statement - 2:27
      • Alter Table - 3:39
      • Null - 2:07
      • Creating a Table - 3:15
      • Drop Table - 2:50
      • Primary Key - 4:48
      • Joining Tables Intro - 4:48
      • Inner Join - 3:16
      • Left Right Outer Join - 3:47
      • Indexing - 4:43
      • Conclusion - 1:53

    View Full Curriculum


    Access
    Lifetime
    Content
    1 hours
    Lessons
    23

    Intro to SQLite Databases for Python

    Learn SQLite Database with Python the Easy Way in Just an Hour

    By John Elder | in Online Courses

    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

    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.

    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
    • Experience level required: basic

    System Requirements

    • PC or Mac
    • Internet access required

    Course Outline

    • Intro To SQLite Databases for Python Programming
      • Introduction - 3:32
      • Install python - 3:27
      • Install sublime and git bash - 4:43
      • Create Connectionb - 5:44
      • Create Table - 10:32
      • Insert Into - 3:11
      • Insert Many - 3:14
      • Query and Fetchall - 2:20
      • Format Results - 7:34
      • Primary Key - 3:12
      • Where - 3:24
      • Update Records - 5:22
      • Delete - 1:42
      • Order By - 3:10
      • And Or - 3:17
      • Limit - 2:28
      • Drop Table - 1:46
      • Our App Show All - 5:00
      • Our App 2 Add Record - 3:33
      • Our App 3 Delete Record - 3:30
      • Our App 4 Add Many - 3:32
      • Our App 5 where - 4:20
      • Conclusion - 5:11

    View Full Curriculum


    Access
    Lifetime
    Content
    2 hours
    Lessons
    26

    Intro to MySQL with Node.js: Learn to Use MySQL with Node

    Learn How to Use MySQL Databases with Node.js & Explore What These Databases Can Do

    By John Elder | in Online Courses

    MySQL 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 Node.js, one of the most popular and powerful web development platforms 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 JavaScript programming.

    • Access 26 lectures & 2 hours of content 24/7
    • Understand how to use MySQL Databases w/ Node.js
    • Install Node, MySQL, Git Bash, Wamp & MySQL module
    • 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

    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.

    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
    • Experience level required: basic

    System Requirements

    • PC or Mac
    • Internet access required

    Course Outline

    • Intro To MySQL With Node.js - Learn To Use MySQL with Node!
      • Introduction - 3:16
      • Install Node - 3:53
      • Install Wamp - 6:09
      • Sublime and Git Bash - 4:35
      • Start Sublime and Bash - 5:24
      • NPM Install Mysql - 3:33
      • Create Connection - 6:55
      • Create Database - 6:09
      • Create Table - 7:34
      • Alter Table - 3:53
      • Insert Into Table - 5:04
      • Insert Many Into Table - 3:47
      • Result Messages - 3:09
      • Select All - 5:31
      • Loop Thru Selected - 4:05
      • Select Specific - 3:14
      • Select Fields - 7:05
      • Where Clause - 6:32
      • And Or - 4:00
      • Where Variables - 3:14
      • Order By - 5:24
      • Delete Record - 4:11
      • Update Records - 4:41
      • Limit Records - 3:40
      • Drop Table - 4:24
      • Conclusion - 6:24

    View Full Curriculum



    Terms

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