Mastering SQL

by Computer Images Claim Listing

This class is designed for database users who want to be able to create, read and modify SQL statements for use with their databases.

$260

Contact the Institutes

Fill this form

Advertisement

Computer Images Logo

img Duration

6 Hours

Course Details

This class is designed for database users who want to be able to create, read and modify SQL statements for use with their databases. Class exercises and discussion cover —

  • What SQL is and how it can be used with desktop applications such as Access, Excel and FileMaker,

  • What SQL can and cannot do,

  • Ways of writing SQL,

  • SQL syntax, reading, writing and understanding the language,

  • The difference between Data Definition Language (DDL) and Data Manipulation Language (DML),

  • Using an SQL SELECT statement to choose data to be returned from a database,

  • Working with the SELECT statement: SELECT, FROM, WHERE, ORDER BY,

  • Specifying conditions for a WHERE clause; using comparison operators, using the IN and LIKE operators,

  • Using the ORDER BY clause to sort data,

  • Using JOINs to link tables, different kinds of JOINs,

  • Introduction to functions in SQL, and

  • Using SQL to retrieve data, insert, update and delete records.

  • Boston Branch

    15 Court Sq Ste 530, Boston

Check out more SQL Server courses in USA

Interface Technical Training Logo

Introduction To Transact-SQL (SQL Server Training)

In this course, you’ll master the skills needed to write Transact-SQL SELECT statements accessing one or more tables. You’ll also learn the various techniques for combining data, filtering the results and how to control and format the statement output.

by Interface Technical Training [Claim Listing ]
Microtek Learning Logo

Introduction to SQL Databases

This Introduction to SQL Databases training is a three-day instructor-led training course. It is for students who want to start their database profession or whose current job is growing to contain database elements.

by Microtek Learning [Claim Listing ]
Kanshe Infotech Logo

Oracle DBA

Oracle DBA course training is offered by Kanshe Infotech for all skill level. We offer individual and corporate training in various technologies as well as technology functions through our Training arm Kanshe University. 

by Kanshe Infotech [Claim Listing ]
  • Price
  • Start Date
  • Duration
Milestone Technical Institute Logo

Oracle Database Administrator

This course prepares student to become a database administrator. Database Administrators (DBAs) are responsible for the design, implementation, support, and maintenance of computerized databases in today’s organizations

by Milestone Technical Institute [Claim Listing ]
Chicago Computer Classes Logo

MySQL Class

MySQL classes are offered by Chicago Computer Classes for all skill level. Tutoring by a professional developer & database administrator that knows all ins and outs.

by Chicago Computer Classes [Claim Listing ]

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