Introduction to SQL Server

Introduction to SQL Server online course
Course Name

Introduction to SQL Server

MS SQL Server is a “world-class” Relational Database Information System platform. Incorporating a tremendous power to scale data as well as the ability to transcend an array of data sources, scaling desktops, portable devices (phones, tablets), and data centers as well as private and/or public clouds. This course is for anyone who is interested in gaining an understanding and a working knowledge of SQL via the flexible MS SQL Server toolset.

Designed to facilitate beginners and/or knowledgeable SQL enthusiasts, this is a hands-on course, which de-mystifies the basics of Administering Microsoft SQL. Topics include: learning how to create and manipulate database objects such as tables, indexes, views, and triggers. Students will learn SQL basics that apply to MS SQL as well as to any major Relational Database Management System (RDBMS); the students will also be introduced to the basics of using SQL Server on the Web. Students will enhance problem solving, analytical and implementation abilities worth maximum currency. Upon completion of this course, students will be a valuable, revenue producing resource on the job and/or in business.

Applicable Job Roles: web programmers, web application developers, database administrators, web designers and data management stakeholders of any sort.

Outline
Week 1: SQL Server Basics
  • Client-Server database architecture and SQL Server architecture
  • Installing MS SQL Server (2008, 2012 or earlier)
  • Tables, relational databases, SQL and database objects
  • Design and develop MS SQL Server databases and tables
  • Referencing objects in SQL Server databases
  • Obtaining information from database tables
  • SQL Server security
Week 2: Understanding Tables and Databases
  • Creating databases manually
  • Creating databases with database wizard
  • Defining a maintenance plan wizard
  • Databases using Transact-SQL
  • Database manipulation: characteristics and deletions
  • Working with tables
Week 3: Indexes and Views
  • The basics of index structures
  • Creating and working with indexes
  • Indexes and table architecture
  • Creating views (including using view manager)
  • Working with views
  • Indexed views
Week 4: Database Diagrams, The Query Analyzer and SQL Basics
  • Working with diagrams
  • Diagramming for pubs database
  • Server connectivity and Screen management
  • Working with queries
  • SQL essentials (select, create table, insert, delete, update)
Week 5: Stored Procedures, Triggers and Replication
  • Components of stored procedures
  • Creating and working with stored procedures/system stored procedures
  • Components of triggers
  • Creating and working with triggers
  • Replication model and types of replication
  • Merge replication
Week 6: Data Transformation Services (DTS), Back Ups/Restores, Users, Roles, Logins and Analysis Manager
  • Creating, importing and exporting DTS
  • Creating, scheduling backups and restores
  • Authentication types, users, roles, security plans
  • Configuring DSN, loading analysis manager and working with cubes
  • Work on a final project
Prerequisites
None
Requirements
MS SQL Server 2012 or previous version, installed on a Windows computer. Download a free copy of Microsoft SQL Server 2012 R2 Express at: http://www.microsoft.com/en-us/download/details.aspx?id=29062
Additional Information
At no Additional Cost, Multimedia (Audio/Video/Gaming), content may be used as part of this courses learning resources.
Course Books
Course Price
  • Member Price: $120 US
  • Non-Member Price: $220.00 US
[Register Now]

Additional Information:
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.

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

Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.


4 Web Study Certificates

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

Introduction to Dreamweaver Online CourseDreamweaver Online CourseBuilding Data-Driven Websites Course
Web Videography CourseIntroduction to Microsoft Excel - Online CourseDigital Market Research Course
Contracting Your Services - Online CourseBlog Content Writing Course - OnlineWeb Content Writing Skills Course
DNS Administration CourseGoogle Web Analyics CourseWordpress Theme Design Course
Wordpress Content Management CourseDrupal Beginner CourseProject Management Training Course
Joomla Training CourseWeb Design Legal Issues CourseInteractive e-Survey Strategies Course
Search Engine Optimization CourseWebsite Promotion and Marketing Course - OnlineEmail Marketing Course Strategies
Social media Marketing CourseInternet Marketing Strategies CourseWeb Design Concepts Training Course
Web Design Course Training OnlineResponsive Web Design Training CourseIntroduction to Bootstrap Training Course
Introduction to Photoshop CC CourseAdobe InDesign CourseAdobe Illustrator Online Course
Mobile Web Design Online CourseHTML5 Online CourseCSS3 Online Course
Introduction to Sass Online CourseWeb Animation with CSS and JavaScript Online CourseSQL Using MySQL Online Web Training
SQL Server Online CoursePHP Online CoursePHP Online Course
JavaScript for Beginners Online Web TrainingJavaScript Level 2 Online CoursejQuery Web Programming Online Course
PHP Online CourseJavaScript for Beginners Online Web TrainingXML Web Programming Online Course