SQL Development Bootcamp

• Familiarity with database management and database management systems

Audience

• Beginners
• Programmers
• Database admins

The SQL Development Bootcamp provides comprehensive lessons for SQL development. Topics covered include database design techniques, data manipulation, and simple and complex query methods.

This instructor-led, live training (online or onsite) is aimed at beginners, programmers, and database administrators who wish to learn or improve their SQL development skills and knowledge.

By the end of this training, participants will be able to install, create, manage, manipulate, and monitor databases using SQL and database management systems.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction to SQL Development Bootcamp

Overview of SQL Development

• Data and databases
• Database management systems (DBMS)
• SQL key concepts

Getting Started with SQL Databases

• Installing DBMS software
• Initial configuration
• Connecting existing databases
• Database development methodology

Exploring SQL Statement Fundamentals

• Data definition language statements
• Transaction control statements
• Session and system control statements
• Embedded SQL statements

Working with SQL Data

• Filtering data
• Comparison and logical operators
• Sorting data
• Row limiting clause
• Substitution variables
• Define and verify commands

Using Single Row, Group, Conversion, and General Functions

• Character functions
• Numeric and date functions
• Conversion functions
• Case and decode functions
• Distinct and null values
• Group by clauses
• Having clauses

Working with SQL Join Clauses

• Inner join
• Non-equijoin
• Outer join
• Cross join

Using Subqueries and SET Operators

• Single row subqueries
• Multi row and multi column subqueries
• SET operators
• Correlated subquery
• Data manipulation with subqueries

Creating Databases and Tables

• Data types
• Primary and foreign keys
• Constraints
• Table actions (create, insert, update, delete)
• Data dictionary views
• Conditional expressions

Working with Views, Sequences, Synonyms, and Indexes

• Creating and querying views
• Creating and modifying sequences
• Creating synonyms
• Creating indexes

Managing Schema Objects

• Constraints management
• Temporary tables
• External tables

Controlling User Access

• System privileges
• Object privileges
• Roles
• Revoking privileges

Managing Data in Different Time Zones

• Interval data types
• Time functions

Troubleshooting

Summary and Conclusion