امن افزار رایکا

فهرست مطالب:

Contents

Foreword

Introduction

Setting Up Python

Your First Python Program

Strings and String Methods

Numbers and Math

Functions and Loops

Finding and Fixing Code Bugs

Conditional Logic and Control Flow

Tuples, Lists, and Dictionaries

Object-Oriented Programming (OOP)

Modules and Packages

File Input and Output

Installing Packages With pip

Creating and Modifying PDF Files

Working With Databases

Interacting With the Web

Scientiрc Computing and Graphing

Graphical User Interfaces

Final Thoughts and Next Steps

فهرست مطالب کتاب Python Notes For Professionals:

Getting started with Python Language

Python Data Types

Indentation

Comments and Documentation

Date and Time

Date Formatting

Enum

Set

Simple Mathematical Operators

Bitwise Operators

Boolean Operators

Operator Precedence

Variable Scope and Binding

Conditionals

Comparisons

Loops

Arrays

Multidimensional arrays

Dictionary

List

List comprehensions

List slicing (selecting parts of lists)

groupby()

Linked lists

Linked List Node

Filter

Heapq

Tuple

Basic Input and Output

Files & Folders I/O

path

Iterables and Iterators

Functions

Defining functions with list arguments

Functional Programming in Python

Partial functions

Decorators

Classes

Metaclasses

String Formatting

String Methods

Using loops within functions

Importing modules

Difference between Module and Package

Math Module

Complex math

Collections module

Operator module

JSON Module

Sqlite3 Module

The os Module

The locale Module

Itertools Module

Asyncio Module

Random module

Functools Module

The dis module

The base64 Module

Queue Module

Deque Module

Webbrowser Module

tkinter

pyautogui module

Indexing and Slicing

Plotting with Matplotlib

graph-tool

Generators

Reduce

Map Function

Exponentiation

Searching

Sorting, Minimum and Maximum

Counting

The Print Function

Regular Expressions (Regex)

Copying data

Context Managers (“with” Statement)

The __name__ special variable

Checking Path Existence and Permissions

Creating Python packages

Usage of “pip” module: PyPI Package Manager

pip: PyPI Package Manager

Parsing Command Line arguments

Subprocess Library

py

Recursion

Type Hints

Exceptions

Raise Custom Errors / Exceptions

Commonwealth Exceptions

urllib

Web scraping with Python

HTML Parsing

Manipulating XML

Python Requests Post

Distribution

Property Objects

Overloading

Polymorphism

Method Overriding

User-Defined Methods

String representations of class instances: __str__ and __repr__ methods

Debugging

Reading and Writing CSV

Writing to CSV from String or List

Dynamic code execution with `exec` and `eval`

PyInstaller – Distributing Python Code

Data Visualization with Python

The Interpreter (Command Line Console)

*args and **kwargs

Garbage Collection

Pickle data serialisation

Binary Data

Idioms

Data Serialization

Multiprocessing

Multithreading

Processes and Threads

Python concurrency

Parallel computation

Sockets

Websockets

Sockets And Message Encryption/Decryption Between Client and Server

Python Networking

Python HTTP Server

Flask

Introduction to RabbitMQ using AMQPStorm

Descriptor

tempfile NamedTemporaryFile

Input, Subset and Output External Data Files using Pandas

Unzipping Files

Working with ZIP archives

Getting start with GZip

Stack

Working around the Global Interpreter Lock (GIL)

Deployment

Logging

Web Server Gateway Interface (WSGI)

Python Server Sent Events

Alternatives to switch statement from other languages

List destructuring (aka packing and unpacking)

Accessing Python source code and bytecode

Mixins

Attribute Access

ArcPy

Abstract Base Classes (abc)

Plugin and Extension Classes

Immutable datatypes(int, float, str, tuple and frozensets)

Incompatibilities moving from Python 2 to Python 3

2to3 tool

Non-official Python implementations

Abstract syntax tree

Unicode and bytes

Python Serial Communication (pyserial)

Neo4j and Cypher using Py2Neo

Basic Curses with Python

Templates in python

Pillow

The pass statement

CLI subcommands with precise help output

Database Access

Connecting Python to SQL Server

PostgreSQL

Python and Excel

Turtle Graphics

Python Persistence

Design Patterns

hashlib

Creating a Windows service using Python

Mutable vs Immutable (and Hashable) in Python

configparser

Optical Character Recognition

Virtual environments

Python Virtual Environment – virtualenv

Virtual environment with virtualenvwrapper

Create virtual environment with virtualenvwrapper in windows

sys

ChemPy – python package

pygame

Pyglet

Audio

pyaudio

shelve

IoT Programming with Python and Raspberry PI

kivy – Cross-platform Python Framework for NUI Development

Pandas Transform: Preform operations on groups and concatenate the results

Similarities in syntax, Differences in meaning: Python vs. JavaScript

Call Python from C#

ctypes

Writing extensions

Python Lex-Yacc

Unit Testing

test

Profiling

Python speed of program

Performance optimization

Security and Cryptography

Secure Shell Connection in Python

Python Anti-Patterns

Common Pitfalls

Hidden Features

فهرست مطالب کتاب PowerShell Notes for Professionals: 

Getting started with PowerShell

Variables in PowerShell

Operators

Special Operators

Basic Set Operations

Conditional logic

Loops

Switch statement

Strings

HashTables

Working with Objects

PowerShell Functions

PowerShell Classes

PowerShell Modules

PowerShell profiles

Calculated Properties

Using existing static classes

Built-in variables

Automatic Variables

Environment Variables

Splatting

PowerShell “Streams”; Debug, Verbose, Warning, Error, Output and Information

Sending Email

PowerShell Remoting

Working with the PowerShell pipeline

PowerShell Background Jobs

Return behavior in PowerShell

CSV parsing

Working with XML Files

Communicating with RESTful APIs

PowerShell SQL queries

Regular Expressions

Aliases

Using the progress bar

exe Command-Line

Cmdlet Naming

Running Executables

Enforcing script prerequisites

Using the Help System

Modules, Scripts and Functions

Naming Conventions

Common parameters

Parameter sets

PowerShell Dynamic Parameters

GUI in PowerShell

URL Encode/Decode

Error handling

Package management

TCP Communication with PowerShell

PowerShell Workflows

Embedding Managed Code (C# | VB)

How to download latest artifact from Artifactory using PowerShell script (v2.0 or below)?

Comment-based help

Archive Module

Infrastructure Automation

PSScriptAnalyzer – PowerShell Script Analyzer

Desired State Configuration

Using ShouldProcess

Scheduled tasks module

ISE module

Creating DSC Class-Based Resources

WMI and CIM

ActiveDirectory module

SharePoint Module

Introduction to Psake

Introduction to Pester

Handling Secrets and Credentials

Security and Cryptography

Signing Scripts

Anonymize IP (v4 and v6) in text file with PowerShell

Amazon Web Services (AWS) Rekognition

Amazon Web Services (AWS) Simple Storage Service (S3)

فهرست مطالب کتاب Microsoft SQL Server Notes for Professionals:

Getting started with Microsoft SQL Server

Data Types

Converting data types

User Defined Table Types

SELECT statement

Alias Names in SQL Server

NULLs

Variables

Dates

Generating a range of dates

Database Snapshots

COALESCE

..ELSE

CASE Statement

INSERT INTO

MERGE

CREATE VIEW

Views

UNION

TRY/CATCH

WHILE loop

OVER Clause

GROUP BY

ORDER BY

The STUFF Function

JSON in SQL Server

OPENJSON

FOR JSON

Queries with JSON data

Storing JSON in SQL tables

Modify JSON text

FOR XML PATH

Join

cross apply

Computed Columns

Common Table Expressions

Move and copy data around tables

Limit Result Set

Retrieve Information about your Instance

With Ties Option

String Functions

Logical Functions

Aggregate Functions

String Aggregate functions in SQL Server

Ranking Functions

Window functions

PIVOT / UNPIVOT

Dynamic SQL Pivot

Partitioning

Stored Procedures

Retrieve information about the database

Split String function in SQL Server

Insert

Primary Keys

Foreign Keys

Last Inserted Identity

SCOPE_IDENTITY()

Sequences

Index

Full-Text Indexing

Trigger

Cursors

Transaction isolation levels

Advanced options

Migration

Table Valued Parameters

DBMAIL

In-Memory OLTP (Hekaton)

Temporal Tables

Use of TEMP Table

Scheduled Task or Job

Isolation levels and locking

Sorting/ordering rows

Privileges or Permissions

SQLCMD

Resource Governor

File Group

Basic DDL Operations in MS SQL Server

Subqueries

Pagination

CLUSTERED COLUMNSTORE

Parsename

Installing SQL Server on Windows

Analyzing a Query

Query Hints

Query Store

Querying results by page

Schemas

Backup and Restore Database

Transaction handling

Natively compiled modules (Hekaton)

Spatial Data

Dynamic SQL

Dynamic data masking

Export data in txt file by using SQLCMD

Common Language Runtime Integration

Delimiting special characters and reserved words

DBCC

BULK Import

Service broker

Permissions and Security

Database permissions

Row-level security

Encryption

PHANTOM read

Filestream

bcp (bulk copy program) Utility

SQL Server Evolution through different versions (2000 – 2016)

SQL Server Management Studio (SSMS)

Managing Azure SQL Database

System database – TempDb

Microsoft SQL Server Management Studio Shortcut Keys