Querying SQL Server 2019 (Intermediate) Eğitimi
Querying SQL Server 2019 (Intermediate) Eğitimi
Eğitim Hakkında
In this training, in which basic database concepts are explained, basic and advanced data query techniques are covered in detail. At the same time, the basic database objects such as Table, View and Function are discussed. At the end of this training, the participants will have learned all kinds of data query techniques and will be able to create and manage database objects.
Sertifika:
Eğitimlerimize %80 oranında katılım gösterilmesi ve eğitim müfredatına göre uygulanacak sınav/projelerin başarıyla tamamlanması durumunda, eğitimin sonunda dijital ve QR kod destekli “BT Akademi Başarı Sertifikası” verilmektedir.
Ön Koşul
Temel SQL Sorgulama Bilgisi Gerekmektedir.Eğitim İçeriği
• SubQuery
o Scaler Sub Queries
o Subqueries with multiple results
• Correleated Subqueris
• EXIST,ANY-SOME - ALL
• Writing Query Using Function.
o Scaler Functions.
▪ Mathematical Functions.
▪ Text Functions.
▪ Date And Time Functions.
o Aggregate Functions
o Querying With Null
o Window Functions
▪ OVER İfadesi.
▪ Rank
▪ Dense_Rank
▪ Row_Number
▪ First_Value
▪ Last_Value
▪ Lead
▪ Lag
▪ Percent_Rank
▪ Cume_Dıst
▪ NTILE
• Convertion Functions
o CAST.
o CONVERT.
o PARSE.
o TRY_PARSE, TYR_CONVERT.
• Logical Functions.
o IIF.
o CHOOSE.
o CASE.
o Pivotting with CASE WHEN
• System Functions.
• Data Types.
o Strings
▪ String Data Types
▪ Concatenate strings
o Numeric Data Types
o Money
o Binary Data Types
o Date and Time Data Types
o INSERT
o SELECT – INSERT
o UPDATE
o Update and Where
o DELETE Cümleceği.
• CREATE
• ALTER
• DROP
• TRUNCATE
• TRUNCATE and DELETE
• Understanding Transactions
• COMMIT
• ROLLBACK
• SAVEPOINT
• Creating a Table
• CONSTRAINTS
o PK
o FK
o NOT NULL
o UNIQUE
o CHECK
o DEFAULT
o IDENTITY
• Views
Kazanımlar
.
