SQL Server Tutorial

SQL Server Training
Class Name

Advanced SQL Server Design and Implementation

Followup course to SQL Server Implementation and Design. Will cover advanced subjects, including TSQL, Stored Procedures, Triggers, Views, and Security. This will be a hands on project class, so students will be required to complete a database project that emcompasses the subjects covered in the class. This course is NOT designed to qualify student for the MCP Exam 70-229.

Applicable IT Job Roles:
  • Database Administrators: maintain, and administer databases.
  • Database Designers/Developers: develop database objects, such as tables, views, triggers, and stored procedures.
  • Web developers: design web interface to database applications, using scripting languages, such as ASP and Cold Fusion.
Outline
Week 1: Using TSQL
  • SQL Server Programming Tools
  • Intro to TSQL
  • TSQL Syntax
  • Executing TSQL Statements
Week 2: Implementing Stored Procedures
  • Intro to Stored Procedures
  • Creating, Modifying, and Deleting Stored Procedures
  • Programming Stored Procedures
Week 3: Implementing Triggers
  • Intro to Triggers
  • Creating and Managing Triggers
  • Programming Triggers
Week 4: Implementating View
  • Intro to Views
  • Creating, Modifying Views
  • Accessing Data with Views
Week 5: SQL Server Administration and Security
  • Overview of SQL Server Security
  • Designing a SQL Server Security Plan
  • Database Security Implementation and Administration
Week 6: SQL Server Agent and Data Transformation Service
  • SQL Server Agent
  • DTS
Prerequisites
Student should have taken SQL Server Implementation and Design, or have equivalent experience, including installing SQL Server, creating databases, and have basic knowledge of the Structured Query Language (SQL).
Requirements
Student will require:
  • Either access to a database server running SQL Server 2000
  • SQL Server client components, such as Enterprise Manager and Query Analyzer (120 day eval version available)
  • OR be able to install SQL Server 2000 server and client components (which requires Windows 2000 or greater). A 120 day evaluation version comes with the text, or is available from Microsoft.
Class Books
Course Price
  • Member Price: $170.00 US
  • Non-Member Price: $270.00 US
[Register Now]

Additional Information:
This online course is limited to 100 participants. Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training.

Refund Policy: Please read our "Terms and Refund Policy" before registering for this course.

Additional Cost: Book and software migh be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

Start Date: Click on the Register Now button to process to the registration page. You will see the start date of the class on that page. To get the start date of other courses, click on Open Class List link on the top navigation bar.

How eClasses Work: Instructors post lectures, reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class. Web Study certificate is also available. Click on the Certificates link on the top navigation bar for more information.

 

Register Now

  • Member Price: $170.00 US
  • Non-Member Price: $270.00 US
  • Course Duration: 6 weeks
  • CEUs: 3.0
  • Web Course No: MS322
  • Course Instructor: Timothy Haight
  • Co-Instructor/TA:
  • Session Open for Registration
Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.

Instructor: Timothy Haight
Timothy Haight Timothy Haight has worked for companies like Bechtel and Lockheed Martin where he developed database and web applications using tools such as SQL Server, Active Server Pages, Cold Fusion. When he is not teaching for eclasses.org, he also teaches Information Technology classes for ITT Technical Institute in Spokane, WA.
Prior to his working as a software developer, he worked as a technical support analyst and web master.
He also served in the U.S. Air Force as a Personnel Technician and as a Security Specialist.
Timothy Haight has a Masters of Science degree from Capella University and Bachelors of Applied Science Degree in Computer Programming from Griffin College in Seattle, Washington.

4 Web Study Certificates

 Valid XHTML 1.0!  Valid CSS1!  Level Triple-A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Intro to DreamweaverAdvanced DreamweaverAdvanced Adobe Flash
Web Animation with Flash (Introductory)Adobe FireworksIntermediate Flash
Web VideographyIntro to Apache AdministrationWeb Content Writing
Intro to DNSIntro to UNIXIntro to Web Analytics
Intro to WordPressIntro to DrupalProject Management
Intro to Joomla!Intermediate Joomla!Logo Design
Legal Issues for Web Designers and Content ManagersSearch Engine OptimizationWeb Site Promotion
Intro to Designing Accessible WebsitesDesign ConceptsIntro to Web Design
Photoshop Level 1Photoshop for the WebAdobe Illustrator
Adobe Illustrator Level 2Intro to HTMLHTML Level 2
Mobile Web DesignIntro to HTML5Intro to Cascading Style Sheets
Intermediate CSS WorkshopCSS 2.1 in DepthIntro to CSS3
Intro to XHTMLIntro to Database DesignIntro to SQL (Using Access)
Intro to SQL (Using MySQL)MySQLIntro to SQL Server
Intro to Programming ConceptsIntro to PHPShopping Cart Using PHP and MySQL
Intro to JSPIntro to ColdFusion Web DevelopmentIntermediate ColdFusion
Intro to JavaScriptIntermediate JavaScriptIntro to AJAX
Intro to jQueryJava for Non-ProgrammersProgramming in Java - Intro
Intermediate Java ProgrammingIntro to PerlIntro to C#
Intro to ASP.NET Web Development with C#Intro to ASPIntermediate ASP
Intro to Web SecurityIntro to XMLIntermediate XML
Intro to Game ProductionIntro to Game Design and DevelopmentIntro to Flash Game Programming
Intro to C++ Using GamesIntro to Windows Game Programming Using C++3D Game Programming Using DirectX