Logo
Post
Image
Leslie Alexander Sr. Instructor
Category :

Microsoft Advanced Excel

20 Reviews:

Overview

XL Technologies is a company specializing in corporate training for Advanced Microsoft Excel and Microsoft Office Professional. Our team comprises skilled trainers with over five years of experience in corporate training. Our tailored training program is designed to elevate your abilities in creating accurate and efficient reports through the utilization of intricate formulas, charts, and graphs. This course will significantly enhance your productivity and contribute to your professional distinction.

Benefits of the Course

"Dive into the realm of data management and unlock your potential with XL Technologies, Okhla, New Delhi's foremost software and IT training provider. Our SQL Server course is meticulously designed to equip professionals with the skills needed for seamless database management. Immerse yourself in hands-on training, gaining proficiency in SQL Server, database design, and optimization. As the leading choice for software and IT training, XL Technologies offers a curriculum led by industry experts, ensuring alignment with current market demands. Elevate your career with in-depth knowledge of SQL Server, positioning yourself as a valuable asset in the competitive IT landscape. Join XL Technologies, where innovation meets expertise, and chart a successful career path in database management."

What you'll learn

  • How It works
  • Database & Tables
  • Primary Key & Foreign Key
  • All Joins
  • Clauses & Store Procedure

Topics for this Course

  • icon 8 Module
  • icon 21 Live class
  • icon 55 Assignment
  • icon 8 Test Project

  • icon Lecture 1.1 Creating Database
  • icon Lecture 1.2 Rename /Alter Database
  • icon Lecture 1.3 Selecting the correct Database before making table

  • icon Lecture 1.1 Creating table
  • icon Lecture 1.2 Insert Data into Table
  • icon Lecture 1.3 View Your Table
  • icon Lecture 1.4 Update Data in Table
  • icon Lecture 1.5 View Your Table with Criteria
  • icon Lecture 1.6 View Your Table with Particular Column
  • icon Lecture 1.8 Creating table
  • icon Lecture 1.9 Insert Data into Table
  • icon Lecture 1.10 View Your Table
  • icon Lecture 1.12Update Data in Table
  • icon Lecture 1.13View Your Table with Criteria
  • icon Lecture 1.14View Your Table with Particular Column
  • icon Lecture 1.15Count Value in a Particular Column

  • icon Lecture 1.1 Relationship between Primary Key & Foreign Key

  • icon Lecture 1.1 Inner Join
  • icon Lecture 1.2 Left Join
  • icon Lecture 1.3 Right Join
  • icon Lecture 1.4 Full Join
  • icon Lecture 1.5 Joins with Particular Columns
  • icon Lecture 1.6 Inner Join with Three Tables

  • icon Lecture 1.1 Union
  • icon Lecture 1.2 Group By
  • icon Lecture 1.3 Showing Columns with different Names (as)
  • icon Lecture 1.4 Having
  • icon Lecture 1.5 Adding a default constraint
  • icon Lecture 1.6 Drop (Delete) any constraint
  • icon Lecture 1.7Cascading Referential Integrity
  • icon Lecture 1.8 Adding a Check Constraint
  • icon Lecture 1.9 Between Statement in SQL
  • icon Lecture 1.10 In / Not in Statement in SQL
  • icon Lecture 1.11Like / Not Like Statement in SQL

  • icon Lecture 1.1 Drop Store Procedure
  • icon Lecture 1.2 Find Text of a Store Procedure
  • icon Lecture 1.3 Find Dependent Tables of a Store Procedure
  • icon Lecture 1.4 Create Store Procedure with input parameters
  • icon Lecture 1.5 Run a SP

  • icon Lecture 1.1 Concatenate in SQL
  • icon Lecture 1.2 Lower Case
  • icon Lecture 1.3 Remove Right Side Space
  • icon Lecture 1.4 Remove Left Side Space
  • icon Lecture 1.5 Count Text
  • icon Lecture 1.6 Extract First Name
  • icon Lecture 1.7 Extract Last Name

  • icon Lecture 1.1 Date Function
  • icon Lecture 1.2 Time Function
thumb

Cameron Williamson

Visitsite: Itech-themes

Self-reflection requires courage and patience. Teaching students to be self- them a skill that will help them throughout their lives.

Student Feedback

4.5

Total 3 Student Ratings

  • 52 Rating
  • 52 Rating
  • 52 Rating
  • 52 Rating
  • 52 Rating
playicon

Course Pricing

$65.00$90.00

Course Features

  • Lectures 55
  • Assignment 55
  • Duration 44 Hrs
  • Skill level All levels
  • Language English/Hindi
  • Students 10000
  • Assessments Yes