• LOGIN
  • No products in the basket.

Overview

If you are aspiring to get into the BI industry, this course might be the one for you. This course is set to guide you thoroughly on business intelligence development and maintenance with Microsoft SQL server, to give your dream career the jumpstart it needs. From server implementation, to server maintenance, you will learn everything you need to know from this course to get started with BI.

You will be walked through how to configure and deploy SSIS, SSAS and SSRS of Microsoft SQL server to get you oriented with the database. How SQL server can be used in data analysis, and other topics such as error handling, scheduling deployed reports, extending reports and many more, will also be discussed in detail through this course.

By the end of this course, you will walk away with an outstanding knowledge on Microsoft SQL server 2008 to assist in your BI career. You can also use this course as a foundation to follow up on the other related courses or to demand for a higher pay or job promotion from your employer.

Why consider learning at study 365?

With so many commitments in our lives, we may not have the time to learn new skills. The beauty of studying online is that you get to find this balance between your education and your daily commitments

Study 365 offers hundreds of online courses to students across the world. Gaining new skills has never been this easy as many of our courses are open to students with little or no qualifications or previous experience. All the courses are up-to-date, relevant, affordable, and will build on existing expertise or give you a jump-start to a new career. The courses are meticulously designed and equals what is offered in a classroom setting. With a solid reputation that has established and made us made us one of the most trusted and reliable online course providers we offer the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in your chosen career. You can learn at your own pace at Study 365 and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules, interactive quizzes and free resources which include Free CV writing pack, free career support and course demo to make your learning experience enriching and more rewarding.

Learning outcomes

  • Learn how to implement, configure, deploy and maintain a SSIS solution
  • Understand how to implement, configure, deploy and maintain a SSAS solution
  • Explore how to implement, configure, deploy and maintain a SSRS solution

Access duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at any time.

Who is this course aimed at?

This course is mainly aimed at individuals interested in embarking on a business intelligence career. BI professionals might also find this course worthwhile to progress in their career. .

Entry requirements

  • Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

Method of assessment

At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed.

Certification and awarding body

Those who successfully complete the course will be awarded the Microsoft SQL Server 2008, Business Intelligence Development and Maintenance certificate by CPD & iAP. The qualification will make you valuable to employers, and your motivation at gaining new skills will be recognised.

Progression and career path

This certificate will improve your eligibility for an array of jobs in the IT industry. You can also use this certificate to study further in the subject or to make significant progress in your career. Below mentioned are few of the job roles this certificate will help you in, along with the average UK salary per annum according to https://www.payscale.com,

  • Configuration Manager – £37,654 per annum
  • Network Analyst – £30,331 per annum
  • Network Administrator – £25,193 per annum
  • Network Manager – £30,824 per annum

Other benefits

  • Written and designed by the industry’s finest expert instructors with over 15 years of experience
  • Repeat and rewind all your lectures and enjoy a personalised learning experience
  • Gain access to quality video tutorials
  • Unlimited 12 months access from anywhere, anytime
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Eligible for a NUS discount card
  • Free Career Support Service
  • 25% Discount on personal Statement and covering letter writing service
  • Free Access to Over 150 courses for 2 days (48 hours)
  • Free access to course before you purchase (For selected courses only

Course Curriculum

free introduction
Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance FREE 00:00:00
Course Brochure – Microsoft 70-448: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance FREE 00:00:00
1: SSIS Packages
1. Introduction 00:00:00
2. Creating SSIS Packages 00:00:00
3. Creating A New Package Lab 00:00:00
4. Data Sources Lab 00:00:00
5. Connections Lab 00:00:00
6. Control Flow 00:00:00
7. Creating And Editing Control Flow Lab 00:00:00
8. Data Flow 00:00:00
9. Data Flow Transformations 00:00:00
10. Data Flow Lab 00:00:00
2: Debugging and Error Handling in SSIS
1. Debugging And Error Handling in SSIS-Part 1-3 00:00:00
2. Enable Transactions And Observe Trans Rollback Lab 00:00:00
3. Set Checkpoints In A Package Lab 00:00:00
4. Setting Up Constraints Lab 00:00:00
5. Turn On Logging Lab 00:00:00
6. Identifying Data Flow Errors Lab 00:00:00
3: Deploying and Configuring SSIS Packages
1. Part 1 Deploying 00:00:00
2. Part 2 Sharing Ordering And Configuring 00:00:00
3. Create An XML Configuration Lab 00:00:00
4. Create A SQL Server Configuration Lab 00:00:00
5. Use A Property Expression To Update A Connection Lab 00:00:00
6. Deploying An SSIS Package 00:00:00
7. Create And Deploy An Installer Kit Lab 00:00:00
4: Securing and Executing SSIS Packages; Service Administration
1. Part 1 Securing And Executing SSIS Packages 00:00:00
2. Part 2 SSIS Package Security 00:00:00
3. Turn On Package Encryption Lab 00:00:00
4. Change Security Roles Lab 00:00:00
5. Executing And Administration 00:00:00
6. Create And Execute A Command-Line Statement Lab 00:00:00
7. Execute A Package Through SQL Server Agent Lab 00:00:00
5: Data Analysis
1. SSAS Cube Development 00:00:00
2. Create SSAS Project Lab 00:00:00
3. Create A Data Source Lab 00:00:00
4. Create A Data Source View Lab 00:00:00
5. Creating And Modifying SSAS Cube 00:00:00
6. Creating A Cube Lab 00:00:00
7. Using Cube Designer To Edit A Cube Structure Lab 00:00:00
8. Creating A Dimension 00:00:00
9. Create A New Dimension Lab 00:00:00
10. Creating Measure Groups And Measures 00:00:00
11. Add Measure Groups Lab 00:00:00
12. Configure Measure Groups And Measures Lab 00:00:00
6: Extending SSAS Cubes
1. Extending SSAS Cubes-Part 1 00:00:00
2. Define Attribute Relationships Lab 00:00:00
3. Define User Hierarchy Lab 00:00:00
4. Extending SSAS Cube-Part 3 00:00:00
5. Implement The Reseller Sales KPI Lab 00:00:00
6. Lesson3 Extending SSAS Cube-Part 3 00:00:00
7. Turn On Proactive Caching Lab 00:00:00
7: Extending SSAS Cubes
1. Part 1 SSAS Storage Processing And Deployment 00:00:00
2. Part 2 Aggregating And Enabling Proactive Caching 00:00:00
3. Turning On Proactive Caching Lab 00:00:00
4. SSAS Deployment 00:00:00
5. Deploy Database With Deployment Wizard Lab 00:00:00
6. Processing 00:00:00
7. Processing Scripts Using SQL Server Agent Lab 00:00:00
8: Securing and Administering SSAS
1. SSAS Security 00:00:00
2. Create A Role And Set Security Lab 00:00:00
3. Backing Up SSAS 00:00:00
4. Backing Up And Maintain Management Studio Lab 00:00:00
5. Managing SSAS Turning And Logging 00:00:00
6. Turning On Query Logging Lab 00:00:00
7. SSAS Administering 00:00:00
8. Turn On And Use SQL Server Profiler Lab 00:00:00
9. Monitor SSAS Performance Lab 00:00:00
9: Working With SSAS Data Mining
1. Part 1 Prepare And Creating Data Mining Structures 00:00:00
2. Part 2 Data Mining Algorithms And Usage 00:00:00
3. Data Mining Wizard Lab 00:00:00
4. Mapping Mining Structure Attributes To Source Columns 00:00:00
5. Create A Model From A Cube Lab 00:00:00
6. Predictive Models 00:00:00
7. Data Mining Security 00:00:00
8. Managing Permissions Lab 00:00:00
10: Developing SSAS Reports
1. Understanding SSRS Reports 00:00:00
2. Creating Reports Lab 00:00:00
3. Creating A New Report Database 00:00:00
4. Generate More Reports Lab 00:00:00
5. Advanced Report Object Properties-Part 1-2 00:00:00
11: Extending and Deploying SSRS Reports
1. SSRS Report Parameters 00:00:00
2. Create A Report Without Using Wizard Lab 00:00:00
3. Extending SSRS Reports 00:00:00
4. Deploying SSRS Reports 00:00:00
12: Scheduling Deployed Reports and Data Sources
1. Scheduling Reports And Subscriptions 00:00:00
2. Creating A New Role For SSRS Lab 00:00:00
3. SSRS And Data Sources 00:00:00
4. Set Up Shared Schedule Lab 00:00:00
13: Configuring And Administering the SSRS Server
1. Installing And Configuring SSRS Server 00:00:00
2. Changing Settings In Configuration Manager Lab 00:00:00
3. Administering The SSES Server And Command-Line Utilities 00:00:00
4. Backing Up And Restoring Encryption Keys Lab 00:00:00
5. Conclusion 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

CPD Accredited

UKRLP

ACCREDITED CERTIFICATE

certificate

Awarded by iAP

Awarded by iAP

CPD Accredited Partner

CPD Accredited

CPD Membership No: 10582

Study independently accredited and recognised CPD courses. Gain your certification today.

cvAll students enrolled with STUDY365 are entitled to a CV Writing and Interview Skills Pack, which includes CV templates, cover letter guidance, and advice for interviews.
MORE INFO

cvIf you need career support STUDY365 is here for you. We provide excellent career support through our Career Support Service.
MORE INFO

TOTUM Card

Totum Card




Address: Study365, 406 White Horse Lane, London E1 3FY

Certificate Code

Secure Payment
top