Master the Fundamentals of SQL with Python in 90 minutes | Max Schallwig | Skillshare

Master the Fundamentals of SQL with Python in 90 minutes

Max Schallwig, Power through programming

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
10 Lessons (1h 24m)
    • 1. Course Overview

      1:21
    • 2. Course Structure and Outline

      0:28
    • 3. Introduction

      8:16
    • 4. Creating And Connecting To A Database

      10:09
    • 5. Navigating a Database

      9:06
    • 6. Creating and Removing Tables

      10:22
    • 7. Inserting Data

      13:52
    • 8. Getting Data

      14:01
    • 9. Conditional Searching of Data

      7:05
    • 10. Updating and Deleting Data

      9:06

About This Class

Python is one of the most friendly and popular programming languages. It finds applications everywhere, ranging from research, over to industry, as well as things like the entertainment industry. Programming in general allows for you to greatly reduce workload, as well as solve problems that would be impossible to solve by hand, or create great, new, and fun applications/software.

A big part of the new digital world is that everything is producing data, and storing as well as using data are becoming emerging and very important industry fields. The ability to combine data usage with programming allows for rapid development and automation, and is extremely superior when compared to systems that need manual input or data handling.

SQL is the language that you can use to interact with one major database type (SQL databases), one that is very wide-spread in today's world. 

Knowing SQL will give you a nice ability and understanding of how to handle data and databases, and being able to integrate it into Python code enables you to create great, dynamic, and automatic systems that combine the power of programming and data.

This course will be using SQLite in Python, which allows us to execute SQL commands through python, and will allow you to create, connect, use, and manage local SQL-based databases. 

37

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Max Schallwig

Power through programming

Report class