This course provides a quick start to SQL language. It covers most of the topics required for a basic understanding of SQL and along with suitable examples.
Each student in our Live Online classes receives a comprehensive set of materials, including course notes and all the class examples.
- Batch size up to 1 to 3.
- Access to the trainer any time for any questions and follow-ups.
- Online in-person training.
- Every session is followed by practical assignments.
- Numerous assignments carefully designed on every topic by our professional trainers.
- Guidance from experienced and professional people in software industry.
- Assignments evaluation, feedbacks and encouragements to develop in better way.
- Focus on hands-on training by students during sessions.
Basic computer skills.
Duration: Min 20 hours of classroom training.
Min 25 assignments.
Introduction to DBMS
- What is Data and Database?
- Why electronics Database?
- Information about various Database engines in Market.
- Features of DBMS
- Introduction to Microsoft SQL Server
- Components of SQL Server
- Database Engine and Service
- Management Studio
- Overview of Relational Database Management System (RDBMS)
- Basic database structures Database, Tables, Columns, and Rows
- RDBMS Concepts- Entities, Attributes
- Basic Data Types
- Introduction to SQL
- Why SQL?
- Characteristics of SQL
- SQL concepts- DDL, DML and DCL
- Querying data using SELECT statement
- Renaming Column and table - Alias
- Sorting the Data - Order by
- TOP Clause
- Arithmetic operations on data - Concate
- Data manipulations using built in functions
- Date Functions
- Filtering the data - WHERE Clause
- Logical operators
- Logical expressions
- Data cleanup by handling NULLs
- Data lookup using CASE
- Data transformation using CAST and CONVERT
- Aggregate functions
- Elimination of duplicate records- DISTINCT
- Groups records into summary rows - Group By
- Filter data after aggregates – HAVING
- UNION ALL
- Entity Relationships, Cardinalities
- Inner Join
- Outer joins - Left, Right, Full
- Cross Join
- Normalized data model
- De-normalized data model
- Database constraints
- Nested Subquery
- Subquery in Case Statement
- Correlated Subquery
- Purpose of View
- Creating and using Database Views
- Limitation and best practices about views
- Using PIVOT to simplify a cross tab style
- Identifying Query performance issues
- Query performance tuning
- Creating and managing indexes
This SQL training is designed for students new to writing SQL queries. You will gain a deeper knowledge and understanding of the SQL and how to write it.