univerpulse@gmail.com
EN
Course cost: $300 / month
Course duration: 2 months, 25 hours
Course start date: September 23, 10:00 - 13:00, Saturdays
Course entry requirements: no requirements

*The course is available in the following languages: English, Russian, Ukrainian
Structured Query Language (SQL)
Course program
Sign up
Course program
Introduction. Basic concepts and definitions
  • What is SQL and why do you need it.
  • SQL standards.
  • Strengths and weaknesses.
  • What is a database? Database management system MySQL.
Relational model
  • Basic Concepts.
  • Relations. Keys of relations.
  • Normal forms. Results of normalization.
  • Relational operations
Getting Started with DB
  • Differences between SQL and relational theory.
  • RDBMS MySQL.
  • Database client application Squirrel.
  • Quick notes of SQL syntax.
Table creation and data manipulation
  • Table creation.
  • Subordinate relations.
  • Data integrity constraints.
  • Data manipulation. Part 1.
Fetching data
  • Test database and populating data.
  • Formulating the task.
  • Answering the questionnaire.
  • SELECT statement syntax.
  • Semantics of query.
  • Composing SELECT: step by step.
Fetching data: WHERE clause
  • The concept of a predicate. Rules of logical expressions.
  • Comparison predicates, LIKE, BETWEEN, IN, IS NULL, MATCH.
Fetching data: aggregation
  • Aggregate functions.
  • HAVING clause.
  • Operators DISTINCT and ALL.
Practice tasks set №1
Fetching data: subqueries
  • The way a subquery is processed.
  • Subqueries in WHERE clause. Once again: predicates.
  • Subqueries in columns.
  • Subqueries in the FROM clause.
Fetching data: joining tables
  • Correspondence with the relational theory.
  • What could be present in the FROM clause.
  • Joining tables using JOIN operator.
  • Inner joins.
  • Outer joins.
  • Join on inequality.
  • The union, division, subtraction operations.
Data Manipulation. Part 2
  • Adding data to a table - INSERT.
  • Changing table data - UPDATE.
  • Adding-or-changing(merging) table data – INSERT … ON UPDATE.
  • Deleting data from a table - DELETE.
  • Merging data.
Practice tasks set №2
Recursive queries
  • The concept of hierarchical data representation.
  • Data processing hierarchy by using the adjacent data model.
  • Data processing hierarchy using the nested set model.
Triggers
  • Triggers usage.
  • Imposing corporate constraints.
  • BEFORE and AFTER triggers.
  • INSERT, UPDATE and DELETE triggers.
  • ROW and STATEMENT triggers.
  • Special objects OLD and NEW.
Creating Views
  • Advantages and disadvantages of creating views.
  • Updatable views.
  • Views with restrictions.
Authorization tools
  • Data dictionary.
  • Users manipulation.
  • Granting and revoking rights.
  • Access levels.
Transaction Management
  • ACID transaction.
  • Transactions phenomena.
  • Isolation levels.
Query performance tuning
  • Large amounts of data.
  • Query planner.
  • Indexing.
  • Partitioning.
  • Join algorithms.
Practice tasks set №3
Database Design using UML
  • Requirements Analysis.
  • Creation of class diagram.
Association, composition and aggregation relationships
Transition from classes diagram to the ERD
The final project: creation of billing system of mobile operator
  • Gathering of functional requirements for project.
  • Preparation of technical requirements.
  • Creation of database.
  • Filling the database and calculation the necessary indicators.
  • Composing of user’s bill.
Sign up
Please fill out the form. Our managers will contact you shortly.
Made on
Tilda