SQL Certification Training Course in Jaipur - Digital Computer Classes

SQL Certification Training Course in Jaipur

Course Name – SQL Training Course

Duration – 1 Month

 

SQL Certification Training Course provides an exhaustive coverage of SQL Language.

 

Take Away – SQL Certification Training Course

 

  • Create database tables

  • Manage database objects

  • Access and manipulate data within the database using SQL statements

  • Control user access to data

  • Oracle 12c : SQL Certification exam readiness

 

Target Audience for SQL Certification Training Course

 

SQL Certification Training Course is effective for those that are, or are going to be , working with Oracle1xi. Experience with relational databases and familiarity with basic programming concepts are helpful. Computer Fundamentals and Windows operating system knowledge is a plus . Any programing language , DBMS like Dbase or FoxPro are preferred and Oracle xi SQL and PL/SQL

 

Prerequisites for SQL Certification Training Course

 

  • Computer Fundamentals,

  • Windows operating system

 

Objectives of SQL Certification Training Course

 

  • Outlining SQL because the cornerstone of database activity

  • Applying the ANSI/ISO standards

  • Describing the fundamental building blocks: tables, columns, primary keys and foreign keys

 

Recommended Next Course

 

  • Certification Exams

  • OCA

  • OCP

 

SQL Certification Training Course Contents

 

 

Building the Database Schema

 

 

Creating tables and columns

 

  • Building tables with CREATE TABLE

  • Modifying table structure with ALTER TABLE

  • Adding columns to an existing table

  • Removing tables with DROP TABLE

 

Protecting data integrity with constraints

 

  • Guaranteeing uniqueness with primary key constraints

  • Enforcing integrity with foreign key constraints

  • Imposing business rules with check constraints

  • Improving performance with indexes

  • Expediting data retrieval with indexes

  • Recommending guidelines for index creation

 

Manipulating Data

 

Modifying table contents

 

  • Adding table rows with INSERT

  • Changing row content with UPDATE

  • Removing rows with DELETE

 

Applying transactions

 

  • Controlling transactions with COMMIT and ROLLBACK

  • Deploying BEGIN TRANSACTION in SQL Server

 

Working with the SELECT Statement

 

Writing Single Table queries

 

  • Retrieving data with SELECT

  • Specifying column expressions

  • Sorting the result with ORDER BY

  • Handling NULL values in expressions

 

Restricting rows with the WHERE filter

 

  • Testing for equality or inequality

  • Applying wildcard characters

  • Avoiding NULL value pitfalls

 

Querying Multiple Tables

 

Applying the ANSI/ISO standard join syntax

 

  • Matching related rows with INNER JOIN

  • Including non matched rows with OUTER JOIN

  • Creating a cartesian product with CROSS JOIN

 

Combining results with set operators

 

  • Stacking results with UNION

  • Identifying matching rows with INTERSECT

  • Utilizing EXCEPT to seek out non matching rows

 

Employing Functions in Data Retrieval

 

Processing data with row functions

 

  • Conditional formatting with the CASE expression

  • Utilizing the CASE expression to simulate IF tests

  • Dealing with NULL values

 

Performing analysis with aggregate functions

 

  • Summarizing data using SUM, AVG and COUNT

  • Finding the highest/lowest values with MAX and MIN

  • Defining the summary level with GROUP BY

  • Applying filter conditions with HAVING

 

Constructing Nested Queries

 

Applying sub queries in filter conditions

 

  • Correlated vs. uncorrelated subqueries

  • Testing the existence of rows

 

Including subqueries in expressions

 

  • Placing subqueries within the column list

  • Creating complex expressions containing subqueries

  • Handling subqueries that return no rows

 

Developing In-Line and Stored Views

 

  • Breaking down complex problems

  • Selecting data from a query result set

  • Subqueries within the FROM clause

 

Creating views in a database

 

  • Building reusable code

  • Editable vs. non-updatable views