1. Singapore
  2. Professional
  3. IT Training
  4. Database Management
  5. SQL Server

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.

VTeach is a great platform for many working professionals and students to strengthen their workforce and increase their productivity through high quality professional training. We work closely with our clients and gain an in-depth understanding of their training objectives.

View Detailed Profile

  • Central Branch

    10 Anson Road #10-11 International Plaza, Central

Check out more SQL Server courses in Singapore

Avantus Training Logo

DP-080T00 | Querying Data with Microsoft Transact-SQL

Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.

by Avantus Training [Claim Listing ]
read more course details
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 ]
read more course details
League Of Coders Logo

MongoDB Database For Developer ( NoSQL)

MongoDB is consistently ranked as the most popular NoSQL database according to the DB-Engines monthly rankings. MongoDB is a free, open-source, cross-platform document database, which stores its data in JSON-like documents. 

by League Of Coders [Claim Listing ]
read more course details
Trainocate Singapore Logo

Oracle Database 18c: Administration Workshop

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. You learn how to create database storage structures appropriate for the business applications supported by your database.

by Trainocate Singapore [Claim Listing ]
read more course details
St.Hua Private School Logo

SQL Essentials

SQL (Structured Query Language) is a standard language for storing, manipulating and retrieving data in databases. This course is designed to help users understand the most common language for database wrangling.

by St.Hua Private School [Claim Listing ]
read more course details
Show Me All Similar Courses

About Coursetakers.com

Coursetakers.com is more than a decade old course aggregator and Online course platform that helps students find courses and compare course prices from Training providers in the UAE, UK, USA, India and South Africa, by just submitting their inquiry through the website. Coursetakers also helps Institutes, Universities and Online Instructors market their courses, gain leads and get more students to enroll into their courses.

  • Instagram
  • Facebook
  • Twitter

Courses

Quick Links

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

Ask Us?