Library
Cuantum trackFull access

Python & SQL Bible

23 chapters and 119 canonical sections synced from the Cuantum content database.

Author
Cuantum Tech.
Chapters
23
Reading time
~ 24h
Level
Professional
Language
English
Edition
2025
Your progress0%
Start reading

Chapters & sections

23 chapters - 119 sections
Chapter 01

Chapter 1: Python: An Introduction

0/4
11.1 Brief History of Python12m21.2 Benefits of Python12m31.3 Python Applications12m41.4 Setting up the Python Environment and Writing Your First Python Program12m
Chapter 02

Chapter 2: Python Building Blocks

0/4
12.1. Python Syntax and Semantics - Part 112m32.2 Variables and Data Types12m42.3 Basic Operators12m52.4 Practice Exercises of Chapter 2: Python Building Blocks12m
Chapter 03

Chapter 3: Controlling the Flow

0/4
13.1 Control Structures in Python - Part 112m23.2 Error and Exception Handling12m33.3 Understanding Iterables and Iterators12m43.4 Practice Exercises12m
Chapter 04

Chapter 4: Functions, Modules, and Packages

0/5
14.1 Function Definition and Call12m24.2 Scope of Variables12m34.3 Modules and Packages12m44.4 Recursive Functions in Python12m54.5 Practical Exercises12m
Chapter 05

Chapter 5: Deep Dive into Data Structures

0/6
15.1 Advanced Concepts on Lists, Tuples, Sets, and Dictionaries - Part 112m25.2 Implementing Data Structures (Stack, Queue, Linked List, etc.)12m35.3 Built-in Data Structure Functions and Methods12m45.4 Python's Collections Module12m55.5 Mutability and Immutability12m65.6 Practical Exercises12m
Chapter 06

Chapter 6: Object-Oriented Programming in Python

0/7
16.1 Classes, Objects, and Inheritance12m26.2 Polymorphism and Encapsulation12m36.3 Python Special Functions12m46.4 Abstract Base Classes (ABCs) in Python12m56.5 Operator Overloading12m66.6 Metaclasses in Python12m76.7 Practical Exercises12m
Chapter 07

Chapter 7: File I/O and Resource Management

0/7
17.1 File Operations12m27.2 Context Managers12m37.3 Directories and Filesystems12m47.4 Working with Binary Data: The pickle and json modules12m57.5 Working with Network Connections: The socket Module12m67.6 Memory Management in Python12m77.7 Practical Exercises12m
Chapter 08

Chapter 8: Exceptional Python

0/5
18.1 Error and Exception Handling12m28.2 Defining and Raising Custom Exceptions12m38.3 Good practices related to raising and handling exceptions12m48.4 Logging in Python12m58.5 Practical Exercises12m
Chapter 09

Chapter 9: Python Standard Library

0/4
19.1 Overview of Python Standard Library12m29.2 Exploring Some Key Libraries12m39.3 Choosing the Right Libraries12m49.4 Practical Exercises12m
Chapter 10

Chapter 10: Python for Scientific Computing and Data Analysis

0/9
110.1 Introduction to NumPy, SciPy, and Matplotlib12m210.2 Digging Deeper into NumPy12m310.3 Working with SciPy12m410.4 Visualizing Data with Matplotlib12m510.5 Exploring Pandas for Data Analysis12m610.6 Introduction to Scikit-Learn12m710.7 Introduction to Statsmodels12m810.8 Introduction to TensorFlow and PyTorch12m910.9 Practical Exercises12m
Chapter 11

Chapter 11: Testing in Python

0/5
111.1 Unit Testing with unittest12m211.2 Mocking and Patching12m311.3 Test-Driven Development12m411.4 Doctest12m511.5 Practical Exercises12m
Chapter 12

Chapter 12: Introduction to SQL

0/6
112.1 Brief History of SQL12m212.2 SQL Syntax12m312.3 SQL Data Types12m412.4 SQL Operations12m512.5 SQL Queries12m612.6 Practical Exercises12m
Chapter 13

Chapter 13: SQL Basics

0/8
113.1 Creating Databases and Tables12m213.2 Inserting Data into Tables12m313.3 Selecting Data from Tables12m413.4 Updating Data in Tables12m513.5 Deleting Data from Tables12m613.6 Filtering and Sorting Query Results12m713.7 NULL Values12m813.8 Practical Exercises12m
Chapter 14

Chapter 14: Deep Dive into SQL Queries

0/4
114.1 Advanced Select Queries12m214.2 Joining Multiple Tables12m314.3 Aggregate Functions12m414.4 Practical Exercises12m
Chapter 15

Chapter 15: Advanced SQL

0/4
115.1 Subqueries12m215.2 Stored Procedures12m315.3 Triggers12m415.4 Practical Exercises12m
Chapter 16

Chapter 16: SQL for Database Administration

0/4
116.1 Creating, Altering, and Dropping Tables12m216.2 Database Backups and Recovery12m316.3 Security and Permission Management12m416.4 Practical Exercises12m
Chapter 17

Chapter 17: Python Meets SQL

0/7
117.1 Python's sqlite3 Module12m217.2 Python with MySQL12m317.3 Python with PostgreSQL12m417.4 Performing CRUD Operations12m517.5 Handling Transactions in Python12m617.6 Handling SQL Errors and Exceptions in Python12m717.7 Practical Exercises12m
Chapter 18

Chapter 18: Data Analysis with Python and SQL

0/6
118.1 Data Cleaning in Python and SQL12m218.2 Data Transformation in Python and SQL12m318.3 Data Visualization in Python and SQL12m418.4 Statistical Analysis in Python and SQL12m518.5 Integrating Python and SQL for Data Analysis12m618.6 Practical Exercises12m
Chapter 19

Chapter 19: Advanced Database Operations with SQLAlchemy

0/10
119.1 SQLAlchemy: SQL Toolkit and ORM12m219.2 Connecting to Databases12m319.3 Understanding SQLAlchemy ORM12m419.4 CRUD Operations with SQLAlchemy ORM12m519.5 Managing Relationships with SQLAlchemy ORM12m619.6 Querying with Joins in SQLAlchemy12m719.7 Transactions in SQLAlchemy12m819.8 Managing Relationships in SQLAlchemy12m919.9 SQLAlchemy SQL Expression Language12m1019.10 Practical Exercise12m
Chapter 20

Chapter 20 - Appendix A: Python Interview Questions

0/1
1Python Interview Questions12m
Chapter 21

Chapter 21 - Appendix B: SQL Interview Questions

0/1
1Appendix B: SQL Interview Questions12m
Chapter 22

Chapter 22 - Appendix C: Python Cheat Sheet

0/6
1Basic Python Syntax12m6Classes and Objects12m2Data Structures12m4Exception Handling12m5File Handling12m3List Comprehensions12m
Chapter 23

Chapter 23 - Appendix D: SQL Cheat Sheet

0/2
2CRUD Operations12m1SQL Syntax12m