Udemy

Platform

English

Language

Programming Languages

Category

110+ Exercises - Python + SQL (sqlite3) - SQLite Databases

Improve your Python and SQL programming skills and solve over 110 exercises with SQLite Databases!

5.00 (8 reviews)

Students

1 hour

Content

Sep 2021

Last Update
Regular Price


What you will learn

projects: E-learning platform, Company database, Forum application

solve 110+ exercises with SQL and Python

Python + SQL (sqlite3) + csv

Python + SQL (sqlite3) + pandas

User-defined SQL functions

deal with real programming problems

work with documentation and Stack Overflow

guaranteed instructor support


Description

------------------------------------------------------------------------------

RECOMMENDED LEARNING PATH

------------------------------------------------------------------------------

PYTHON DEVELOPER:

  • 200+ Exercises - Programming in Python - from A to Z

  • 210+ Exercises - Python Standard Libraries - from A to Z

  • 150+ Exercises - Object Oriented Programming in Python - OOP

  • 150+ Exercises - Data Structures in Python - Hands-On

  • 100+ Exercises - Advanced Python Programming

  • 100+ Exercises - Unit tests in Python - unittest framework

  • 100+ Exercises - Python Programming - Data Science - NumPy

  • 100+ Exercises - Python Programming - Data Science - Pandas

  • 100+ Exercises - Python - Data Science - scikit-learn

  • 250+ Exercises - Data Science Bootcamp in Python

  • 110+ Exercises - Python + SQL (sqlite3) - SQLite Databases


SQL DEVELOPER:

  • SQL Bootcamp - Hands-On Exercises - SQLite - Part I

  • SQL Bootcamp - Hands-On Exercises - SQLite - Part II

  • 110+ Exercises - Python + SQL (sqlite3) - SQLite Databases


------------------------------------------------------------------------------

COURSE DESCRIPTION

------------------------------------------------------------------------------

110+ Exercises - Python + SQL (sqlite3) - SQLite Databases

Welcome to the course 110+ Exercises - Python + SQL (sqlite3) - SQLite Databases, where you can check your programming skills in Python and SQL. This course is designed for people who have basic knowledge in Python and SQL. It consists of over 110 exercises with solutions.


During this course you will be able to test your programming skills in Python and SQL (SQLite). This is a great test for people who want to become a Python Developer and are looking for new challenges. Exercises are also a good test for an interview. Many popular topics were covered in this course. Before taking the course, please make sure that you meet the requirements.


Don't hesitate any longer and take the challenge today!


Screenshots

110+ Exercises - Python + SQL (sqlite3) - SQLite Databases
110+ Exercises - Python + SQL (sqlite3) - SQLite Databases
110+ Exercises - Python + SQL (sqlite3) - SQLite Databases
110+ Exercises - Python + SQL (sqlite3) - SQLite Databases

Content

Configuration (optional)

Info

Google Colab + Google Drive

Google Colab + GitHub

Google Colab - Intro

Anaconda installation - Windows 10

Introduction to Spyder

Anaconda installation - Linux

Tips

A few words from the author

Starter

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

----- Project - E-learning platform -----

Intro

One-To-Many / Many-To-One

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

Exercise 5

Solution 5

Exercise 6

Solution 6

Exercise 7

Solution 7

Exercise 8

Solution 8

Exercise 9

Solution 9

Exercise 10

Solution 10

Exercise 11

Solution 11

Exercise 12

Solution 12

Exercise 13

Solution 13

Many-To-Many

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

Exercise 5

Solution 5

Exercise 6

Solution 6

Exercise 7

Solution 7

Exercise 8

Solution 8

Exercise 9

Solution 9

Exercise 10

Solution 10

Exercise 11

Solution 11

Exercise 12

Solution 12

Exercise 13

Solution 13

Exercise 14

Solution 14

Many-To-Many + additional columns

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

Exercise 5

Solution 5

Exercise 6

Solution 6

DML - Data Manipulation Language

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

SQL Injection

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

Exercise 5

Solution 5

----- Mini Projekt - Company -----

Intro

One-To-One

Exercise 1

Solution 1

Exercise 2

Solution 2

Many-To-Many

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

Exercise 5

Solution 5

Exercise 6

Solution 6

Exercise 7

Solution 7

----- Project - Forum Application -----

Intro

Forum application

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

Exercise 5

Solution 5

Exercise 6

Solution 6

Exercise 7

Solution 7

Exercise 8

Solution 8

Exercise 9

Solution 9

Exercise 10

Solution 10

Exercise 11

Solution 11

Exercise 12

Solution 12

Exercise 13

Solution 13

Exercise 14

Solution 14

Exercise 15

Solution 15

Exercise 16

Solution 16

Exercise 17

Solution 17

Exercise 18

Solution 18

Exercise 19

Solution 19

Exercise 20

Solution 20

Exercise 21

Solution 21

Exercise 22

Solution 22

Exercise 23

Solution 23

Exercise 24

Solution 24

Exercise 25

Solution 25

DML - Data Manipulation Language

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

Exercise 5

Solution 5

Exercise 6

Solution 6

Exercise 7

Solution 7

Exercise 8

Solution 8

Exercise 9

Solution 9

Exercise 10

Solution 10

----- csv + pandas -----

Intro

sqlite3 + csv

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

sqlite3 + pandas

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

Exercise 5

Solution 5

Exercise 6

Solution 6

----- User-defined functions -----

Intro

User-defined functions

Exercise 1

Solution 1

Exercise 2

Solution 2

Exercise 3

Solution 3

Exercise 4

Solution 4

Exercise 5

Solution 5

Exercise 6

Solution 6

Bonus

Discount coupons


Coupons

DateDiscountStatus
6/26/202150% OFFExpired
7/5/202150% OFFExpired
7/19/202150% OFFExpired

4108650

Udemy ID

6/8/2021

Course created date

6/26/2021

Course Indexed date
mpapadaki
Course Submitted by