Introduction to SQL (Using MySQL)

SQL stands for Structured Query Language. SQL is a standard language that was designed to query and manage data in relational database management systems (RDBMS). An RDBMS is a database management system that is used today in every type of desktop or web-based application.

MySQL is one of the most popular RDBMS used today and a solid understanding of SQL is critical if you want to have a successful career in web development.

This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, students will understand SQL functions, join techniques, database objects and be able to write queries and stored procedures.

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

Course Objectives:

  • Overview of MySQL and PHPMyAdmin
  • Understand basic concepts of how a database stores information via tables
  • Understanding of SQL syntax used with MySQL
  • Learn how to retrieve and manipulate data from one or more tables
  • Know how to filter data based upon multiple conditions
  • Updating and inserting data into existing tables
  • Learning how the relationships between tables will affect the SQL.
  • The advantages of store procedures with storing data using variables and functions.
  • How SQL can be used with programming languages like PHP to create dynamic websites for visitors.
  • Review of some sample PHP projects interacting with MySQL.
Outline
Week 1: SELECT Statement
  • Review of MySQL and PHPMyAdmin
  • Setting up your sample database and tables
  • SQL Overview
  • SELECT statement review
    • Filtering your data with WHERE clause
    • ORDER By clause
    • Selecting all columns
Week 2: Single Table Queries
  • Elements of SELECT
    • Operators of WHERE clause (=, <>, >, <, BETWEEN, LIKE, IN)
    • DISTINCT keyword
  • AND & OR keywords
  • Column Aliasing
  • In and Between
  • Updating Tables
    • UPDATE statement
    • INSERT INTO statement
Week 3: Joins: Multiple Table Queries
  • Cross Joins
  • Inner Joins
  • Outer Joins
Week 4: Sub Queries
  • Understanding the differences between a sub query and a join
  • Functions
    • Min()
    • Max()
    • Sum()
    • Now()
    • Avg()
Week 5: Programmable Objects
  • Variables
  • Stored Procedures
Week 6: Overview of PHP and MySQL
  • PHP basic syntax
  • Executing SQL commands from PHP code.
  • Sample PHP projects
Prerequisites
No prerequisites for this class.
Requirements
You will need the MySQL database with the phpMyAdmin interface to access it. Almost all UNIX/LINUX hosting account will have this, but please check before registering for class.


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 might be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost .

How eClasses Work:Instructors post lectures (text-based, no video or audio), 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.

1977

Price: $220.00
IWA Member Price: $120.00
Course No.: MS304
Instructor Frank Stepanski
Co-instructor/TA
CEUs 3
Duration 6 weeks
Cost 48
Open Courses:
- Start Date: Jun 26, 2017
(Register by: Jun 29, 2017)
- Start Date: Jul 24, 2017
(Register by: Jul 27, 2017)
- Start Date: Aug 21, 2017
(Register by: Aug 24, 2017)
- Start Date: Sep 18, 2017
(Register by: Sep 21, 2017)
- Start Date: Oct 16, 2017
(Register by: Oct 19, 2017)
- Start Date: Nov 13, 2017
(Register by: Nov 16, 2017)

Testimonials

Instructor's Profile:
InstructorFrank Stepanski has over 10 years experience in the IT field as a Web Developer. Frank has worked with technologies such as PHP, MySQL, ASP.NET, SQL Server as well as HTML, CSS and JavaScript. He has a Masters Degree in Software Engineering from Penn State University. He has also taught web programming classes at a local community college.
Before you register for this class, please read the Outline, Prerequisites, Requirements, Books, and Refund Policy sections carefully.
 

 Testimonials

Ratings
"I have been trying to develop some MySQL skills for the past 2-3 years and all without success... Every time I tried to learn something, I felt overwhelmed and lost... until NOW! I absolutely loved doing this course and enjoyed the way it was broken down into bite-sized manageable pieces for me. The instructor, Thuy is very knowledgeable and friendly and she even learnt some Maori, my native language, along the way (Ka pai Thuy!). I work for a company that develops software using MySQL, so to finally get some foundation skills and a good base for learning more MySQL will help my work and career progression greatly. Thanks Thuy!" - Toherangi Holloway
"Great class. The lessons were straight forward and easy to follow along. Never had any experience with SQL before but found out that writing queries was fun. It prepared me to move on and take MySQL. I would definitely recommend it for any web developer." - Jennifer Wilson
"Excellent introduction to SQL. Lectures were simple, clear and to the point. This class gives you the proper foundation for using SQL properly." - Philip Napora
"It was a very good course led by a very helpful instructor. I enjoyed it a lot and managed to learn more than expected in the given time period. I like the way eClasses works, I&#039;ll definitely be trying out some more courses. Thanks a lot." - Jacob Bruce
"I had fun with this class. I found the class very easy and the lessons easy to understand. It is worth taking if you plan to work on the web. I would recommend this class to all." - Sanjay Shetty
"Straight-forward 4-week introduction to MySQL with clear and concise lectures, and with prompt teacher responses to student work and questions." - Stewart Moore
"Enjoyed the introductory course to SQL - the lecture notes were concise and clear, which helped making the learning much more smoothly. The instructor was very encouraging, supportive, responding with comments and feedback in a timely manner. Great course - Thank You!" - Dana Mah
"I thought the assignments covered things that we would likely need to do when working with databases." - Letitia Wetterauer
"phpMyAdmin gave me a headache but after this class I feel comfortable with it - and of course with Thuy's help I really got there. Thanks Thuy you were a great help. " - Dorothy Wegmueller-Ngudle
"Thuy Le responded so quickly to problems in my assignments that it was hard to keep up (I mean this in a good way). His comments were diplomatic and always helpful, and the lectures were informative enough to justify the class not having a required text. I really enjoyed the class." - Scott Guhse
"I think we could use having a book for reference (or online materials). One section was particularly tough, and that was how to do joins. The last exercise was particularly good in that we had to make up our own data. We had to really think about the way the query language actually works." - Tamara Peace
"Good way to learn MySQL if you have a full time job." - Kevin (Xiao) Wang
"beginning of class was a little bit basic...I think maybe the first two weeks worth of assignments could be rolled into one...then you would have an extra week to go over all the material introduced in the third and fourth weeks (which were more challenging)...overall a nice course... " - John Petroshius
"I found this course exactly the right level for me - each lecture taught me something new and the assignments were challenging without being too difficult." - Emily Tarrant
"I used the SQL/MySQL course to brush up on SQL before continuing to the database design and MySQL courses. The lectures were well structured and easy to understand, and we got good and clear answers to our questions from the instructor, who also answered amazingly fast. A nice and very useful course." - Susanne Layla Petersen
"I enjoyed the class and liked the direct approach Thuy took in the lectures and assignments." - Paula Grigsby