Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

SQL Server

11 Reviews

Mathikere, Bangalore

Course ID: 25021

Mathikere, Bangalore

Students Interested 1 (Seats Left 0)

₹ 20,000

11 Reviews

Date and Time

Not decided yet.

iTAS

MBA

About iTAS

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

Praveen Kumar

Attended SQL Server

"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. "

M

Manohar

Attended SQL Server

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.

S

Smd Elyaz

Attended SQL Server

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

T

Thrinath G

Attended SQL Server

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

L

Leelesha

Attended SQL Server

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

S

Sandeep T V

Attended SQL Server

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

M

Mailkarjuna R M

Attended SQL Server

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.

V

V Vinod Kumar

Attended SQL Server

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.

R

R.k Rajeshwari

Attended SQL Server

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.

G

Girish K

Attended SQL Server

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

T

Trilok

Attended SQL Server

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

View more Reviews

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

Reviews (11) See all Reviews

P

Praveen Kumar

Attended SQL Server

"iTAS is a place to learn all Analytic Tools. With good professional trainers, individual attention and...

M

Manohar

Attended SQL Server

It was a great learning experience for me and i would surely recommend this place to anyone who is looking...

S

Smd Elyaz

Attended SQL Server

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

T

Thrinath G

Attended SQL Server

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

L

Leelesha

Attended SQL Server

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

S

Sandeep T V

Attended SQL Server

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

Discussions

Students Interested 1 (Seats Left 0)

₹ 20,000

Post your requirement and let us connect you with best possible matches for BI Reporting Training Post your requirement now
₹ 20,000 Enquire

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