Course Outline

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

Requirements

  • Familiarity with database management and database management systems

Audience

  • Beginners
  • Programmers
  • Database admins
  35 Hours
 

Number of participants


Starts

Ends


Dates are subject to availability and take place between 09:30 and 16:30.
Open Training Courses require 5+ participants.

Testimonials (11)

Related Courses

Related Categories