• Home
  • Jobs
  • Courses
  • Advice
  • Login
  • Register
  • Employer ?
    • Login
    • Register
    • Employer Services
Find Course Providers Courses Advice
  • Products
    • Find Course Providers
    • Courses Advice
  • Advertise Your Courses
    Advertise Your Courses for Free

    T-SQL Training Using Real World Scenarios:Tricks Of The Trade | Simpliv

    Course by Simpliv LLC

    (Course Id: 244820 | 131 Views) Posted 00 UNK
    Category:
    Education, Information Technology
    How the course is given:
    Online
    When the courses is given:
    Flexible
    Qualification Level:
    Short Course/Training Certification
    Course Duration:
    06:01:36
    Price:
    $ 9.99
    Location:
    Fremont, CA 

    Registration is Available at Anytime

    View Courses by this company

    Course Description

    Description

    This online T-SQL video training course on Microsoft SQL Server Technology includes a lot of real world scenario which i learnt in my professional work. I have covered the course contents with the real life situation example for every topic.

    Real Life situations are as follow

    • How to view the structure of a table 
    • How to create your own shortcuts in SSMS
    • Dropping multiple tables in one go having a fixed pattern
    • Guidelines while performing DML Operations
    • How to create Solution File in SSMS and what is the need for it
    • How to insert a row with old identity value which was deleted
    • How to reset table identity
    • How to delete duplicate records from a table
    • How to select only duplicate records from a table
    • How to produce Date Dimension using Recursive CTE Query
    • How to Merge New Changes to an Existing Table
    • What are the advantages of Stored Procedure
    • BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT
    • How to produce running totals or cumulative totals using sql server query
    • How to compare current year sales with the previous year sales 
    • How to compare current year sales since the start of the business year sales
    • How to switch between different SQL Servers within a query window in SSMS
    • How to use a single sql script file for different SQL Servers
    • Reducing Roundtrips using Table Valued Stored Procedure
    • Pagination in SQL Server using OFFSET-FETCH
    • BEGIN AND COMMIT TRANSACTION IS NOT SUFFICIENT
    • Relevance of Batch in SQL Server
    • How to create and store customized errors
    • Guidelines of writing a Stored Procedure

    Following are the major topics covered 

    • Deep dive into Window Functions
    • Ranking Functions - (Rank, Dense_Rank Row_Number, NTile )
    • Aggregate Functions - (Sum,Min,Max,Avg,Count)
    • Analytical Functions-(Lead , Lag, First_Value, Last_Value)
    • Stored Procedures
    • Input Parameters
    • Output Parameters
    • Default Parameters
    • Return
    • Table Valued Parameters
    • Common Table Expressions
    • Recursive Common Table Expressions
    • Synonyms
    • Identity Columns
    • Transactions
    • Raiserror/Throw
    • Error Handling (Try….Catch)

    Basic knowledge
    • Elementary knowledege of Transact SQL is needed like SSMS,Database Tables, Select , Join , Group By Commands ,Primary Key, Foreign Key

    What will you learn
    • Participant's knowledge will be deepened to handle real life situations in T-SQL
    • Please watch the course description to see more details
    ENROLL COURSE

    About the Provider

    Simpliv is a global online learning marketplace that transforms lives by offering online training on a wide variety of topics. Created with the aim of making education accessible to all, Simpliv removes barriers to education among all communities, imparts life skills to learners, and bridges gaps in learning through cost-effective courses. Simpliv believes that learning has no boundaries. It brings learning to any person who wants to learn, whether it is management, technology, life sciences,... Read More

    Course Provider Contact

    Simpliv LLC
     39658 Mission Boulevard, Fremont,
    CA 94539, USA.
      Phone: +510-849-6155
      Email: sudheer@simpliv.com
    Saved

    Related Courses

      Flexible Education Courses

      Flexible Information Technology Courses

      Education Short Course/Training Certification Courses

      Information Technology Short Course/Training Certification Courses

      Education Courses in California

      Information Technology Courses in California

      All Education Courses

      All Information Technology Courses

      Courses at Simpliv LLC

    About Us

    Ethiojobs.net is the first online recruitment solution provider introduced in Ethiopia. The website advertises jobs across a wide range of job types by different employers, including private, local, international, multinational, who are hiring in Ethiopia.

    Job -Seekers

    • Find Jobs
    • Register
    • Post CVs
    • Job Alerts

    Employers

    • Login
    • Register
    • Post Jobs
    • Services

    Contact us

    • Snap Plaza 8th floor, Bole Next to The Millennium hall. Addis Ababa, Ethiopia

    • +251-116-67-33-24
      +251-924 91 08 47
    • info@ethiojobs.net
    • About Us
    • Contact Us
    • FAQ's
    • Courses Terms & Conditions
    • Privacy Policy
    • Sitemap

    © 2021 Powered by Ethiojobs.net. All Rights Reserved.