Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

0( 0 REVIEWS )
Overview If you are aspiring to get into the BI industry, this course might be the one for you. This …


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?
  • Learning outcomes
  • Access duration
  • Who is this course aimed at?
  • Entry requirements
  • Method of assessment
  • Certification and awarding body
  • Progression and career path
  • Other benefits

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.

  • 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

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.

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

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

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.

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.

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,

  • Configuration Manager – £37,654 per annum
  • Network Analyst – £30,331 per annum
  • Network Administrator – £25,193 per annum
  • Network Manager – £30,824 per annum
  • 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 TOTUM discount card

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

Students feedback


Average rating ()
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

WhatsApp chat