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