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