At the completion of this course participants will be able to use SQL scripting to query databases

Course Outline:

• Using Sql Server Management Studio
• Retrieve data
• Sorting data
• Filtering data
• Calculated fields
• Data manipulation functions
• Grouping data
• Working with subqueries
• Joins
• Inserting, updating and deleting
• Creating and manipulating tables
• Views

Participants should have an IT background but do not need to have prior SQL experience

At the completion of this course participants will be able to program tasks in SQL and understand how and when to use SQL transactions

• Triggers
• Stored procedures
• User defined functions
• Transaction processing
• Writing administration scripts

Participants should have an IT background, have attended the SQL essentials course and be familiar with programming.

At the completion of this course participants will be able to create simple web sites

Course Covers:

• Using Visual Studio
• Web development basics
• HTML
• CSS
• Bootstrap 4
• Server side vs client side
• Introduction to Javascript
• Basic web application security
• The benefits of using a CMS

Participants should have an IT background but do not need to have prior web development experience

At the completion of this course participants will be able to create simple applications using Visual Studio and C#

Course Covers:

• Using Visual Studio
• Understanding VS projects
• How to choose an application type
• Developing console applications
• Windows forms applications
• asp.net applications
• Web services

Participants should have an IT background and be proficient in at least one programming language. Prior experience with C# is not required.