Preparing your future career......
Get in touch Your account

Request more information

If you prefer, you can get the information in an instant pack.

Call now: 01202 238640

Course name

Location

Date: DateFrom - DateTo

Fill in the form below or give us a call to start the booking process.

Call now: 01202 238640

Code Your Way Into The Future

Software Developer

You’ll be the creative mind behind the computer program – you’ll devise a design based on the end-user’s needs and develop software to mirror that. Your role will see you balancing technical function with aesthetics.

As a Software Developer, you’ll need to prove your knowledge through relevant certificates – the crux to successful employment.

What Will I Do as a Software Developer?

As a Software Developer, you’ll oversee the development process for software – this gives you flexibility to create and problem solve to achieve the end result. You’ll collaborate with other specialists to create the best outcome for your client. Understand whether you’re getting the most from the user experience – you’ll design the program before passing it on to a programmer to code.

Off paper, you’ll flex your analytical, communication, detail oriented, interpersonal and problem-solving skills. If you’re an all-rounder, it’s an ideal career move!

Fill in the form below or give us a call to start the booking process.

Call now: 01202 238640

How Do I Become a Software Developer?

You don’t need a degree to become a Software Developer. As with many roles though, the more qualified you are, the easier it will be to find employment. Many people look to certifications to gain crucial knowledge – this turns a pipe dream into a reality!

Take a career boost and get your knowledge in shape with the following certificates:

Course Overview

Here at The Training Room, our Software Developer course includes key industry recognized training and certification giving you both the knowledge and qualifications needed to kick start your career in Software.  

Our course includes:

  • Microsoft Software Development Fundamentals (MTA) 
  • CIW: Advanced HTML5 and CSS3 Specialist 
  • Oracle OCA Java SE 8 Programmer Course
  • Microsoft MCSA/MCSE Querying Microsoft SQL Server 2012 

Software Developer Course

This course will help you build an understanding of these topics: Core Programming, Object-Oriented Programming, General Software Development, Web Applications, Desktop Applications, and Databases. After completing this course students will be able to: Understand Core Programming, Understand Object-Oriented Programming, Understand General Software Development, Understand Web Applications, Understand Desktop Applications and Understand Databases.

Lesson 1:
• Understanding Core Programming
• Understand computer storage and data types
• Understand computer decision structures
• Identify the appropriate method for handling repetition
• Understand error handling

Lesson 2:
• Understanding Object-Oriented Programming
• Understand the fundamentals of classes
• Understand inheritance
• Understand polymorphism
• Understand encapsulation

Lesson 3:
• Understanding General Software Development
• Understand Application Life Cycle Management
• Interpret application specifications
• Understand algorithms and data structures

Lesson 4:
• Understanding Web Applications
• Understand Web page development
• Understand Microsoft ASP.NET Web application development
• Understand Web hosting
• Understand Web services

Lesson 5:
• Understanding Desktop Applications
• Understand Windows Forms applications
• Understand console-based applications
• Understand Windows Services

Lesson 6:
• Understanding Databases
• Understand relational database management systems
• Understand database query methods
• Understand database connection methods

 

Gain hands-on expertise in CIW Advanced HTML5 and CSS3 Specialist exam by Advanced HTML5 and CSS3 Specialist course. CIW Advanced HTML5 and CSS3 Specialist exam is a vendor neutral, entry-level credential designed for IT, Software Developers, Marketing Professionals, Web Site Designers, and Graphic Artists to demonstrate advanced uses of the canvas element; identify program flow issues in relation to JavaScript-based applications; validate HTML5 code; and much more.

Lesson 1:
• HTML5 Essentials
• Introduction to HTML5 and CSS3
• Migration to Mobile Devices
• The Web Development Trifecta
• The Evolution of HTML5
• HTML5 Structure Elements
• Validating HTML5 Code
• HTML5 APIs

Lesson 2:
• Using Cascading Style Sheets (CSS) Technology
• Cascading Style Sheets (CSS)
• Style Guides
• CSS and HTML
• CSS Terms and Syntax
• Applying CSS Styles
• Page Layout with CSS
• CSS Positioning Schemes
• The CSS Box Model

Lesson 3:
• Introduction to CSS Version 3 (CSS3)
• Introduction to CSS3
• CSS3 Selectors and Properties
• CSS3 Background Properties
• CSS3 Border Properties
• CSS3 Font Properties
• CSS3 Text Effects

Lesson 4:
• Using Advanced CSS3 Techniques
• Introduction to Advanced CSS3 Techniques
• CSS3 2D and 3D Transformations
• CSS3 Transitions
• CSS3 Animations
• CSS3 User Interfaces
• Creating Menus and Buttons with CSS3

Lesson 5:
• Introduction to JavaScript
• HTML5 and JavaScript
• Introduction to Scripting
• JavaScript Characteristics
• JavaScript vs. Other Languages
• Embedding JavaScript into HTML5 Documents
• JavaScript and Common Programming Concepts
• Objects, Properties and Methods
• Variables
• Expressions and Operators

Lesson 6:
• JavaScript Events, Functions and Methods
• User Events and JavaScript Event Handlers
• Introduction to JavaScript Functions
• Defining a Function
• Calling a Function
• Methods as Functions
• Errors in JavaScript

Lesson 7:
• Using HTML5 APIs
• Introduction to HTML5 APIs
• Document Object Model (DOM)
• Common HTML5 APIs
• The Canvas API
• The Offline AppCache API
• The Geolocation API
• The Drag-and-Drop API
• The File API
• The History API
• Retrieving Data with XMLHttpRequest
• Manipulating Data with jQuery

Lesson 8:
• Developing HTML5 Forms
• Introduction to HTML5 Forms
• Cross-Browser Compatible HTML5 Forms
• HTML5 Form Input Types
• New Form Elements in HTML5
• HTML5 Global Attributes for Form Elements

Lesson 9:
• Completing, Submitting and Validating User Input Forms
• Improving Forms with HTML5
• HTML5 Attributes for the <form> Element
• HTML5 Attributes for the <input> Element
• Submitting Forms with the <button> Element
• Concepts and Techniques for Validating User Input
• Validating User Input with HTML5 Attributes
• Validating User Input with JavaScript

Lesson 10:
• Designing for Mobile Devices
• Introduction to Mobile Design
• Mobile Web Sites vs. Mobile Apps
• Designing Web Sites for Mobile Devices
• Page Layout for Mobile Devices
• Navigation and Hyperlinks for Mobile Devices
• Images and Mobile Design
• Validating and Testing Mobile Web Pages
• Responsive Web Design

Lesson 11:
• Appendix A: CIW Advanced HTML5 And CSS3 Specialist Objectives and Locations

Lesson 12:
• Appendix B: Web Developer Resources
• A List Apart: For People Who Make Web Sites 
• W3Schools
• HTML Goodies: The Ultimate Web Resource
• Yahoo! List of Site Development Resources
• HTML5 Rocks: A Resource for Open Web HTML5 developers

Lesson 13:
• Appendix C: Works Consulted

Gain hands-on expertise in Oracle Java SE 8 Programmer I exam certification exam by Oracle Java SE 8 Programmer I course. Oracle Java SE 8 Programmer I exam is designed to certify the competency of Java professionals in developing Java applications, mastering Java data types, operators and decision control structures, and understanding OOPs concepts of Java.

Lesson 1:
• Packaging, Compiling, and Interpreting Java Code
• The Java Platform
• Understand Packages
• Understand Package-Derived Classes
• Understand Class Structure
• Compile and Interpret Java Code
• Certification Summary
• Two-Minute Drill

Lesson 2:
• Programming with Java Statements
• Understand Assignment Statements
• Create and Use Conditional Statements
• Create and Use Iteration Statements
• Create and Use Transfer of Control Statements
• Certification Summary
• Two-Minute Drill

Lesson 3:
• Programming with Java Operators and Strings
• Understand Fundamental Operators
• Use String Objects and Their Methods
• Use StringBuilder Objects and Their Methods
• Test Equality Between Strings and Other Objects
• Certification Summary
• Two-Minute Drill

Lesson 4:
• Working with Basic Classes and Variables
• Understand Primitives, Enumerations, and Objects
• Use Primitives, Enumerations, and Objects
• Certification Summary
• Two-Minute Drill

Lesson 5:
• Understanding Methods and Variable Scope
• Create and Use Methods
• Pass Objects by Reference and Value
• Understand Variable Scope
• Create and Use Constructors
• Use the this and super Keywords
• Create Static Methods and Instance Variables
• Certification Summary
• Two-Minute Drill

Lesson 6:
• Programming with Arrays
• Work with Java Arrays
• Work with ArrayList Objects and Their Methods
• Certification Summary
• Two-Minute Drill

Lesson 7:
• Understanding Class Inheritance
• Implement and Use Inheritance and Class Types
• Understand Encapsulation Principles
• Advanced Use of Classes with Inheritance and Encapsulation
• Certification summary
• Two-Minute Drill

Lesson 8:
• Understanding Polymorphism and Casts
• Understand Polymorphism
• Understand Casting
• Certification Summary
• Two-Minute Drill

Lesson 9:
• Handling Exceptions
• Understand the Rationale and Types of Exceptions
• Understand the Nature of Exceptions
• Alter the Program Flow
• Recognize Common Exceptions
• Certification Summary
• Two-Minute Drill

Lesson 10:
• Programming with the Date and Time API
• Understand the Date and Time API
• Certification Summary
• Two-Minute Drill

Lesson 11:
• Understanding Lambda Expressions
• Write Lambda Expressions
• Certification Summary
• Two-Minute Drill

Lesson 12:
• Appendix A: Class Relationships
• Understand Class Compositions and Associations
• Class Compositions and Associations in Practice
• Appendix Summary

Lesson 13:
• Appendix B: Java SE 8 Packages
• Core Packages
• Integration Packages
• User Interface Packages
• Security Packages
• XML-based Packages
• Temporal Packages

Lesson 14:
• Appendix C: Java Keywords

Lesson 15:
• Appendix D: Bracket Conventions
• Java Bracket Conventions
• Miscellaneous Bracket Conventions


Lesson 16:
• Appendix E: Unicode Standard
• ASCII Punctuation Characters
Lesson 17:
• Appendix F: Pseudo-code Algorithms
• Implementing Statement-Related Algorithms from
Pseudocode
Lesson 18:
• Appendix G: Unified Modeling Language
• Recognizing Representations of Significant UML
Elements
• Recognizing Representations of UML Associations
Lesson 19:
• Appendix H: Functional Interfaces
• Specific-Purpose FIs
• General-Purpose FIs

Gain hands-on expertise in Microsoft SQL Server course and performance-based labs. Performance based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. This course covers creating database objects; working and modifying data; and troubleshooting and optimizing queries and transactions.

Lesson 1:
• Understanding SQL Server’s Role
• Overview
• What Is Information Technology?
• Introduction to Databases
• Database Servers and Applications
• SQL Server’s Role

Lesson 2:
• Installing SQL Server 2012
• Installation Planning
• Installing a Default Instance
• Installing Named Instances
• Installing to a Cluster
• Installing Extra Features
• Upgrading from Previous Versions
• Validating an Installation
• Removing an Installation

Lesson 3:
• Querying SQL Server
• Understanding the SQL Language
• SQL Statement Types
• SQL Syntactical Elements
• Coding Recommendations
• Using SELECT Statements
• Advanced Query Techniques
• Using DDL Statements
• Using DCL Statements
• Modifying Data
• Create and modify constraints (simple statements)
• Work with functions
• SqlGeography Methods
• Tuning and Optimizing Queries

Lesson 4:
• Database Concepts and Terminology
• Relational Database Theory
• Database Design Processes
• Project Management for the DBA

Lesson 5:
• ERD and Capacity Planning
• Planning a Database
• Understanding Entity Relationship Diagramming
• Building an ERD
• Capacity Planning

Lesson 6:
• Normalization and Other Design Issues
• Designing for Normalization
• Designing for Performance
• Designing for Availability
• Designing for Security

Lesson 7:
• Creating SQL Server Databases
• SQL Server Databases
• Database Storage
• Database Options and Properties
• Creating Databases in the GUI
• Creating Databases with T-SQL
• Creating Databases with PowerShell
• Attaching and Detaching Databases
• Database Snapshots

Lesson 8:
• Creating Tables
• Data Types
• Query and manage XML data
• Collations
• Table Creation Process
• Data Partitioning

Lesson 9:
• Indexes and Views
• Understanding Indexes
• Creating Basic Indexes
• Creating Advanced Indexes
• Managing Indexes
• Understanding Views
• Creating Views

Lesson 10:
• Triggers and Stored Procedures
• Triggers Defined
• Using Triggers
• Creating Triggers
• Understanding Stored Procedures
• Creating Stored Procedures

Course Comparison

Units

  Standard  
  Premium  
Microsoft Software Development Fundamentals (MTA)
CIW: Advanced HTML5 and CSS3 Specialist
Oracle OCA Java SE 8 Programmer Course
Microsoft SQL Server 20461
Microsoft SQL Server 20462
Microsoft SQL Server 20463

Premium Software Developer Course

This course will help you build an understanding of these topics: Core Programming, Object-Oriented Programming, General Software Development, Web Applications, Desktop Applications, and Databases. After completing this course students will be able to: Understand Core Programming, Understand Object-Oriented Programming, Understand General Software Development, Understand Web Applications, Understand Desktop Applications and Understand Databases.

Lesson 1:
• Understanding Core Programming
• Understand computer storage and data types
• Understand computer decision structures
• Identify the appropriate method for handling repetition
• Understand error handling

Lesson 2:
• Understanding Object-Oriented Programming
• Understand the fundamentals of classes
• Understand inheritance
• Understand polymorphism
• Understand encapsulation

Lesson 3:
• Understanding General Software Development
• Understand Application Life Cycle Management
• Interpret application specifications
• Understand algorithms and data structures

Lesson 4:
• Understanding Web Applications
• Understand Web page development
• Understand Microsoft ASP.NET Web application development
• Understand Web hosting
• Understand Web services

Lesson 5:
• Understanding Desktop Applications
• Understand Windows Forms applications
• Understand console-based applications
• Understand Windows Services

Lesson 6:
• Understanding Databases
• Understand relational database management systems
• Understand database query methods
• Understand database connection methods

Gain hands-on expertise in CIW Advanced HTML5 and CSS3 Specialist exam by Advanced HTML5 and CSS3 Specialist course. CIW Advanced HTML5 and CSS3 Specialist exam is a vendor neutral, entry-level credential designed for IT, Software Developers, Marketing Professionals, Web Site Designers, and Graphic Artists to demonstrate advanced uses of the canvas element; identify program flow issues in relation to JavaScript-based applications; validate HTML5 code; and much more.

Lesson 1:
• HTML5 Essentials
• Introduction to HTML5 and CSS3
• Migration to Mobile Devices
• The Web Development Trifecta
• The Evolution of HTML5
• HTML5 Structure Elements
• Validating HTML5 Code
• HTML5 APIs

Lesson 2:
• Using Cascading Style Sheets (CSS) Technology
• Cascading Style Sheets (CSS)
• Style Guides
• CSS and HTML
• CSS Terms and Syntax
• Applying CSS Styles
• Page Layout with CSS
• CSS Positioning Schemes
• The CSS Box Model

Lesson 3:
• Introduction to CSS Version 3 (CSS3)
• Introduction to CSS3
• CSS3 Selectors and Properties
• CSS3 Background Properties
• CSS3 Border Properties
• CSS3 Font Properties
• CSS3 Text Effects

Lesson 4:
• Using Advanced CSS3 Techniques
• Introduction to Advanced CSS3 Techniques
• CSS3 2D and 3D Transformations
• CSS3 Transitions
• CSS3 Animations
• CSS3 User Interfaces
• Creating Menus and Buttons with CSS3

Lesson 5:
• Introduction to JavaScript
• HTML5 and JavaScript
• Introduction to Scripting
• JavaScript Characteristics
• JavaScript vs. Other Languages
• Embedding JavaScript into HTML5 Documents
• JavaScript and Common Programming Concepts
• Objects, Properties and Methods
• Variables
• Expressions and Operators

Lesson 6:
• JavaScript Events, Functions and Methods
• User Events and JavaScript Event Handlers
• Introduction to JavaScript Functions
• Defining a Function
• Calling a Function
• Methods as Functions
• Errors in JavaScript

Lesson 7:
• Using HTML5 APIs
• Introduction to HTML5 APIs
• Document Object Model (DOM)
• Common HTML5 APIs
• The Canvas API
• The Offline AppCache API
• The Geolocation API
• The Drag-and-Drop API
• The File API
• The History API
• Retrieving Data with XMLHttpRequest
• Manipulating Data with jQuery

Lesson 8:
• Developing HTML5 Forms
• Introduction to HTML5 Forms
• Cross-Browser Compatible HTML5 Forms
• HTML5 Form Input Types
• New Form Elements in HTML5
• HTML5 Global Attributes for Form Elements

Lesson 9:
• Completing, Submitting and Validating User Input Forms
• Improving Forms with HTML5
• HTML5 Attributes for the <form> Element
• HTML5 Attributes for the <input> Element
• Submitting Forms with the <button> Element
• Concepts and Techniques for Validating User Input
• Validating User Input with HTML5 Attributes
• Validating User Input with JavaScript

Lesson 10:
• Designing for Mobile Devices
• Introduction to Mobile Design
• Mobile Web Sites vs. Mobile Apps
• Designing Web Sites for Mobile Devices
• Page Layout for Mobile Devices
• Navigation and Hyperlinks for Mobile Devices
• Images and Mobile Design
• Validating and Testing Mobile Web Pages
• Responsive Web Design

Lesson 11:
• Appendix A: CIW Advanced HTML5 And CSS3 Specialist Objectives and Locations

Lesson 12:
• Appendix B: Web Developer Resources
• A List Apart: For People Who Make Web Sites 
• W3Schools
• HTML Goodies: The Ultimate Web Resource
• Yahoo! List of Site Development Resources
• HTML5 Rocks: A Resource for Open Web HTML5 developers

Lesson 13:
• Appendix C: Works Consulted

Gain hands-on expertise in Oracle Java SE 8 Programmer I exam certification exam by Oracle Java SE 8 Programmer I course. Oracle Java SE 8 Programmer I exam is designed to certify the competency of Java professionals in developing Java applications, mastering Java data types, operators and decision control structures, and understanding OOPs concepts of Java.

Lesson 1:
• Packaging, Compiling, and Interpreting Java Code
• The Java Platform
• Understand Packages
• Understand Package-Derived Classes
• Understand Class Structure
• Compile and Interpret Java Code
• Certification Summary
• Two-Minute Drill

Lesson 2:
• Programming with Java Statements
• Understand Assignment Statements
• Create and Use Conditional Statements
• Create and Use Iteration Statements
• Create and Use Transfer of Control Statements
• Certification Summary
• Two-Minute Drill

Lesson 3:
• Programming with Java Operators and Strings
• Understand Fundamental Operators
• Use String Objects and Their Methods
• Use StringBuilder Objects and Their Methods
• Test Equality Between Strings and Other Objects
• Certification Summary
• Two-Minute Drill

Lesson 4:
• Working with Basic Classes and Variables
• Understand Primitives, Enumerations, and Objects
• Use Primitives, Enumerations, and Objects
• Certification Summary
• Two-Minute Drill

Lesson 5:
• Understanding Methods and Variable Scope
• Create and Use Methods
• Pass Objects by Reference and Value
• Understand Variable Scope
• Create and Use Constructors
• Use the this and super Keywords
• Create Static Methods and Instance Variables
• Certification Summary
• Two-Minute Drill

Lesson 6:
• Programming with Arrays
• Work with Java Arrays
• Work with ArrayList Objects and Their Methods
• Certification Summary
• Two-Minute Drill

Lesson 7:
• Understanding Class Inheritance
• Implement and Use Inheritance and Class Types
• Understand Encapsulation Principles
• Advanced Use of Classes with Inheritance and Encapsulation
• Certification summary
• Two-Minute Drill

Lesson 8:
• Understanding Polymorphism and Casts
• Understand Polymorphism
• Understand Casting
• Certification Summary
• Two-Minute Drill

Lesson 9:
• Handling Exceptions
• Understand the Rationale and Types of Exceptions
• Understand the Nature of Exceptions
• Alter the Program Flow
• Recognize Common Exceptions
• Certification Summary
• Two-Minute Drill

Lesson 10:
• Programming with the Date and Time API
• Understand the Date and Time API
• Certification Summary
• Two-Minute Drill

Lesson 11:
• Understanding Lambda Expressions
• Write Lambda Expressions
• Certification Summary
• Two-Minute Drill

Lesson 12:
• Appendix A: Class Relationships
• Understand Class Compositions and Associations
• Class Compositions and Associations in Practice
• Appendix Summary

Lesson 13:
• Appendix B: Java SE 8 Packages
• Core Packages
• Integration Packages
• User Interface Packages
• Security Packages
• XML-based Packages
• Temporal Packages

Lesson 14:
• Appendix C: Java Keywords

Lesson 15:
• Appendix D: Bracket Conventions
• Java Bracket Conventions
• Miscellaneous Bracket Conventions

Lesson 16:
• Appendix E: Unicode Standard
• ASCII Punctuation Characters

Lesson 17:
• Appendix F: Pseudo-code Algorithms
• Implementing Statement-Related Algorithms from Pseudocode

Lesson 18:
• Appendix G: Unified Modeling Language
• Recognizing Representations of Significant UML Elements
• Recognizing Representations of UML Associations

Lesson 19:
• Appendix H: Functional Interfaces
• Specific-Purpose FIs
• General-Purpose FIs

1 - Introduction to Microsoft SQL Server 2014

  • The Basic Architecture of SQL Server
  • SQL Server Editions and Versions
  • Getting Started with SQL Server Management Studio
  • Lab : Working with SQL Server 2014 Tools

2 - Introduction to T-SQL Querying

  • Introducing T-SQL
  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Lab : Introduction to Transact-SQL Querying

3 - Writing SELECT Queries

  • Writing Simple SELECT Statements
  • Eliminating Duplicates with DISTINCT
  • Using Column and Table Aliases
  • Writing Simple CASE Expressions
  • Lab : Writing Basic SELECT Statements

4 - Querying Multiple Tables

  • Understanding Joins
  • Querying with Inner Joins
  • Querying with Outer Joins
  • Querying with Cross Joins and Self Joins
  • Lab : Querying Multiple Tables

5 - Sorting and Filtering Data

  • Sorting Data
  • Filtering Data with a WHERE Clause
  • Filtering with the TOP and OFFSET-FETCH Options
  • Working with Unknown and Missing Values
  • Lab : Sorting and Filtering Data

6 - Working with SQL Server 2014 Data Types

  • Introducing SQL Server 2014 Data Types
  • Working with Character Data
  • Working with Date and Time Data
  • Lab : Working with SQL Server 2014 Data Types

7 - Using DML to Modify Data

  • Inserting Data
  • Modifying and Deleting Data
  • Lab : Using DML to Modify Data

8 - Using Built-In Functions

  • Writing Queries with Built-In Functions
  • Using Conversion Functions
  • Using Logical Functions
  • Using Functions to Work with NULL
  • Lab : Using Built-In Functions

9 - Grouping and Aggregating Data

  • Using Aggregate Functions
  • Using the GROUP BY Clause
  • Filtering Groups with HAVING
  • Lab : Grouping and Aggregating Data

10 - Using Subqueries

  • Writing Self-Contained Subqueries
  • Writing Correlated Subqueries
  • Using the EXISTS Predicate with Subqueries
  • Lab: Using Subqueries

11 - Using Table Expressions

  • Using Derived Tables
  • Using Common Table Expressions
  • Using Views
  • Using Inline Table-Valued Functions
  • Lab : Using Table Expressions

12 - Using Set Operators

  • Writing Queries with the UNION Operator
  • Using EXCEPT and INTERSECT
  • Using APPLY
  • Lab: Using Set Operators

13 - Using Window Ranking, Offset, and Aggregate Functions

  • Creating Windows with OVER
  • Exploring Window Functions
  • Lab: Using Window Ranking, Offset and Aggregate Functions

14 - Pivoting and Grouping Sets

  • Writing Queries with PIVOT and UNPIVOT
  • Working with Grouping Sets
  • Lab: Pivoting and Grouping Sets

15 - Executing Stored Procedures

  • Querying Data with Stored Procedures
  • Passing Parameters to Stored Procedures
  • Creating Simple Stored Procedures
  • Working with Dynamic SQL
  • Lab: Executing Stored Procedures

16 - Programming with T-SQL

  • T-SQL Programming Elements
  • Controlling Program Flow
  • Lab: Programming with T-SQL

17 - Implementing Error Handling

  • Using TRY / CATCH Blocks
  • Working with Error Information
  • Lab: Implementing Error Handling

18 - Implementing Transactions

  • Transactions and the Database Engine
  • Controlling Transactions
  • Isolation Levels
  • Lab: Implementing Transactions

1 - Introduction to SQL Server 2014 Database Administration

  • Database Administration Overview
  • Introduction to the SQL Server Platform
  • Database Management Tools and Techniques
  • Lab: Using SQL Server Administrative Tools
  • Using SQL Server Management Studio
  • Using the sqlcmd Utility
  • Using Windows PowerShell with SQL Server

2 - Installing and Configuring SQL Server 2014

  • Planning SQL Server Installation
  • Installing SQL Server 2014
  • Post-Installation Configuration
  • Lab: Installing SQL Server 2014
  • Preparing to Install SQL Server
  • Installing SQL Server
  • Performing Post-Installation Configuration

3 - Working with Databases and Storage

  • Introduction to Data Storage with SQL Server
  • Managing Storage for System Databases
  • Managing Storage for User Databases
  • Moving Database Files
  • Configuring the Buffer Pool Extension
  • Lab: Managing Database Storage
  • Configuring tempdb Storage
  • Creating Databases
  • Attaching a Database

4 - Planning and Implementing a Backup Strategy

  • Understanding SQL Server Recovery Models
  • Planning a Backup Strategy
  • Backing up Databases and Transaction Logs
  • Using Backup Options
  • Ensuring Backup Reliability
  • Lab: Backing Up SQL Server Databases
  • Backing Up Database
  • Performing Database, Differential, and Transaction Log Backups
  • Performing a Partial Backup

5 - Restoring SQL Server 2014 Databases

  • Understanding the Restore Process
  • Restoring Databases
  • Advanced Restore Scenarios
  • Working with Point-in-Time Recovery
  • Lab: Restoring SQL Server Databases
  • Restoring a Database Backup
  • Restoring Database, Differential, and Transaction Log Backups
  • Performing a Piecemeal Restore

6 - Importing and Exporting Data

  • Introduction to Transferring Data
  • Importing and Exporting Table Data
  • Copying or Moving a Database
  • Lab: Importing and Exporting Data
  • Using the SQL Server Import and Export Wizard
  • Using the bcp Utility
  • Using the BULK INSERT Statement
  • Using the OPENROWSET Function

7 - Monitoring SQL Server 2014

  • Introduction to Monitoring SQL Server
  • Dynamic Management Views and Functions
  • Performance Monitor
  • Lab: Monitoring SQL Server 2014
  • Collecting Baseline Metrics
  • Monitoring a Workload

8 - Tracing SQL Server Activity

  • Tracing SQL Server Workload Activity
  • Using Traces
  • Lab: Tracing SQL Server Workload Activity
  • Capturing a Trace in SQL Server Profiler
  • Generating Database Tuning Recommendations
  • Using SQL Trace

9 - Managing SQL Server Security

  • Introduction to SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Principals
  • Managing Database Permissions
  • Lab: Managing SQL Server Security
  • Managing Server-Level Security
  • Managing Database-Level Security
  • Testing Database Access

10 - Auditing Data Access and Encrypting Data

  • Auditing Data Access in SQL Server
  • Implementing SQL Server Audit
  • Encrypting Databases
  • Lab: Auditing Data Access and Encrypting Data
  • Implementing Auditing
  • Implementing Transparent Database Encryption

11 - Performing Ongoing Database Maintenance

  • Ensuring Database Integrity
  • Maintaining Indexes
  • Automating Routine Database Maintenance
  • Lab: Performing Ongoing Database Maintenance
  • Managing Database Integrity
  • Managing Index Fragmentation
  • Implementing a Maintenance Plan

12 - Automating SQL Server 2014 Management

  • Automating SQL Server Management
  • Implementing SQL Server Agent Jobs
  • Managing SQL Server Agent Jobs
  • Managing Job Step Security Contexts
  • Managing Jobs on Multiple Servers
  • Lab: Automating SQL Server Management
  • Creating a Job
  • Scheduling a Job
  • Configuring Job Step Security Contexts

13 - Monitoring SQL Server 2014 by Using Alerts and Notifications

  • Monitoring SQL Server Errors
  • Configuring Database Mail
  • Configuring Operators, Alerts, and Notifications
  • Lab: Monitoring SQL Server by Using Alerts and Notifications
  • Configuring Database Mail
  • Implementing Operators and Notifications
  • Implementing Alerts

1 - Introduction to Data Warehousing

  • Overview of Data Warehousing
  • Considerations for a Data Warehouse Solution
  • Lab: Exploring a Data Warehousing Solution
  • Exploring Data Sources
  • Exploring and ETL Process
  • Exploring a Data Warehouse

2 - Planning Data Warehouse Infrastructure

  • Considerations for Data Warehouse Infrastructure
  • Planning Data Warehouse Hardware
  • Lab: Planning Data Warehouse Infrastructure
  • Planning Data Warehouse Hardware

3 - Designing and Implementing a Data Warehouse

  • Data Warehouse Design Overview
  • Designing Dimension Tables
  • Designing Fact Tables
  • Physical Design for a Data Warehouse
  • Lab: Implementing a Data Warehouse
  • Implement a Star Schema
  • Implement a Snowflake Schema
  • Implement a Time Dimension

4 - Creating an ETL Solution with SSIS

  • Introduction to ETL with SSIS
  • Exploring Data Sources
  • Implementing Data Flow
  • Lab: Implementing Data Flow in an SSIS Package
  • Exploring Data Sources
  • Transferring Data by Using a Data Flow Task
  • Using Transformations in a Data Flow

5 - Implementing Control Flow in an SSIS Package

  • Introduction to Control Flow
  • Creating Dynamic Packages
  • Using Containers
  • Managing Consistency
  • Lab: Implementing Control Flow in an SSIS Package
  • Using Tasks and Precedence in a Control Flow
  • Using Variables and Parameters
  • Using Containers
  • Lab: Using Transactions and Checkpoints
  • Using Transactions
  • Using Checkpoints

6 - Debugging and Troubleshooting SSIS Packages

  • Debugging an SSIS Package
  • Logging SSIS Package Events
  • Handling Errors in an SSIS Package
  • Lab: Debugging and Troubleshooting an SSIS Package
  • Debugging an SSIS Package
  • Logging SSIS Package Execution
  • Implementing an Event Handler
  • Handling Errors in a Data Flow

7 - Implementing a Data Extraction Solution

  • Planning Data Extraction
  • Extracting Modified Data
  • Lab: Extracting Modified Data
  • Using a Datetime Column
  • Using Change Data Capture
  • Using the CDC Control Task
  • Using Change Tracking

8 - Loading Data into a Data Warehouse

  • Planning Data Loads
  • Using SSIS for Incremental Loads
  • Using Transact-SQL Loading Techniques
  • Lab: Loading a Data Warehouse
  • Loading Data from CDC Output Tables
  • Using a Lookup Transformation to Insert or Update Dimension Data
  • Implementing a Slowly Changing Dimension
  • Using the MERGE Statement

9 - Enforcing Data Quality

  • Introduction to Data Quality
  • Using Data Quality Services to Cleanse Data
  • Using Data Quality Services to Cleanse Data
  • Lab: Cleansing Data
  • Creating a DQS Knowledge Base
  • Using a DQS Project to Cleanse Data
  • Using DQS in an SSIS Package

10 - Master Data Services

  • Introduction to Master Data Services
  • Implementing a Master Data Services Model
  • Managing Master Data
  • Creating a Master Data Hub
  • Lab: Implementing Master Data Services
  • Creating a Master Data Services Model
  • Using the Master Data Services Add-in for Excel
  • Enforcing Business Rules
  • Loading Data Into a Model
  • Consuming Master Data Services Data

11 - Extending SQL Server Integration Services

  • Using Scripts in SSIS
  • Using Custom Components in SSIS
  • Lab: Using Custom Scripts
  • Using a Script Task

12 - Deploying and Configuring SSIS Packages

  • Overview of SSIS Deployment
  • Deploying SSIS Projects
  • Planning SSIS Package Execution
  • Lab: Deploying and Configuring SSIS Packages
  • Creating an SSIS Catalog
  • Deploying an SSIS Project
  • Running an SSIS Package in SQL Server Management Studio
  • Scheduling SSIS Packages with SQL Server Agent

13 - Consuming Data in a Data Warehouse

  • Introduction to Business Intelligence
  • Enterprise Business Intelligence
  • Self-Service BI and Big Data
  • Lab: Using a Data Warehouse
  • Exploring an Enterprise BI Solution
  • Exploring a Self-Service BI Solution

What Should I Know About the Software Developer Course?

  • You’ll develop your knowledge in Microsoft Software Fundamentals, HTML5, CSS3, Oracle OCA Java and Microsoft SQL Server 20461
  • Upgrade your learning with our Premium Software Developer course, benefit from 2 additional certificates in Microsoft SQL Server 20462 & 20463
  • Get your career in Software Development started in as little as 3 months
  • Be supported throughout your studies with your dedicated tutor - they're just an email or phone call away!
  • Complete your learning online and have flexibility over your studies – learn around and life’s other commitments

price-match-guarantee-sticker-01.png

At The Training Room we strive to offer our customers first-class service and training a competitive prices. In order to uphold our IT Price Match Guarantee we actively monitor the prices offered by our competitors. If you find a cheaper price for the same training - we'll match it.
 

Read our Terms and Conditions here