Pradeep

Years of Experience in SQL Programming Training

10

Teaching Experience in detail in SQL Programming Training

SQL Programing Relational Database Fundamentals ? Overview of Relational Database Concepts ? Relational Databases and Relational Database Management Systems ? Data Normalization ? DDL Syntax Creating a Database ? Database Development Methodology Overview ? Building a Logical Data Model ? Identifying Entities and Attributes ? Isolating Keys ? Relationships Between Entities ? Creating Entity-Relationship Diagrams ? Transforming to Physical Design ? Migrating Entities to Tables ? Selecting Primary Keys ? Defining Columns ? Enforcing Relationships with Foreign Keys ? Constructing the Database Using DDL ? Creating Tables, Indexes, Constraints and Views ? Dropping Tables, Indexes, Constraints and Views ? Modifying Tables, Indexes, Constraints and Views Writing Basic SQL Queries ? Displaying Table Structures ? Retrieving Column Data From a Table or View ? Selecting Unique Values ? Filtering Rows Using the WHERE Clause ? Sorting Results Using ORDER BY ? Joining Multiple Tables ? Using Column and Table Aliases Manipulating Query Results ? Using Row Functions ? Character ? Numeric ? Date and Time ? Data Conversion (CAST and CONVERT) ? Using the CASE Function ? Handling Null Values Advanced Query Techniques ? Inner Joins ? Outer Joins (Left, Right, Full) ? Performing Self-Joins ? Subqueries ? Simple ? Correlated ? Using the EXISTS Operator ? Tips for Developing Complex SQL Queries ? Using Aggregate Functions ? AVG ? COUNT ? SUM ? MIN ? MAX ? Performing Set Operations ? UNION ? INTERSECT ? EXCEPT/MINUS ? Aggregating Results Using GROUP BY ? Restricting Groups with the HAVING Clause ? Creating Temporary Tables Manipulating Table Data Using SQL's Data Manipulation Language (DML) ? Inserting Data into Tables ? Updating Existing Data ? Deleting Records ? Truncating Tables ? Performing Bulk Inserts ? Using the OUTPUT Clause ? Merging Data ? Working with Identity Columns and Sequences Stored Procedures ? Definition and Benefits of Use ? CREATE PROCEDURE ? Syntax ? Defining Input Parameters ? Defining Output Parameters ? Defining Optional Parameters ? ALTER and DROP PROCEDURE ? Implementation Differences complex Queries ? Using Wildcard Characters with Like ? Allowing Users to Build SQL Queries Dynamically ? Pivoting Data ? Summarizing Data with ROLLUP and CUBE ? Using Partitioned Aggregates Working with Data Types and Functions ? Effective Use of Data Types in SQL ? String ? Numeric ? Time/Date ? Other ? Substitution of Non-null Values with the COALESCE and ISNULL Functions ? Analyzing Data Points Using Ranking Functions Working with Table Expressions ? Overview of Table Expressions ? Working with Views ? Using Derived Tables ? Common Table Expressions ? Table-Valued Functions T-SQL Code Constructs ? Exploiting the Programming Features of T-SQL ? Conditional Constructs ? Looping Constructs ? Building Multi-Batch Scripts ? Invoking System Functions ? Using Variables in Scripts ? Using Temporary Tables in Scripts ? Handling Errors ? Using TRY...CATCH Blocks ? Using System Variables and Functions Triggers ? Definition and Benefits of Use ? Alternatives (e.g., Constraints) ? CREATE TRIGGER ? Syntax ? Trigger Types ? "Inserted" (or "NEW") and "Deleted" (or "OLD") Tables ? Event Handling and Trigger Execution ? ALTER and DROP TRIGGER Using T-SQL Cursors ? Overview of Cursors ? Declaring a Cursor ? Using OPEN CURSOR, CLOSE CURSOR, DEALLOCATE CURSOR Statements ? FETCHing Results ? Testing @@FETCH_STATUS and @@CURSOR_ROWS ? Updating Records with Cursors