Advanced SQL with Stored Procedures Course

Course Code: RT 412
Course Abstract: This course teaches the intricacies of SQL using an interactive approach via a Windows SQL Server environment. It provides intermediate and advanced SQL techniques as well as Stored Procedures and Triggers.
Audience: This course is designed for analysts, designers, and programmers that need an understanding of how SQL is effectively and efficiently used to access data via SQL Server.
Duration: 4 days
Learning Outcomes:
Upon completion of this course, the participant will be able to:
> Utilize stored procedures and triggers within a Windows SQL Server environment
Course Topics:
Topics provide the attendee with the ability to understand:
that performance needs effective design
the effective use and creation of Triggers
how to create and utilize Stored Procedures
the performance advantages of Stored Procedures
the security advantages of using Stored Procedures
the 'thought process' of developing an effective query
the use of the elusive ALL, ANY, and EXIST parameters
the efficiencies and the inefficiencies in the SQL language
what correlation variables can do to simplify query processing
when SCALAR and AGGREGATE FUNCTIONs should be used
how to use the many types of sub query constructs most effectively
when which one of the four JOIN types should be used for efficiencies
Boolean constructs, CASE constructs, and multiple condition constructs
how NULLs are helpful to reduce processing time and query complexity
when to utilize the 'nested table expression' to improve query performance
what and when the UNION operation is most effective vs. other techniques
the runtime LOCKING issues with INSERT, UPDATE and DELETE operations
when to (and not to) use DISTINCT, IN, LIKE, BETWEEN and other predicates
how DATE and TIME data types can effectively be used for audits and compliance
Prerequisites:

None
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning

Testimonials

Excellent training that covered current Cisco IOS and routing and switching technologies. We also covered how to subnet, supernet, and use CIDR which was invaluable to putting our design into place. The instructor did an excellent job in teaching the CCNA class. I have been struggling to understand subnetting and networking. This class brought it all together for me.

–Student