-MSBI developer and trainer having 6+ years of real time experience
-Provide real time training with live example starting from Ms SQL basics like what SQL, database and understanding how data is essential for applications and organisation.
-Covering the topics and guiding from Basics to expert level
Giving real time tasks, involving in real-time examples.
-Explaning the role of developer, understand the requirements, communication towards clients.
-Guiding zero level knowledge to 4+years of Knowledge as MS SQL developer.
- Real time knowledge and examples will be used to explain each and every topic that we cover
SQL Topics:
Introduction to Data, Structured, Unstructured Data, -Database, DBMS and RDBMS
Datatypes
SQL Statements
Constraints
Identity Property
Joins
Conditional Operators, Mathematical Operators and Set Operators
String Functions
Date Functions
Ranking Function
Aggregate Functions
Sub Queries
Temporary Table & Table Variable
T-SQL Topics
Views
User Defined Functions
Stored Procedures
Indexes
Synonyms
Cursor
Triggers
CTE (Common Table Expression) and Derived Table
Query Tuning Techniques
Transactions and ACID Properties
Locks, Blocking and Dead Locks
Dynamic SQL
Subjects
-
SQL Beginner-Expert
-
SQL Scripting Beginner-Expert
-
SQL RDBMS Beginner-Expert
-
SQL Queries Beginner-Expert
-
SQL query writing Beginner-Expert
Experience
-
Senior software Engineer (Dec, 2018
–Present) at Infinite Computer Solutions
MSBI developer having 6+ years of experience in Ms SQL development
5+experience in SSIS, POWER BI AND AZURE
Fee details
₹250–400/hour
(US$2.97–4.76/hour)
Course fee will be varied based level of training required