The Complete SQL Bootcamp

Master in-demand SQL skills by creating complex databases and building reports for real-world projects.

  • 4th week of April, 2019
  • 2 sessions
  • 3.0 hours/session

About this Course

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, this course is for you.

By the end of the course, you’ll be able to interact with and query any SQL database. You’ll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.

The content will be taught across 2 sessions for the bootcamp.

Objectives

In this course, you’ll learn to:

- Install the MySQL server in your local system
- Set up and configure the MySQL database server
- Create databases and queries
- Use logical operators and manipulate tables/rows/data
- Use the “join” function

Course Plan

- Overview and installation
- Introducing the concept of data and storage
- Create a database with SQL
- Create a table with SQL
- Inserting data with SQL
- Understanding data structures
- SELECT statement
- Making a query with WHERE SQL
- Building filters
- Updating data
- DELETE statement
- DISTINCT statement
- Sorting data with ORDER BY statement
- Aggregating data with GROUP BY statement
- MIN, MAX, SUM and AVG functions
- Basic data types
- Date time types
- EQUALS and NOT EQUALS, GREATER THAN and LESS THAN statements
- BETWEEN, IN and NOT IN and CASE statements
- Understanding ONE to MANY and MANY to ONE relationships
- Multiple table queries with JOIN statement

Prerequisites

There are no prerequisites for this bootcamp.

This course is perfect for:
- Anyone interested in learning SQL to help with their current job or to find a new role
- Anyone looking to answer complex business problems and generate reports using data
- Business owners and people in sales or marketing roles who are interested in understanding their company data better
- Developers who are looking to build applications (e.g. social network, ecommerce site) using MySQL
Active Course Runs

Lesson Dates/Timings

  • April 27, 20190930 - 1230 hrs
  • April 27, 20191300 - 1600 hrs
  • The Cathay

    The Cathay, 2 Handy Road #03-06 Singapore 229233

    Instructor

    ZP


    UpCode Academy

    Attend coding classes taught by true experts working in the industry. Get practical instructions and interact with these practitioners during the classes.

    • 23 Courses
    • 1,092 Students
    • 23 Instructors

    Subscribe to our Newsletter