loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for SQL Server

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With iTech Analytic Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

Share

course photo

SQL Server

Mathikere, Bangalore

20,000

11 Reviews
1 Interested

About the Course


Microsoft SQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights and quickly build solutions to extend data across on-premises and public clouds, backed by mission critical confidence. SQL Server 2012 continues the evolution and maturity of a trusted platform that continuously leads in industry-relevant and real-world application performance benchmarks. It still includes many of the same capabilities and characteristics that administrators have come to trust for over 10 years while also launching some new features that change how databases make data available across the enterprise

Topics Covered

MS SQL 2012 - SQL DBA Concepts –> 30 Hours
The First time in ITECH History we are introducing MS SQL SERVER 2012 Training for DEVELOPER/DBA/MS BI Professionals.
This training for SQL Developer Professionals, DBA Professionals and MS BI Professionals.
MS SQL 2012 Developer CONCEPTS:
1. Introduction like what is SQL, what are the major differences in SQL 2005/2012: -1 Hour
2. Querying Databases – 2 hour
3. Retrieving Result Sets. – 2 hours
4. Functions and Joins – 2 hours
5. Using Sub queries and Managing Databases– 4 hours
6. Creating Tables and Enforcing Data Integrity. – 2 hours
7. Manage Data in Tables. – 2 hours
8. Implementing Indexes– 2 hours
9. Implementing Views and Batches– 4 hours
10. Implementing Stored Procedures– 4 hours
11. Implementing Triggers– 2 hours
12. Implementing Transactions and Cursors– 2 hours
13. UNIONS, CTE and MERGE Concepts– 2 hours
14. Real time issues/experience/ any specific questions/Scenarios– 2 hours
MS SQL 2012 MS BI CONCEPTS - SSIS:
1. Basic Data Warehouse/BI Concepts – 1 hour
2. Working with Connection Managers– 2 hours
3. Integration Services service. – 2 hours
4. Integration Services Object Model– 1 hour
5. Integration Services Runtime and the run-time executables– 1 hour
6. Integration Services Data Flow– 2 hours
7. Saving and Running Packages– 2 hours
8. Deploying SSIS packages– 2 hours
9. Scheduling SSIS packages– 2 hours
10. Sample of Project.


MS SQL 2012 MS BI CONCEPTS - SSRS:
1. Basics
2. Reporting Services Components
3. Windows Service:
4. Reporting Services Components - Report Designer
5. Business Intelligence Development Studio (BIDS)
6. Create a Simple Report with the Wizard
7. Launch the Report Wizard
8. Design the Query
9. Different Report Types
10. Report Deployment
MS SQL 2012 DBA CONCEPTS:
MS Sql 2012 DBA is completely real time training which includes below topics in advance level from real time expertise. In the training we concentrating on practical part rather than covering theoretical part. In each topic we discuss with Practice files, Reference Docs and Assignments. Training material and software is provided and also resume building technique is free from this training.
1) Performance Tuning – 3 hours.
2) Optimization – 2 hours.
3) DBCC Concepts – 1hour.
4) How to give access to Users – 1 hour.
5) Usage of profilers – 2 hours.
6) Backups Models – 2 hours.
7) Restore concepts – 2 hours.
8) Different recovery models – 2 hours.
9) Operators, Database email, Schemas, Security Models – 2 hours.
10) How to create Indexing and its types – 4 hours.
11) Index scan-seek/table scan-seek concepts – 2 hours.
12) Advance Topics – 5 hours.
13) Assignments – 2 hours.


Who should attend

Anyone who are interested in Database Management

Pre-requisites

Basic Computer Knowledge

What you need to bring

Bring your own laptops

Key Takeaways

Skills of Database, Queries and good knowledge of Analytics
Content
Reviews

Praveen Kumar

""iTAS is a place to learn all Analytic Tools. With good professional trainers, individual attention and eye for detail you surely would want to try this place out for SAS, VBA, Excel and many more tools. It was a great learning experience for me and i would surely recommend this place to anyone who is looking to kick start or enhance their career by improving the technical skills. Thanks iTAS. " "

attended SQL Server


Manohar

"It was a great learning experience for me and i would surely recommend this place to anyone who is looking to kick start or enhance their career by improving the technical skills. Thanks iTAS. "

attended SQL Server


Smd Elyaz

""iTAS consistently provides the best trainings. No exception here. Soon joining SAS and SQL courses." "

attended SQL Server


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Praveen Kumar

""iTAS is a place to learn all Analytic Tools. With good professional trainers, individual attention and eye for detail you surely would want to try this place out for SAS, VBA, Excel and many more tools. It was a great learning experience for me and i would surely recommend this place to anyone who is looking to kick start or enhance their career by improving the technical skills. Thanks iTAS. " "

attended SQL Server


Manohar

"It was a great learning experience for me and i would surely recommend this place to anyone who is looking to kick start or enhance their career by improving the technical skills. Thanks iTAS. "

attended SQL Server


Smd Elyaz

""iTAS consistently provides the best trainings. No exception here. Soon joining SAS and SQL courses." "

attended SQL Server


Thrinath G

""Achieved, this course will allow me to gain faster standalone proficiency in Macros and SQL and importantly in Analytics." "

attended SQL Server


Leelesha

""Achieved, this course will allow me to gain faster standalone proficiency in Macros and SQL and importantly in Analytics." "

attended SQL Server


Sandeep T V

""iTAS consistently provides the best trainings. No exception here. Soon joining SAS and SQL courses." "

attended SQL Server


Mailkarjuna R M

"I went through the training for mainly excel and sql. They were excellent, very professional, and extremely helpful and helped to increase my knowledge regarding these tools. "

attended SQL Server


V Vinod Kumar

"I went through the trainers for mainly excel and sql. They were excellent, very professional, and extremely helpful and helped increase my knowledge regarding these tools. "

attended SQL Server


R.k Rajeshwari

"I have studied SQL course in iTech Analytic Solutions , it is easy to understand the concepts, and very use full. The classes are taken perfectly and we can acquire the knowledge. The faculty was very good and he explained all the concepts of SQL queries with real time scenario. Sandeep sir was excellent in his teaching we are lucky to get such a good staff. This is a well-organized Institute. "

attended SQL Server


Girish K

"Achieved, this course will allow me to gain faster standalone proficiency in Macros and SQL and importantly in Analytics. "

attended SQL Server


Trilok

"Thank you ITAS for giving me the opportunity to do this course. It has given me knowledge and great confidence for further career progression "

attended SQL Server


Date and Time

Not decided yet.

cash back100% Money Back Guarentee

About the Trainer

iTAS

MBA


10+ Years of experience in Advance Excel, VBA, Macros, Access, Dashboard Designing, Automation, MS Word, MS PowerPoint, SAS, Analytics, Statistics
Seats Left-

Students Interested 1

Course Id: 25021