SQL

SQL
Course duration:

45 hours | 1.5 months (Live online/classroom training+ Projects + assignment)

Training Mode:​

Online & Classroom

Course Fees:
  • Group training: INR 15000 USD 450 (Other countries)
  • Individual training INR 25000 | USD 650 (Other countries)
Pre-requisites for SQL Course:

Candidate must know basics of computer and internet. Knowledge of Microsoft Excel and Access or any other database would be an added advantage.

Certification:

At end of the course, we will issue a SQL training certificate.

Syllabus - program of study:

  • SQL Course overview
  • What is SQL?
  • Editors and Platforms to learn SQL
  • Quick-start introduction
  • Using the basic SELECT statement
  • Selecting rows and columns
  • Counting rows, Inserting data, Updating data, Deleting data
  • Databases and tables
  • SQL syntax overview
  • Creating and Deleting tables
  • Inserting rows into a table
  • Deleting rows from a table
  • What is NULL?
  • Controlling column behaviours with constraints
  • Changing a schema with ALTER
  • Creating a column with ID
  • Filtering data with WHERE, LIKE, and IN
  • Removing duplicates with SELECT DISTINCT
  • Sorting with ORDER BY
  • Understanding joins
  • Accessing related tables with JOIN
  • Multiple related tables
  • About SQL strings
  • Finding the length of a string
  • Selecting part of a string
  • Removing spaces with TRIM
  • Making strings uppercase and lowercase
  • Use of Dates and times
  • Date- and time-related functions
  • How aggregates work
  • Using aggregate functions
  • Aggregating DISTINCT values
  • Why use transactions?
  • Using transactions
  • Using Rollbacks
  • Updating a table with a trigger
  • Preventing automatic updates with a trigger
  • Automating timestamps with a trigger
  • Creating a simple subselect
  • Searching within a result set
  • Creating a view
  • Creating a joined view
  • Importing database using SQL
  • Exporting database using SQL

 

  • Learn about database models
  • Gain a thorough understanding of Transact-SQL language and SQL Server Management Studio
  • Learn how to write simple as well as complex queries for retrieving data from database
  • Learn how to retrieve data from tables
  • Master the calculation of information across result sets leveraging aggregate queries
  • Learn how to update, insert and delete data
  • Learn how to work with data types
  • Learn about Functions and Procedure and gain understanding on different Views
  • Learn how to work with Triggers and design a database
  • Learn how to create and manage views
  • Understand the concept of managing databases, tables as well as sequences with SQL statements
  • Learn how to manage binary data leveraging BLOBs
  • Learn how to ensure integrity related to multiple an related database updates

 

  • SQL Server database Overview
  • What is DDL, DML
  • Data Types
  • What are Constraints (Identity, Unique, Check, NULL, Default)
  • Operators and Aggregates
  • Where, Group by, Having, Distinct, Top
  • Date functions
  • Temp tables, Table Variables
  • Usage of While loop & if conditions
  • Case Statement
  • Ranking Functions, Scalar Functions
  • Exception handling, Transactions, Joins, Sub Queries
  • Views, CTE, Cursor, Stored Procedures
  • User Defined Functions (String, Table value: inline Functions and multi value)
  • Triggers