Mark Russell - SQL 2005 Trainer (MCT, MCDBA, MCSD.NET, MCSE Security, CEH, Security+)
Mark Russell has over twenty years total networking and programming experience with a current focus enterprise database development and training using Microsoft SQL Server tools and technologies. Mark is a Certified Technical Trainer. He has taught over 500 Desktop Applications classes and over 500 Technical classes. Mark has completed Microsoft approved Train-the Trainer Program. He was named Instructor of the Year in 1999 with New Horizons Worldwide. As a Microsoft Certified Trainer, Mark has maintained an overall class (Instructor score) average of 9.62 on a 10 scale.
- Main Menu
Move through hours of in-depth content - quickly and easily due to the efficient and organized structure.
- PowerPoint
Utilizing PowerPoint presentations enhances the delivery by displaying a variety of visual information to the user. This type of representation allows the user to better interpret the material through charts, definitions, graphs, and more...
- Exclusive Learning Zone
Train around the clock, around the world. Our certified online instructors are located at global support centers in the U.S., U.K., Australia, and Singapore to provide real-time answers to technology- and soft-skill-related questions 24x7. This means access to a live subject matter expert no matter where you are - day or night. This level of student/instructor interaction provides real-time training specific support and extends training beyond content and instructor-led solutions by providing flexibility to accommodate individual needs and schedules.
- Controls
Move forward, back, and repeat entire topics or just a section. A progress bar illuminates as you advance through exercises.
- Full Motion Video
All courses feature full-motion videos of instructors teaching the information as if they are speaking directly to you. Our unique delivery simulates a one-on-one classroom environment creating a more personal lesson and learning experience.
- Study Guides
Printable study guides for the entire course are available. This allows all material to be viewed, reviewed, and printed for viewing at a later date.
- Review Exercises
Each section has a review quiz to aid in the learning process by validating the comprehension of the material covered before moving on to a new section.
- Resume
All courses are resumed to where you left off last session allowing you to learn when it is convenient for you without the hassle of remembering where you where.
- Microsoft Authorized Practice Exams
Our Training includes Authorized Practice Exams from Microsoft Certified Practice Test Provider (MeasureUp) to fully prepare you for the certification exams. Because many companies offer training and practice tests, the Microsoft MCP program has designated MeasureUp as a certified test provider to help IT candidates select the highest quality products and services. Microsoft performs quality reviews on all Practice Test Provider, and only approved practice test vendors bear the Microsoft Certified Practice Test Provider logo.
- Live Demonstrations
Demonstrations are a way for the instructor to show and tell the user how to perform
a task by actually doing it on screen in front of them. In this format it gives the user the power to see things done by a professional in the intended environment as many times as they would like.
- Labs
This course features cutting-edge, interactive labs, which provide a hands-on learning experience. This environment allows you to interact with the software with out the need for purchasing it or having it installed on your computer.
- Certificate of Completion
Our training is recognized worldwide for its technology-based IT training curriculums. Upon successful completion of our program, you will be receiving an official Distance Education Certificate of Completion.
Module 1 - Introduction to Computer Programs
Overview
Software Development
Computer Programs
How Does Software Work?
The Execution Process
Computer Programming Roles
Execution Phases of a Computer Program
The Input Phase Works
The Process Phase
The Output Phase
Problem-Solving Techniques
Approaches
Flowcharts
Demonstration: Drawing a Flowchart
Pseudocode
Program Types
Windows-Based Programs
Demonstration: Using a Window-Based Program
Web-Based Programs
Demonstration: Using a Web-Based Program
Module 2 - Introduction to Scripting
Overview
Web Scripting
Overview of Web Basics
Demonstration: Identifying Your IP Address
HTML
Demonstration: HTML Source
Demonstration: Creating a Web Page
What Is Web Scripting?
Demonstration: Writing a Simple Web Script
Macro Scripting
What Is a Macro?
Demonstration: Writing a Word Macro
Windows Scripting
What Is Windows Scripting?
Demonstration: Writing a Windows Script
Module 3 - Using Data and Variables
Overview
Variables
What Are Variables?
Uses of Variables
Data Types
Naming Variables
Declaring Variables
Initializing Variables
Operators
Arithmetic Operators
Relational Operators
Logical Operators
Demonstration: Using Operators
Syntax
Keywords
Demonstration: Identifying Keywords
Syntax Errors
Module 4 - Using Program Logic
Overview
Branching
Using the IF Statement
Demonstration: Flowcharting the IF Statement
Loops
Using a FOR Loop
Demonstration: Printing the Product of the First 8 Even Numbers
Using a WHILE Loop
Determining What Loop Statement to Use
Logic Errors
What Are Logic Errors?
Identifying Logic Errors
Module 5 - Using Procedures and Functions
Overview
Procedures
What Are Procedures?
Creating Procedures
Using Procedures
Passing Data to Procedures
Procedure Example
Functions
What Are Functions?
Predefined Functions
Creating Functions
Using Functions
Module 6 - Introduction to Developing a User Interface
Overview
Designing the User Interface
User Interfaces
User Interface Components
Helpful Features
Building the User Interface
Demonstration: Adding Controls to a Windows Program
Demonstration: Adding Controls to a Web Program
Module 7 - Introduction to Working with Data
Overview
Managing Data
External Data Storage Devices
Files
Records?
Databases
Entity Relationship Modeling
Entities
Attributes
Relationships
Types of Relationships
Subtypes and Supertypes
Tables
Using Keys to Sort Data
Primary Keys
Alternate Keys
Composite Keys
Foreign Keys
Demonstration: Creating an Entity Relationship Diagram with Visio
XML
What is XML?
Using XML
Demonstration: Using XML
Module 8 - Programming Approaches
Overview
Procedural Programming
What Is Procedural Programming?
Limitations of Procedural Programming
Object-Oriented Programming
What Is Object-Oriented Programming?
Classes and Objects
Abstraction
Inheritance
Module 9 - Introduction to Software
Development Process
Overview
Development Phases
Envisioning
Planning
Developing
Stabilizing
Unified Modeling Language
What Is UML?
Goals of UML
UML Views
UML Diagrams
UML Views and the Software Development Life Cycle Phases
Use-Case Diagrams
Use Cases
Actors
Identifying Actors
Use-Case Diagrams
Drawing Use-Case Diagrams
Demonstration: Creating Use-Case Diagrams
Other UML Diagrams
Class Diagrams
Object Diagrams
Collaboration Diagram
Sequence Diagrams
Module 10 - Where Do We Go From Here?
Overview
Looking Back
Development Types
Programming Fundamentals
Looking Forward
.NET Programming
ASP.NET Web Development
Database Programming with ADO.NET
Web Services