Hope Tutors leading training provider in SQL server.Our SQL server training institute will focus on examples from real world.

Microsoft SQL Server Training in Chennai

Hope Tutors SQL server training course is conducted by professionals with 8+ years of experience. We provide 100% real-time Microsoft SQL Server Training with assured placement.

Best Online Microsoft SQL Server Training

Online training has become an easy mode to learn by sitting in your location. Hope Tutors is well equipped with Trainers and Technology to provide best online Microsoft SQL Server training to you.

Microsoft SQL Server Training Course Certification

  • We will give you SQL Server Training certificate under the name of Hope Tutors.

 

Reach us today through call / email / chat to know more about our SQL Server Training. Hope Tutors wishes you good luck for your career growth.

Course Curriculum

Review of Basic SQL and history of SQL:
• Introduction 00:00:00
• History of SQL 00:00:00
• Evolution of SQL 00:00:00
• Select 00:00:00
• Project 00:00:00
• Join 00:00:00
• Describing Oracle tables 00:00:00
• Restricting row returns 00:00:00
• Where clause 00:00:00
• Complex Boolean logic in SQL 00:00:00
• ROWID restrictions 00:00:00
Entity/relation modeling
Types of data relationships 00:00:00
Data normalization 00:00:00
One-to-one relationships 00:00:00
One-to-many relationships 00:00:00
Many-to-many relationships 00:00:00
Recursive many-to-many relationships 00:00:00
Optimizing Oracle SQL
Steps in SQL optimization Parsing a SQL statement 00:00:00
First_rows vs all_rows optimization Oracle optimizer overview 00:00:00
Management issues with system-wide optimization Different modes of SQL optimization 00:00:00
Bi-modal databases Rule-based optimization Cost-based optimization All rows optimization First_rows optimization 00:00:00
• SQL Semantic Analysis 00:00:00
• Generating the execution plan 00:00:00
• Using optimizer plan stability 00:00:00
• Using the v$sql view 00:00:00
• Using the v$sql_plan view 00:00:00
• Using SQL*Plus 00:00:00
• Creating basic reports 00:00:00
• Using the set commands 00:00:00
• Adjusting line output 00:00:00
• Setting pagesize and linesize 00:00:00
• Echo 00:00:00
• Feedback 00:00:00
• Feedback 00:00:00
• termout 00:00:00
• Column wrapping 00:00:00
• Creating breaks and summaries 00:00:00
• Adding prompts to queries 00:00:00
Explain plan and reading execution plans
Explain plan 00:00:00
Oracle autotrace 00:00:00
How to read an execution plan 00:00:00
Altering SQL execution plans
Using hints 00:00:00
Table joining internals
• Sort-merge joins 00:00:00
• Nested Loop joins 00:00:00
• Hash joins 00:00:00
• STAR joins 00:00:00
• Bitmap joins 00:00:00
• Equi-join 00:00:00
• Outer join 00:00:00
• Hiding joins by creating views 00:00:00
Subqueries
• Using IN, NOT IN, EXISTS and NOT EXISTS 00:00:00
• Subqueries 00:00:00
• Correlated subquery 00:00:00
• Non-correlated subqueries 00:00:00
Advanced SQL operators
Between operator 00:00:00
IN and NOT In operators 00:00:00
Sub-queries 00:00:00
EXISTS clause 00:00:00
Using wildcards in queries (LIKE operator) 00:00:00
SQL access methods
Review of Basic joining methods 00:00:00
Merge join 00:00:00
Hash Join 00:00:00
Nested Loop join 00:00:00
Advanced SQL operators 00:00:00
Between operator 00:00:00
SQL Tuning
DML and SQL Tuning
Writing and optimizing INSERT statements 00:00:00
Writing and optimizing DELETE statements 00:00:00
• Writing and optimizing DELETE statements 00:00:00
Optimizer Statistics
Purpose of statistics 00:00:00
Types of statistics (table, column, system) Histogram statistics 00:00:00
Dynamic sampling using dbms_stats 00:00:00
Exporting/importing statistics 00:00:00
Statistics management 00:00:00
SQL Tuning and full-table scans
Basics of file I/O 00:00:00
Sequential reads vs. scattered reads 00:00:00
When full scans are best 00:00:00
RAM caching in the SGA Automating table caching 00:00:00
Solid State Disks 00:00:00
Aggregation in SQL
Count(*) 00:00:00
Sum 00:00:00
Avg 00:00:00
Min and max 00:00:00
Using the group by clause 00:00:00
PL/SQL Section
Basics of PL/SQL
PL/SQL architecture 00:00:00
PL/SQL and SQL*Plus 00:00:00
PL/SQL Basics 00:00:00
Introduction to PL/SQL 00:00:00
PL/SQL as a 4th generation language 00:00:00
Compiling vs. Interpreting 00:00:00
Declare statement 00:00:00
Using PL/SQL Variables 00:00:00
PL/SQL Constants 00:00:00
PL/SQL Datatypes 00:00:00
PL/SQL structures
Simple blocks 00:00:00
Control structures 00:00:00
PL/SQL records 00:00:00
Recognizing the Basic PL/SQL Block and Its Sections 00:00:00
Describing the Significance of Variables in PL/SQL 00:00:00
Distinguishing Between PL/SQL and Non-PL/SQL Variables 00:00:00
Declaring Variables and Constants 00:00:00
Executing a PL/SQL Block 00:00:00
Error checking – exception handling
Defining exceptions 00:00:00
Using the when others clause 00:00:00
Ensuring complete error checking 00:00:00
Passing error messages to calling routine 00:00:00
Boolean logic in PL/SQL
• Identifying the Uses and Types of Control Structures 00:00:00
• Constructing an IF Statement 00:00:00
• Constructing and Identifying Different Loop Statements 00:00:00
• Controlling Block Flow Using Nested Loops and Labels 00:00:00
• Using Logic Tables 00:00:00
• If-then-else structure 00:00:00
• Testing for numbers characters and Booleans 00:00:00
Cursors in PL/SQL
Cursor basics 00:00:00
Using a cursor for a multi-row SQL query 00:00:00
Iteration in PL/SQL
For loop 00:00:00
While loop 00:00:00
PL/SQL tables
Defining PL/SQL tables 00:00:00
Reasons to use PL/SQL tables 00:00:00
Populating a PL/SQL table 00:00:00
Retrieving from a PL/SQL table 00:00:00
Dynamic SQL in PL/SQL
Introduction to the dbms_sql package 00:00:00
Creating a dynamic SQL statement 00:00:00
Nested blocks in PL/SQL
Creating nested blocks 00:00:00
Understanding scope in nested blocks 00:00:00
Triggers in PL/SQL
Triggers and database events 00:00:00
Defining a trigger 00:00:00
Timing a trigger 00:00:00
Enabling and disabling a trigger 00:00:00
Stored procedures, functions and packages
• Basics of stored procedures 00:00:00
• Basics of functions 00:00:00
• Basics of packages 00:00:00
• Defining stored procedures & functions 00:00:00
• Function and stored procedures prototypes 00:00:00
• Passing arguments to functions and stored procedures 00:00:00
• Package forward declaration 00:00:00
• Package dependency 00:00:00
• Package overloading 00:00:00
• Listing package information 00:00:00
• Recompiling functions and stored procedures 00:00:00
• Pinning packages in the SGA with dbms_shared_pool.keep 00:00:00
Bulking in PL/SQL
Bulk queries 00:00:00
Bulk DML (forall statement) 00:00:00
Using cursor attributes 00:00:00

Course Reviews

4

130 ratings
  • 5 stars0
  • 4 stars1
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Excellent Institute

    Excellent Training institute.Trainer name is Deepan who is having more than 8 years of experience in IT industry.Hope Tutors having excellent syllabus in hand which will provide depth knowledge in SQL server.

PRIVATE COURSE
  • PRIVATE
  • 1 day, 6 hours
  • Course Certificate
  • Average Rating4
166 STUDENTS ENROLLED


    Google Reviews

    veera ragavan
    veera ragavan
    10:19 16 Aug 17
    I can learn many things on this tutorial. I have a good teacher on this tutorial. Good to teach and interviews training well good tutorial. I am sure this is better than ever
    Parthiban Gandhi
    Parthiban Gandhi
    06:14 15 Sep 17
    Apt place for your BP training. More hands on experience which helps you to learn quickly and you make mistakes for good and learn from it. the trainer is well experienced and ready to help and clarify. thanks.
    Darwin C
    Darwin C
    01:47 11 Sep 17
    In my opinion this institute is marvellous place to study with there so supportive staff faculty who boost every student to give there own best by being a friend of every student . Infrastructure might be ok. But overall its amazing place for our development of skills and preparing ourselves for future
    sabari sab
    sabari sab
    06:57 28 Jul 17
    Everything is good.I have learned the blue prism from the scratch. Trainer is having good experience in blue prism.He is very calm in explaining the concepts.I have automated applications in training itself. I am fresher and Initially i am having some fear to learn blue prism.Now i am going to work in this Blue prism in my company.
    guru prasath
    guru prasath
    03:50 04 Sep 17
    Good place to learn the basics of blue prism, tutor was kind enough to clear the queries regarding subjects. Could have been better if more practical sessions are available to practice as they have only few machines with blue prism.
    See All Reviews
    © 2017 Hope Tutors. All rights reserved.