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.
This course provides a complete, hands-on introduction to SQL including the use of both SQL Developer and SQL*Plus, leveraging the latest editions of Oracle. A full presentation of the basics of relational databases and their use are also covered.
This “skills-centric” course is about 50% hands-on lab and 50% lecture, designed to train attendees core SQL programming and database skills, coupling the most current, effective techniques with the soundest industry practices. Throughout the course students will be led through a series of progressively advanced topics, where each topic consists of lecture, group discussion, comprehensive hands-on lab exercises, and lab review.
Our engaging instructors and mentors are highly experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working within in an engaging, hands-on learning environment, guided by our expert team, attendees will explore:
- Basic RDBMS Principles
- The SQL Language and Tools
- Using SQL Developer
- SQL Query Basics
- WHERE and ORDER BY
- ANSI 92 JOINS
- ANSI 99 Joins
- GROUP BY and HAVING
- Regular Expressions
This is an introductory- level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Basic computer skills are required. A basic knowledge of databases is desired but not required.
Take After: Our core SQl and database training courses provide students with a solid foundation for continued learning based on role, goals, or their areas of specialty. Our learning paths offer a wide variety of follow-on courses such as:
- Intermediate or Advanced SQL programming topics
- Database or tooling topics (SQL Server, Oracle, OBIEE, TOAD, etc)
- Database security topics
- Data Analytics / Big Data training – Spark, Hadoop, etc.
- Please contact us for recommended next steps tailored to your longer-term education, project, role or development objectives.
Each student will receive a Student Guide with course notes, code samples, software tutorials, diagrams and related reference materials and links (as applicable). Our courses also include step by step hands-on lab instructions and and solutions, clearly illustrated for users to complete hands-on work in class, and to revisit to review or refresh skills at any time. Students will also receive the project files (data sets or code, as applicable) and solutions required for the hands-on work.