• logo
  • 9861600203
  • 5555545
  • info@mentorit.com.np
header-logo.png

Overview

SQL Fundamentals course overview

SQL plays a foundational role in Business Intelligence as it provides us with a way to extract data from databases for use in other BI tools. 

This course covers SQL’s foundational syntax and essential transformations with practical, hands-on examples. To do this, learners are provided with access to an Azure Data Studio data warehouse from which they can run the queries taught throughout this course. Connecting to the data warehouse is simple and can be from a Windows, iOS, or Linux computer.

This course will walk you through retrieving and filtering data from a database with basic SQL syntax, transforming that data with functions, combining data from multiple tables, best practices when using SQL and common mistakes. By the end of this course, you’ll have the core skills business analysts need to extract data from a database using SQL.

Upon completing this course, you will be able to:

  • Retrieve and filter data using basic SQL syntax

  • Transform data with the help of numerical, date, and text functions

  • Identify strategies for constructing an unbiased sample

  • Understand essential terminology related to SQL, databases, and data warehouses

Course Content

  • What is Data, Field, Record and database?
  • Limitations of File Management System.
  • Basic Concepts of Advantages of DBMS
  • Exploring Relational DBMS
  • Understanding Client and Server
  • Analyzing the Requirement
  • Identify Entities and their Relationships
  • Drawing E-R Diagram
  • Conversion of E.R. Diagrams into Tables
  • First Normal Form
  •  
  • Third Normal Form Practically Normalizing Tables
  • What is SQL Server Version history and different editions
  • Basic Features Components and Tools
  • Starting and Stopping SQL Server Instances / Services
  • Introduction to Management Studio
  • Types of System Databases in SQL
  • Basics of SQL Types of SQL Statements
  • DDL, DML, DQL, DCL and TCL
  • Create Database using Management Studio
  • Datatypes in SQL Server
  • Exploring DDL Statements on Table using Management Studio
  • Why write statements in Frontends?
  • Create, Alter and Drop Table Insert
  • Update and Delete Statement Truncate Statement
  • Understanding Select Statement
  • Usage of Top, Distinct, Null etc…keywords
  • Using String and Arithmetic Expressions
  • Exploring Where Clause with Operators
  • Using Advanced Operators
  • Sorting data using Order By clause
  • Working with basic of Sub Queries
  • Using functions in Queries
  • Count, Sum, Min, Max, Avg Group By and Having Clause
  • Using Group By with Rollup and Cube
  • Introduction to Joins Cross Joins
  • Inner Join
  • Outer Join
  • Self Join
  • Co-related Sub Queries
  • Set Operations using Unions, Intersect and Except
  • Unique
  • Not NULL
  • Primary Key
  • Default Check Foreign Key
  • Introduction & Advantages of Views
  • Creating, Altering, Dropping Views
  • Advance Options while Creating a View
  • SQL Server Catalogue Views
  • Creating Users & Roles
  • Granting & Revoking of Roles & privileges
  • Managing using Management Studiov
  • Introduction Clustered and Non Clustered Index
  • Creating and Dropping Indexes
  • What is T-SQL?
  • Using System Functions
  • Using Dynamic SQL
  • Introduction to stored procedures
  • Benefits of Stored Procedures
  • Creating, Executing Modifying, Dropping
  • Working with Temp tables
  • Error Handling

Instructors not Assigned

No reviews for this course


Write a Message

Security Check
2 + 2 =

    Course Features

  • Course Duration30 hrs