It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life

Training on Learn Oracle SQL from Scratch - Step by Step Approach

This training is jointly organized by LEADS Technology Limited & BASIS Institute of Technology & Management(BITM)

 

This unique introductory SQL tutorial not only provides easy-to-understand Oracle SQL instructions, but it allows you to prepare for SQL Interviews and Oracle Certifications. This course bundles Basic + Intermediate + Advanced SQL + SQL Interview Questions + Oracle Certification Preparation.

 

 

Training will be held in LEADS Technology Limited premises.

FEE - Tk BDT 15000

Prerequisite

This Course is for beginners who don’t have any knowledge about SQL. I have taught the course in such a way that any non-technical person will understand easily all Database Concepts and SQL Commands.

Project Oriented Course

One will practically learn all mentioned tools and techniques by completing a project through this practical training course.

Course Outline

  • Querying
  • Introduction to T-SQL Querying
  • Executing Basic SELECT Statements, Executing queries which filter data using predicates, Executing queries which sort data using ORDER BY
  • Writing SELECT Queries
  • Write simple SELECT Statements, Eliminate Duplicates Using Distinct, Use Table and Column Aliases, Use a Simple CASE Expression
  • Querying Multiple Tables
  • Writing Queries That Use Inner Joins, Writing Queries That Use Multiple-Table Inner Join, Writing Queries That Use Self Joins, Writing Queries That Use Outer Loins, Writing Queries
  • That Use Cross Join
  • Sorting and Filtering Data
  • Writing Queries That Filter Data Using a WHERE Clause, Writing Queries That Filter Data Using an ORDER BY Clause, Writing Queries That Filter Data Using the TOP Option, Writing Queries.
  • Writing Queries That Return Date and Time Data, Writing Queries That Use Date and Time Functions, Writing Queries That Return Character Data, Writing Queries That Use Character Functions
  • Using Built-In Functions
  • Write queries which use conversion functions, Write queries which use logical functions, Write queries which test for nullability
  • Grouping and Aggregating Data
  • Write queries which use the GROUP BY clause, Write queries which use aggregate functions, Write queries which use distinct aggregate functions, Write queries which filter groups with the HAVING clause
  • Using Sub queries
  • Write queries which use self-contained sub queries, Write queries which use scalar and multiresult sub queries, Write queries which use correlated sub queries and EXISTS predicate
  • Using Table Expressions
  • Write Queries Which Use Views, Write Queries Which Use Derived Tables.
  • Using Set Operators
  • Write queries which use UNION set operators and UNION ALL multi-set operators, Write queries which use CROSS APPLY and OUTER APPLY operators, Write queries which use EXCEPT and INTERSECT operators
  • Pivoting and Grouping Sets
  • Write queries which use the PIVOT operator, Write queries which use the UNPIVOT operator, Write queries which use the GROUPING SETS subclause Views
  • Creating and Managing Views, Using Views, Using the View Designer
  • Programming with T-SQL
  • Declaring Variables and Delimiting Batches, Using Control-of-Flow Elements,Using Synonyms
  • Implementing Error Handling
  • Redirecting Errors with TRY / CATCH, Using THROW to Pass an Error Message Back to a Client
  • Implementing Transactions
  • Controlling transactions with BEGIN, COMMIT, and ROLLBACK, Adding error handling to a CATCH block

Used Tools

No learning tool Required

COURSE SUMMARY

Course Duration : 2 Month Days
Total Hour : 60 Hours
Number of Batch : 01 Batch

Application Last Date : 21 August, 2016

Class Schedule

Day & Time : Friday 6:00 pm - 9:00 pm
: Monday 6:00 pm - 9:00 pm
: Wednesday 6:00 pm - 9:00 pm
Duration : 3 Hours per class per class

Project:

Project based


Certificate:

Project name will be given on class.