About the Course
• Sub Queries (Step by step to create subqueries)
• Normalization
• Entity-relationship
• One to One relationship
• One to Many relationship
• Many to many relationship
Stored Procedure
• Introduction
• Default delimiter
• Create Stored Procedure
• Remove Stored Procedure
• Variables
Parameters
• IN
• OUT
• INOUT
• Alter Procedure
• List Procedure
Conditional Statements
• IF statement
• CASE statement
Loops
• Loop
• While Loop
• Repeat Loop
• Leave statement
Error Handling
• Handling exceptions
• Raising errors
Section 6. Stored Functions
• Creating a stored function.
• Removing a stored function
• Listing stored functions
Triggers
• Create triggers
• Time - Before and After,
• Event - Insert, Update, Delete
• Drop triggers – show you how to drop a trigger.
• Show triggers – list triggers in a database, table by specific patterns.
Partitioning Table
• Partition by Range
• Partition by List
What is special in this course compare to other trainers?
• 26+ Years real-time experienced trainer.
• Teaching from the basic to advanced topic in methodological way.
• All concept is explained with realtime data
• On spot practice
• Assignment for each concept
• Online objective type test to check your knowledge
• Each query concept will be explained in step by step in-depth.
• Interview tips
Who should take up SQL course Level 2?
Software Engineers and Data Analysts
Business Intelligence Professionals
SAS Developers wanting to learn the SQL
Those aspiring for a career in Data Science
What are the prerequisites?
You should be thorough with SQL Level 1. Basic knowledge of programming language can be helpful.