Microsoft SQL Server Training Packages



Do you have personnel transitioning into Microsoft SQL Server related roles? Do you want to get them up to speed in no time?

Not to worry, Black Ninja Software offers comprehensive packages that will train your employees to be more effective and efficient in Microsoft SQL Server.

All training happens on-site, so your employees will work in a familiar environment.

None of the packages seem to fit your needs? Contact us, and we would gladly consult with you and provide you a package or training that meets your requirements.

Microsoft SQL Server Developer Starter Training Package

This provides a comprehensive overview of what Microsoft SQL Server developers typically do. This course will cover a guided and hands on approach to:

  • Using and making the most of Microsoft SQL Server Management Studio
  • Scripting with Transact-SQL
  • Creating and managing database objects (tables, indexes, views, stored procedures, user defined functions, triggers)

Intended audience:

  • Those who are new to Microsoft SQL Server
  • Those who want a refresher on Microsoft SQL Server

You can choose this package in two formats:

  • Fast Track – 1 day, fast paced, minimal hands on
  • Normal Track – 3 days, regularly paced, more hands on

Microsoft SQL Server Developer Advanced Training Package

This provides a comprehensive overview of more advanced Microsoft SQL Server 2005/2008 features that developers can take advantage of.

  • Common Table Expressions, cross/outer apply, set operations
  • XML, XQuery, XPath
  • SQL CLR (Common Language Runtime) – including SQL CLR UDFs, Stored Procedures, Triggers and Aggregates
  • SQLCMD developer tricks

You can choose this package in two formats:

  • Fast Track – 1 day, fast paced, minimal hands on
  • Normal Track – 3 days, regularly paced, more hands on

Microsoft SQL Server DBA Starter Training Package

If you are managing databases, there are some basic tasks you need to be aware of. This course provides a comprehensive overview of typical operational DBA tasks and responsibilities.

  • Monitoring SQL Server activity
  • Managing SQL Server security
  • Backup/Restore
  • Import/Export
  • Log shipping and other high availability options

There is one format for this course:

  • Normal Track – 1 day, fast paced, minimal hands on

Microsoft SQL Server Business Intelligence Developer Starter Training Package

This provides a comprehensive overview of what SQL Server BI developers typically use and do. This course will cover a guided and hands on approach to:

  • SQL Server Reporting Services
  • SQL Server Integration Services

Microsoft SQL Server Reporting Services Training Package

This provides a comprehensive overview of what SQL Server BI developers typically use and do. This course will cover a guided and hands on approach to:

  • Installing and configuring SSRS
  • Creating basic reports
  • Creating advanced reports
  • Deploying reports
  • Managing basic report security
  • (Optional) Integrating SSRS with SharePoint

Microsoft SQL Server Integration Services Training Package

This provides a comprehensive overview of what SQL Server BI developers typically use and do. This course will cover a guided and hands on approach to:

  • Installing and configuring SSIS
  • Updating DTS packages
  • Converting data from heterogeneous sources (Access, Excel, Text File, ODBC)
  • Creating SSIS packages with common data transformations
  • Working with file system (creating, copying, moving, deleting, FTP’ing files)
  • Working with XML (creating XML files from the database, traversing and querying XML nodes)
  • Capturing and logging errors
  • Deploying and securing packages
  • (Optional) SSIS for DBAs

Please send an email to contact@blackninjasoftware.com to request an outline and learning outcomes for these courses, or for price quotes.

Archives

Upcoming Training Events


We also have courses on Ruby on Rails and iOS Development!

Check our training page for schedule, content and rates!

We are experts

Black Ninja Software was created with the idea that great software comes from great people. We are passionate about the technologies we use and continually refine our skills to better master what we do. This is what makes us Ninjas. We architect, design, and implement solutions using Microsoft Office SharePoint Server, SQL Server, and ASP.NET

We create software

If you have a business process that needs refining or automation, or you have a current project in distress that needs rescuing, we can help. Our wealth of experience will create your great idea from scratch if that's what you need ninjas to do for you. In addition to the work we do for our clients, we also have several of our own projects that are currently being developed. We use the same tools and the same skills on our projects as we do on yours.