Workspace

Dashboard Library Academies Learning Paths

Study

Your annotations Practice AI TutorBeta

Account

Access & Billing Account

GLGuest learnerSign in

Lesson reader

Language

Python & SQL Bible

Python: An Introduction0/4

1.1 Brief History of Python 1.2 Benefits of Python 1.3 Python Applications 1.4 Setting up the Python Environment and Writing Your First Python Program

Python Building Blocks0/4

2.1. Python Syntax and Semantics - Part 1 2.2 Variables and Data Types 2.3 Basic Operators 2.4 Practice Exercises of Chapter 2: Python Building Blocks

Controlling the Flow0/4

3.1 Control Structures in Python - Part 1 3.2 Error and Exception Handling 3.3 Understanding Iterables and Iterators 3.4 Practice Exercises

Functions, Modules, and Packages0/5

4.1 Function Definition and Call 4.2 Scope of Variables 4.3 Modules and Packages 4.4 Recursive Functions in Python 4.5 Practical Exercises

Deep Dive into Data Structures0/6

5.1 Advanced Concepts on Lists, Tuples, Sets, and Dictionaries - Part 1 5.2 Implementing Data Structures (Stack, Queue, Linked List, etc.)5.3 Built-in Data Structure Functions and Methods 5.4 Python's Collections Module 5.5 Mutability and Immutability 5.6 Practical Exercises

Object-Oriented Programming in Python0/7

6.1 Classes, Objects, and Inheritance 6.2 Polymorphism and Encapsulation 6.3 Python Special Functions 6.4 Abstract Base Classes (ABCs) in Python 6.5 Operator Overloading 6.6 Metaclasses in Python 6.7 Practical Exercises

File I/O and Resource Management0/7

7.1 File Operations 7.2 Context Managers 7.3 Directories and Filesystems 7.4 Working with Binary Data: The pickle and json modules 7.5 Working with Network Connections: The socket Module 7.6 Memory Management in Python 7.7 Practical Exercises

Exceptional Python0/5

8.1 Error and Exception Handling 8.2 Defining and Raising Custom Exceptions 8.3 Good practices related to raising and handling exceptions 8.4 Logging in Python 8.5 Practical Exercises

Python Standard Library0/4

9.1 Overview of Python Standard Library 9.2 Exploring Some Key Libraries 9.3 Choosing the Right Libraries 9.4 Practical Exercises

Python for Scientific Computing and Data Analysis0/9

10.1 Introduction to NumPy, SciPy, and Matplotlib 10.2 Digging Deeper into NumPy 10.3 Working with SciPy 10.4 Visualizing Data with Matplotlib 10.5 Exploring Pandas for Data Analysis 10.6 Introduction to Scikit-Learn 10.7 Introduction to Statsmodels 10.8 Introduction to TensorFlow and PyTorch 10.9 Practical Exercises

Testing in Python0/5

11.1 Unit Testing with unittest 11.2 Mocking and Patching 11.3 Test-Driven Development 11.4 Doctest 11.5 Practical Exercises

Introduction to SQL0/6

12.1 Brief History of SQL 12.2 SQL Syntax 12.3 SQL Data Types 12.4 SQL Operations 12.5 SQL Queries 12.6 Practical Exercises

SQL Basics0/8

13.1 Creating Databases and Tables 13.2 Inserting Data into Tables 13.3 Selecting Data from Tables 13.4 Updating Data in Tables 13.5 Deleting Data from Tables 13.6 Filtering and Sorting Query Results 13.7 NULL Values 13.8 Practical Exercises

Deep Dive into SQL Queries0/4

14.1 Advanced Select Queries 14.2 Joining Multiple Tables 14.3 Aggregate Functions 14.4 Practical Exercises

Advanced SQL0/4

15.1 Subqueries 15.2 Stored Procedures 15.3 Triggers 15.4 Practical Exercises

SQL for Database Administration0/4

16.1 Creating, Altering, and Dropping Tables 16.2 Database Backups and Recovery 16.3 Security and Permission Management 16.4 Practical Exercises

Python Meets SQL0/7

17.1 Python's sqlite3 Module 17.2 Python with MySQL 17.3 Python with PostgreSQL 17.4 Performing CRUD Operations 17.5 Handling Transactions in Python 17.6 Handling SQL Errors and Exceptions in Python 17.7 Practical Exercises

Data Analysis with Python and SQL0/6

18.1 Data Cleaning in Python and SQL 18.2 Data Transformation in Python and SQL 18.3 Data Visualization in Python and SQL 18.4 Statistical Analysis in Python and SQL 18.5 Integrating Python and SQL for Data Analysis 18.6 Practical Exercises

Advanced Database Operations with SQLAlchemy0/10

19.1 SQLAlchemy: SQL Toolkit and ORM 19.2 Connecting to Databases 19.3 Understanding SQLAlchemy ORM 19.4 CRUD Operations with SQLAlchemy ORM 19.5 Managing Relationships with SQLAlchemy ORM 19.6 Querying with Joins in SQLAlchemy 19.7 Transactions in SQLAlchemy 19.8 Managing Relationships in SQLAlchemy 19.9 SQLAlchemy SQL Expression Language 19.10 Practical Exercise

Chapter 20 - Appendix A: Python Interview Questions0/1

Python Interview Questions

Chapter 21 - Appendix B: SQL Interview Questions0/1

Appendix B: SQL Interview Questions

Chapter 22 - Appendix C: Python Cheat Sheet0/6

Basic Python Syntax Data Structures List Comprehensions Exception Handling File Handling Classes and Objects

Chapter 23 - Appendix D: SQL Cheat Sheet0/2

SQL Syntax CRUD Operations

Python & SQL BibleChapter 223

List Comprehensions

Section 3 of 6-~ 1 min read-Synced from Cuantum content

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