Discover Classes. Earn Rewards.

Advanced SQL Server Developer Bootcamp is unfortunately unavailable

Thankfully we have 6 other SQL Server Classes for you to choose from. Check our top choices below or see all classes for more options.

SQL Level I

NYC Career Centers - Virtually Online

Learn the fundamentals of SQL and relational databases in this introductory course, where you'll gain the skills to write SQL queries, filter results, and combine data from multiple tables. Explore the basics of database architecture and develop your skills in writing real SQL code with practical, hands-on exercises.

(679) Beginner 18 and older

SQL Level II

NYC Career Centers - Virtually Online

Take your SQL skills to the next level by mastering advanced functions and techniques, including grouping data, filtering groups, working with dates and times, and performing advanced JOINs. Unlock the power of SQL to extract and analyze data with precision and turn it into actionable insights.

(679) Intermediate 18 and older

SQL Server Bootcamp

Noble Desktop - Virtually Online

Gain actionable insights and turn raw data into useful information with the SQL Server Bootcamp. Learn Microsoft SQL Server and how to write SQL queries to extract, join, aggregate, and filter data in databases. Take your data analysis skills to the next level at Noble Desktop.

(372) All levels 18 and older
$975

3 sessions

Gift it!

SQL Level III

NYC Career Centers - Virtually Online

Take your SQL skills to the next level with advanced techniques including subqueries, views, functions, and stored procedures in this comprehensive course.

(679) Advanced 18 and older

SQL Bootcamp

NYC Career Centers - Virtually Online

Master the art of extracting actionable insights from databases with the SQL Bootcamp at NYC Career Centers. Learn Microsoft SQL Server, join tables, aggregate data, and filter results in this hands-on course. Gain the skills needed to turn raw data into valuable insights for decision-making in any industry.

(679) All levels 18 and older
$975

3 sessions

Gift it!
See all SQL Server classes Online

Advanced SQL Server Developer Bootcamp

Master the intricacies of SQL Server development with the Advanced SQL Server Developer Bootcamp. This comprehensive course covers relational database fundamentals, SQL programming, Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS), as well as ASP.NET Web forms. Optional learning in Power BI is also available. Join now to gain a competitive edge in the IT workplace.

  • Advanced
  • 18 and older
  • $6,000
  • Virtual Classroom
  • 12 hours

Start Dates (0)

  • $6,000
  • Virtual Classroom
  • 12 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this sql server training:

The Advanced SQL Server Developer bootcamp includes coverage of relational database fundamentals, SQL programming, Reporting Services (SSRS), Integration Services (SSIS), and Analysis Services (SSAS) as well as coverage of ASP.NET Web forms. Students may optionally choose to also learn about Power BI, which is a business analytics service and reporting tool from Microsoft.

Our unique approach to teaching advanced SQL Server development combines on-demand training with personal facilitation and comprehensive hands-on exercises to assure successful training and competence in the IT workplace. Our support staff provides personal setup assistance, guidance and lab equipment setup for each student. An instructor with extensive SQL Server development experience is assigned to each student to assist in completing lab exercises and to help with any questions about the SQL Server developer content. Instructors have on average 10 years of direct SQL Server development experience, and are able to give students the advantage of their knowledge. Our classes are designed to be 50% lecture and 50% hands on exercises. Lab exercises are performed via direct high-speed access to a dedicated lab machine, providing responsive interaction and anywhere/anytime accessibility by the lab facilitator as well as the student.

This Advanced SQL Server Developer bootcamp provides a solid understanding of relational database design concepts, coding and utilizing SQL queries and database management tools. This SQL Server bootcamp includes comprehensive coverage of SQL syntax including complex queries, as well as creating and using stored procedures, functions, views and triggers. You will learn how to deploy and manage Reporting Services, create and customize reports including Table, Matrix, Parameterized and Linked reports. You’ll be introduced to the design and use of data warehouses and the use of SSIS to import/export data. A thorough introduction to SSAS includes creation of data cubes to support business analytics, and syntax for extracting information including the use of MDX to develop Multidimensional models. Administration topics include installing and configuring SQL Server, backing up and restoring databases, configuring security as well as monitoring and optimizing performance of a SQL Server. Students will also be introduced to creating dynamic Web sites with ASP.NET Web Forms and the .NET framework, including how to use ADO.NET to interact with databases by running SQL queries and executing stored procedures. Students may also choose to learn about using Microsoft's Power BI suite of products to import, analyze, and visualize business data, and to share business intelligence.

Program Highlights:

  • Designing normalized table structures for relational databases
  • Creating databases and tables
  • Writing SQL queries
  • Using triggers and stored procedures
  • Creating, deploying and configuring SQL Server Reporting Services
  • Rendering reports as Excel, Word or PDF files
  • Adding charts and gauges to reports
  • Using Report Builder to create reports
  • Using SSIS to create import/export routines between SQL Servers and many other data sources
  • Designing and building data warehouses
  • Creating cubes using SSAS Implementing data mining algorithms against cubes to support predictive and trending analysis
  • Installing and configuring SQL Server 2016
  • Using the SQL Server client tools to manage and configure SQL Server
  • Configuring security in SQL Server
  • Backing up and restoring databases
  • Managing multiple SQL Server instances using central management

Required Courses:

  • SQL Programming (21 hours )
  • SQL Server 2016 Reporting Services (21 hours)
  • SQL Server 2016 Business Intelligence: Integration Services and Analysis Services (35 hours)
  • Microsoft SQL Server 2016 Administration (35 hours)
  • ASP.NET Web Forms Programming Using C# (35 hours)

Note: Schedule posted is the Start and End date of the class. You may access the class at any time, day or night, within the date provided. Date can also be flexible if needed.



SQL Programming

This SQL programming course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.


Duration: 21 hours


Prerequisites: None.


Students Will Learn:

  • Introduction to Relational Databases and SQL
  • Designing Relational Databases
  • Creating Databases and Tables
  • Working with Records
  • JOIN Statements
  • Advanced SELECT Statements
  • Understanding Subqueries
  • SQL Procedural Programming
  • Views and Triggers
  • Database Security and Transactions

Course Overview:

Relational Database Fundamentals

  • Overview of Relational Database Concepts
  • Relational Databases and Relational Database Management Systems
  • Data Normalization
  • DDL Syntax

Writing Basic SQL Queries

  • Displaying Table Structures
  • Retrieving Column Data From a Table or View
  • Selecting Unique Values
  • Filtering Rows Using the WHERE Clause
  • Sorting Results Using ORDER BY
  • Joining Multiple Tables
  • Using Column and Table Aliases

Creating a Database

  • Database Development Methodology Overview
  • Building a Logical Data Model
    - Identifying Entities and Attributes
    - Isolating Keys
    - Relationships Between Entities
    - Creating Entity-Relationship Diagrams
  • Transforming to Physical Design
    - Migrating Entities to Tables
    - Selecting Primary Keys
    - Defining Columns
    - Enforcing Relationships with Foreign Keys
  • Constructing the Database Using DDL
    - Creating Tables, Indexes, Constraints and Views
    - Dropping Tables, Indexes, Constraints and Views
    - Modifying Tables, Indexes, Constraints and Views

Manipulating Query Results

  • Using Row Functions
    - Character
    - Numeric
    - Date and Time
    - Data Conversion (CAST and CONVERT)
  • Using the CASE Function
  • Handling Null Values

Advanced Query Techniques

  • Inner Joins
  • Outer Joins (Left, Right, Full)
  • Performing Self-Joins
  • Subqueries
    - Simple
    - Correlated
  • Using the EXISTS Operator
  • Tips for Developing Complex SQL Queries
  • Using Aggregate Functions
    - AVG
    - COUNT
    - SUM
    - MIN
    - MAX
  • Performing Set Operations
    - UNION
    - INTERSECT
    - EXCEPT/MINUS
  • Aggregating Results Using GROUP BY
  • Restricting Groups with the HAVING Clause
  • Creating Temporary Tables

Manipulating Table Data Using SQL's Data Manipulation Language (DML)

  • Inserting Data into Tables
  • Updating Existing Data
  • Deleting Records
  • Truncating Tables
  • Implementing Data Integrity with Transactions
    - Beginning Explicit Transactions
    - Committing Transactions
    - Rolling Back Transactions

User-Defined Functions

  • Definition and Benefits of Use
  • CREATE FUNCTION
    - Syntax
    - RETURN Clause and the RETURNS Statement
    - Scalar vs. Table Functions
  • Comparison with Stored Procedures
  • Returning Scalar Values and Tables
  • ALTER and DROP FUNCTION

Stored Procedures

  • Definition and Benefits of Use
  • CREATE PROCEDURE
    - Syntax
  • - Variables and Parameters
  • Control of Program Flow
  • ALTER and DROP PROCEDURE
  • Implementation Differences

Triggers

  • Definition and Benefits of Use
  • Alternatives (e.g., Constraints)
  • CREATE TRIGGER
    - Syntax
    - Trigger Types
  • "Inserted" (or "NEW") and "Deleted" (or "OLD") Tables
  • Event Handling and Trigger Execution
  • ALTER and DROP TRIGGER

Working with Table Expressions

  • Overview of Table Expressions
  • Working with Views
  • Using Derived Tables
  • Common Table Expressions
  • Table-Valued Functions

SQL Server 2016 Reporting Services

This course includes an overview of the SQL Server business intelligence architecture focusing the role of Reporting services. All reports are developed utilizing SQL Server Data Tools (SSDT), however the new 2016 Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing the newly designed charts, gauges, KPIs, spark lines, data bars and tree maps will be built. Exercises will incorporate the use of report parameters and features such as drill down, interactive sorting, hyperlinks, book marks and report maps.


Consuming data from relational, multi-dimensional and the new tabular data sources will be incorporated into report designs. Students will become familiar with report deployment to the new Reporting Service Web Portal (replaced Report Manager) and learn how to use portal the management tools to configure report caches, snapshots and subscriptions. Instruction and practice in designing report security to insure protection of enterprise data will be provided.


The student will gain experience with the new Report Services Web portal, which enables publishing content other than paginated reports, such as Excel and Power BI. Students will also learn how to include KPIs (Key Performance Indicators) directly from a shared data set.


Duration: 21 hours


Prerequisites: Familiarity with database concepts


Students Will Learn:

  • Installing and configuring SQL Server Reporting Services
  • Designing reports using SQL Server Data Tools (SSDT)
  • Creating multi-dimensional, two-dimensional and tabular data sources and sets
  • Using the Tablix object to display information in Tables, Matrix (pivot tables) and free form Lists
  • Using visualization objects to create Charts, Spark Lines, Data Bars and Tree Maps
  • Adding images, page headers and footers and report metadata
  • Including report parameterization enabling filtering by users
  • Configuring report interactivity, including drill-downs, report maps and book marks
  • Linking to parameterized child reports via hyperlinks or sub-reports
  • Creating calculated fields and custom report formatting
  • Deploying reports to the new Reporting Services Web Portal
  • Configuring report snapshots, caches and subscriptions
  • Securing reports and data sources

Course Overview:


Reporting Services Architecture

  • Defining Report Server Components
  • Reviewing the Report Server Databases
  • Managing the Report Server Web Portal
  • Creating Mobile Reports and Dashboards
  • Report Lifecycle Step by Step

Creating Basic Reports

  • Creating Table Reports
  • Formatting Options
  • Adding Headers and Footers
  • Using Subtotals and Formulas
  • Adding Charts and Gauges
  • Using Lists for Free-Form Reports
  • Paging and Sorting
  • Managing Data Sources
  • Adding Key Performance Indicators (KPIs)

Advanced Report Features

  • Setting Up Input Parameters
  • Adding Custom Report Navigation
  • Adding Drill-Down for Master-Detail Reports
  • Linking Reports
  • Using Sub-Reports
  • Adding Conditional Formatting

Matrix Reports

  • Pivoting Data with Matrix Controls
  • Adding Multiple Data Regions
  • Grouping and Sorting
  • Adding Subtotals
  • Adding Custom Aggregate Formulas
  • Using the Tablix object

Implementing BI Semantic Model

  • Understanding Multi-Dimensional Models
  • Using Tabular Models
  • Creating MDX Data Sources and Data Sets

Report Designer

  • Creating Reports with Report Designer
  • Adding Charts and Gauges in Report Designer
  • Differences Between SQL Server Data Tools and Report Builder

Reporting Services Security

  • Organizing Reports in Folders
  • Setting Permissions on Reports and Folders
  • Managing Security Roles
  • Securing Data Sources and Report Models
  • Logging Activity on the Report Server

Automating Report Creation and Delivery

  • Creating Snapshot Reports
  • Storing Previous Versions of Reports
  • Caching Reports to Improve Performance
  • Defining Subscriptions to Automate Report Delivery
  • Rending Reports in Excel, MS Word or as a PDF
  • Hiding Reports from Users

Adding Custom Code

  • Querying the Report Server
  • Creating Custom Data Extensions
  • Creating Command Objects
  • Creating Data Reader Objects
  • Generating Report Definition Language

.NET Integration with Reporting Services

  • Writing User-Defined Functions in .NET
  • Using Custom Functions
  • Referencing .NET Libraries
  • Managing Report Servers from .NET Applications
    - Accessing SSRS from .NET Applications
    - Retrieving Report Items
    - Listing Report Metadata

SQL Server 2016 Business Intelligence: Integration Services and Analysis Services

The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources.


Students will learn how to design and build data warehouses and marts using SQL Server Management Studio. In a series of exercises, students develop SSIS packages designed to maintain a data warehouse using the Data Flow control flow task. Also demonstrated are other control flow tasks that can interact with an NTFS file system, FTP server, execute Win32 processes, send emails, and run .NET scripts.


Based on the populated data warehouse they have created, students will then learn how to develop both Multidimensional and Tabular SSAS models using the languages Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX). Cubes will be customized to include Key Performance Indicators (KPIs), Calculated Members, Named Sets, Navigational Hierarchies, and Perspectives.


Duration: 35 hours


Prerequisites: Familiarity with database concepts


Students Will Learn:

  • Structure and function of a data warehouse or data mart
  • Data warehouse design to support enterprise reporting
  • The role of SSIS within the business intelligence framework
  • Developing SSIS Extract Transform Load (ETL) processes to populate data warehouses
  • Functionality of all SSIS Control Flow tasks
  • Deploying SSIS projects to SSIS Catalogs
  • Configuring SSIS environments, runtime variables and parameters
  • BI Semantic Model
  • Multidimensional Expressions (MDX) syntax
  • Developing SSAS Multidimensional models
  • Data Analysis Expressions (DAX)
  • Developing SSAS Tabular models
  • Deploying and securing Multidimensional and Tabular models
  • Implementing SSAS Data Mining models for predictive analysis
  • Consuming the BI Semantic Model in reports and dashboards

Course Overview:


Business Intelligence Framework Overview

  • SQL Server Data Tools Overview
  • Installation and Configuration
  • Components of a BI Solution
  • Introduction to the BI Semantic Model

Integration Services Architecture

  • Architecture of the SSIS Data Engine
  • Using Data Transformation Tasks
  • Managing Connections to Sources and Destinations
  • ADO.NET Data Source and Destination
  • Understanding Data Buffers
  • Control Flow Tasks and Containers

Common SSIS Tasks

  • Executing SQL Statements
  • Connecting to FTP Servers
  • Sending E-mail
  • Notifying Administrators of Errors
  • Completing Bulk Inserts
  • Copying, Moving and Deleting Files and Folders

Data Transformations

  • Converting Data Types
  • Merging Data from Multiple Sources
  • Splitting Data to Multiple Destinations
  • Counting Rows
  • Sampling and Sorting Records
  • Copying Columns

Advanced SSIS Tasks

  • Executing .NET Scripts and Win32 Processes
  • Using the Windows Management Instrumentation (WMI) Tasks
  • Performing Database Maintenance and Backups During SSIS Routines
  • Using Variables and Input Parameters
  • Profiling Database Tables
  • Comparing XML Files Against Schemas

Advanced Data Transformations

  • Filling in Missing Data with Lookups
  • Locating Near Duplicate Rows with Fuzzy Grouping
  • Adding Audit Information to Results
  • Counting the Occurrence of Keywords
  • Sending Rows that Process Correctly and Incorrectly to Different Destinations
  • Responding to Truncation Errors

SSIS Administration and Automation

  • Deploying SSIS Projects
  • Manually Running SSIS Tasks
  • Automating SSIS Package Execution
  • Configuring Notifications for Execution Success, Failure or Both
  • SSIS Security
  • Troubleshooting Techniques

Data Warehouse Design

  • Understanding Fact and Dimension Tables
  • Modeling Slowly Changing and Rapidly Changing Dimensions
  • Modeling Fact Tables
  • Using Star and Snowflake Schemas for Dimension Tables
  • Implementing Surrogate Keys
  • Defining Business Keys

Creating and Populating Data Warehouses

  • Creating Data Warehouses (OLAP Databases)
  • Adding Fact Tables
  • Adding Dimension Tables and Joining Them to Fact Tables
  • Loading Data into Fact and Dimension Tables
  • Validation Techniques for Data Loads

Creating and Managing Cubes

  • Creating Data Sources to Connect to Data Warehouses
  • Using SSAS to Create Cubes
  • Applying Friendly Names to Measures and Attributes
  • Customizing Dimensions and Measures
  • Setting up Navigational Hierarchies
  • Optimizing Cubes with Attribute Relationships

Multidimensional (MDX) Essentials

  • Using MDX Queries to Pull Data from Cubes
  • Understanding Tuples and Sets
  • MDX Expressions vs. Queries
  • Grouping Attribute Values into Named Sets
  • Adding Custom Calculations for Cubes Using MDX

MDX Functions

  • Using MDX Aggregate Functions
  • Using Navigations Functions to Move Though Hierarchies
  • Grouping, Filtering and Sorting Functions
  • Time-Based MDX Functions

Customizing Cubes

  • Adding Key Performance Indicators (KPIs)
  • Customizing Dimensions and Attributes
  • Adding Translations to Support Multiple Languages
  • Adding Custom Calculations
  • Subdividing Cubes Using Perspectives

Cube Deployment and Administration

  • Cube Storage Calculations
  • Configuring Desired Aggregation
  • Configuring Caching
  • Deploying and Processing Cubes
  • Connecting to Cubes from Excel and Other Clients
  • Partitioning and Processing Cubes
  • Backing Up and Restoring Options
  • Securing Cubes

Creating and Customizing Tabular Models

  • Creating Tabular Modules in SSDT
  • Introducing DAX
  • Customizing Tabular Models
  • Refreshing Data in Tabular Models

Understanding the Data Mining Process

  • Types of Business Analysis Supported by Data Mining
  • Data Mining Process Explained
  • Understanding the Key Components of Data Mining
  • Using Built-In Data Mining Algorithms
  • Matching Mining Algorithms to Business Needs

Working with Data Mining Structures

  • Adding Data Mining Structures
  • Mining for Hidden Information
  • Discovering Patterns in Data
  • Creating Predictive Models
  • Using the Data Mining Wizard
  • Modifying Mining Structures with the Data Mining Designer

Using the Semantic Models in the Presentation Layer

  • Using SSAS Data Sources in Excel and Power View
  • Using SSAS Data Sources in SSRS
  • Using SSAS Data Sources in Power BI
  • Using SSAS Data Sources in SharePoint Performance Point Services

Microsoft SQL Server 2016 Administration

This course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure.


The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.


Duration: 35 hours


Prerequisites: Familiarity with database concepts


Students Will Learn:

  • Installing and configuring SQL Server 2016
  • Authenticating and authorizing users
  • Assigning server and database roles
  • Authorizing users to access resources
  • Protecting data with encryption and auditing
  • Recovery models and backup strategies
  • Backing up SQL Server databases
  • Restoring SQL Server databases
  • Automating database management
  • Configuring security for the SQL Server agent
  • Managing alerts and notifications
  • Tracing access to SQL Server
  • Monitoring a SQL Server infrastructure
  • Troubleshooting a SQL Server infrastructure
  • Importing and exporting data
  • Creating a high availability solution

Course Overview:


Installation and Configuration

  • Installing Multiple Instances of SQL Server 2016
  • Applying a Service Pack
  • Creating Aliases
  • Setting up a Central Management Server

Authenticating and Authorizing Users

  • Authenticating Connections to SQL Server
  • Authorizing Logins to Access Databases
  • Authorization Across Servers
  • Partially Contained Databases

Assigning Server and Database Roles

  • Working with Server Roles
  • Working with Fixed Database Roles
  • Creating User-Defined Database Roles

Authorizing Users to Access Resources

  • Authorizing User Access to Objects
  • Authorizing Users to Execute Code
  • Configuring Permissions at the Schema Level

Protecting Data with Encryption and Auditing

  • Options for Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Managing SQL Server Audit
  • Protecting Data with Encryption

SQL Server Recovery Models

  • Backup Strategies
  • Understanding SQL Server Transaction Logging
  • Planning a SQL Server Backup Strategy

Backup of SQL Server Databases

  • Backing up Databases and Transaction Logs
  • Managing Database Backups
  • Working with Backup Options

Restoring SQL Server Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Working with Point-in-time Recovery
  • Restoring System Databases and Individual Files

Tracing Access to SQL Server

  • Capturing Activity Using SQL Server profiler
  • Improving Performance with the Database Engine Tuning Advisor
  • Working with Tracing Options

Monitoring SQL Server

  • Monitoring Activity
  • Capturing and Managing Performance Data
  • Analyzing Collected Performance Data

Troubleshooting SQL Server

  • Resolving Service Related Issues
  • Resolving Login and Connectivity Issues
  • Troubleshooting Common Issues

Importing and Exporting Data

  • Transferring Data to/from SQL Server
  • Importing and Exporting Table Data
  • Using BCP and BULK INSERT to Import Data

Maintaining High Availability of Data

  • Windows Clustering
  • AlwaysOn Availability Groups
  • Implementing AlwaysOn
  • Implementing Log Shipping

ASP.NET Web Forms Programming Using C#

This course provides students with hands on experience using Visual Studio to create dynamic Web sites with ASP.NET Web Forms and the .NET Framework using C#. The class provides a thorough introduction to the C# programming language, including coverage of the essentials of the C# programming language, built in data types, operators, control structures, classes and methods, collections and exception handling.


Students then learn how to leverage the power of the .NET Framework to build Web user interfaces. Students will learn use the power of ASP.NET Web server controls combined with HTML5 to design Web pages. They will use ASP.NET Validation controls to provide both client-side and server-side data validation for user input. Students will learn how to use master pages to enforce a consistent look and feel across a set of Web pages, as well as how to use user controls to reuse smaller pieces of HTML across multiple pages.


Students explore the complexities of state management in ASP.NET Web Forms and how to use session and view state objects to manage state between HTTP requests.


Students spend time exploring how to use ADO.NET to interact with databases by running SQL queries and executing stored procedures. They will also learn how to read/write XML files using DataSets and DataTables. Students learn how ASP.NET Web Forms data binding to easily display data in list controls, the GridView control and the DetailsView control.


Microsoft provides support for Ajax-enabled Web Forms applications using the ASP.NET AJAX Framework. Students will learn how to use some of the server-side features to make asynchronous postbacks from the browser, perform partial page updates using the UpdatePanel, use CSS to dim a page during postback and use the Timer fetch data from the server asynchronously.


Other topics include: 

  • using a Web.config file to control application configuration
  • working with the query string
  • working with cookies
  • reading and writing files
  • deploying ASP.NET web applications. 

Comprehensive labs provide the students with extensive experience creating and deploying dynamic ASP.NET Web Form applications.


Duration: 35 hours


Prerequisites: Prior experience with a scripting or programming language is required.


Students Will Learn:

  • Introduction to .NET Architecture
  • Creating Web Sites using Visual Studio
  • C# Basic Data Types, Variables and Scoping Rules
  • Defining a C# Class
  • Working with Objects
  • Converting Between Types
  • Operators and Expressions
  • Formatting Output
  • Conditional Constructs (if, if/else, switch)
  • Looping (while, do/while, foreach, break)
  • Exception Handling
  • Working with Arrays
  • .NET Collections
  • User-Defined Data Types
  • Overview of LINQ
  • Overview of Object-Oriented Programming
  • Creating ASP.NET Web Forms Applications
  • Using ASP.NET Server Controls
  • Handling Events
  • Using ASP.NET Server Controls
  • Using ASP.NET Validation Controls
  • Reusing Design: User Controls and Master Pages
  • Maintaining State
  • Overview of ADO.NET
  • Using XML
  • Using Data Binding
  • Introduction to ASP.NET AJAX
  • Deploying ASP.NET Applications

Course Overview:


Introduction to .NET

  • Overview of the .NET Framework
  • How .NET is Different from Traditional Programming
  • Common Language Runtime (CLR)
  • Common Language Specification (CLS)
  • Common Type System (CTS)
  • .NET Assemblies
  • Microsoft Intermediate Language (CIL)
  • .NET Namespaces
  • .NET Framework Class Library

Introduction to Visual Studio

  • Creating a Project
  • Using the Code Editor
  • Correcting Syntax Errors
  • Setting Project Properties
  • Adding References
  • Compiling a Program
  • Running a Program
  • Debugging a Program
  • Using the MSDN (Help)

Language Fundamentals

  • C# Program Structure
  • Defining Namespaces
  • Understanding C# Data Types
  • Defining Variables and Constants
  • Comparing Value Types vs. Reference Types
  • Working with Operators and Expressions
  • Performing Type Conversions
  • Using Console I/O
  • Formatting Numbers, Date and Times

Conditionals and Looping

  • if/else
  • switch
  • while and do/while
  • for
  • foreach

Methods and Parameters

  • Defining Static and Instance Methods
  • Passing Parameters by value and by reference
  • Overloading Methods
  • Using Variable Length Parameter Lists

Exception Handling

  • What are Exceptions?
  • .NET Exception Hierarchy
  • Catching Exceptions
  • Throwing Exceptions
  • Managing Resources with Finally

Collections

  • Defining and Using Arrays
  • Understanding System.Array
  • .NET Collections vs Generic Collections
  • Working with Lists
  • Working with Dictionaries
  • Using LINQ to Objects

Object-Oriented Programming

  • Overview of Object-Oriented Programming
  • Building Classes
  • Defining Properties
  • Using Auto-Implemented Properties
  • Defining Methods
  • Understanding Constructors
  • Extending .NET Classes via Inheritance
  • Defining and Implementing Interfaces
  • Understanding the Role of Interfaces in .NET

Overview of ASP.NET Web Forms

  • ASP.NET Technologies
  • Web Forms vs. MVC
  • Understanding the HTTP Request and Response Cycle
  • Client-Side vs. Server-Side Code Execution
  • Exploring an ASP.NET Web Form
  • Understanding the Life-Cycle of an ASP.NET Page Object

Creating ASP.NET Web Forms Applications

  • Building ASP.NET Web Forms Applications Using Visual Studio
  • Understanding a Web Form Application Project Structure
  • Designing Web Forms
  • Incorporating CSS into the Web Application
  • Understanding the Page Directive
  • Working with the Code-Behind Model
  • Understanding Web.config
  • Transformational Config Files

Using ASP.NET Server Controls

  • Working with Web Server Controls
  • Using Hyperlinks and Button-Based Controls
  • Using Label and Textbox Controls
  • Using List Controls
  • Using the Image Control
  • Exploring Other Web Server Controls

Handling Events

  • Working with Page-Based Event Handlers
  • Writing Control Event Handlers
  • Sharing Event Handlers
  • Understanding PostBack vs. Non-PostBack Events
  • Handling Application-Based Events in Global.asax

Using ASP.NET Validation Controls

  • Understanding ASP.NET Validation Controls
  • Performing Client-Side Validation
  • Performing Server-Side Validation
  • Using the Required Field Validator
  • Using the Comparison and Range Validators
  • Using the Regular Expression Validator
  • Customizing Validation
  • Working with Validation Groups
  • Unobtrusive Validation
  • Using the NuGet Package Manager to Download AspNet.ScriptManager.jQuery

Reusing Design: User Controls and Master Pages

  • Reusing HTML Snippets with User Controls
  • Designing a User Control
  • Embedding a User Control on a Page
  • Understanding the Master Page Architecture
  • Designing a Master Page
  • Designing Content Pages

Maintaining State

  • Maintaining State within ASP.NET Web Forms Applications
  • Using the Session Object
  • Using the ViewState Object
  • Reading and Writing Cookies
  • Using the Query String

ADO.NET

  • Understanding the ADO.NET Object Model
  • Connected vs. Disconnected Access
  • Using a Connection to Connect to a Data Source
  • Using a Command to Execute Queries and Stored Procedures
  • Using a DataReader to Work with Cursors
  • Using a DataSet with Disconnected Data
  • Using DataAdapters with DataSets

Using XML

  • Introducing XML and XML Schemas
  • Writing XML Schemas with a DataSet
  • Reading XML Schemas with a DataSet
  • Writing XML Data with a DataSet
  • Reading XML Data with a DataSet

Using Data Binding

  • Understanding ASP.NET Data Source Controls
  • Configuring Data Sources
  • Examining ASP.NET Data Bound Controls
  • Using List Controls
  • Using the GridView Control
  • Using the DetailsView Control
  • Exploring Other Data Bound Controls

Introduction to ASP.NET AJAX

  • Understanding Ajax
  • Enabling ASP.NET AJAX with the ScriptManager
  • Configuring Partial Page Updates with the UpdatePanel
  • Displaying a Progress Indicator Using UpdateProgress
  • Making Periodic Postbacks Using the Timer
  • Using the NuGet Package Manager to Download jQuery

Deploying ASP.NET Applications

  • Configuring IIS for Deployment
  • Configuring an ASP.NET Web Form Application for Deployment
  • Using Publish to Deploy a ASP.NET Web Application

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

  • Cancellations made at least 2 business days in advance of the class will be honored with a refund less 5% cancellation fee.
  • Students who cancel less than 2 business days prior to the start time of the class will receive a credit towards a future class.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.


Similar Classes

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 60000 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Developer Bootcamp

Our bootcamps are focused on the needs of today's industrial environment. We’ve trained tens of thousands of students over the last 20 years, many of them practicing professional software engineers and system administrators so our programs are focused on developing the practical skills needed for...

Read more about Developer Bootcamp

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

Developer Bootcamp

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...