SQL / UNIX

SQL COURSE WITH TOAD

UNIX FUNDAMENTALS
Structured Query Language (SQL) is a very important data manipulation language. It is used in many different types of DBMS such Oracle,MS sql server, and MS access In this course, students will learn how to use SQL to retrieve, store or update data in Microsoft Access. The SQL syntax and data types may be different in other databases but students would manage to learn them very quickly once they have the foundation knowledge gained from this SQL course.Introduction

  • Database basics
  • Structured Query Language (SQL)
  • SELECT statement
  • ORDER BY clause

Setting Conditions

  • LIKE and wildcards
  • AND and OR
  • BETWEEN
  • IN and NOT IN

Advanced Queries

  • Multitable joins
  • Union queries
  • Built-in functions
  • GROUP BY
  • HAVING

 Manipulating Tables

  • Create and delete tables
  • Modify and delete existing fields
  • Create, update and delete records
  • Create indexes

 

 This course introduces the information technology professional to the UNIX operating system. They will learn to use both unix shell commands and on dis utilities to perform a basic user tasks, to customize the user environment and execute application. Course labs put special emphasis on using the korn shell and unix utilities 

 

Course OBJECTIVES

  • Describe the UNIX operating system
  • Login and logout using text terminals
  • Describe and navigate the UNIX file system
  • Manage files and directories
  • Create text files using vi editor
  • Executing the shell scripts and Batch Jobs
  • Using autosys commands to run the batch jobs