Programming 5 Books in 1 Learn Python, JavaScript, C++, C, and SQL Quickly (Code Quickly [Quickly, Code]) (z-library.sk, 1lib.sk, z-lib.sk)

📄 File Format: PDF

💾 File Size: 28.8 MB

📖 Read Online ⬇️ Download

Registered users can read the full content for free

Register as a Gaohf Library member to read the complete e-book online for free and enjoy a better reading experience.

📄 Page 1

(This page has no text content)

📄 Page 2

Programming: 5 Books in 1 Learn Python, JavaScript, C++, C#, and SQL Quickly (Coding Crash Course With Hands-On Projects)

📄 Page 3

Code Quickly

📄 Page 4

Table of Contents Book 1: Learn Python Quickly Foreword Chapter 1: Introducing Python 1.1 - What is Python? 1.2 - Why Learn Python? 1.3 - A Note on Python Versions 1.4 - Installing Python 1.5 - Definitions: Interpreter, Terminal, Shell, IDE 1.6 - The Python Interpreter 1.7 - Using an IDE 1.8 - Using PyCharm 1.9 - Good Programming Practices 1.10 - Writing Comments in Python Chapter 2: Variables and Operators 2.1 - Variables 2.2 - Operators 2.3 - Combining Operators Chapter 3: Data Types 3.1 - Data Types 3.2 - String Manipulation 3.3 - String Formatting 3.4 - Type Casting 3.5 - Assignment and Formatting Exercise Chapter 4: Data Structures

📄 Page 5

4.1 - Lists 4.2 - Tuples 4.3 - Dictionaries 4.4 - Data Structures Exercise Chapter 5: Inputs, Printing, and Formatting Outputs 5.1 - Inputs 5.2 - Printing and Formatting Outputs 5.3 - Input and Formatting Exercise Chapter 6: Conditional Statements and Control Flow Statements 6.1 - Handling Conditions 6.2 - Conditional Statements 6.3 - Control Flow Statements 6.4 - If Statement 6.5 - For Loops and While 6.6 - Recursion Vs. Iteration 6.7 - Break/Continue 6.8 - Try/Except 6.9 - Predefined Errors 6.10 - For Loops and Errors Exercise Chapter 7: Functions and Modules 7.1 - Functions 7.2 - Creating Your Own Functions 7.3 - Variable Scope 7.4 - Default Parameters 7.5 - Variable-Length Arguments - Lists and Keywords (*args and **kwargs) 7.6 - Importing Modules 7.7 - Creating Modules 7.8 - Useful Built-In Functions and Methods

📄 Page 6

7.9 - Functions and Imports Exercise Chapter 8: Object-Oriented Programming Part 1 - Classes and Instances 8.1 - What are Classes? 8.2 - Creating Classes 8.3 - Class Variables and Instance Variables 8.4 - Class Methods and Static Methods Chapter 9: Object-Oriented Programming Part 2 - Inheritance, Child Classes, and Special Methods 9.1 - Inheritance 9.2 - Multiple Inheritance 9.3 - Importing Classes 9.4 - Python Special Methods 9.5 - Classes and Methods Exercise Chapter 10: Files 10.1 Opening and Reading 10.2 - Writing to Text Files 10.3 - Buffer Size/Binary Files 10.4 - Deleting and Renaming Chapter 11: Intermediate and Advanced Concepts 11.1 - Recursion 11.2 - Lambda Functions 11.3 - Advanced Dictionary Handling: Min, Max, and Sort 11.4 - Threading 11.5 - Packages and the Pip Package Manager 11.6 - Virtual Environments 11.7 - Useful Libraries 11.8 - Working with Images 11.9 - Working with Text: Regular Expressions 11.10 - SQLite

📄 Page 7

11.11 - JSON Data 11.12 - Sys Module 11.13 - Iterators vs Generators 11.14 - if __name__ == ‘__main__’ 11.15 - Jupyter Notebooks 11.16 - Unit Testing Chapter 12: Projects 12.1 - Project 1: Story Idea Generator 12.2 - Project 2: Weather Application References Book 2: Learn JavaScript Quickly Chapter 1: What is Programming? Introduction Algorithms Programming Languages Language Translation Chapter 2: What is JavaScript? Background Interacting with web pages A First Example Editors and IDEs JavaScript Versions Using the Language Chapter 3: Rules of the Road A New Example Statements

📄 Page 8

Literals Identifiers Functions Comments Input and Output Chapter 4: Computing Results Variables Assignment Statements Operators and Expressions Arithmetic Operators Comparison and Boolean Operators String Operator Numbers in Strings Assignment Operators Grouping and Precedence Chapter 5: Making Choices Conditions If Statement If-Else Statement Switch Statement More About Conditions Repetition Chapter 6: Repeating Yourself While Statement Do While Statement For Statement Break and Continue Chapter 7: Input, Output, and the DOM

📄 Page 9

The Document Object Model Making it Pretty Another Example Manipulating HTML Elements Chapter 8: Functions Overview Function Definitions Function Invocation Anonymous Functions Arrow Functions Variable Scope Let and Const Hoisting Chapter 9: Objects and Methods Objects Properties Iteration using for ... in Methods Some Predefined Objects Chapter 10: Arrays, Maps and Sets What are Arrays? Reading and Writing Array Elements Managing Tables Adding and Removing Elements Multidimensional Arrays Array Iteration Break and Continue Maps and Sets

📄 Page 10

Chapter 11: Events, Timers, and Errors HTML Events Handling Events Event Listeners Timers Errors Chapter 12: More about Data and Expressions Number Literals Bitwise Operators Type Conversion The typeof Operator Methods for Searching Strings Regular Expressions Chapter 13: Working with Objects Constructors and Prototypes More about "new" JavaScript Classes Accessors Is Everything an Object? Chapter 14: The DOM and the BOM The Document Object Model JavaScript and the DOM The Document Object The Element Object The Browser Object Model Chapter 15: Related Technologies HTML and CSS XML

📄 Page 11

XHTML JSON AJAX jQuery Chapter 16: Beyond the Browser Web Server Architecture Breaking Loose of the Browser Node.js Appendix A: Reserved Words Appendix B: Exercises Appendix C: Solutions Appendix D: A Little HTML Appendix E: A Little CSS Appendix F: Resources Book 3: Learn C++ Quickly Chapter 1: Introduction Chapter 2: Creating Your First Program Chapter 3: Write your very first program Chapter 4: The C++ Structure Chapter 5: Data Types & Variables Program assignment: Convert Fahrenheit to Celsius Chapter 6: if and else if statements Chapter 7: Strings Chapter 8: Arrays Chapter 9: Loops Chapter 10: Switch Case Statements

📄 Page 12

Chapter 11: Conditional Ternary Operator?: Chapter 12: Infinite loops Chapter 13: Functions Chapter 14: Pointers Chapter 15: Object-Oriented Programming Chapter 16: Static class members Chapter 17: Operator overloading Chapter 18: C++ Encapsulation Chapter 19: Inheritance Chapter 20: Polymorphism Chapter 21: Exercises in C++ Chapter 22: Final Project C++ - Advanced Section Chapter 23: Smart Pointers Chapter 24: Exception Handling in C++ Chapter 25: C++ I/O and Stream Chapter 26: The Standard Template Library STL Chapter 27: Multithreading and Concurrency in C++ Chapter 28: C++ Coroutines Book 4: Learn C# Quickly Chapter 1: Introductory Topics 1.1 - Introduction 1.2 - Variable 1.3 - Data Types 1.4 - Bit 1.5 - Byte

📄 Page 13

1.6 - Heap 1.7 - Integer 1.8 - Decimal 1.9 - String 1.10 - Boolean 1.11 - Var 1.12 - Arrays 1.13 - Process 1.14 - Thread Chapter 2: Branches and Loops 2.1 - For Loop 2.2 - While Loop 2.3 - Recursion 2.4 - If…Else Chapter 3: Methods and Properties 3.1 - Access modifiers 3.2 - Return values Chapter 4: Classes, Structs, Enums, and Objects 4.1 - Class 4.2 - Struct 4.3 - Enum 4.4 - Object 4.5 - Interface Chapter 5: Collections 5.1 - List 5.2 - Dictionary 5.3 - ForEach Chapter 6: Object-Oriented Programming

📄 Page 14

6.1 - Encapsulation 6.2 - Inheritance 6.3 - Abstraction 6.4 - Polymorphism Chapter 7: SOLID Principles 7.1 - Single Responsibility Principle 7.2 - Open-Closed Principle 7.3 - Liskov 7.4 - Interface Segregation Principle 7.5 - Dependency Inversion Principle Chapter 8: Advanced Topics 8.1 - Asynchronous Programming 8.2 - Parallel Programming 8.3 - LINQ 8.4 - Generics 8.5 - Dependency Injection 8.6 - Object Relational Mappers 8.7 - Mappers 8.8 - Unit Testing Chapter 9: The Final Project Chapter 10: Conclusion Book 5: Learn SQL Quickly Chapter 1: Introduction 1.1 - What this book offers 1.2 - How this book is different 1.3 - What you will learn:

📄 Page 15

1.4 - What is a database? 1.5 - What is SQL? 1.6 - MySQL vs. Alternatives Chapter 2: Getting Started 2.1 - Learning Context 2.2 - Installation Chapter 3: Establishing a Connection Chapter 4: Building up a Database 4.1 - Create Statements 4.2 - Common Data Types 4.3 - Numeric Data Types 4.4 - MySQL Boolean Data Types 4.5 - MySQL String Data Types 4.6 - MySQL Date and Time Data Types 4.7 - MySQL Spatial Data Types 4.8 - JSON Data Type 4.9 - Insert Statements – Build Up Your Database Chapter 5: The SELECT Statement 5.1 - Selecting single columns 5.2 - SELECT DISTINCT 5.3 - SELECT DISTINCT on Multiple Columns 5.4 - The WHERE Clause 5.5 - AND Operator 5.6 - HAVING 5.7 - Other Conditional Operators Chapter 6: Using Regular Expressions 6.1 - Regular Expression Metacharacter Cheat Sheet 6.2 - Regular Expression Summary

📄 Page 16

Chapter 7: Table Joins 7.1 - What are JOINs? 7.2 - INNER JOIN 7.3 - MySQL Alias for Columns 7.4 - LEFT JOIN 7.5 - RIGHT JOIN 7.6 - CROSS JOIN 7.7 - UNION Chapter 8: Setting Primary and Foreign Keys 8.1 - What is a primary key in MySQL? 8.2 - What is an index? 8.3 - Establishing Primary Keys 8.4 - Using Alter Table Statement for Primary Keys 8.5 - Establishing Composite Primary Keys 8.6 - What is a Foreign Key 8.7 - Why do we need Foreign Keys? 8.8 - TEMPORARY Tables Chapter 9: Indexing and Performance 9.1 - Adding a single column index 9.2 - A Multiple Column Index 9.3 - Primary Key Indexes 9.4 - Secondary Indexes 9.5 - Covering Indexes 9.6 - Indexes with ORDER and GROUP BY 9.7 - Effect of Indexes on JOIN 9.8 - THE EXPLAIN Statement 9.9 - Redundant indexes 9.10 - Index Merge

📄 Page 17

9.11 - Constraint Indexes 9.12 - What columns should I Index? 9.13 - Star system 9.14 - Other considerations 9.15 - How will MySQL choose an index? 9.16 - Testing an index Chapter 10: Data Altering Commands 10.1 - Using UPDATE 10.2 - Using DELETE 10.3 - Using TRUNCATE 10.4 - DELETE vs. TRUNCATE 10.5 - CAST 10.6 - CONVERT 10.7 - CAST vs. CONVERT Chapter 11: The GROUP BY Clause and Aggregate Functions 11.1 - Aggregate Functions 11.2 - MIN() and MAX() 11.3 - AVG() 11.4 - SUM() 11.5 - ORDER BY Chapter 12: Subqueries/Nested Queries 12.1 - What is a subquery? 12.2 - Subqueries vs. JOIN 12.3 - Inner Query 12.4 - Outer Query Chapter 13: Control Flow Tools 13.1 - The CASE Function 13.2 - The IF Function

📄 Page 18

Chapter 14: Views, Stored Procedures, and Triggers 14.1 - Views 14.2 - Altering a View 14.3 - Deleting a View 14.4 - Stored Procedures 14.5 - LOOPs 14.6 - WHILE 14.7 - REPEAT 14.8 - IF THEN ELSE 14.9 - Triggers 14.10 - DROP TRIGGER Chapter 15: String Functions 15.1 - LENGTH 15.2 - CONCAT 15.3 - FORMAT 15.4 - INSERT 15.5 - LEFT 15.6 - RIGHT 15.7 - MID 15.8 - SUBSTRING 15.9 - TRIM 15.10 - LTRIM 15.11 - RTRIM 15.12 - UPPER 15.13 - LOWER Chapter 16: Numerical Functions 16.1 – ABS 16.2 – CEILING

📄 Page 19

16.3 – FLOOR 16.4 – ROUND 16.5 - MOD 16.6 - SQRT Chapter 17: Date and Time Functions 17.1 - ADDDATE 17.2 - SUBDATE 17.3 - ADDTIME 17.4 - SUBTIME 17.5 - CURRENT DATE 17.6 - CURRENT TIME STAMP 17.7 - DATE DIFF 17.8 - DAY 17.9 - WEEK 17.10 - MONTH 17.11 - YEAR 17.12 - TO_DAYS Chapter 18: Final Project 18.1 Conclusion

📄 Page 20

Learn Python Quickly