SQL Fundamentals And Advanced Querying

by VTeach Claim Listing

Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases can join this course.

S$495

Contact the Institutes

Fill this form

Advertisement

VTeach Logo

img Duration

2 Days

Course Details

Upon successful completion of this course, students will be able to:

  • Connect to the SQL Server database and execute a simple query.
  • Include a search condition in a simple query.
  • Use various functions to perform calculations on data.
  • Organize data obtained from a query before it is displayed on-screen.
  • Retrieve data from tables.
  • Format an output, save a result, and generate a report.
  • Use subqueries to generate query output.
  • Manipulate table data by inserting and updating records in a table and deleting records from a table.
  • Manipulate the table structure.
  • Create views, manipulate data through views, modify the view structure, and drop views.
  • Create indices on table columns and drop inefficient indices.
  • Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction.
  • Central Branch

    10 Anson Road #10-11 International Plaza, Central

Check out more SQL Server courses in Singapore

New Horizons Singapore Logo

SQL Server Training And Certification

Get hands-on SQL Server training to master the most widely used database management system and open the door to new career possibilities.

by New Horizons Singapore [Claim Listing ]
NobleProg (Singapore) Logo

Oracle SQL Intermediate - Data Extraction

The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.

by NobleProg (Singapore) [Claim Listing ]
The IT Enabling Company Logo

Oracle Database SQL Certified Expert

This course teaches participants queries, insert, update and delete SQL statements, Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization. You will also learn how to use SQL to create and manipulate tables in an Oracle Database.

by The IT Enabling Company [Claim Listing ]
ITEL Learning Systems Logo

SQL Server

SQL Server is a relational database management system (RDBMS) from Microsoft that is designed for the enterprise environment.

by ITEL Learning Systems [Claim Listing ]
NTUC LearningHub Logo

Querying Data With TransactSQL (SF)

The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

by NTUC LearningHub [Claim Listing ]
  • Price
  • Start Date
  • Duration

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy