Categories
Entrepeneurship
Microsoft SQL Server Bootcamp 2023: Go from Zero to Hero
Course Curriculum
Microsoft SQL Server Bootcamp 2023: Go from Zero to Hero
Microsoft SQL Server Bootcamp 2023: Go from Zero to Hero
Microsoft SQL Server Bootcamp 2023: Go from Zero to Hero
-
Course Curriculum
-
How to get course requirements
-
Getting started on Windows, Linux or Docker
-
How to ask great questions
-
Introduction
-
FAQ
-
Source code file
Module 2
Module 2
Module 2
-
Section IntroductionÂ
-
Microsoft SQL Server Installation
-
SQL Server Management Studio (SSMS)
-
How to connect MS SQL
-
How to connect MS SQL
-
Download and Restore Sample Database
Module 3
Module 3
Module 3
-
Section Introduction
-
Overview of Databases
-
Creating Database
-
SQL Data Types
-
Column Data Types and SSMS
-
Creating Table
-
Overview of Primary Key and Foreign Key
-
Primary Key
-
Foreign Key
-
Creating Temporary tables
Module 4
Module 4
Module 4
-
Insert statements
-
Update statement
-
Section Introduction
-
Delete statement
Module 5
Module 5
Module 5
-
CREATE table statement
-
DROP statement
-
ALTER statement
-
Section Introduction
-
TRUNCATE statement
-
COMMENT in query
-
RENAME
Module 6
Module 6
Module 6
-
Create Database user
-
GRANT permissions
-
REVOKE permissions
Module 7
Module 7
Module 7
-
Section Introduction
-
SELECT Statament
-
SELECT DISTINCT
-
SQL Statement basic
-
SELECT with column headings
-
Column AS statement
Module 8
Module 8
Module 8
-
SELECT WHERE Clause – practical
-
SELECT WHERE Clause – theory
Module 9
Module 9
Module 9
-
Sum
-
Min – Max
Module 10
Module 10
Module 10
-
Order by statement
-
SELECT TOP clause in SQL
-
BETWEEN command
-
IN operator
-
Wildcard Characters and LIKE
Module 11
Module 11
-
Group by – theory
-
Group by – practical
-
HAVING statement
-
Section Introduction
Module 12
Module 12
-
Overview of Joins
-
Inner join
-
Left outer join
-
What are Joins
-
Right outer join
-
Full outer join
-
Union
-
Cross join
-
Query Exercise
-
Solution for Query Exercise
Module 13
Module 13
-
Section introduction
-
Check constarint
-
NOT NULL constarint
-
UNIQUE constraint
Module 14
Module 14
-
Reporting with multiple tables
-
Creating Views
Module 15
-
Section Introduction
-
Extract from timestamp
-
Timestamp
-
Mathematical scalar functions
-
String functions
-
Sub Query
-
SELECT with calculations
Module 16
-
Stored procedure with parameter
-
Create stored procedure
Module 17
-
Section Introduction
-
Import .csv or excel file
-
Import Flat File
-
Export Data to Excel or any format
Module 18
-
Creating Database backup
-
Restoring Database backup
-
Section Introduction
Student Ratings & Reviews
No Review Yet
£19.99
-
LevelIntermediate
-
Last UpdatedOctober 23, 2024
-
CertificateCertificate of completion
Hi, Welcome back!
£99.00
£39.99
£99.00