110+ Exercises - Python + Sql (Sqlite3) - Sqlite Databases

[LeeAndro]

Last updated 7/2022MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 189.56 MB | Duration: 1h 10m

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

What you'll 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
Requirements
completion of all courses in the Python Developer learning path
completion of all courses in the SQL Developer learning path
I have courses which can assist in obtaining all the necessary skills for this course
Description
Welcome to the 110+ Exercises - Python + SQL (sqlite3) - SQLite Databases course, 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!SQLiteSQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database ee. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.SQLite is an embedded SQL database ee. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems.

Overview

Section 1: Configuration (optional)

Lecture 1 Info

Lecture 2 Requirements

Lecture 3 Google Colab + Google Drive

Lecture 4 Google Colab + GitHub

Lecture 5 Google Colab - Intro

Lecture 6 Anaconda installation - Windows 10

Lecture 7 Introduction to Spyder

Lecture 8 Anaconda installation - Linux

Section 2: Tips

Lecture 9 A few words from the author

Section 3: Starter

Lecture 10 Solution 1

Lecture 11 Solution 2

Lecture 12 Solution 3

Section 4: Project - E-learning platform

Lecture 13 Intro

Section 5: One-To-Many / Many-To-One

Lecture 14 Solution 1

Lecture 15 Solution 2

Lecture 16 Solution 3

Lecture 17 Solution 4

Lecture 18 Solution 5

Lecture 19 Solution 6

Lecture 20 Solution 7

Lecture 21 Solution 8

Lecture 22 Solution 9

Lecture 23 Solution 10

Lecture 24 Solution 11

Lecture 25 Solution 12

Lecture 26 Solution 13

Section 6: Many-To-Many

Lecture 27 Solution 1

Lecture 28 Solution 2

Lecture 29 Solution 3

Lecture 30 Solution 4

Lecture 31 Solution 5

Lecture 32 Solution 6

Lecture 33 Solution 7

Lecture 34 Solution 8

Lecture 35 Solution 9

Lecture 36 Solution 10

Lecture 37 Solution 11

Lecture 38 Solution 12

Lecture 39 Solution 13

Lecture 40 Solution 14

Section 7: Many-To-Many + additional columns

Lecture 41 Solution 1

Lecture 42 Solution 2

Lecture 43 Solution 3

Lecture 44 Solution 4

Lecture 45 Solution 5

Lecture 46 Solution 6

Section 8: DML - Data Manipulation Language

Lecture 47 Solution 1

Lecture 48 Solution 2

Lecture 49 Solution 3

Lecture 50 Solution 4

Section 9: SQL Injection

Lecture 51 Solution 1

Lecture 52 Solution 2

Lecture 53 Solution 3

Lecture 54 Solution 4

Lecture 55 Solution 5

Section 10: Mini Projekt - Company

Lecture 56 Intro

Section 11: One-To-One

Lecture 57 Solution 1

Lecture 58 Solution 2

Section 12: Many-To-Many

Lecture 59 Solution 1

Lecture 60 Solution 2

Lecture 61 Solution 3

Lecture 62 Solution 4

Lecture 63 Solution 5

Lecture 64 Solution 6

Lecture 65 Solution 7

Section 13: Project - Forum Application

Lecture 66 Intro

Section 14: Forum application

Lecture 67 Solution 1

Lecture 68 Solution 2

Lecture 69 Solution 3

Lecture 70 Solution 4

Lecture 71 Solution 5

Lecture 72 Solution 6

Lecture 73 Solution 7

Lecture 74 Solution 8

Lecture 75 Solution 9

Lecture 76 Solution 10

Lecture 77 Solution 11

Lecture 78 Solution 12

Lecture 79 Solution 13

Lecture 80 Solution 14

Lecture 81 Solution 15

Lecture 82 Solution 16

Lecture 83 Solution 17

Lecture 84 Solution 18

Lecture 85 Solution 19

Lecture 86 Solution 20

Lecture 87 Solution 21

Lecture 88 Solution 22

Lecture 89 Solution 23

Lecture 90 Solution 24

Lecture 91 Solution 25

Section 15: DML - Data Manipulation Language

Lecture 92 Solution 1

Lecture 93 Solution 2

Lecture 94 Solution 3

Lecture 95 Solution 4

Lecture 96 Solution 5

Lecture 97 Solution 6

Lecture 98 Solution 7

Lecture 99 Solution 8

Lecture 100 Solution 9

Lecture 101 Solution 10

Section 16: csv + pandas

Lecture 102 Intro

Section 17: sqlite3 + csv

Lecture 103 Solution 1

Lecture 104 Solution 2

Lecture 105 Solution 3

Section 18: sqlite3 + pandas

Lecture 106 Solution 1

Lecture 107 Solution 2

Lecture 108 Solution 3

Lecture 109 Solution 4

Lecture 110 Solution 5

Lecture 111 Solution 6

Section 19: User-defined functions

Lecture 112 Intro

Section 20: User-defined functions

Lecture 113 Solution 1

Lecture 114 Solution 2

Lecture 115 Solution 3

Lecture 116 Solution 4

Lecture 117 Solution 5

Lecture 118 Solution 6

Section 21: Bonus

Lecture 119 Bonus

everyone who wants to practice SQL and Python,everyone who wants to learn by doing,everyone who wants to prepare for an interview,data scientists / data analytics / machine learning eeers

HomePage:

Https://anonymz.com/https://www.udemy.com/course/exercises-python-sql-sqlite3-sqlite-databases/

DOWNLOAD

https://1dl.net/m6s4ebh5xvjr/rmf3pALS__110_Exerci.rar.html