Courses Teach on USKILO 🛒 0 Login Sign Up

What you’ll learn

  • Use SQL to query a database
  • Use SQL to query a database
  • Be comfortable putting SQL and Microsoft SQL on their resume
  • Replicate real-world situations and query reports
  • Complete basic SELECT statements querying against a single table
  • Complete basic SELECT statements querying against a single table
  • Sort data using the ORDER BY clause
  • Understand the difference between the INNER JOIN, LEFT/RIGHT OUTER JOIN, and FULL OUTER JOIN
  • Import Flat, .CSV, Excel to SQL Database
  • Write SELECT on Query Calculations to get Discount and Non Discount Sales
  • Participate in Coding Exercise to test your learning skills
  • Get a job as a junior Database developer
  • Use SQL to perform data analysis
  • Learn to perform GROUP BY statements
  • Complete literal SELECT statements.
  • Filter data using the WHERE clause
  • Using joins, return columns from multiple tables in the same query
  • Complete SQL statements that use aggregate functions
  • Perform Secure Backup and Restore Full SQL Database task
  • learn what is Generative AI for future learning
  • Learn how to boost productivity and save time using AI-driven platforms

Course Content

Getting Started

Introduction ▶ Preview
Course Curriculum ▶ Preview
How to get course requirements ▶ Preview
Getting started on Windows, Linux or Docker ▶ Preview
How to ask great questions ▶ Preview
FAQ’s ▶ Preview
source code file 🔒

SQL Server setting up

Section Introduction 🔒
Microsoft SQL Server Installation ▶ Preview
SQL Server Management Studio (SSMS) Installation ▶ Preview
How to connect MS SQL (Windows Authentication) ▶ Preview
How to connect MS SQL (SQL Server Authentication) ▶ Preview
Download and Restore Sample Database 🔒

SQL Database basic

Section Introduction 🔒
Overview of Databases ▶ Preview
Creating Database ▶ Preview
SQL Data Types 🔒
Column Data Types on SSMS 🔒
Creating Table 🔒
Overview of Primary Key and Foreign Key 🔒
Primary Key 🔒
Foreign Key 🔒
Creating Temporary tables 🔒

SQL DML (Data Manipulation Language)

Section Introduction 🔒
Insert statement 🔒
Update statement 🔒
Delete statement 🔒

SQL DDL (Data Definition Language)

Section Introduction 🔒
CREATE table statement 🔒
CREATE table statement 🔒
DROP statement 🔒
ALTER statement 🔒
TRUNCATE statement 🔒
COMMENT in query 🔒
RENAME 🔒

SQL DCL (Data Control Language)

Create Database user 🔒
GRANT permissions 🔒
REVOKE permissions 🔒

SQL Statement Basic

Section Introduction 🔒
SQL Statement basic 🔒
SELECT Statement 🔒
SELECT DISTINCT 🔒
SELECT with column headings 🔒
Column AS statement 🔒

Filtering Data rows

SELECT WHERE Clause – theory 🔒
SELECT WHERE Clause – practical 🔒

Aggregate functions

Sum() 🔒
Min()-Max() 🔒

SQL Query statements

Order By statement 🔒
SELECT TOP clause in SQL 🔒
BETWEEN command 🔒
IN operator 🔒
Wildcard Characters and LIKE 🔒

SQL Group by statement

Section Introduction 🔒
Group by – theory 🔒
Group by – practical 🔒
HAVING statement 🔒

JOINS

Overview of Joins 🔒
What are Joins 🔒
Inner join 🔒
Left outer join 🔒
Right outer join 🔒
Full outer join 🔒
Union 🔒
Cross join 🔒
Query Exercise 🔒
Solution for Query Exercise 🔒

SQL Constraints

Section introduction 🔒
Check constraint 🔒
NOT NULL constraint 🔒
UNIQUE constraint 🔒

Views

Creating Views 🔒
Reporting with multiple tables 🔒

Advanced SQL commands

Section Introduction 🔒
Timestamp 🔒
Extract from timestamp 🔒
Mathematical scalar functions 🔒
String functions 🔒
Sub Query 🔒
SELECT with calculations 🔒

SQL Stored procedures

Create stored procedure 🔒
Stored procedure with parameter 🔒

Import & Export data

Section Introduction 🔒
Import Flat File 🔒
Import .csv or excel file 🔒
Export Data to Excel or any format 🔒

Backup and Restore Database

Section Introduction 🔒
Creating Database backup 🔒
Restoring Database backup 🔒

Requirements

  • No prior technical experience is required! All you need a computer!
  • No software is required in advance of the course (all software used in the course is free)
  • No pre-knowledge is required - you will learn from basic

Description

The "Microsoft SQL Server Bootcamp: Zero to Hero" is a comprehensive, hands-on course designed to take you from beginner to advanced in Microsoft SQL Server. Whether you're looking to master SQL for data analysis, application development, or database administration, this bootcamp covers all essential skills you need to become an expert.


Starting with the basics, you’ll learn how to install and configure Microsoft SQL Server and connect it to your development environment. You’ll explore key concepts such as databases, tables, and relationships, and learn how to create and manipulate SQL databases effectively. Through practical exercises, you’ll gain a deep understanding of data types, key indexes, and primary and foreign keys.

update: Learn the top AI tools every professional needs to boost productivity


As you progress, the bootcamp delves into more advanced topics, including writing complex SQL queries with JOINs, subqueries, and aggregate functions. You’ll master how to perform data analysis using GROUP BY and HAVING, as well as how to optimize queries for better performance.


The course also covers filter records for reporting services and teaches you how to implement security measures, such as user authentication. Learn about backups and restoration techniques to ensure your data is safe and recoverable.


By the end of this bootcamp, you’ll be proficient in Microsoft SQL Server, equipped with the skills to design, manage, and optimize databases for both development and business needs. Enroll today to become a Microsoft SQL Server hero!

Who this course is for

  • Beginner SQL, Database, Query and DBA admin - developers curious about SQL Database Career
  • Anyone who wants to start explore Data Science concepts
  • Anyone who works with data, tables, or databases!
  • Anyone who wants to become financially independent
  • Anyone who wants to start their own business or become freelance
  • Anyone who wants to become a Full stack web developer
  • If you work in: marketing, finance, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects information
  • Someone who wants to learn skills that give them the potential to earn near SIX figures!

Recommended Courses

Complete ASP.NET Core MVC 6 with Real-World Projects
₹519
Building Web Applications with Django and PostgreSQL
₹796
Mastering Full Stack Development : From Frontend to Backend
₹599
Excel with AI From Zero to Hero in Data Skills
₹499
₹496
₹2,989 83% off

This course includes:

  • 🎥 5+ hours on-demand video
  • 📱 Access on mobile and desktop
  • ♾ Full lifetime access
  • 🧠 Practical sessions
  • 📜 Certificate of completion