Tag Archives: Visual studio

Training Database with Visual Studio 2010 – 3 days

Class overview :

This three-day, instructor-led course provides students with the knowledge and skills to properly manage the SQL Server 2005/2008 database development lifecycle in an Agile environment. The student will learn how to manage changes to the database schema, ensuring quality through T-SQL unit testing, and how to automate the building and deploying of SQL Server databases.

Class goals :

Understand the database development capabilities of Visual Studio 2010
Understand the areas of integration with Team Foundation Server
Understand how the tools support an Agile database development lifecycle
Create and configure database projects and server projects
Compare schemas and data for differences from two SQL Server instances
Generate scripts to reconcile differences in schemas and data
Understand and create effective T-SQL unit tests
Understand and use database refactoring correctly
Use MSBuild and Team Build to manage build and deployment
Extend Visual Studio by creating your own database refactoring method, test data generator, unit test condition, and static code analysis rule

Content of Training Database with Visual Studio 2010

Class Outline

  1. Agile Database Development
    1. Agile database development
    2. Agile database techniques
    3. Visual Studio 2010 Premium Edition
    4. Case study
    5. Resources
    6. Lab Exercises
      1. Meet the AdventureWorks team
      2. Review the environment
      3. Deploy the database
  2. Database Projects
    1. Architecture of a database project
    2. Creating and managing database projects
    3. Visual Studio 2010 integration
    4. Importing database schema
    5. Importing SQL scripts
    6. Permissions
    7. Lab Exercises
      1. Explore Visual Studio integration
      2. Create a new database project
      3. Modify the database project
      4. Import a database schema
      5. Import a SQL script
  3. Change Management
    1. Introduction to Team Foundation Server
    2. Working with Team Projects
    3. Process templates and work items
    4. Using Team Foundation Version Control
    5. Placing database projects under version control
    6. Detecting and reconciling database schema differences
    7. Detecting and reconciling table data differences
    8. Lab Exercises
      1. Create a Team Project and work items
      2. Configure Team Foundation Version Control
      3. Place a database project under version control
      4. Explore and Visual Studio 2010 version control features
      5. Compare schemas for differences from two SQL Server instances
      6. Compare data for differences from two SQL Server tables
      7. Generate scripts to reconcile differences in schemas and data
      8. Explore the MSSCCI provider from SQL Server Management Studio (optional)
  4. Unit Testing
    1. Reasons to unit test your database code
    2. How to create database unit tests manually
    3. How to create database unit tests automatically
    4. Assertions vs. conditions
    5. Executing unit tests
    6. Managing and publishing test results
    7. Static code analysis
    8. Lab Exercises
      1. Create and execute database unit tests
      2. Use pre-test and post-test actions
      3. Use an ordered list to run tests
      4. Export and import test results
      5. Create unit tests automatically from the Schema View window
      6. Run static code analysis
  5. Refactoring
    1. Introduction to refactoring
    2. Refactoring support in Visual Studio 2010
    3. Database refactoring methods
    4. Rename refactoring methods
    5. Move refactoring method
    6. Fully-qualify refactoring method
    7. Expand-wildcard refactoring method
    8. Resources
    9. Lab Exercises
      1. Approaches to renaming database objects
      2. Use the rename refactor method
      3. Preview changes
      4. Undo refactoring using global undo
      5. Review the refactoring log
  6. Data Generation
    1. Issues with test data and some potential solutions
    2. Data generation plans
    3. Data generators
    4. Regular expression generator
    5. Data bound generator
    6. Creating and running a data generation plan
    7. Automatically generating data prior to running unit tests
    8. Lab Exercises
      1. Create a data generation plan
      2. Use the Regular Expression data generator
      3. Use the Data Bound generator
      4. Configure generation for related table and set ratios
      5. Generate data automatically prior to running unit tests
  7. Build and Deploy
    1. The need for automated build and deployment
    2. Building database projects
    3. Deploying schema changes
    4. The VSDBCMD.exe command line utility
    5. Integration with MSBuild
    6. Integration with Team Foundation Build
    7. Lab Exercises
      1. Build the database project
      2. Deploy database schema changes
      3. Use custom deployment scripts
      4. Automate using MSBuild and Team Foundation Build
  8. Extensibility
    1. Visual Studio 2010 Areas of extensibility
    2. Visual Studio database project and item templates
    3. Custom database refactoring methods
    4. Custom static code analysis rules
    5. Custom test data generators
    6. Custom unit test conditions
    7. Custom check-in policies
    8. Lab Exercises
      1. Customize database object templates
      2. Create a custom data generator
      3. Create a custom unit test condition
      4. Create a custom code analysis rule (optional)
      5. Create a custom refactoring method (optional)
      6. Create and debug a custom check-in policy (optional)
Database with Visual Studio 2010
Training Database with Visual Studio 2010

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …

Training Real World Agile and Scrum – 2 days

Class overview :

This is not your typical Agile and Scrum 101 course. This course is designed to spend 25% of the time on « What » and « Why » behind Agile and Scrum and 75% on how you can actually start using it on your team tomorrow! This is team training so all roles (including the business product owners) should attend! In this Agile and Scrum course, attendees will learn real world techniques used by dozens of teams.

Class goals :

Compare Waterfall to Agile.
Learn the Agile values and principles.
Learn what Scrum is, the roles involved, and the process.
Compare and contrast Agile and Scrum roles to traditional roles and responsibilities.
Learn the Agile Lifecycle.
Learn to plan your release and build the backlog.
Learn to identify good stories.
Learn the methods for prioritizing and sizing stories.
Learn Sprint Planning and task estimating.
Learn about the Daily Scrum Meeting.
Learn about the Sprint review and retrospective.
Learn why Agile and Scrum are adopted.
Learn how Agile can fail and how to avoid pitfalls.

Content of Training Real World Agile and Scrum

Class Outline

  1. What is Agile & Scrum and Why?
    1. Traditional Project Characteristics
    2. The Agile Values
    3. What is Agile
    4. What is Scrum
    5. Agile Characteristics
    6. The Iteration Process
    7. The Backlog
    8. Agile/Scrum Top Terms
    9. Scrum Rules Cheat Sheet
  2. Agile / Scrum Roles
    1. Scrum Roles
    2. Who is the Product Owner?
    3. Product Owner is the Business Value Driver
    4. Product Owner is the Daily Decision Maker
    5. Business Users and SMEs
    6. The ScrumMaster
    7. ScrumMaster is a Servant Leader
    8. The Team
    9. Sample Team Structure
    10. The Team – Characteristics
    11. Team Maturity Stages
    12. Management Has a Role Too
    13. Best Practice: Reduce Cross-Project Multi-Tasking
    14. Best Practice: Plan Well for Shared Resources
    15. New Skills Are Needed
    16. Agile Roles – Handout
    17. Workshop – Agile vs. Traditional Roles
    18. So Why is Agile Being Adopted?
    19. So Who is Doing Agile?
    20. Challenges with Agile Adoption
    21. Workshop – Assessing Your Agility
    22. The Agile Lifecycle – Big Picture
    23. READY… SET… GO!
  3. Release Planning
    1. Product roadmap
    2. Release Planning
    3. Release Planning Steps
    4. Release Planning (picture)
    5. Principles for Identifying Stories
    6. Identifying Features / Stories
    7. Use Case Diagrams
    8. Themes, Features, Epics, Stories
    9. Sample Backlog
    10. What is a Story?
    11. Sample Stories
    12. Writing Good Stories
    13. Workshop – Identifying Features Using Use Cases
    14. Breaking Stories Into Small Chunks
    15. Sample Compound Stories
    16. Sample Complex Stories
    17. Sample Non-Functional Stories
    18. Workshop – Writing Stories
    19. How to Prioritize
    20. Prioritization Factors
    21. Dependency Chart Example
    22. Best Practice: Do Collaborative Requirements Gathering
    23. Workshop – Prioritizing Stories
    24. Sizing Stories Based on Complexity
    25. Story Points
    26. Hours vs. Story Points
    27. Playing Poker
    28. The ‘Complexity Buckets’ Method
    29. Workshop – Sizing Stories
    30. Building a Release Plan
    31. Defining the Team’s ‘Done’
    32. Sample Definition of ‘Done’
    33. Sample Definition of ‘Done’ ..
    34. How Long Should My Iteration Be?
    35. Estimating Initial Velocity
    36. Workshop – Estimating Initial Velocity
    37. Planning for Additional Iterations
    38. Developing the Project Estimate
    39. Have Realistic Expectations
    40. Sample Release Plan
    41. Workshop – Building Your Release Plan
  4. Iteration 0 / Setup
    1. Sprint 0 – Setting Up the Foundation for Success
    2. High Level Designs
    3. Team Training
    4. The Team Room / Environment
    5. Best Practice – Plan for ‘Gotchas’
    6. Workshop – Iteration 0 Planning
  5. Iteration Execution
    1. Iteration Planning
    2. Sample Iteration Plan
    3. Best Practices for Efficient Iteration Planning
    4. sample user test cases
    5. Best Practices for Task Breakdown
    6. everyone writes their tasks
    7. commitment reality check
    8. resource utilization sample
    9. best practice – involve shared resources
    10. Best practice – plan for ‘design’ and ‘code review’ tasks
    11. Workshop – Iteration Planning
    12. Creating the Task Board
    13. Task Board Variations
    14. daily tracking
    15. Daily Standup Rules
    16. Best Practice: ETA Dates vs. Hours Remaining
    17. Best Practice: Control Common Standup Dysfunctions
    18. Best Practice: Task Dependency Chart
    19. Iteration Burn down Charts
    20. iteration burn down – by story
    21. Best Practice Use Them With Caution
    22. Workshop- Controlling Standup Dysfunctions
    23. What Happens During the Iteration
    24. The ScrumMaster
    25. The Product Owner
    26. The Architect
    27. The Developer
    28. The BA
    29. The Tester
    30. impediments
    31. Impediment sample
    32. preparing for the review/demo
    33. iteration review
    34. Tracking Team’s Performance (Velocity)
    35. Managing Scope Changes
    36. Release Burnup Chart
    37. Iteration Retrospective
    38. best practices for retrospectives
    39. sample retrospective output
    40. Workshop – The Retrospective
  6. Pre-Release & Closure
    1. The Pre-Release Sprint
    2. Workshop – The Art of the ‘Possible’
  7. Our Top Best Practices
    1. Our Top Management Best Practices
    2. Our Top Team Best Practices
    3. Our Top Requirements Best Practices
    4. Our Top Technical Best Practices
Real World Agile and Scrum
Training Real World Agile and Scrum

Onze voordelen :

  • Type of training: Inter-company, intra-company and individual
  • 100% flexible & personalised training : You choose the place, the dates and the training program
  • Offer request : Response within 24 hours
  • 50% discount for SME’s from Brussels-Capital Region
  • Free parking, lunch & drinks
  • Free use of our Digital Competence Centre: Manuals, courses, exercises, …