Workspace

Dashboard Library Academies Learning Paths

Study

Your annotations Practice AI TutorBeta

Account

Access & Billing Account

GLGuest learnerSign in

Lesson reader

Python & SQL Bible

01Python: An Introduction0/4

11.1 Brief History of Python 21.2 Benefits of Python 31.3 Python Applications 41.4 Setting up the Python Environment and Writing Your First Python Program

02Python Building Blocks0/4

12.1. Python Syntax and Semantics - Part 1 32.2 Variables and Data Types 42.3 Basic Operators 52.4 Practice Exercises of Chapter 2: Python Building Blocks

03Controlling the Flow0/4

13.1 Control Structures in Python - Part 1 23.2 Error and Exception Handling 33.3 Understanding Iterables and Iterators 43.4 Practice Exercises

04Functions, Modules, and Packages0/5

14.1 Function Definition and Call 24.2 Scope of Variables 34.3 Modules and Packages 44.4 Recursive Functions in Python 54.5 Practical Exercises

05Deep Dive into Data Structures0/6

15.1 Advanced Concepts on Lists, Tuples, Sets, and Dictionaries - Part 1 25.2 Implementing Data Structures (Stack, Queue, Linked List, etc.)35.3 Built-in Data Structure Functions and Methods 45.4 Python's Collections Module 55.5 Mutability and Immutability 65.6 Practical Exercises

06Object-Oriented Programming in Python0/7

16.1 Classes, Objects, and Inheritance 26.2 Polymorphism and Encapsulation 36.3 Python Special Functions 46.4 Abstract Base Classes (ABCs) in Python 56.5 Operator Overloading 66.6 Metaclasses in Python 76.7 Practical Exercises

07File I/O and Resource Management0/7

17.1 File Operations 27.2 Context Managers 37.3 Directories and Filesystems 47.4 Working with Binary Data: The pickle and json modules 57.5 Working with Network Connections: The socket Module 67.6 Memory Management in Python 77.7 Practical Exercises

08Exceptional Python0/5

18.1 Error and Exception Handling 28.2 Defining and Raising Custom Exceptions 38.3 Good practices related to raising and handling exceptions 48.4 Logging in Python 58.5 Practical Exercises

09Python Standard Library0/4

19.1 Overview of Python Standard Library 29.2 Exploring Some Key Libraries 39.3 Choosing the Right Libraries 49.4 Practical Exercises

10Python for Scientific Computing and Data Analysis0/9

110.1 Introduction to NumPy, SciPy, and Matplotlib 210.2 Digging Deeper into NumPy 310.3 Working with SciPy 410.4 Visualizing Data with Matplotlib 510.5 Exploring Pandas for Data Analysis 610.6 Introduction to Scikit-Learn 710.7 Introduction to Statsmodels 810.8 Introduction to TensorFlow and PyTorch 910.9 Practical Exercises

11Testing in Python0/5

111.1 Unit Testing with unittest 211.2 Mocking and Patching 311.3 Test-Driven Development 411.4 Doctest 511.5 Practical Exercises

12Introduction to SQL0/6

112.1 Brief History of SQL 212.2 SQL Syntax 312.3 SQL Data Types 412.4 SQL Operations 512.5 SQL Queries 612.6 Practical Exercises

13SQL Basics0/8

113.1 Creating Databases and Tables 213.2 Inserting Data into Tables 313.3 Selecting Data from Tables 413.4 Updating Data in Tables 513.5 Deleting Data from Tables 613.6 Filtering and Sorting Query Results 713.7 NULL Values 813.8 Practical Exercises

14Deep Dive into SQL Queries0/4

114.1 Advanced Select Queries 214.2 Joining Multiple Tables 314.3 Aggregate Functions 414.4 Practical Exercises

15Advanced SQL0/4

115.1 Subqueries 215.2 Stored Procedures 315.3 Triggers 415.4 Practical Exercises

16SQL for Database Administration0/4

116.1 Creating, Altering, and Dropping Tables 216.2 Database Backups and Recovery 316.3 Security and Permission Management 416.4 Practical Exercises

17Python Meets SQL0/7

117.1 Python's sqlite3 Module 217.2 Python with MySQL 317.3 Python with PostgreSQL 417.4 Performing CRUD Operations 517.5 Handling Transactions in Python 617.6 Handling SQL Errors and Exceptions in Python 717.7 Practical Exercises

18Data Analysis with Python and SQL0/6

118.1 Data Cleaning in Python and SQL 218.2 Data Transformation in Python and SQL 318.3 Data Visualization in Python and SQL 418.4 Statistical Analysis in Python and SQL 518.5 Integrating Python and SQL for Data Analysis 618.6 Practical Exercises

19Advanced Database Operations with SQLAlchemy0/10

119.1 SQLAlchemy: SQL Toolkit and ORM 219.2 Connecting to Databases 319.3 Understanding SQLAlchemy ORM 419.4 CRUD Operations with SQLAlchemy ORM 519.5 Managing Relationships with SQLAlchemy ORM 619.6 Querying with Joins in SQLAlchemy 719.7 Transactions in SQLAlchemy 819.8 Managing Relationships in SQLAlchemy 919.9 SQLAlchemy SQL Expression Language 1019.10 Practical Exercise

20Chapter 20 - Appendix A: Python Interview Questions0/1

1Python Interview Questions

21Chapter 21 - Appendix B: SQL Interview Questions0/1

1Appendix B: SQL Interview Questions

22Chapter 22 - Appendix C: Python Cheat Sheet0/6

1Basic Python Syntax 6Classes and Objects 2Data Structures 4Exception Handling 5File Handling 3List Comprehensions

23Chapter 23 - Appendix D: SQL Cheat Sheet0/2

2CRUD Operations 1SQL Syntax

Python & SQL BibleChapter 223

List Comprehensions

Section 6 of 6-~ 12 min read-Synced from Cuantum content

squares = [x**2 for x in range(10)]