www.telat.gen.tr (((GERİ))) www.tutorialspoint.com-sql SQL Tutorial 001-SQL - Home 002-SQL - Overview 003-SQL - RDBMS Concepts 004-SQL - Databases 005-SQL - Syntax 006-SQL - Data Types 007-SQL - Operators 008-SQL - Expressions SQL Database 001-SQL - Create Database 002-SQL - Drop Database 003-SQL - Select Database 004-SQL - Rename Database 005-SQL - Show Databases 006-SQL - Backup Database SQL Table 001-SQL - Create Table 002-SQL - Show Tables 003-SQL - Rename Table 004-SQL - Truncate Table 005-SQL - Clone Tables 006-SQL - Temporary Tables 007-SQL - Alter Tables 008-SQL - Drop Table 009-SQL - Delete Table 010-SQL - Constraints SQL Queries 001-SQL - Insert Query 002-SQL - Select Query 003-SQL - Select Into 004-SQL - Insert Into Select 005-SQL - Update Query 006-SQL - Delete Query 007-SQL - Sorting Results SQL Views 001-SQL - Create Views 002-SQL - Update Views 003-SQL - Drop Views 004-SQL - Rename Views SQL Operators and Clauses 001-SQL - Where Clause 002-SQL - Top Clause 003-SQL - Distinct Clause 004-SQL - Order By Clause 005-SQL - Group By Clause 006-SQL - Having Clause 007-SQL - AND & OR 008-SQL - BOOLEAN (BIT) Operator 009-SQL - LIKE Operator 010-SQL - IN Operator 011-SQL - ANY, ALL Operators 012-SQL - EXISTS Operator 013-SQL - CASE 014-SQL - NOT Operator 015-SQL - NOT EQUAL 016-SQL - IS NULL 017-SQL - IS NOT NULL 018-SQL - NOT NULL 019-SQL - BETWEEN Operator 020-SQL - UNION Operator 021-SQL - UNION vs UNION ALL 022-SQL - INTERSECT Operator 023-SQL - EXCEPT Operator 024-SQL - Aliases SQL Joins 001-SQL - Using Joins 002-SQL - Inner Join 003-SQL - Left Join 004-SQL - Right Join 005-SQL - Cross Join 006-SQL - Full Join 007-SQL - Self Join 008-SQL - Delete Join 009-SQL - Update Join 010-SQL - Left Join vs Right Join 011-SQL - Union vs Join SQL Keys 001-SQL - Unique Key 002-SQL - Primary Key 003-SQL - Foreign Key 004-SQL - Composite Key 005-SQL - Alternate Key SQL Indexes 001-SQL - Indexes 002-SQL - Create Index 003-SQL - Drop Index 004-SQL - Show Indexes 005-SQL - Unique Index 006-SQL - Clustered Index 007-SQL - Non-Clustered Index Advanced SQL 001-SQL - Wildcards 002-SQL - Comments 003-SQL - Injection 004-SQL - Hosting 005-SQL - Min & Max 006-SQL - Null Functions 007-SQL - Check Constraint 008-SQL - Default Constraint 009-SQL - Stored Procedures 010-SQL - NULL Values 011-SQL - Transactions 012-SQL - Sub Queries 013-SQL - Handling Duplicates 014-SQL - Using Sequences 015-SQL - Auto Increment 016-SQL - Date & Time 017-SQL - Cursors 018-SQL - Common Table Expression 019-SQL - Group By vs Order By 020-SQL - IN vs EXISTS 021-SQL - Database Tuning SQL Function Reference 001-SQL - Date Functions 002-SQL - String Functions 003-SQL - Aggregate Functions 004-SQL - Numeric Functions 005-SQL - Text & Image Functions 006-SQL - Statistical Functions 007-SQL - Logical Functions 008-SQL - Cursor Functions 009-SQL - JSON Functions 010-SQL - Conversion Functions 011-SQL - Datatype Functions SQL Useful Resources 001-SQL - Questions and Answers 002-SQL - Quick Guide 003-SQL - Useful Functions 004-SQL - Useful Resources 005-SQL - Discussion Selected Reading 001-UPSC IAS Exams Notes 002-Developer's Best Practices 003-Questions and Answers 004-Effective Resume Writing 005-HR Interview Questions 006-Computer Glossary 007-Who is Who