News

Webinars from Spindustry on SharePoint, MS Teams, and Power BI

Spindustry offers a variety of ways to learn more about solutions to benefit your business. Below is a list of upcoming webinars or pre-recorded sessions that we hope you find helpful.

Five Benefits of Live Instructor Led Training

Five Benefits of Live Instructor Led Training

Experts still agree that there are no viable replacements for having a live professional in the room during training sessions.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.


CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Working with Data Using C# .NET or Visual Basic .NET and SQL Server 2005

Course Code: STT1009
Length: 5 Days
Tuition: $1,500.00

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

 

This 5-day, instructor-led course provides students with a solid understanding data from a C# or VB.NET perspective. This course concentrates on the items that a C# or VB.NET developer would need to know while working with data in the .NET environment. It includes information about ADO.NET and Transact-SQL syntax such as Select, Insert, Update and Delete statements. This course also discusses real-world subjects like Stored Procedures, User-defined Functions and how they can be used to make a .NET application more efficient. It also covers information on administering SQL Server and the tools needed for administering SQL Server as it pertains to a C# developer including topics like creating a database, backing up a database and securing the database. This course also covers how to increase the performance of a SQL Server 2005 database including subjects like Indexes, Statistics and efficient Relational Database Design. It is designed as a hands-on, lab intensive 5 day class.

Prerequisites

  • Familiarity with relational data.

Course Outline:

 What we need to know before learning to write queries or code

 
·         Introduction to Microsoft SQL Server 2005
o   Overview of items we will need for this course:
Microsoft SQL Server Management Studio (SSMS)
Connecting to a server
The Object Explorer
The Query Window
Creating a Project / Solution
 
·         Overview of Relational Data
o   Relationships overview
o   Database Diagrams
o   Database Schemas
 
Administration Overview of SQL Server
 
            SQL Server Tools
·         SQL Server Management Studio
·         SQL Server Configuration Manager
·         SQL Profiler
·         Using Visual Studio to access data
 
Managing Databases and Files Overview
Managing Security
            Logins
            Database Users
            Permissions
            Roles
            Object Schemas
 
 
Implementing Databases
 
            Data Types
            Creating Tables
            Implementing Data Integrity with Constraints
·         Foreign Key Constraints
·         Check
·         Default
 
Retrieving and Manipulating Data
 
·         Select Statements
o   SELECT List
Using an Alias for column names
o   FROM Clause
o   WHERE Clause
IN operator
BETWEEN operator
LIKE operator
AND / OR / NOT operators
o   ORDER BY Clause
o   TOP keyword
 
·         Useful T-SQL Functions
 
·         Joining Multiple Tables
o   JOIN Operator
o   LEFT / RIGHT / OUTER JOIN
o   UNION
 
·         Grouping and Summarizing Data
o   Working with Aggregate Functions
o   GROUP BY Clause
o   HAVING Clause
o   COMPUTE and COMPUTE BY
 
·         Using Subqueries
o   Subqueries as expressions
o   Subqueries as Tables
o   Correlated Queries
o   EXIST Clause
 
Inserting, Updating and Deleting Data
·         INSERT statements
·         UPDATE statements
·         DELETE statements
 
Advanced T-SQL Topics
·         Stored Procedures
·         Views
·         User Defined Functions Overview
·         Triggers Overview
·         Advanced T-SQL Functions
 
 
ADO.NET
·         ADO.NET Overview
·         The Process of Connecting to a Database
·         Creating and saving connection strings
·         SQLConnection Object Features
·         Understanding Connection Pooling
 
 
Querying and Updating a database using ADO.NET SQLCommand object
·         SqlCommand object features
·         Passing parameters into commands
·         Using commands to execute stored procedures
 
Transactions
            SQL Server transactions
            ADO.NET transactions
 
ADO.NET Dataset Object
·         Disconnected data using Datasets
·         SQLDataAdapter
·         Working with Table Adapters and Typed Datasets
·         XML Representations of Datasets
 
More Implementing Databases
 
            Creating and Tuning Indexes
Query Performance Overview
Query Execution Plans
            Transactions and Locking
            Cursors and Cursor Refactoring

 

back to top