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


Summary and Conclusion


  • Familiarity with database management and database management systems


  • Beginners
  • Programmers
  • Database admins
  35 Hours


Related Courses

SQL in Microsoft Access

  14 hours

Microsoft Access - download the data

  14 hours

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours

SQL in SQL Server

  14 hours

Transact SQL Basic

  14 hours

Transact SQL Advanced

  7 hours

SQL Fundamentals

  14 hours

SQL Advanced in MySQL

  7 hours


  14 hours

ORACLE PL/SQL Fundamentals

  21 hours

ORACLE SQL Fundamentals

  14 hours

Oracle SQL Language

  14 hours

Oracle SQL for beginners

  21 hours

Oracle SQL Advanced

  14 hours

Developing Desktop Applications with Visual Studio 2012, VB.NET and SQL Server 2012

  21 hours