Movatterモバイル変換


[0]ホーム

URL:


Packt
Search iconClose icon
Search icon CANCEL
Subscription
0
Cart icon
Your Cart(0 item)
Close icon
You have no products in your basket yet
Save more on your purchases!discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Profile icon
Account
Close icon

Change country

Modal Close icon
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timerSALE ENDS IN
0Days
:
00Hours
:
00Minutes
:
00Seconds
Home> Programming> Programming Language> Python and SQL Bible
Python and SQL Bible
Python and SQL Bible

Python and SQL Bible: From Beginner to World Expert: Unleash the true potential of data analysis and manipulation.

Arrow left icon
Profile Icon Cuantum Technologies LLC
Arrow right icon
€25.99
eBookJun 2024519 pages1st Edition
eBook
€25.99
Arrow left icon
Profile Icon Cuantum Technologies LLC
Arrow right icon
€25.99
eBookJun 2024519 pages1st Edition
eBook
€25.99
eBook
€25.99

What do you get with eBook?

Product feature iconInstant access to your Digital eBook purchase
Product feature icon Download this book inEPUB andPDF formats
Product feature iconDRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tickCompleted

Billing Address

Table of content iconView table of contents

Key benefits

  • Comprehensive coverage of Python and SQL from basics to advanced techniques.
  • Equip yourself with essential programming and data analysis skills for the tech industry.
  • Learn through detailed explanations, interactive exercises, and real-world projects.

Description

Embark on a transformative journey with this course designed to equip you with robust Python and SQL skills. Starting with an introduction to Python, you'll delve into fundamental building blocks, control flow, functions, and object-oriented programming. As you progress, you'll master data structures, file I/O, exception handling, and the Python Standard Library, ensuring a solid foundation in Python.The course then transitions to SQL, beginning with an introduction and covering basics, and proceeding to advanced querying techniques. You'll learn about database administration and how Python integrates seamlessly with SQL, enhancing your data manipulation capabilities. By combining Python with SQLAlchemy, you'll perform advanced database operations and execute complex data analysis tasks, preparing you for real-world challenges.By the end of this course, you will have developed the expertise to utilize Python and SQL for scientific computing, data analysis, and database management. This comprehensive learning path ensures you can tackle diverse projects, from basic scripting to sophisticated data operations, making you a valuable asset in the tech industry. You'll also gain hands-on experience with real-world datasets, enhancing your problem-solving skills and boosting your confidence.

Who is this book for?

This course is ideal for a wide range of learners, including technical professionals, aspiring data scientists, software developers, and database administrators looking to enhance their skill set. It's perfect for beginners with little to no programming experience, as well as those with some background in coding who want to deepen their knowledge of Python and SQL. Additionally, it serves business analysts and IT professionals aiming to leverage data analysis and database management in their roles.

What you will learn

  • Understand and apply Python fundamentals.
  • Master control flow and object-oriented programming in Python.
  • Perform advanced SQL queries and database administration.
  • Integrate Python with SQL for enhanced data manipulation.
  • Conduct complex data analysis using Python and SQLAlchemy.
  • Manage files and handle exceptions in Python effectively.

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date :Jun 14, 2024
Original Publication date :Jun 01, 2023
Length:519 pages
Edition :1st
Language :English
ISBN-13 :9781836206262
Category :
Languages :

What do you get with eBook?

Product feature iconInstant access to your Digital eBook purchase
Product feature icon Download this book inEPUB andPDF formats
Product feature iconDRM FREE - Read whenever, wherever and however you want
OR

Contact Details

Modal Close icon
Payment Processing...
tickCompleted

Billing Address

Product Details

Publication date :Jun 14, 2024
Original Publication date :Jun 01, 2023
Length:519 pages
Edition :1st
Language :English
ISBN-13 :9781836206262
Category :
Languages :
Concepts :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
€18.99billed monthly
Feature tick iconUnlimited access to Packt's library of 7,000+ practical books and videos
Feature tick iconConstantly refreshed with 50+ new titles a month
Feature tick iconExclusive Early access to books as they're written
Feature tick iconSolve problems while you work with advanced search and reference features
Feature tick iconOffline reading on the mobile app
Feature tick iconSimple pricing, no contract
€189.99billed annually
Feature tick iconUnlimited access to Packt's library of 7,000+ practical books and videos
Feature tick iconConstantly refreshed with 50+ new titles a month
Feature tick iconExclusive Early access to books as they're written
Feature tick iconSolve problems while you work with advanced search and reference features
Feature tick iconOffline reading on the mobile app
Feature tick iconChoose a DRM-free eBook or Video every month to keep
Feature tick iconPLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick iconExclusive print discounts
€264.99billed in 18 months
Feature tick iconUnlimited access to Packt's library of 7,000+ practical books and videos
Feature tick iconConstantly refreshed with 50+ new titles a month
Feature tick iconExclusive Early access to books as they're written
Feature tick iconSolve problems while you work with advanced search and reference features
Feature tick iconOffline reading on the mobile app
Feature tick iconChoose a DRM-free eBook or Video every month to keep
Feature tick iconPLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick iconExclusive print discounts

Frequently bought together


Mastering PowerShell Scripting
Mastering PowerShell Scripting
Read more
May 2024826 pages
Full star icon5 (27)
eBook
eBook
€26.98€29.99
€37.99
Python and SQL Bible
Python and SQL Bible
Read more
Jun 2024519 pages
eBook
eBook
€25.99
SQL Query Design Patterns and Best Practices
SQL Query Design Patterns and Best Practices
Read more
Mar 2023270 pages
Full star icon4.7 (11)
eBook
eBook
€17.99€20.99
€26.99
Stars icon
Total97.97
Mastering PowerShell Scripting
€37.99
Python and SQL Bible
€32.99
SQL Query Design Patterns and Best Practices
€26.99
Total97.97Stars icon

Table of Contents

25 Chapters
Who we areChevron down iconChevron up icon
Who we are
Our Philosophy:
Our Expertise:
IntroductionChevron down iconChevron up icon
Introduction
Chapter 1: Python: An IntroductionChevron down iconChevron up icon
Chapter 1: Python: An Introduction
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
Chapter 1 Conclusion
Chapter 2: Python Building BlocksChevron down iconChevron up icon
Chapter 2: Python Building Blocks
2.1 Python Syntax and Semantics
2.2 Variables and Data Types
2.3 Basic Operators
2.4 Practice Exercises
Chapter 2 Conclusion
Chapter 3: Controlling the FlowChevron down iconChevron up icon
Chapter 3: Controlling the Flow
3.1 Control Structures in Python
3.2 Error and Exception Handling
3.3 Understanding Iterables and Iterators
3.4 Practice Exercises
Chapter 3 Conclusion
Chapter 4: Functions, Modules, and PackagesChevron down iconChevron up icon
Chapter 4: Functions, Modules, and Packages
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
Chapter 4 Conclusion
Chapter 5: Deep Dive into Data StructuresChevron down iconChevron up icon
Chapter 5: Deep Dive into Data Structures
5.1 Advanced Concepts on Lists, Tuples, Sets, and Dictionaries
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
Chapter 5 Conclusion
Chapter 6: Object-Oriented Programming in PythonChevron down iconChevron up icon
Chapter 6: Object-Oriented Programming in Python
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
Chapter 6 Conclusion
Chapter 7: File I/O and Resource ManagementChevron down iconChevron up icon
Chapter 7: File I/O and Resource Management
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
Chapter 7 Conclusion
Chapter 8: Exceptional PythonChevron down iconChevron up icon
Chapter 8: Exceptional Python
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
Chapter 8 Conclusion
Chapter 9: Python Standard LibraryChevron down iconChevron up icon
Chapter 9: Python Standard Library
9.1 Overview of Python Standard Library
9.2 Exploring Some Key Libraries
9.3 Choosing the Right Libraries
9.4 Practical Exercises
Chapter 9 Conclusion
Chapter 10: Python for Scientific Computing and Data AnalysisChevron down iconChevron up icon
Chapter 10: Python for Scientific Computing and Data Analysis
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
Chapter 10: Conclusion
Chapter 11: Testing in PythonChevron down iconChevron up icon
Chapter 11: Testing in Python
11.1 Unit Testing with unittest
11.2 Mocking and Patching
11.3 Test-Driven Development
11.4 Doctest
11.5 Practical Exercises
Chapter 11 Conclusion
Chapter 12: Introduction to SQLChevron down iconChevron up icon
Chapter 12: Introduction to SQL
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
Chapter 12 Conclusion
Chapter 13: SQL BasicsChevron down iconChevron up icon
Chapter 13: SQL Basics
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
Chapter 13 Conclusion
Chapter 14: Deep Dive into SQL QueriesChevron down iconChevron up icon
Chapter 14: Deep Dive into SQL Queries
14.1 Advanced Select Queries
14.2 Joining Multiple Tables
14.3 Aggregate Functions
14.4 Practical Exercises
Chapter 14 Conclusion
Chapter 15: Advanced SQLChevron down iconChevron up icon
Chapter 15: Advanced SQL
15.1 Subqueries
15.2 Stored Procedures
15.3 Triggers
15.4 Practical Exercises
Chapter 15 Conclusion
Chapter 16: SQL for Database AdministrationChevron down iconChevron up icon
Chapter 16: SQL for Database Administration
16.1 Creating, Altering, and Dropping Tables
16.2 Database Backups and Recovery
16.3 Security and Permission Management
16.4 Practical Exercises
Chapter 16 Conclusion
Chapter 17: Python Meets SQLChevron down iconChevron up icon
Chapter 17: Python Meets SQL
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
Chapter 17 Conclusion
Chapter 18: Data Analysis with Python and SQLChevron down iconChevron up icon
Chapter 18: Data Analysis with Python and SQL
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
Chapter 18 Conclusion
Chapter 19: Advanced Database Operations with SQLAlchemyChevron down iconChevron up icon
Chapter 19: Advanced Database Operations with SQLAlchemy
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 19 Conclusion
ReferencesChevron down iconChevron up icon
References
ConclusionChevron down iconChevron up icon
Conclusion
Where to continue?Chevron down iconChevron up icon
Where to continue?
Know more about usChevron down iconChevron up icon
Know more about us

Recommendations for you

Left arrow icon
Debunking C++ Myths
Debunking C++ Myths
Read more
Dec 2024226 pages
Full star icon5 (1)
eBook
eBook
€20.99€23.99
€29.99
Go Recipes for Developers
Go Recipes for Developers
Read more
Dec 2024350 pages
eBook
eBook
€20.99€23.99
€29.99
50 Algorithms Every Programmer Should Know
50 Algorithms Every Programmer Should Know
Read more
Sep 2023538 pages
Full star icon4.5 (68)
eBook
eBook
€26.98€29.99
€37.99
€37.99
Asynchronous Programming with C++
Asynchronous Programming with C++
Read more
Nov 2024424 pages
Full star icon5 (1)
eBook
eBook
€22.99€25.99
€31.99
Modern CMake for C++
Modern CMake for C++
Read more
May 2024504 pages
Full star icon4.7 (12)
eBook
eBook
€26.98€29.99
€37.99
Learn Python Programming
Learn Python Programming
Read more
Nov 2024616 pages
Full star icon5 (1)
eBook
eBook
€20.99€23.99
€29.99
Learn to Code with Rust
Learn to Code with Rust
Read more
Nov 202457hrs 40mins
Video
Video
€56.99
Modern Python Cookbook
Modern Python Cookbook
Read more
Jul 2024818 pages
Full star icon4.9 (21)
eBook
eBook
€28.99€32.99
€41.99
Right arrow icon

People who bought this also bought

Left arrow icon
50 Algorithms Every Programmer Should Know
50 Algorithms Every Programmer Should Know
Read more
Sep 2023538 pages
Full star icon4.5 (68)
eBook
eBook
€26.98€29.99
€37.99
€37.99
Event-Driven Architecture in Golang
Event-Driven Architecture in Golang
Read more
Nov 2022384 pages
Full star icon4.9 (11)
eBook
eBook
€26.98€29.99
€37.99
The Python Workshop Second Edition
The Python Workshop Second Edition
Read more
Nov 2022600 pages
Full star icon4.6 (22)
eBook
eBook
€27.99€31.99
€38.99
Template Metaprogramming with C++
Template Metaprogramming with C++
Read more
Aug 2022480 pages
Full star icon4.6 (14)
eBook
eBook
€25.99€28.99
€35.99
Domain-Driven Design with Golang
Domain-Driven Design with Golang
Read more
Dec 2022204 pages
Full star icon4.4 (19)
eBook
eBook
€23.99€26.99
€33.99
Right arrow icon

About the author

Profile icon Cuantum Technologies LLC
Cuantum Technologies LLC
LinkedIn icon
Cuantum Technologies is a leading innovator in the realm of software development and education, with a special focus on leveraging the power of Artificial Intelligence and cutting-edge technology. They specialize in web-based software development, authoring insightful programming and AI literature, and building captivating web experiences with the intricate use of HTML, CSS, JavaScript, and Three.js. Their diverse array of products includes CuantumAI, a pioneering SaaS offering, and an array of books spanning from Python, NLP, PHP, JavaScript, and beyond. Through their services, they are constantly striving to demystify AI and technology, making it accessible, understandable, and useable for all.
Read more
See other products by Cuantum Technologies LLC
Getfree access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

How do I buy and download an eBook?Chevron down iconChevron up icon

Where there is an eBook version of a title available, you can buy it from the book details for that title. Add either the standalone eBook or the eBook and print book bundle to your shopping cart. Your eBook will show in your cart as a product on its own. After completing checkout and payment in the normal way, you will receive your receipt on the screen containing a link to a personalised PDF download file. This link will remain active for 30 days. You can download backup copies of the file by logging in to your account at any time.

If you already have Adobe reader installed, then clicking on the link will download and open the PDF file directly. If you don't, then save the PDF file on your machine and download the Reader to view it.

Please Note: Packt eBooks are non-returnable and non-refundable.

Packt eBook and Licensing When you buy an eBook from Packt Publishing, completing your purchase means you accept the terms of our licence agreement. Please read the full text of the agreement. In it we have tried to balance the need for the ebook to be usable for you the reader with our needs to protect the rights of us as Publishers and of our authors. In summary, the agreement says:

  • You may make copies of your eBook for your own use onto any machine
  • You may not pass copies of the eBook on to anyone else
How can I make a purchase on your website?Chevron down iconChevron up icon

If you want to purchase a video course, eBook or Bundle (Print+eBook) please follow below steps:

  1. Register on our website using your email address and the password.
  2. Search for the title by name or ISBN using the search option.
  3. Select the title you want to purchase.
  4. Choose the format you wish to purchase the title in; if you order the Print Book, you get a free eBook copy of the same title. 
  5. Proceed with the checkout process (payment to be made using Credit Card, Debit Cart, or PayPal)
Where can I access support around an eBook?Chevron down iconChevron up icon
  • If you experience a problem with using or installing Adobe Reader, the contact Adobe directly.
  • To view the errata for the book, see www.packtpub.com/support and view the pages for the title you have.
  • To view your account details or to download a new copy of the book go to www.packtpub.com/account
  • To contact us directly if a problem is not resolved, use www.packtpub.com/contact-us
What eBook formats do Packt support?Chevron down iconChevron up icon

Our eBooks are currently available in a variety of formats such as PDF and ePubs. In the future, this may well change with trends and development in technology, but please note that our PDFs are not Adobe eBook Reader format, which has greater restrictions on security.

You will need to use Adobe Reader v9 or later in order to read Packt's PDF eBooks.

What are the benefits of eBooks?Chevron down iconChevron up icon
  • You can get the information you need immediately
  • You can easily take them with you on a laptop
  • You can download them an unlimited number of times
  • You can print them out
  • They are copy-paste enabled
  • They are searchable
  • There is no password protection
  • They are lower price than print
  • They save resources and space
What is an eBook?Chevron down iconChevron up icon

Packt eBooks are a complete electronic version of the print edition, available in PDF and ePub formats. Every piece of content down to the page numbering is the same. Because we save the costs of printing and shipping the book to you, we are able to offer eBooks at a lower cost than print editions.

When you have purchased an eBook, simply login to your account and click on the link in Your Download Area. We recommend you saving the file to your hard drive before opening it.

For optimal viewing of our eBooks, we recommend you download and install the free Adobe Reader version 9.


[8]ページ先頭

©2009-2025 Movatter.jp