A company’s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases with little room for error. When databases aren’t built or maintained correctly, it’s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered.
* Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Learning Objectives
Working in a hands on learning environment led by our expert practitioner, attendees will explore:
Basic RDBMS Principles
The SQL Language and Tools
Using SQL Developer
SQL Query Basics
WHERE and ORDER BY
Functions
ANSI 92 Joins
ANSI 99 Joins
Subqueries
Regular Expressions
Analytics
$1,795
Length: 3.0 days (24 hours)
Level:
Course Schedule:
6:00 PM ET