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

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

Getting started with SQL

Identifier

Data Types

NULL

Example Databases and Tables

SELECT

GROUP BY

ORDER BY

AND & OR Operators

CASE

LIKE operator

IN clause

Filter results using WHERE and HAVING

SKIP TAKE (Pagination)

EXCEPT

EXPLAIN and DESCRIBE

EXISTS CLAUSE

JOIN

UPDATE

CREATE Database

CREATE TABLE

CREATE FUNCTION

TRY/CATCH

UNION / UNION ALL

ALTER TABLE

INSERT

MERGE

cross apply, outer apply

DELETE

TRUNCATE

DROP Table

DROP or DELETE Database

Cascading Delete

GRANT and REVOKE

XML

Primary Keys

Indexes

Row number

SQL Group By vs Distinct

Finding Duplicates on a Column Subset with Detail

String Functions

Functions (Aggregate)

Functions (Scalar/Single Row)

Functions (Analytic)

Window Functions

Common Table Expressions

Views

Materialized Views

Comments

Foreign Keys

Sequence

Subqueries

Execution blocks

Stored Procedures

Triggers

Transactions

Table Design

Synonyms

Information Schema

Order of Execution

Clean Code in SQL

SQL Injection

فهرست مطالب کتاب The AI Revolution in Networking, Cybersecurity, and Emerging Technologies:

Preface

Introducing the Age of AI: Emergence, Growth, and Impact on Technology

Connected Intelligence: AI in Computer Networking

Securing the Digital Frontier: AI’s Role in Cybersecurity

AI and Collaboration: Building Bridges, Not Walls

AI in the Internet of Things (AIoT)

Revolutionizing Cloud Computing with AI

Impact of AI in Other Emerging Technologies

Index

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

Getting started with iOS Development

UILabel

UILabel text underlining

attributedText in UILabel

UIButton

UIDatePicker

UILocalNotification

UIImage

Convert NSAttributedString to UIImage

UIImagePickerController

UIImageView

Resizing UIImage

Cut a UIImage into a circle

UITableView

UITableViewController

UIRefreshControl TableView

UITableViewCell

Custom methods of selection of UITableViewCells

Custom methods of selection of UITableViewCells

UIView

Snapshot of UIView

UIAlertController

UIColor

UITextView

UITextField Delegate

UINavigationController

UIGestureRecognizer

UIBarButtonItem

UIScrollView

UIStackView

Dynamically updating a UIStackView

UIScrollView with StackView child

UIScrollView AutoLayout

UITextField

Custom UITextField

UIViewController

UISwitch

UICollectionView

UISearchController

UITabBarController

UIWebView

UIActivityViewController

UIControl – Event Handling with Blocks

UISplitViewController

UISlider

UIStoryboard

UIPageViewController

UISplitViewController

UIFont

UIDevice

Make selective UIView corners rounded

Custom UIViews from XIB files

UIBezierPath

UIPickerView

UIFeedbackGenerator

UIAppearance

UIKit Dynamics with UICollectionView

UIPheonix – easy, flexible, dynamic & highly scalable UI framework

UIKit Dynamics

UI Testing

Change Status Bar Color

UISegmentedControl

Passing Data between View Controllers

Managing the Keyboard

Checking for Network Connectivity

Accessibility

Auto Layout

MKMapView

NSArray

NSAttributedString

Convert HTML to NSAttributed string and vice verse

NSTimer

NSDate

NSNotificationCenter

NSURLSession

NSUserDefaults

NSHTTPCookieStorage

NSURLConnection

NSURL

NSData

NSInvocation

NSUserActivity

NSPredicate

NSBundle

CAAnimation

Concurrency

CAGradientLayer

Safari Services

CALayer

iOS – Implementation of XMPP with Robbie Hanson framework

Swift and Objective-C interoperability

Custom fonts

AVSpeechSynthesizer

Localization

Alamofire

iBeacon

CLLocation

Checking iOS version

Universal Links

PDF Creation in iOS

In-App Purchase

CGContext Reference

Core Location

FacebookSDK

AFNetworking

CTCallCenter

Push Notifications

Extension for rich Push Notification – iOS 10.

Rich Notifications

Key Value Coding-Key Value Observation

Initialization idioms

Storyboard

Background Modes and Events

Fastlane

CAShapeLayer

WKWebView

UUID (Universally Unique Identifier)

Categories

Handling URL Schemes

Realm

ARC (Automatic Reference Counting)

Dynamic Type

SWRevealViewController

DispatchGroup

GCD (Grand Central Dispatch)

Size Classes and Adaptivity

IBOutlets

AWS SDK

Debugging Crashes

CloudKit

GameplayKit

Xcode Build & Archive From Command Line

XCTest framework – Unit Testing

AVPlayer and AVPlayerViewController

Deep Linking in iOS

Core Graphics

Segues

EventKit

SiriKit

Contacts Framework

iOS 10 Speech Recognition API

StoreKit

Code signing

Create .ipa File to upload on appstore with Applicationloader

Size Classes and Adaptivity

MKDistanceFormatter

3D Touch

GameCenter Leaderboards

Keychain

Handle Multiple Environment using Macro

Set View Background

Block

Content Hugging/Content Compression in Autolayout

iOS Google Places API

Navigation Bar

App wide operations

CoreImage Filters

Face Detection Using CoreImage/OpenCV

MPMediaPickerDelegate

Graph (Coreplot)

FCM Messaging in Swift

Create a Custom framework in iOS

Custom Keyboard

AirDrop

SLComposeViewController

AirPrint tutorial in iOS

Carthage iOS Setup

Healthkit

Core SpotLight in iOS

Core Motion

QR Code Scanner

plist iOS

WCSessionDelegate

AppDelegate

App Submission Process

FileHandle

Basic text file I/O

iOS TTS

MPVolumeView

Objective-C Associated Objects

Passing Data between View Controllers (with MessageBox-Concept)

MVVM

Cache online images

Chain Blocks in a Queue (with MKBlockQueue)

Simulator

Background Modes

OpenGL

MVP Architecture

Configure Beacons with CoreBluetooth

Core Data

Profile with Instruments

Application rating/review request

MyLayout

Simulator Builds

Simulating Location Using GPX files iOS

SqlCipher integration

Security

App Transport Security (ATS)

Guideline to choose best iOS Architecture Patterns

Multicast Delegates

Using Image Aseets

Runtime in Objective-C

ModelPresentationStyles

CydiaSubstrate tweak

Create a video from images

Codable

Load images async

Adding a Swift Bridging Header

Creating an App ID

Swift: Changing the rootViewController in AppDelegate to present main or login/onboarding flow

فهرست مطالب کتاب 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)

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

Getting started with Java Language

Type Conversion

Getters and Setters

Reference Data Types

Java Compiler – ‘javac’

Documenting Java Code

Command line Argument Processing

The Java Command – ‘java’ and ‘javaw’

Literals

Primitive Data Types

Strings

StringBuffer

StringBuilder

String Tokenizer

Splitting a string into fixed length parts

Date Class

Dates and Time (java.time.*)

LocalTime

BigDecimal

BigInteger

NumberFormat

Bit Manipulation

Arrays

Collections

Lists

Sets

List vs Set

Maps

LinkedHashMap

WeakHashMap

SortedMap

TreeMap and TreeSet

Queues and Deques

Dequeue Interface

Enums

Enum Map

EnumSet class

Enum starting with number

Hashtable

Operators

Constructors

Object Class Methods and Constructor

Annotations

Immutable Class

Immutable Objects

Visibility (controlling access to members of a class)

Generics

Classes and Objects

Local Inner Class

Nested and Inner Classes

The java.util.Objects Class

Default Methods

Packages

Inheritance

Reference Types

Console I/O

Streams

InputStreams and OutputStreams

Readers and Writers

Preferences

Collection Factory Methods

Alternative Collections

Concurrent Collections

Choosing Collections

super keyword

Serialization

Optional

Object References

Exceptions and exception handling

Calendar and its Subclasses

Using the static keyword

Properties Class

Lambda Expressions

Basic Control Structures

BufferedWriter

New File I/O

File I/O

Scanner

Interfaces

Regular Expressions

Comparable and Comparator

Java Floating Point Operations

Currency and Money

Object Cloning

Recursion

Converting to and from Strings

Random Number Generation

Singletons

Autoboxing

2D Graphics in Java

JAXB

Class – Java Reflection

Networking

NIO – Networking

HttpURLConnection

JAX-WS

Nashorn JavaScript engine

Java Native Interface

Functional Interfaces

Fluent Interface

Remote Method Invocation (RMI)

Iterator and Iterable

Reflection API

ByteBuffer

Applets

Expressions

JSON in Java

XML Parsing using the JAXP APIs

XML XPath Evaluation

XOM – XML Object Model

Polymorphism

Encapsulation

Java Agents

Varargs (Variable Argument)

Logging (java.util.logging)

log4j / log4j2

Oracle Official Code Standard

Character encoding

Apache Commons Lang

Localization and Internationalization

Parallel programming with Fork/Join framework

Non-Access Modifiers

Process

Java Native Access

Modules

Concurrent Programming (Threads)

Executor, ExecutorService and Thread pools

ThreadLocal

Using ThreadPoolExecutor in MultiThreaded applications.

Common Java Pitfalls

Java Pitfalls – Exception usage

Java Pitfalls – Language syntax

Java Pitfalls – Threads and Concurrency

Java Pitfalls – Nulls and NullPointerException

Java Pitfalls – Performance Issues

ServiceLoader

Classloaders

Creating Images Programmatically

Atomic Types

RSA Encryption

Secure objects

Security & Cryptography

Security & Cryptography

SecurityManager

JNDI

misc.Unsafe

Java Memory Model

Java deployment

Java plugin system implementations

JavaBean

Java SE 7 Features

Java SE 8 Features

Dynamic Method Dispatch

Generating Java Code

JShell

Stack-Walking API

Sockets

Java Sockets

FTP (File Transfer Protocol)

Using Other Scripting Languages in Java

C++ Comparison

Audio

Java Print Service

CompletableFuture

Runtime Commands

Unit Testing

Asserting

Multi-Release JAR Files

Just in Time (JIT) compiler

Bytecode Modification

Disassembling and Decompiling

JMX

Java Virtual Machine (JVM)

XJC

JVM Flags

JVM Tool Interface

Java Memory Management

Java Performance Tuning

Benchmarks

FileUpload to AWS

AppDynamics and TIBCO BusinessWorks Instrumentation for Easy Integration

Installing Java (Standard Edition)

Java Editions, Versions, Releases and Distributions

The Classpath

Resources (on classpath)

فهرست مطالب کتاب 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