(Click Category to List Courses)

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

IT-D 101 - SQL Databases and Querying

Code Start Date Duration Venue
IT-D 101 27 March 2023 5 Days Istanbul Registration Form Link
IT-D 101 22 May 2023 5 Days Istanbul Registration Form Link
IT-D 101 17 July 2023 5 Days Istanbul Registration Form Link
IT-D 101 11 September 2023 5 Days Istanbul Registration Form Link
IT-D 101 06 November 2023 5 Days Istanbul Registration Form Link
IT-D 101 18 December 2023 5 Days Istanbul Registration Form Link
Please contact us for fees


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

Course Details/Schedule

Day 1

  • Introducing database systems
  • Fundamentals of the relational database engine
  • Overview of the SQL language
  • SQL Server components and tools

Day 2

  • Building the database
  • Constructing a relational database
  • Defining tables
  • Safeguarding data with constraints
  • Leveraging server programmability

Day 3

  • Retrieving data with Transact-SQL
  • Modifying data with SQL commands
  • Developing programming constructs
  • Administering SQL server databases
  • Executing the maintenance plan wizard
  • Automating administrative tasks

Day 4

  • Monitoring SQL Server resources
  • Securing the database infrastructure
  • Integrating external applications
  • Pulling data from SQL Server into Excel
  • Creating a front-end interface with Access
  • Importing and exporting data from text files
  • Migrating an Access database to SQL Server

Day 5

  • Understanding Sets
  • Understanding Predicate Logic
  • Understanding the Logical Order of Operations in SELECT statements
  • Introduction to Transact-SQL Querying
  • Executing Basic SELECT Statements
  • Executing queries which filter data using predicates
  • Executing queries which sort data using ORDER BY