Topics

• Arrays
• Getting started with Microsoft SQL Server
• Datepicker
• Join
• Common Table Expressions
• Dates
• Limit Result Set
• Stored Procedures
• CREATE VIEW
• String Functions
• ORDER BY
• SELECT statement
• Index
• Ranking Functions
• IF...ELSE
• Aggregate Functions
• PDO
• Spatial Data
• Pagination
• Query Hints
• Microsoft SQL Server Management Studio Shortcut Keys

Examples

• Initializing an Array
• PDO: connecting to MySQL/MariaDB server
• Database Transactions with PDO
• Limiting With TOP
• PDO: Get number of affected rows by a query
• Limiting with FETCH
• Creating and executing a basic stored procedure
• CREATE VIEW
• CREATE VIEW With INNER JOIN
• Getting the last day of a month
• CREATE Indexed VIEW
• STORED PROCEDURE with OUT parameters
• Create Clustered index
• Create Non-Clustered index
• Recursive CTE
• Multiple IF Statements
• Multiple IF...ELSE Statements
• Stored Procedure with If...Else and Insert Into operation
• Self Join
• SUM()
• AVG()
• MAX()
• MIN()
• COUNT()
• PDO::lastInsertId()
• CTE with multiple AS statements
• Pagination using ROW_NUMBER with a Common Table Expression
• Pagination with OFFSET FETCH
• Paginaton with inner query
• MAXDOP Option
• Shortcut Examples
• INDEX Hints