SQL Programming and Database Design- 6 Hour Hands-on Workshop (Part 2)
Hosted by HacDC
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/)
