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
