Description
This SQL / JavaScript / Web Course is for anyone who wants to get into the world of Database Developers or Business Intelligence . Create web-enabled apps with a database back-end using Node.JS and MySql
Prerequisites
Intro To Programming with JavaScript recommended, however if you did not do it, you might find a strong need to do it after this course in order to build more web-apps.
Intended Audience
- This SQL / Javascript web training course is for anyone who wants to get into the world of Database Developers / Administrators or Business Intelligence and wants the ability to develop small / medium web-enabled database systems with reporting .
- Some familiarity with spreadsheets, relational databases and basic SQL might be helpful. Some coding experience might be helpful.
- Anyone interested in learning SQL to help with their current job or to find a new role. SQL is one of today’s most in-demand skills
- Anyone looking to answer complex business problems and generate reports using data
- Business owners, people in sales, or people in marketing roles who are interested in understanding company data better.
- Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL
After this course you should
- Know SQL syntax
- Know SQL database design concepts
- Know advanced querying
- Know how to do hard core database manipulation with Subqueries, Joins and Transactions
- Understand effective and efficient database design and creation
- Be able to query, normalize and join data
- Be ready to prepare for the MTA DBA Fundamentals Exam 98-364
- Create your own database or interact with existing databases
- Write complex SQL queries across multiple tables
- Build a web app using NodeJS and MySQL
- Model real-world data and generate reports using SQL
- Answer company performance or sales questions using data
Alignment
- Microsoft MTA DBA Fundamentals Exam 98-364 (MTA Exam not included in course price) – please ask for study material if you want to pursue this exam
- w3schools.com/sql
Further Training
- Consider doing our Advanced SQL Querying or DB Design
Course Material
- Course material included (electronic)
Course Contents
DAY 1
- Introduction to SQL
- Getting Started: Overview and Installation
- Creating Databases and Tables
- Inserting Data (and a couple other things)
DAY 2
- CRUD commands
- CRUD Challenge Section
- The World Of String Functions
- Refining Selections
DAY 3
- Aggregate Functions
- Revisiting Data Types
- Logical Operators
- One To Many
DAY 4
- Many To Many
- Basics
- Creating Our Tables
- 7 Joins Exercises
- Social Media Database Example
- Working With Lots Of Social Media Data
- Loading lots of data
- 7 Exercises
DAY 5
- Node.js
- MySQL and Other Languages
- BUT WHAT ABOUT PHP
- Introduction to JOIN US app
- Setting Up Cloud9 for Node
- 5 Minute NodeJS Crash Course
- Note about Faker install
- Introduction to NPM and Faker
- Introducing the MySQL Package
- Connecting Node to MySQL
- Creating The Users Table
- Selecting Using Node
- Inserting Using Node
- Some MySQL/Node Magic
- Bulk Inserting 500 Users
- Building Our Web App with Express JavaScript Framework
- Database Triggers for the Web App
Duration and pricing
Certificate
Read about our certificates
Questions
Please email us
Schedule for Johannesburg
On the calendar on this page below.
If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our ‘Contact Us’ page.