(Click Category to List Courses)

38 - IT-D Information Technology - Databases and Related Technologies

---

IT-D 101 - SQL Databases and Querying

Code	Start Date	Duration	Venue
IT-D 101	07 October 2024	5 Days	Istanbul	Registration Form Link
IT-D 101	11 November 2024	5 Days	Istanbul	Registration Form Link
IT-D 101	16 December 2024	5 Days	Istanbul	Registration Form Link

 

Course Description

A database is an organized collection of data. The data is typically organized to model relevant aspects of reality in a way that supports processes requiring this information. Nowadays Databases are used everywhere, they are used in web sites, bookkeeping, sales and inventory, or even the lowly to-do list. Also, SQL is considered as the most common language for database operations. This course helps participants to understand all aspects of databases and SQL language. A variety of lab exercises and small projects will be used to ensure they gain familiarity with how the design and execution environments work, and be prepared to build real world applications. Additionally the course introduces Transact SQL as the primary querying language of SQL Server. It discusses the basic structure of T-SQL queries, the logical flow of a SELECT statement, and introduces concepts such as predicates and set-based operations.

Course Objectives

• Being familiar with database fundamentals
• Understanding the role of databases in the conservation, recovery, protection, and easy retrieval of data
• Learning how to create and administer databases
• Being able  to write Transact-SQL queries to retrieve and manipulate data

Who Should Attend?

• Managers
• IT professionals
• Engineers involved in data storage operations
• Anyone who deals directly or indirectly with data