Skip to content

Details

This SQL programming and database design workshop teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. This workshop is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements.

Below is the link to the first part of this workshop:
https://www.meetup.com/hac-dc/events/238343247/

You will learn

• Design normalized table structures for relational databases

• Create databases and tables Using primary and foreign keys

• Writing SQL queries

• Using simple joins

• Using DML for SELECT, INSERT, UPDATE, DELETE

• Using subqueries

About Instructor

Matt Zand has over 6 years of experience in back-end coding. He has developed more than 20 custom websites and mobile Apps. He is the founder of myhsts.org (http://myhsts.org/) and dcwebmakers.com (http://dcwebmakers.com/)

Mr. Zand has designed many large scale MySQL databases with over 100 tables. Below are some of his portfolio:
weg2g.com (http://www.weg2g.com/application/weg2g/index.php)
abovezest.com (http://www.weg2g.com/application/abovezest/)
touchstonewords.com (http://www.weg2g.com/application/touchstonewords/)
510club.com (http://www.weg2g.com/application/510club/)

https://www.linkedin.com/pulse/15-tricks-any-serious-mysql-database-developer-should-matt-zand

Workshop Info

Length: 6 hours
Registration Fee: $190 Per Person

Refund Policy

  • We fully refund you if we cancel the event. If we reschedule it and you can not make it, we fully refund you.

Workshop Prerequisites

General computer knowledge. Familiarity with relational database concepts is helpful but not required.
Workshop Preparations
We focus on MySQL coding. Bring along your laptop with a charger. Install the XAMPP (https://www.apachefriends.org/index.html) local server. We use phpMyAdmin on your localhost to run SQL commends. If time permits, we may run SQL codes from shell scripts.

Related Workshops

Design a Responsive Website with Bootstrap in a 6 Hour Workshop (https://www.meetup.com/hac-dc/events/237914196/)

Related topics

You may also like