(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 Fees
IT-D 101 07 December 2020 5 Days London $ 5950 Registration Form Link
IT-D 101 02 January 2021 5 Days Istanbul Array[0] 5950 Registration Form Link
IT-D 101 27 February 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 101 27 March 2021 5 Days Istanbul Array[2] 5950 Registration Form Link
IT-D 101 24 April 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 101 22 May 2021 5 Days Istanbul Array[4] 5950 Registration Form Link
IT-D 101 19 June 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 101 14 August 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 101 11 September 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 101 09 October 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 101 06 November 2021 5 Days Istanbul $ 3950 Registration Form Link
IT-D 101 04 December 2021 5 Days Istanbul $ 3950 Registration Form Link
DOWNLOAD PDF

 

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