Querying SQL Server Temel Eğitimi

Introduction to SQL Server

• Data, Database and Database Management Systems Concepts
• Relational Database Systems and Table Structure
• What is SQL? Where to use? What is SQL Server?
• Getting to Know SQL Server Management Studio (SSMS)
• Query Execution Methods

Quick Introduction to T-SQL Language

• What Can We Do With SQL?
• (Select, Where,Like,Sum,Min…)
• Basic T-SQL Elements
• Classification of T-SQL Commands
• Select
• Querring with Select Statement
• Listing All Tables and Columns

Querying Data with the Select Statement

• Basic Select Statement
• Dıstınct
• Select Count (Distinct)
• Aliasing Columns and Tables

Operators And Filtering

• Arithmetic Operators
• Where Structure and Basic Comparison Operators
• Where Structure and Logical Operators
• And & amp; OR
• Where Structure and Other Operators (In, Like, Between, Is Nul)
• Like Operator and Wildcards

Sorting

• Order By
• Offset-Fetch
• TOP İfadesi

Working with Groups and Grouped Data

• Aggregate Functions
• Sum, Count, Min, Max, Avg
• Aggregate Functions and Distinct
• Group By
• Group By and Having
• Having vs Where
• Grouping Set
• Cube, Rollup
• SQL Query Processing Orde

Queryying Multiple Tables – Join

• Understanding Database Structure
• Database Diagram
• PK and FK
• Joın Types
• Join Kavramı
• Understanding Joıns
• Join Types
• Inner Join
• Left Join
• Right Join
• Full Join
• Cross Join
• İleri Joinler
• Self Join Kavramı

SET Operators and PIVOT

• Union ve Union All
• Except ve Intersect Kullanımı
• Pivot, Unpivot Kullanımı