Duration
1 months
Mode
Online/Offline
Batch Size
10
Modules
1
LMS Access
Yes
Timing
Weekday/Weekends
Introduction
Many industries rely on relational databases to manage their data and make predictions. For example, a retail company may have a table for every customer, for every purchase made, and for every item in stock.
Through unique identifiers, such as a customer or item ID, multiple tables can relate to one another. With relational database management (RDMS) systems and SQL, those tables’ connections can help provide valuable insights. For example, which customers are purchasing the highest volume of a product? What time of year are certain products in demand?
SQL can be more intuitive and easier to learn than more complex data analytics languages. It is used in industries ranging from finance to music and can be a requested skill for roles that manage and interpret data.
Goal of Course
- Building Tables
- Designing Relational Schema
- Creating Indices
- Implementing views
- Ensuring data integrity
- Writing queries to fatch data
Key Modules
- MS Excel Formulas
- Data Summarization with Pivot
- MIS Reporting with MS Excel
- Understanding of VBA/Macro Programming
SQL Overview & Building Database
- Building the Database Schema
- Building tables with CREATE TABLE
- Modifying table structure with ALTER TABLE
- Adding columns to an existing table
- Removing tables with DROP TABLE
Protecting Data Integrity With Constraints
- Guaranteeing uniqueness with primary key constraints
- Enforcing integrity with foreign key constraints
- Imposing business rules with check constraints
- Enabling and disabling constraints
- Removing constraints with ALTER TABLE
Manipulating Data
- Modifying table contents , Adding table rows with INSERT
- Changing row content with UPDATE , Removing rows with DELETE
Writing Table Queries
- Retrieving data with SELECT
- Restricting rows with the WHERE filter
- Sorting the result with ORDER BY
- Handling NULL values in expressions
- Avoiding NULL value pitfalls in filter conditions
- Matching related rows with INNER JOIN
- Including nonmatched rows with OUTER JOIN
- Creating a Cartesian product with CROSS JOIN
- Stacking results with UNION
- Identifying matching rows with INTERSECT
- Utilizing EXCEPT to find nonmatching rows
- Processing data with row functions
- Conditional formatting with the CASE expression
- Utilizing the CASE expression to simulate IF tests
- Dealing with NULL values
- Performing analysis with aggregate functions
- Summarizing data using SUM, AVG and COUNT
- Finding the highest/lowest values with MAX and MIN
- Defining the summary level with GROUP BY
- Applying filter conditions with HAVING
- Constructing Nested Queries
- Applying subqueries in filter conditions
- Correlated vs. noncorrelated subqueries
Advanced MS SQL Server
- SQL Indexes
- SQL Views
- Transaction Management
- TSQL Programming
- SQL Function Programs
- Stored Sub Programs
- Triggers
- Exception Handling
- Backup & Restoration
- User Management
Note :you can speak to our team for detailed content and available batch timings.
