SQL DATABASE PROGRAMMING

ENROLL NOW

COURSE DESCRIPTION

Structured query language (SQL) is the language of databases. Whether you run reports or provide a dynamic website, you need to know SQL to add, delete, edit and view records. Databases organize and collect your data, and the SQL language is the liaison between you and the data. This course provides a step-by-step overview and instructions that help you get started with the SQL language.

APPLY NOW

PROJECT CURRICULUM

APPLY YOUR TECHNICAL SKILLS TO AN INDUSTRY BASED PROJECT. ONCE YOU LEAVE LANTERN YOU WILL HAVE SOMETHING TANGIBLE FOR YOUR PORTFOLIO

INDUSTRY INSTRUCTOR

LEARN FROM WORKING PROFESSIONALS AS THEY TAKE YOU THROUGH A CAREFULLY CRAFTED INDUSTRY BASED SYLLABUS

FLEXIBLE PACKAGES

INTERESTED IN CORPORATE TRAINING, CORPORATE SPONSORSHIP & MORE. WE PROVIDE FLEXIBLE TRAINING OPTIONS FOR YOUR UNIQUE NEEDS

LIVE ONLINE TRAINING

YOUR INSTRUCTOR WILL BE THERE EVERY STEP OF THE WAY USING OUR LIVE ONLINE HYBRID TRAINING MODEL TO MAKE YOUR TRAINING SESSION AS INTERACTIVE AS POSSIBLE

AMIRSINA ESKANDARIFAR

DATA SCIENTIST
INTERAC CORP

Amirsina is a Specialist Analytics and Data Scientist at Interac Co. He has done his masters in Mechanical Engineering at University of Toronto, and his thesis was about improving a computational fluid dynamic model in C++. His great programming skills and interest in statistics brought him to the field of machine learning. He started his professional career as a data scientist, machine learning engineer at Acerta Analytics Solution. At Acerta, he worked on anomaly detection models for different mechanical systems. He is currently working in finance sector and develops different statistical models for analytics and fraud department of Interac Co. Amirsina is very passionate about teaching, and follows this passion as a part-time instructor.

CURRICULUM &
INSTRUCTOR

SQL is Structured Query Language, which is a computer language for storing, manipulating and retrieving data stored in a relational database.

SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.

COURSE TOPICS

  • RELATIONAL DATABASE MANAGEMENT SYSTEMS WITH MYSQL
  • DATA DEFINITION LANGUAGE
  • MODELING AND DESIGNING OF A DATABASE
  • DATA MANIPULATION LANGUAGE
  • RETRIEVING DATA FROM DB AND SELECT STATEMENT
  • JOINS AND FOREIGN KEY, UNIONS, SUB QUERIES

LETS GET STARTED

NOT SURE WHICH PROGRAM OR COURSE IS RIGHT FOR YOU? BOOK A VIRTUAL CONSULTATION TO LEARN MORE ABOUT OUR COURSES, PROGRAMS, SCHOLARSHIPS AND MORE.

BOOK A CONSULTATION

FINANCING OPTIONS & TUITION COSTS

TUITION COSTS

$499 $299
  • $399 CAD plus HST
FINANCING

PACKAGE DISCOUNTS

INTERESTED IN ENROLLING IN OUR TRAINING PROGRAMS. DID YOU KNOW PYTHON IS A FUNDAMENTAL COURSE IN OUR CERTIFICATE PROGRAMS

EMPLOYMENT SPONSORSHIP

OPTIONS TO GET CORPORATE FUNDED TRAINING? LET LANTERN PROVIDE YOU WITH THE NECESSARY RESOURCES TO HELP YOU GET PARTIAL OR TOTAL TUITION COVERED.

THIRD PARTY LOAN

LANTERN INSTITUTE HAS WORKED WITH MANY THIRD PARTY VENDORS TO HELP WITH YOUR FINANCING. REQUIRED RESOURCES AND DOCUMENTATION CAN BE PROVIDED UPON REQUEST.

UPCOMING SESSIONS

APPLY NOW

PROGRAMS & COURSES

INTERESTED IN LEARNING MORE ABOUT OUR PROGRAMS? DID YOU KNOW THAT OUR PYTHON PROGRAMMING COURSE IN APART OF OUR TRAINING PROGRAM PACKAGES.

PROGRAMS & COURSES

DOWNLOAD
COURSE SYLLABUS