Web Design Training by IWA-HWG

Introduction to SQL (Using MySQL)

Introduction to SQL (Using MySQL) online course
Introduction to SQL (Using MySQL) Web Design Courses Web Certification Classes Home   

 

 

Class Name

Introduction to SQL (Using MySQL)

Structured Query Language (SQL) is a very important data manipulation language. It is used in many different types of DBMS such as MySQL, Oracle, DB2, Microsoft SQL Server, and Microsoft Access. In this course, students will learn how to use SQL to retrieve, store or update data in MySQL. The SQL syntax and data types may be different in other databases but students would manage to learn them very quickly once they have the foundation knowledge gained from this SQL course. Weekly lectures provide practical examples, illustration images, and detailed explanations. Weekly assignments will help students practice and go beyond what they have learned in the class.

Applicable Job Roles: web programmers, web application developers, database administrator, webmasters, and web project managers.

Course Objectives: at the end of this course, you will be able to:

  • Write queries to get information from the database
  • Change your queries based on specific requirements to produce ad hoc reports
  • Create and modify tables based on specific business needs
  • Understand basic queries written in php or asp pages or other web programming languages
Outline
Week 1: Introduction
  • Database basics
  • Structured Query Language (SQL)
  • SELECT statement
  • ORDER BY clause
Week 2: Setting Conditions
  • LIKE and wildcards
  • AND and OR
  • BETWEEN
  • IN and NOT IN
Week 3: Advanced Queries
  • Multitable joins
  • Union queries
  • Built-in functions
  • GROUP BY
  • HAVING
Week 4: Manipulating Tables
  • Create and delete tables
  • Modify and delete existing fields
  • Create, update and delete records
  • Create indexes
Prerequisites
None
Requirements
MySQL database and access to MySQL command line or PHPMyAdmin or any other MySQL administration tools to run queries. (Note that you do not need to know MySQL. But you need to have access to MySQL database. Usually you have access to MySQL databases and PHPMyAdmin if you have an Unix web hosting account. If you want to use MS Access for the course, take the MS303 course instead.)
Class Books

[
]
Course Price
  • Member Price: $80 US
  • Non-Member Price: $180.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

  • Member Price: $80 US
  • Non-Member Price: $180.00 US
  • Web Course No: MS304
  • Instructor: Open Position
  • Co-instructor/TA:
  • CEUs: 2
  • Duration: 4 weeks
  • Session Open for Registration
Before you register for this class, please read carefully the Outline, Prerequisites, Requirements, Books, and Refund Policy sections.


4 Web Study Certificates
Privacy Policy | Classes Refund Terms| Help-FAQ | Introduction to SQL (Using MySQL) | Web Design Association | Webmaster Association | Web Design Courses
© 1994-2013 by the HTML Writers Guild
Headquarters: 119 E. Union St., Suite F, Pasadena, California.
MS304 course by IWA-HWG

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

Intro to DreamweaverAdvanced DreamweaverBuilding Data-Driven Websites with Adobe Dreamweaver
Advanced Adobe FlashIntro to FlashAdobe Fireworks
Adobe Flash Level IIWeb VideographyContracting Your Services
Intro to Apache AdministrationBlog and Article WritingWeb Content Writing
Intro to DNSIntro to UNIXIntro to Web Analytics
WordPress Theme DesignIntro to WordPressIntro to Drupal
Project ManagementIntro to Joomla!Intermediate Joomla!
Logo DesignWebsite Project ManagementLegal Issues for Web Designers and Content Managers
Search Engine OptimizationWebsite PromotionEmail Marketing and Strategies
Social Media MarketingIntro to Designing Accessible WebsitesDesign Concepts
Intro to Web DesignIntro to Adobe MuseMobile Application UI Design
Photoshop Level 1Photoshop for the WebPhotoshop Retouching
InDesign Level 1Adobe IllustratorAdobe Illustrator Level 2
Intro to Adobe Edge AnimateIntro to HTMLHTML Level 2
Mobile Web DesignHTML5 IntroIntro 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 Visual Basic.NETIntro to ASP
Intermediate ASPIntermediate ASP.NET Web Development with C#Intro to Web Security
Intro to XMLIntermediate XMLIntro to Android App Development
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