SQL Essential

Overview

SQL Essential covers everything you need to know in a compact course that takes you in 4 weeks from basic concepts like understanding data types, to advanced concepts like creating programmed triggers and stored procedures using RDBMS (MySQL and SQLite) and NoSQL (Cassandra).

After this class, you will know how to:

• Understanding RDBMS
• Understanding SQL terminology and syntax
• Understanding CRUD operations
• Creating and updating databases and tables
• Creating/Updating a view
• Writing basic SQL queries
• Sorting and filtering data
• Accessing related tables with SELF-JOIN
• Accessing related tables with JOIN
• Using built-in functions
• 10 Homeworks
• 4 In-class tests (multiple-choice)
• 15 SQL interview questions/answers
• 10+ hours of videos

Prerequisites

None.

Course Duration

4 weeks

Course Format

This is an online course. We apply a powerful learning cycle of 3 hours lecture twice a week. (6 hours per week)
Each student gets a lab code and the entire course content printed out, interview questions/answers, tests and quizzes.
Learning cycle process is used repeatedly, first to integrate basic concepts, and then to reuse those concepts to master more advanced topics.
Practical exercises will be performed to take the learned knowledge to the level of practical application.
Detailed discussions will thoroughly deepen the understanding on which options are available at each step in the design process.

Пожалуйста зарегистрируйтесь, заполнив форму Register for Online Courses или по почте: register@alex.academy