Show findcourses.com as: Mobile
Training overview
Professional Course
Webinar, Self-paced Online, Virtual Classroom
21 hours (live)/30 days (on-demand)
From 1,495 USD
Start dates
Online
1,495 USD
Inquire for more information

Online
1,495 USD
Start anytime

Online
1,495 USD
Start anytime

Course description

SQL Programming

This course teaches students relational database fundamentals and SQL programming skills. Topics covered include relational database architecture, database design techniques, and thorough analysis of query syntax. This class is intended for analysts, developers, designers, administrators, and managers who need to be able to construct sophisticated SQL queries. Upon completion, participants will understand SQL functions, advanced join techniques, database objects and constraints, and will be able to write useful SELECT, INSERT, UPDATE and DELETE statements. Comprehensive hands on exercises are integrated throughout the class to reinforce learning and develop real competency.

Students who require coverage of Microsoft-specific features including T-SQL data types, stored procedure enhancements, intrinsic functions, T-SQL cursors and table-valued functions should attend the Microsoft Transact-SQL Programming course rather than this course.

Who should attend?

General computer knowledge is required to learn SQL.

Training content

  • Relational Database Fundamentals
  • Creating a Database
  • Advanced Query Techniques
  • User-Defined Functions
  • Triggers
  • Writing Basic SQL Queries
  • Manipulating Query Results
  • Manipulating Table Data Using SQL's Data Manipulation Language (DML)
  • Stored Procedures
  • Working with Table Expressions

Course delivery details

Delivery Options: Attend face-to-face in the classroom,remote-live or via on-demand training.

Certification / Credits

  • Designing normalized table structures for relational databases
  • Creating databases and tables
  • Using primary and foreign keys
  • Writing SQL queries
  • Using inner and outer joins
  • Using set operators (UNION, INTERSECT, EXCEPT)
  • Using DML for SELECT, INSERT, UPDATE, DELETE
  • Using subqueries
  • Using triggers and stored procedures
  • Using aggregate functions to return totals and subtotals
  • Using table expressions

About HOTT

Hands On Technology Transfer, Inc.

Hands On Technology Transfer (HOTT) was established in 1995 and has always had the same mission: to provide the best possible IT training and always assure that students attain competence and confidence in the skills being taught. HOTT’s innovative approach...


Read more and show all training delivered by this supplier

Contact this provider

Fill out your details to find out more about SQL Programming.

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

Hands On Technology Transfer, Inc.


 Show phone number
www.traininghott.com


Reviews

Average rating 5

Based on 3 reviews.

B.H.
This was a great experience. I always did classroom settings in college as I felt I preferred the face to face interaction with my instructors over the on-line modules, but HOTT's remote attendance offers the flexibility of on-line without giving up the ability to have a more face-to-face learning experience and ability to ask questions. I would...
Show more
C.W., HTRI
I want to first thank you for the training last week on SQL Programming. This was the most beneficial training I have ever received. I learned so much and have already been able to put a majority of it into use at my job. You did a great job explaining everything and answering all of my questions. I cannot thank you enough and express my gra...
Show more
G.G., Kaplan University
This was the best SQL class I have been to. The instructor did an excellent job. He presented the material in a way that ensured everyone in the class was following along. I thought the learning material was well designed. I would recommend this class to my peers.
Contact provider

Have a question about this course? Fill out this form and the provider will get in touch with you shortly

Training reviews
Course rating
(5.0)
Based on 3 reviews.

Need help with your search?

findcourses.com offers a free consultancy service to help compare training for you and your team

Request a free quote

Request a free training quote