fbpx

Intensive course “Databases and SQL”

Supported by the American University of Central Asia

Schedule: Tue, Thu 19:00 — 21:00 Sat 10:00 — 12:00

Course duration: 5 weeks

Price: 10 000 KGS per month

img

(RU)

Учись бесплатно сейчас, оплачивай потом! Подробности по

ссылке

During 5 weeks you will got knowledge and skills which are required for a programmer of any IT field. This course will introduce you to the history of creating systems for processing structured data, approaches to information processing, the development of data models and data management systems.

What will you learn?

You will get acquainted with the basic concepts of database theory, with their components and architecture. You will learn how to write queries in SQL and prepare reports using MS SQL Server Reporting Services, as well as the basic SQL tools for data processing in SQL-DBMS.

Who is this course for?

This course is suitable for beginners who want to start their career in IT.

In addition, this course will be useful for professionals working with data – accountants, analysts, auditors and other specialists will be able to learn new tools and methods in their work.

img

Andrew Titov

Andrew Titov has 14 years of experience in professional software development, has extensive experience in the field of IT and telecommunications. He is an expert in C # / C ++, has a good knowledge of network and parallel programming, GUI development, has extensive experience in developing drivers, peripherals and in database development. His track record also includes extensive experience in managing problem projects.

Course content

1. Basic concepts of database theory
2. Database architecture and information systems
1. General concepts of the relational approach to the organization of the database
2. ER-modeling
3. Normalization of databases
1. The concept of CRUD. Basic construction SELECT. The WHERE clause.
2. Expressions INNER JOIN, LEFT JOIN, RIGHT JOIN. The expression ORDER BY.
3. Subqueries. Common table expressions. Expressions GROUP BY, HAVING.
4. Constructions INSERT, UPDATE, DELETE, MERGE.
5. Representations, procedures and functions.
1. Planning, preparing and creating reports.

How is the training?

img
img
img

We provide modern computers and the necessary software for training

Each lesson is recorded to repeat the material

Upgrade your knowledge and master a new profession with a friend!

Bring a friend and get a discount of 10%.
Bring two friends and get 15% discount