𝔖 Scriptorium
✦   LIBER   ✦

πŸ“

Python Programming and SQL: Beginners to Advanced

✍ Scribed by K, Amit


Publisher
Independently Published
Year
2023
Tongue
English
Leaves
205
Category
Library

⬇  Acquire This Volume

No coin nor oath required. For personal study only.

✦ Synopsis


his book is for beginners and experienced user to learn and understand easily Python and SQL in step by step.
It is easy to follow, very informative and interactive.The course format is perfect for someone who wants to learn the basics of Python & SQL programming quickly.

There are a lot of exercises which help to consolidate what you have learned.Right balance between the theoretical and practical knowledge.This book will guide you in easliy learning.
Whether you're a non-programmer or someone who's already familiar with programming,this is the perfect book to get you started and help you get the most out of these languages.

Writing python scripts to work successfully.This book will help you to get start with new projects.
You will find this book very useful in understanding the basics.The book provides step by step instructions to get started.

In this book you will start learning python and SQL. It is a very practical book, with real-world examples.It provides the necessary basics to get you started with both programs.
You must-have. This book is the ultimate guide for SQL and Python, and it will teach you everything you need to know from scratch.

This book written in such a way that it is not boring and is very practical.It covers almost everything beginners need to know about this language.

✦ Table of Contents


Introduction to Python

What is Python

Python is easy to connect to other components:

Python is a languague that can run on multiple platforms.

Python is very simple and easy to learn

Python is an open source language

Install Python on Windows

What is Python

Download Python

Install Python

Start with Python

Install PyDev for Eclipse

What is PyDev

Requirements

Installing PyDev

Conventions and Grammar versions in Python

Conventions in Python

Some naming rules in Python

The keywords in Python

List of special words

The common functions

Statement and Block

The rule of writing a statement on multiple lines

The rules of writing multiple statements on a line

Rule writing a string

Comment

Grammar Versions in Python

Python Tutorial for Beginners

Requirements

Create Project

Create your first module

Branching statements in Python

Comparison operators

if-else statement

Python Loops Tutorial with Examples

Overview of the loops in Python

while loop

for loop with range

Use for loop and array

Use the break statement in the loop

Use the continue statement in the loop

Use the pass statement in the loop

Use the 'else' statement with a loop

Python Function Tutorial with Examples

Python Function

Function examples

Function with required parameters

Function with default parameters

Function with Variable-Length parameter

Anonymous function

Class and Object in Python

Object Oriented in Python

Create class in Python

Constructor with default parameters

Compare objects

Attributes

Function Attributes

Built-In Class Attributes

Class's Variables

List members of a class or object

Inheritance and polymorphism in Python

Introduction

Inheritance in Python

Override method

Abstract Method

Multiple inheritance

issubclass and isinstance function

Polymorphism with function

Python exception handling Tutorial with Examples

What is Exception

Exception Hierarchy

Handling exception with try-except

try-except-finally

Re-throw exception

Exception Wrapping

Python String Tutorial with Examples

Python String

Access values in string

String is immutable

Escape Characters

String operators

Python Lists Tutorial with Examples

Python List

Access the elements of the list

Update List

Delete the elements in the list

Operators

Functions of List

Methods of List

Python Tuples Tutorial with Examples

Python Tuples

List vs Tuple

Access the elements of Tuples

Update Tuples

Operators for Tuples

Functions for Tuples

Methods

Python Dictionary Tutorial with Examples

Python Dictionary

Update Dictionary

Delete dictionary

Functions for Dictionary

Python Date Time Tutorial with Examples

Overview

The concept of Ticks

time module

datetime module

datetime.timedelta

datetime.date

Connect to MySQL Database in Python using PyMySQL

What is PyMySQL

Install PyMySQL

Sample Database

Connect MySQL from Python with PyMySQL

Query Example

Insert Example

Update Example

Delete Example

Call Procedure

Call Function


πŸ“œ SIMILAR VOLUMES


PYTHON PROGRAMMING AND SQL:Coding Course
✍ International πŸ“‚ Library πŸ“… 2023 🌐 English

"Unlock the Power of Python and SQL with a Comprehensive 5-Volume Guide: 'PYTHON PROGRAMMING AND SQL: Coding Courses from Beginner to Advanced. For Study Well'" Embark on a transformative journey through the realms of Python and SQL with this meticulously crafted 5-volume series, designed to elevat

Python Advanced Programming: The guide t
✍ Marcus Richards πŸ“‚ Library πŸ“… 2024 πŸ› Marcus Richards 🌐 English

<p>Β </p><p>If you want to learn the most modern programming language in the world, then keep reading. Python is an high-level programming language.Β It's a modern language, easy to learn and understand but very powerful.</p><p>It's a versatile programming language that is now being used on a lot o

Python for Beginners: Master Python Prog
✍ Tim Simon πŸ“‚ Library πŸ“… 2024 πŸ› Independently Published 🌐 English

This book is an essential resource for all beginners taking their first steps in Python programming and looking to expand their experience. We will start with the very basics of syntax and gradually move on to more advanced level. The topics that this guide will cover for you (with lots of code e

Python Programming and SQL: [7 in 1] The
✍ Pharell Hearst πŸ“‚ Library πŸ“… 2023 πŸ› Independently published 🌐 English

Python Programming and SQL 7-in-1 is your ticket to quick and effortless programming success. Brace yourself for a journey that will take you from beginner to expert in no time! Our goal in writing this book was to make learning to code as easy and entertaining as possible, so we included detailed i