Training Program - Database and Datawarehouse/ETL Devlopers

Introduction to Course

Database Development is the most critical phase for IT project execution where data modeling and database development and administration concepts are applied to build robust data marts and database. The backbone of a Business Application is the database and database experts are sought out by the industry as they provide the basis of project development. A Database developer/Modeler is the most critical consultant of IT projects. A Career in Datawarehousing is very rewarding and satisfying.

We invite motivated individuals beginners or experienced professionals who are interested in making a skilled career in Microsoft SQL server Technologies.

The course is exhaustive with introduction to SQL Server and SQL server development and TSQL, Coaching on SQL, OLTP (Online transaction Processing), OLAP (Online Analytical Procesing or data warehousing), relational database concepts, start schema and OLAP modeling concepts, ETL, (Extract Transform and Load) database administration at a beginners level and introduction to SSIS, SSRS and SSAS technologies. The course is taught using live data and scenarios built out by senior industry experts.

Pre-requisites

To be successful, learners who attend this course must have working knowledge of SQL and RDBMS concepts, and Pass a SQL test, to be inducted into the course. Students who have no prior background of SQL will be guided by our staff to various self study links on SQL or may participate in workshops and gear up in the SQL area. Students must have a database inclination and excellent communication skills and a strong desire to work in a highly communicative and fast moving world. Students must have done atleast one course during their education related to database management.

Logistics of the Course

This comprehensive instructor-led course that will span over 4 to 6 weeks weeks spanning 40 hours of instruction and access to case studies.

The base lectures are conducted by in-house experts who have more than a decade of SQL Servre experience and are exposed to various modules and there will be one guest lecture by an industry experts who is carrying forth a lead SQL developer role with a Fortune 100 company currently.

Every lecture is concluded with a case study. Students are encouraged to discuss their issues they faced completing the case studies during the class. Students use google groups to communicate with each other and google docs to review material.

Project Work

After the Completion of the 4 to 6 week week course students are required present their project work and explain what they have accomplished as a business analyst.

Audience

The target audience for this course will be beginners with a US Masters degree or experienced professionals who have a strong desire to be database and datawarehouse developers

What you get out of the Course

Students will be able to understand the basic techniques of data modeling, ER diagrams, SQL, will be able to write stored procedures, understand relational tables very well and understand start schema modeling very well. Advanced Students will also be able to work on SSIS and SSRS reports.

Start off as a SQL Server developer in the industry. Junior Developers will be able to get a big picture of the Suite of products and be able to decide their career path in which area they would like to do database development and students will be exposed to that technology area as well. Students can chose to be administrators or BI developers.

Contact Details

Please call us at 973-917-4139 or email us at training@armo-solutions.com to discuss logistics.

Print Application Form

Please click on link below to save and print our application form for training; Please email form along with your resume to training@armo-solutions.com and we will contact you promptly.

1) ARMO Data Training Application Form

Course Schedule for 2010

Subject to slight variation depending on hiring batch size of 5; Aug 8, Aug 15 2010 through Sep 8 or Sep 15, plus additional 2 weeks for project completion.

Course Outline

Introduction to SQL, TSQL, RDBMS, OLTP systems, MSSQL Server Basic concepts and architecture, ER diagrams, Data modeling, Star, Snowflake and OLAP concepts. Exercises in Transact SQL and execution of procedures. Introduction to ETL, SSIS and Reporting SSRS and advanced concepts. Introduction to SSAS (Analytics only for senior consultants) Project execution, build of Database coding, strored procedures, SSIS data ETL and SSRS. Resume and interview preparation and positioning into projects.