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

  • Post category:StudyBullet-5
  • Reading time:15 mins read


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

  • 250+ Questions – Job Interview – Python Developer

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

  • 200+ Questions – Job Interview – SQL Developer

JOB INTERVIEW SERIES:

  • 250+ Questions – Job Interview – Python Developer

  • 200+ Questions – Job Interview – SQL Developer

  • 200+ Questions – Job Interview – Software Developer – Git

  • 200+ Questions – Job Interview – Data Scientist

——————————————————————————


Get Instant Notification of New Courses on our Telegram channel.


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!

English
language

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
Enroll for Free

💠 Follow this Video to Get Free Courses on Every Udemy Topics! 💠

Tags: , , , , ,