Sale!

Intermediate SQL

INR 15,000.00 INR 7,500.00

Cost includes complimentary Smart-Book and an International University Certificate.

Please Select University

Product price
Additional options total:
Order total:

Description

What You Will Learn

  • Explore how to write and implement complex queries on multiple tables simultaneously and how to apply advanced filtering techniques
  • Learn to create union queries that combine records from multiple queries, and how to use union queries to exclude or include duplicate records
  • Find out how to use text strings within union queries
  • Master advanced techniques for updating various types of data stored in your tables
  • Learn how to update a single field, multiple fields, multiple records, date fields, and calculated fields
  • Learn how to update and set NULL values using an update statement
  • Use advanced insertion techniques to add data to your tables and learn how to create, query, and modify temporary tables
  • Learn how to implement techniques to handle duplicate values stored in a table and how to limit the results of a result set
  • Discover how to use string functions to perform complicated searches on strings, how to implement date and time functions to insert and extract portions of a date, and how to create queries that accept input from users

Requirements

Hardware Requirements:

  • This certification can be taken on either a PC or Mac device.

Software Requirements:

  • PC: Windows XP or later.
  • Mac: OS X Snow Leopard 10.6 or later.
  • Browser: The latest version of Google Chrome or Mozilla Firefox are preferred. Microsoft Edge and Safari are also compatible.
  • Adobe Flash Player. Click here to download the Flash Player.
  • Adobe Acrobat Reader. Click here to download the Acrobat Reader.
  • Email capabilities and access to a personal email account.
  • Software must be installed and fully operational before the certification begins.

Reviews

There are no reviews yet.

Be the first to review “Intermediate SQL”

Your email address will not be published. Required fields are marked *