Deskription My Name is Dilip, I love sharing my knowledge so far I am going to start a new T-SQL batch starting first week of Feb. Intended audience: • Any one who doesnot have any IT industry experience • Any one who wants to jump into IT industry as Database (T-SQL) Developer • Any one who is commited to learn SQL Database and BI (SSIS,SSRS, SSAS) tools There will be 3 (every other day) classes in a week and training will make you SQL expert in 7-8 weeks. For your information: I will take online Classes through webex New Batch starting from Tuesday Feb 6, 2017 at 8:00 PM CST There will total 24 classes (2 hr/Class) Interactive session with lot of real time examples Note: Don't miss learning Opportunities Training Fee: $300.00 for Independent student. Training Fee: Free for Vastika Inc Contractors (IF you want to do marketing through Vastika). Contact: Phone: 214-518-4192 (after 6 PM CST) Email: chapagaindr@gmail.com http://dchapagain.blogspot.com... This training will be covered using T-SQL and also below tools will be also covered during training: 1. Microsoft SQL server management studio 2. Transact SQL Developer 3. SQL Server Integration Services 4. SQL Server Reporting Services 5. Data Warehousing Concept 6. SQL Server Analysis Services SQL CLASS [24 hr] SQL: [12 hr], SSIS: [6 hr], SSRS: [3 hr], SSAS: [3 hr] SQL: [12 hr]: 1) Downloading and Introduction of SQL 2) Creating Tables and Other Permanent Objects 3) Writing Single Table Queries -Building Your Foundation 4) T-SQL Fundamentals: System Functions and Query Writing 5) Data Types, Temp table, Derived table, IF, and Variables 6) Subqueries, CTEs, Set, Rank Operations and More 7) SQL Constraints and Indexes 8) SQL JOINS 9) Stored Procedure 10) Triggers, View and Functions 11) Transactions, Locking and Blocking 12) Execution Plan and Performance Tuning Tips SSIS: [6 hr]: 1) Introduction of Package Creation 2) Tools and Transformations 3) Common SSIS Tasks 4) Saving, Encrypting and Logging 5) Configuration and Deployment 6) Project work and Interview Question SSRS: [3 hr]: 1) Employee Details, Drill down E Details Reports 2) Parameterized, Cascaded Parameterized Reports 3) Sub/Chart Report and Interview Questions SSAS: [3 hr]: 1) Introductions and Data warehouse concept 2) Sample Star Schema example 3) Terms and Terminologies Bonus Class [1 hr]: 1) Interview Questions Resume Preparation Last edited: 24-Jan-17 09:23 PM