Querying SQL Server 2019 (Beginner) Eğitimi

• 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.

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

• Basic Select Statement.
• DISTINCT.
• SELECT COUNT (DISTINCT).
• Aliasing Columns and Tables.

• Arithmetic Operators.
• Where Structure and Basic Comparison Operators.
• Where Structure and Logical Operators.
• AND & OR
• Where Structure and Other Operators.. ( In, Like, Between, Is Null…)
• Like Operator and Wildcards

• Order By.
• Offset-Fetch.
• TOP İfadesi.

• Aggregate Functions.
o Sum, Count,Min,Max, Avg
o Aggregate Functions and DISTINCT
• Group By
• Group By and Having
• Having vs Where
• Grouping Set.
• Cube, Rollup.
• SQL Query Processing Order.

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

• UNION ve UNION ALL.
• EXCEPT ve INTERSECT Kullanımı.
• PIVOT, UNPIVOT Kullanımı.