Master the Fundamentals of SQL with Python uDemy

Master the Fundamentals of SQL with Python | uDemy
English | Size: 915.24 MB
Category: Tutorial

Master the Fundamentals of SQL with Python
Integrating SQL based databases directly into your Python programms
4.5 (6 ratings)
99 students enrolled
Created by Maximilian Schallwig
Last updated 11/2017
English
English [Auto-generated]

About the Instructor
Maximilian Schallwig
Data Scientist

I’ve worked for over two years in physics research and mathematical analysis. I participated in two international physics competitions, where my two teammates and I won silver and gold. My thesis was in the field of Quantum Biology, focusing on analyzing the behavior of excitons at room temperature with electronic interaction.

Due to my affinity for math and statistics from my studies in physics, I tend towards data mining, processing, and analysis, which are also the things that I find most exciting.

I enjoy learning new methods and developing my skills, and am constantly studying new literature and documentation to find exciting material that can be applied in the field of data analysis.

If you want to keep up with what else I’m doing in the fields of programming, data, and data science, you can check me out at codingwithmax.

What Will I Learn?
Understand SQL databases
Integrating database interaction into your code
Be able to dynamically add and extract data from your database

Requirements
You should be comfortable with the fundamentals of python
Description
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.

Who is the target audience?
Anyone who wants to learn about database
Anyone who wants to integrate databases into their code
Anyone who wants to learn about SQL databases

Curriculum For This Course
Collapse All 9 Lectures
01:22:25

Database Setup
27:59
Course Structure and Outline
Preview
00:28
Introduction
Preview
08:16
Creating And Connecting To A Database
Preview
10:09
Navigating a Database
09:06

Managing Data
54:26
Creating and Removing Tables
10:22
Inserting Data
13:52
Getting Data
14:01
Conditional Searching of Data
07:05
Updating and Deleting Data
09:06

About WoW Team

I'm WoW Team , I love to share all the video tutorials. If you have a video tutorial, please send me, I'll post on my website. Because knowledge is not limited to, irrespective of qualifications, people join hands to help me.