Microsoft Silver Partner
Make a request

Course - SQL Essential

Изображение к курсу SQL Essential
Course SQL Essential
Duration 10 days / 20 hours
Lessons number 9

Fulltime studies

2520 UAH Register

Online learning

2520 UAH Register

Video trainings

Subscribe

Consultations

Register
SQL is a structured query language used for creation, modification and managing data in relational database systems.

The SQL Essential course consists of 9 lessons that help beginners to understand the main concepts of software development for SQL Server 2012 R2. This course involves SQL Server optimization, instructions for development, tasks of administering that would be useful for experienced developers as well.

The students will be provided with guidelines and lessons examples that would be explained by trainer. Lessons consist of the theoretical part, helping to understand the content of the hands-on tasks and complete them. The second half of a lesson consists of classroom hands-on tasks, during which the trainer explains all the arising issues.

Every lesson ends with conclusions and questions to summarize the studied material, and students get home task.
• Anyone with basic computer skills
• Knowledge and ability to use the main definitions and language design concepts of the C# language
Beginners and also professionals who wish to update their knowledge
Lesson 1

Lesson 1. Introduction to SQL

• Basic concepts of databases
• Objects of the relational database
• Introduction to Management Studio
• The data types of T-SQL

Lesson 2

Lesson 2. T-SQL, Queries

• What is SQL, T-SQL
• What is DML
• General inquiries of DML language: SELECT, INSERT, UPDATE, DELETE
• Further development of funds of the Management Studio

Lesson 3

Lesson 3. Basics of DDL

• What is the DDL
• The main needs of DDL language : CREATE, ALTER, DROP
• The concepts of user-defined constraints, primary and foreign keys
• Types of relations

Lesson 4

Lesson 4. Designing a database.

• Normalization
• Development of a visual tools for database design

Lesson 5

Lesson 5. Subqueries

• Subqueries
• Related subqueries
• Working with cursors

Lesson 6

Lesson 6. JOIN-s

• Review of internal connections
• Consideration of external connections
• Consideration of the association

Lesson 7

Lesson 7. Indexing

• Organization of memory of the database
• B-trees
• Review of all kinds of indexes

Lesson 8

Lesson 8. Representation. Stored procedures. User-defined functions.

• Representations
• Conditionals constructions, cycles, handling of error messages
• Stored procedures
• Functions

Lesson 9

Lesson 9. Transactions. Triggers

• Transactions
• Mechanisms for transaction rollback
• Triggers

• Databases projecting
• Work with data with the help of queries
• Data notation
• Create and work with simulations
• Create search queries for hierarchical compositions
• Create functions and procedures
• Work with triggers
• Database optimization
• Database administration
• Data models building
Check mark Register for classes Separator Online registration form
Fulltime Weekends Three times a week
Start date End date Time
02.10.2017 12.10.2017 09:00-11:00 Register
02.10.2017 12.10.2017 11:30-13:30 Register
02.10.2017 12.10.2017 19:00-21:00 Register
02.10.2017 12.10.2017 16:30-18:30 Register
16.10.2017 26.10.2017 09:00-11:00 Register
16.10.2017 26.10.2017 11:30-13:30 Register
16.10.2017 26.10.2017 16:30-18:30 Register
16.10.2017 26.10.2017 19:00-21:00 Register

Did not find a suitable course in the timetable? Make a order

Fulltime Weekends Three times a week
Start date End date Time
02.10.2017 12.10.2017 09:00-11:00 Register
02.10.2017 12.10.2017 11:30-13:30 Register
02.10.2017 12.10.2017 19:00-21:00 Register
02.10.2017 12.10.2017 16:30-18:30 Register
16.10.2017 26.10.2017 09:00-11:00 Register
16.10.2017 26.10.2017 11:30-13:30 Register
16.10.2017 26.10.2017 16:30-18:30 Register
16.10.2017 26.10.2017 19:00-21:00 Register

Did not find a suitable course in the timetable? Оформите заявку