勉強日記

チラ裏

勉強メモ

MySQL 5.6 Developer試験対策 5 基本的な最適化 -- 最適でないSQLコマンドを認識する。最適でないSQLコマンドを修正する -- DMLステートメントの最適化

MySQL 5.6 Developer試験 公式「試験内容 チェックリスト」 https://education.oracle.com/ja/mysql-56-developer/pexam_1Z0-882education.oracle.com MySQL 5.6 リファレンスマニュアル dev.mysql.com 最適でないSQLコマンドを認識する。最適でないSQLコマ…

MySQL 5.6 Developer試験対策 5 基本的な最適化 -- 最適化が必要な文を識別する

MySQL 5.6 Developer試験 公式「試験内容 チェックリスト」 https://education.oracle.com/ja/mysql-56-developer/pexam_1Z0-882education.oracle.com MySQL 5.6 リファレンスマニュアル dev.mysql.com 最適化が必要な文を識別する 式と関数の速度の測定 MyS…

MySQL 5.6 Developer試験対策 4 結合、副問合せおよびUNION

MySQL 5.6 Developer試験 公式「試験内容 チェックリスト」 https://education.oracle.com/ja/mysql-56-developer/pexam_1Z0-882education.oracle.com MySQL 5.6 リファレンスマニュアル dev.mysql.com MySQLのコマンドにおけるJOINを識別し、説明する。MySQ…

Programming TypeScript ch12 Building and Running TypeScript / npmパッケージ公開した

www.oreilly.com Building Your TypeScript Project Project Layout Artifacts Dialing In Your Compile Target Enabling Source Maps Project References column: Using extends to Reduce tsconfig.json Boilerplate Error Monitoring Running Typescript …

MySQL 5.6 Developer試験対策 3 データに対する問い合わせ

MySQL 5.6 Developer試験 公式「試験内容 チェックリスト」 https://education.oracle.com/ja/mysql-56-developer/pexam_1Z0-882education.oracle.com MySQL 5.6 リファレンスマニュアル dev.mysql.com 基本的なSELECT文を実行する SELECT文で返される行を制…

MySQL 5.6 Developer試験対策 2 MySQLのスキーマ・オブジェクトの設計と作成

MySQL 5.6 Developer試験 公式「試験内容 チェックリスト」 https://education.oracle.com/ja/mysql-56-developer/pexam_1Z0-882education.oracle.com MySQL 5.6 リファレンスマニュアル dev.mysql.com 正規化されたデータベースを設計する。正規化されたデ…

MySQL 5.6 Developer試験対策 1 MySQL アーキテクチャ

MySQL 5.6 Developer試験 公式「試験内容 チェックリスト」 https://education.oracle.com/ja/mysql-56-developer/pexam_1Z0-882education.oracle.com MySQL 5.6 リファレンスマニュアル dev.mysql.com MySQL ServerとのインターフェースであるMySQL クライ…

Programming TypeScript ch8 Asynchronous Programming, Concurrency, and Parallelism (2/2)

www.oreilly.com Typesafe Multithreading In the Browser: With Web Workers - メインスレッドがブロックされるとUIの応答性を損なうので、Web Workerに逃がす 型付け Typesafe protocols In NodeJS: With Child Processes Exercises General-Purpose promi…

Programming TypeScript ch11 Interoperating with JavaScript

www.oreilly.com Type Declarations Ambient Variable Declarations Ambient Type Declarations Ambient Module Declarations Gradually Migrating from JavaScript to Typescript Step 1: Add TSC Step 2a: Enable Typechecking for JavaScript (Optional) …

Programming TypeScript ch10 Namespaces.Modules

www.oreilly.com A Brief History of JavaScript Modules import, export Dynamic Imports Using CommonJS and AMD Code Module Mode Versus Script Mode Namespaces Collisions Compiles Output Column: Prefer Modules over Namespaces When Possible Decl…

Programming TypeScript ch8 Asynchronous Programming, Concurrency, and Parallelism (1/2)

www.oreilly.com Asynchronous Programming, Concurrency, and Parallelism JavaScript's Event Loop Working with Callbacks Regaining Sanity with Promises async and await Async Streams Event Emitters Emitters in the Wild Asynchronous Programming…

Programming TypeScript ch7 Handling Errors

www.oreilly.com Returning Null Throwing Exceptions Returning Exceptions The Option Type Returning Null Pros 最もlightweightな方法 Cons 「なぜ失敗したか」の情報を欠く 「日付のパースに失敗しました」よりは「Ymdで入力してください」の方が親切 T…

Programming TypeScript ch6 (3/3) Advanced Function Types

www.oreilly.com Advanced Function Types Improving Type Inference for Tuples User-Defined Type Guards Conditional Types Distributive Conditionals The infer Keyword Build-in Conditional Types Escape Hatches Type Assertions Nonnull Assertions…

Programming TypeScript ch6 (2/3) Advanced Function Types

www.oreilly.com Totality TSC Flag: noImplicitReturns Advanced Object Types Type Operators for Object Types The keyof operator TSC Flag: keyofStringsOnly The Record Type Mapped Types Built-in mapped types Companion Object Pattern Totality s…

CCNA試験対策 ch21 OSPF Network Types and Neighbors

OSPF Network Types The OSPF Broadcast Network Type Verifying Operations with Network Type Broadcast Configuring to Influence the DR/BDR Election The OSPF Point-to-Point Network Type OSPF Neighbor Relationships OSPF Neighbor Requirements Is…

CCNA試験対策 ch20 Implementing OSPF

Implementing Single-Area OSPFv2 OSPF Single-Area Configuration Wikdcard Matching with the network Command Verifying OSPF Operation Verifying OSPF Configuration Configurating the OSPF Router ID Implementing Multiarea OSPF Using OSPFv2 Inter…

CCNA試験対策 ch19 Understanding OSPF Concepts

Comparing Dynamic Routing Protocol Features Routing Protocol Functions Interior and Exterior Routing Protocols Comparing IGPs IGP Routing Protocol Algorithms Metrics Other IGP Comparisons Administrative Distance OSPF Concepts and Operation…

CCNA試験対策 ch25 Implementing IPv6 Routing

Connected and Local IPv6 Routes Static IPv6 Routes Static Routes Using the Outgoing Interface Static Routes Using Next-Hop IPv6 Address Static Default Routes Sttaic IPv6 Host Routes Floating Static Ipv6 Routes The Neighbor Discovery Protoc…

CCNA試験対策 ch29 Building a Wireless LAN

Conecting a Cisco AP Accessing a Cisco WLC Connectiong a Cisco WLC Using WLC Ports Wsing WLC Interfaces Configuring a WLAN Step 1. Configure a RADIUS Server Step 2. Create a Dynamic Interface Step 3. Create a New WLAN Configuring WLAN Secu…

CCNA試験対策 ch24 Implementing IPv6 Addressing on Routers

Implementing Unicast IPv6 Addresses on Routers Static Unicast Address Configuration configuring the full 128-bit address Enabling IPv6 Routing Verifying the IPv6 Address Configuration Generating a Unique Interface ID Using Modified EUI-64 …

CCNA試験対策 ch28 Securing Wireless Networks

Anatomy of a Secure Connection Authentication Message Privacy Message Integrity Wireless Client Authentication Method Open Authentication WEP 802.1x/EAP LEAP EAP-FAST PEAP EAP-TLS Wireless Privacy and Integrity Methods TKIP CCMP GCMP WPA, …

CCNA試験対策 ch27 Analyzing Cisco Wireless Architectures

Autonomous AP Architecture Cloud-based AP Architecturea Split-MAC Architectures Comparing Wireless LAN Controller Deployments Cisco AP Modes Autonomous AP Architecture 自律型 各L3switchどうしをtrunk linkで結び、APごとにVLANの設定を行う デ…

CCNA試験対策 ch26 Fundamentals of Wireless Networks

Comparing Wired and Wireless Networks Wireless LAN Topologies Basic Service Set Distrubution System Extended Services Set Independent Basic Service Set Other Wireless Topologies Repeater Workgroup Bridge Outdoor Bridge Mesh Network RF Over…

CCNA試験対策 ch22-23 IPv6まわり

ch22 Fundamentals of IP Version 6 Introduction to IPv6 The Historical Reasons for IPv6 The IPv6 Protocols IPv6 routing IPv6 Routing Protocols IPv6 Addressing Formats and Conventions ch23 IPv6 Addressing and Subnetting Global Unicast Addres…

CCNA試験対策 ch18 Troubleshooting IPv4 Routing

Problem Isolation Using the ping Command Ping Command Basics Strategies and Results When Testing with the ping Command Testing Longer Routes from Near the Source of the Problem Using Extended Ping to Test the Reserve Route Testing LAN Neig…

CCNA試験対策 ch17 IP Routing in the LAN

VLAN Routing with Router 802.1Q Trunks Configuring ROAS Verifying ROAS Troubleshooting ROAS VLAN Routing with Layer 3 Switch SVIs Configuring Routing Using Switch SVIs Verifying Routing with SVIs Troubleshooting Routing with SVIs VLAN Rout…

CCNA試験対策 ch16 Configuring IPv4 Addresses and Static Routes

IP Routing IPv4 Routing Process Reference An Example of IP Routing Host Forwards the IP Packet to the Default Router (Gateway) Configuring IP Addresses and Connected Routes Connected Routes and the ip address Command The ARP Table on a Cis…

CCNA試験対策 ch15 operating cisco routers

Installing Cisco Routers Installing Enterprise Routers Installing SOHO Routers Enabling IPv4 Support on Cisco Router Interfaces Access the Router CLI Router Interfaces Interface Status Codes Router Inteface IP Addresses Router Auxiliary Po…

CCNA試験対策 ch12~14 IPアドレスやサブネットのビット演算問題まわり

ch12 Analyzing Classful IPv4 Networks Classful Network Concepts IPv4 Network Clases and Related Facts ch13 Analyzing Subnet Masks ch14 Analyzing Existing Subnets ch12 Analyzing Classful IPv4 Networks Classful Network Concepts IPv4 Network …

CCNA試験対策 ch11 Perspectives on IPv4 Subnetting

Introduction to Subnetting Subnetting Defined Through a Simple Example Operational View Versus Design View of Subnetting Analyze Subnetting and Addressing Needs Rules About Which Hosts Are in Which Subnet Determining the Number of Subnets …