Introduction to SQL Programming Basics

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.

• 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
• GROUP BY and HAVING
• Subqueries  
• Regular Expressions
• Analytics

Basic computer skills are required.  A basic knowledge of databases is desired but not required.

This in an introductory-level course geared for end users, data scientists, business analysts, application developers and database administrators new to SQL.