Sql And Bi Extensive Training New Batch Starting Soon..

[loveindia]

Hi guys,

 

I am starting a new batch for Microsoft SQL Server and Business Intelligence (SSIS, SSAS, SSRS) coming Monday. If anyone is interested in joining the course and listening to the demo class, do let me know. 

 

As a part of this course, apart from the Curriculum students will be working a real-time scenario based Timesheet Application Project for the whole class.

 

The topics that will be covered are as following.

 

· SQL Server Development Tools 
· Query Editor Features 
· Working with Tables 
· Selecting and Grouping Data 
· Limiting and Sorting Data 
· Combining Data from Multiple Sources 
· Transaction Principles 
· System and T-SQL Functions 
· Managing Locking and Query Performance 
· Implementation and Best Practices for Temporary Data Structures 
· Creating and Managing View and Triggers 
· Designing and Implementing User Defined Functions 
· Working with Variables 
· Developing and Implementing Stored Procedures  

SSIS

· Introduction to the SSIS environment
· Business Intelligence Development Studio (BIDS) 
· How to create a shared connection. 
· Overview of the commonly used tasks. 
· Overview of the commonly used transforms, source and destinations. 
· How to diagnose a problem in SSIS 
· Expressions and Variables 
· The expression language in SSIS. 
· The scoping of variables. 
· Debugging SSIS with the watch window 
· How to use variables and expressions to make a package dynamic. 
· Using the various containers. 
· Looping through tasks. 
· Writing common SSIS scripts 
· Using configuration files to externalize configurations 
·. Event Handlers 
· Deploying a package. 
· Scheduling SSIS packages. 
· Issues that you will encounter 
· Import and Export Column transforms 

 

SSAS

· Introduction to SSAS

· Facts

· Dimensions

· Data warehouse concepts

· KPI's

· Perspectives and slicing window partitioning.

· What is MDX?

· Star and Snow Flake Schema.

SSRS 
· Data Warehousing Uses
· Introduction to SSRS Environment 

· Report Types(Matrix, Tabular) 

· Creating a Project 
· Design Pane 
· Preview Pane 
· Solution Explorer 
· Report Wizard 
· Data Sets 
· Report Data Window 
· Basic Report with a Table 
· Data Retrieval 
· Queries 
· Query Builder(edit as text) 
· Stored procedure 
· Parameters in a Query 
· Parameters in a Stored Procedures 
· Deploying 
· Using Report Builder 
· Build a report with report builder 
· Text Box 
· Sub report 
· Actions (Drill downs. Open web pages) 
· Advanced Parameters 
· Stored Procedure Parameters 
· Cascading Parameters 
· Default Values 
· Multi value 
· Drop down menu 
· Administration 
· Report Manager portal 
· Report Server 
· Deploying 
· Subscriptions 
· Report Delivery Options

 

After the end of the course, if you are planning to take up a career in databases, I can guide you towards that.

 

Let me know if you are interested or please forward to any others that might be interested.

 

Please drop me a pm for more details if you need.

[BahuBali]

LTT 

[loveindia]

about the fee structure,

 

300 -- for fast paced course (just more like basics from where you get a gist of everything and can carry forward.) Not included in the Project.

 

500 -- total course including the project and advanced topics.

 

1000 -- Training + Marketing + Placement package.. Once you get placed, you will given back the amount you paid for Marketing and placement which is 500. 

 

Billing rates my students at least are working at 50+ (which is average I guess and believe).

 

If you have more questions, Pm me for answers...

[loveindia]

Basic course would last for atleast 30 days, Advanced for 40 days(which is basic+10days more) and with marketing and placement continuing after that.

[loveindia]

LTT 

 

why are you crying man???

[Hyderabad_Nawab]

LTT...

[DaleSteyn1]

about the fee structure,

 

300 -- for fast paced course (just more like basics from where you get a gist of everything and can carry forward.) Not included in the Project.

 

500 -- total course including the project and advanced topics.

 

1000 -- Training + Marketing + Placement package.. Once you get placed, you will given back the amount you paid for Marketing and placement which is 500. 

 

Billing rates my students at least are working at 50+ (which is average I guess and believe).

 

If you have more questions, Pm me for answers...

Which company are you affliated with ?

[loveindia]

Which company are you affliated with ?

 

I have my own company and I train for 4 consultancies and work with some prime vendors for the clients I worked for... ye affiliation aitey enti man job vachinda leda important... 

[loveindia]

LTT...

 

Happy new year Nani man.... 

[Hyderabad_Nawab]

Happy new year Nani man.... 

 

aasal nee bathuki siggu anedi unda

bazar lanjjjjjja laga matladutunnav

nek husband unnada aasal

tikka munda... tuuuu db ki ravali antene chirak dengutundi nee matal susutune

dengey lanjaaaaa

 

Haffy New Year baa.. e year nee consul lo >50 mandhi join avvalani praying..

 

IP Piccha Serious @ Pinkie..

[DaleSteyn1]

I have my own company and I train for 4 consultancies and work with some prime vendors for the clients I worked for... ye affiliation aitey enti man job vachinda leda important... 

 

refer cheyadaniki adiganu man ..cons definitely matters a lot desi gallu pay sarigga cheyaru so andhuke adiganu nee company name enti ?
 

[loveindia]

Haffy New Year baa.. e year nee consul lo >50 mandhi join avvalani praying..

 

IP Piccha Serious @ Pinkie..

 

This when happened man... edo sinna sinna gif lu esukune IP inta serious ayyadaa... 

[Hyderabad_Nawab]

This when happened man... edo sinna sinna gif lu esukune IP inta serious ayyadaa... 

Frustration Sir Incrustation...

[loveindia]

refer cheyadaniki adiganu man ..cons definitely matters a lot desi gallu pay sarigga cheyaru so andhuke adiganu nee company name enti ?
 

 

Company name nenu eppudu ikkada evariki cheppaledu man... anavasarapu publicity avasaram ledu ani... training nachitey they will join or else students telusugaa ela vellipotaaro... it's upto them I leave it always... inka pay antaava... okadi potta kotti mana potta nimpukovalsina avasaram ledu man... nenu student ga unnappudu elanti issues face chesaaano alanti issues lekunda business cheskovali anukunna... atlaney chestunna.... I will pm the company name for you later, if you really refer someone to me.. Thanks for that :) 

[DaleSteyn1]

Company name nenu eppudu ikkada evariki cheppaledu man... anavasarapu publicity avasaram ledu ani... training nachitey they will join or else students telusugaa ela vellipotaaro... it's upto them I leave it always... inka pay antaava... okadi potta kotti mana potta nimpukovalsina avasaram ledu man... nenu student ga unnappudu elanti issues face chesaaano alanti issues lekunda business cheskovali anukunna... atlaney chestunna.... I will pm the company name for you later, if you really refer someone to me.. Thanks for that :)

 

Sorry man if you are not so positive about posting your company name here I would rather refer them to  dallas Sai instead of you .All the best