Topics
SQL Programming
RDBMS Kavramı
T-SQL
DML
SELECT
INSERT
UPDATE
DELETE
DDL
CREATE
ALTER
DROP
DCL
GRANT
REVOKE
DENY
View
Stored Procedure
Function
Trigger
SQL & PL/SQL Programming
Introduction
Retrieve Data using the SQL SELECT Statement
Restricted and Sorted Data
Usage of Single-Row Functions to Customize Output
Conversion Functions and Conditional Expressions
Aggregated Data Using the Group Functions
Display Data From Multiple Tables
Usage of Subqueries to Solve Queries
SET Operators
Data Manipulation
DDL Statements to Create and Manage Tables
Other Schema Objects
Introduction to PL/SQL
PL/SQL Identifiers
Write Executable Statements
Interaction with the Oracle Server
Control Structures
Usage of Composite Data Types
Explicit Cursors
Exception Handling
Stored Procedures and Functions
HTML - CSS - JavaScript
HTML
HTML Nedir ? Temel Kavramlar
Temel Etiketler ve Kurallar
Paragraf / Link / Görsel / Başlık Etiketleri
İçerik Etiketleri
Belge Tipi Bildirimi (DOCTYPE)
Tablolar
Stiller
Renkler
Bloklar ve Div Kullanımı
iFrame Kullanımı
CSS Kullanımı
Sınıflar
CSS
CSS Nedir
CSS Kod Yapısı
Seçiciler
Renkler
Background
Border
Margin Kullanımı
Padding Kullanımı
Yükseklik ve Genişlik
Metin Özellikleri
Font Kullanımı
Google Font Kullanımı
Link Özellikleri
Liste ve Tablo Özellikleri
Position / Overflow
JavaScript
JavaScript'e Giriş
JavaScript Söz Dizimi
Doküman Nesne Modeli (DOM)
JavaScript'i Formlar ile Kullanmak
Javascript'i Görüntüler ve Linkler ile Kullanmak
Düzenli İfadeler (Regular Expressions)
Hata Yönetimi (Exception Handling)
Nesne Yönelimli JavaScript
.NET Core Programming
Introduction
Evolution of .NET and .NET Core
.NET SKDs and Runtimes
Visual Studio and Visual Studio Code
.NET SDK
Installation
Version Management
Command-Line Interface (CLI)
Software, Windows and .NET Development Fundamentals
Programming in C# and Object Oriented Programming
Record Types
Init Only Setters
Nullable Reference Types
Application Configuration
Configure and ConfigureServices
Configuration Providers and Sources
Configuration API
Options Pattern o HTTPS and HTTP/2
Request Routing
RESTful Services
Endpoint Routing
Route Templates
Route Constraints
Route Template Precedence
Attribute-Based Routing
Models
Persistence Ignorance
Dependency Inversion
Asynchronous Data Access
Object-Relational Mapping
Entity Framework Core
Dapper ORM
Controllers
Responsibilities
Requirements and Conventions
Dependencies o Action Results
Views o Responsibilities
Conventions o Razor Syntax
Layouts
ViewData and ViewBag
Strongly-Typed Views
Partial Views o HTML and URL Helpers
Tag Helpers
View Components
Client-Side Dependencies
Razor Pages o View Models
HTML Forms
Tag Helpers
Form Submissions
Model Binding
Input Validation
Introduction
Data Annotations
Model Binding
Input Tag Helpers
Validation Tag Helpers
Application State
Client-Side vs. Server-Side
HttpContext.Items
Session State
TempData
Error Handling
Best Practices
HTTP Error Status Codes
Status Code Pages
Developer Exception Page
Logging
Configuration
ILogger
Serilog and Seq
Testing
Unit Testing
xUnit
Testing Controllers
Integration Testing
Web APIs
API Controllers o OpenAPI / Swagger
Testing APIs
CRUD Operations
Cross-Origin Resource Sharing (CORS)
Remote Procedure Calls (gRPC)
Introduction
Protobuf
Server
Client
Limitations
Blazor
Razor Components
Blazor Server
Blazor WebAssembly
Class
Interface
Delegate
OOP Principals
C# Data Access with Entity Framework
Solid Principles and Design Patterns
ASP.NET ile Web Programlama