SQL Server

SQL Server Examples Map

SQL Server SQL DML

• Select
• Update
• Insert
• Delete

SQL Server String Functions

• Substring function
• Upper/Lower functions
• LTRIM/RTRIM functions

SQL Server Stored Procedures

• Select stored procedure
• Update stored procedure
• Insert stored procedure
• Delete stored procedure

SQL Server Transactions

• Nested Transaction (Dependent)

SQL Server Views

• Views/Basics

SQL Server Table Basic

• Create SQL Table
• Foreign Key Constraint
• Data Types
• Add / Alter Column
• Drop Table

MySQL

MySQL Examples Map

MySQL SQL DML

• Select
• Update
• Insert
• Delete

MySQL String Functions

• Substring
• Upper and Lower
• Ltrim and Rtrim

MySQL Stored Procedures

• Select Stored Procedure
• Update Stored Procedure
• Insert Stored Procedure
• Delete Stored Procedure

MySQL SQL Views

• Views 101

SQL Table Basics

• Zip file schema/data
• Create SQL Table
• Foreign Key Constraint
• Data Types
• Add Column
• Drop Table

Oracle

Oracle Examples Map

Oracle SQL DML

• SQL Select
• SQL Update
• SQL Insert
• SQL Delete

Oracle SQL Functions

• Substring function
• Upper and Lower functions
• RTRIM and LTRIM functions

Oracle Stored Procedures

• Select stored procedure
• Update stored procedure
• Insert stored procedure
• Delete stored procedure

Oracle SQL View

• Introduction to SQL Views

Oracle - SQL Schema

• Create SQL Table
• Foreign Key Constraint
• SQL Data Types
• Add / Alter SQL Column
• Drop SQL Table