Welcome to the
MS SQL eAcademy
Welcome to the
MS SQL eAcademy
Welcome to the
MS SQL eAcademy
Master MS SQL Server Basics
Duration: 20 hours (10 sessions x 2 hours)
Master MS SQL Server Basics
Duration: 20 hours (10 sessions x 2 hours)
Master MS SQL Server Basics
Duration: 20 hours (10 sessions x 2 hours)
In this course, you will learn the basics of MS SQL Server: setup, database creation, queries, security, and backups
In this course, you will learn the basics of MS SQL Server: setup, database creation, queries, security, and backups
In this course, you will learn the basics of MS SQL Server: setup, database creation, queries, security, and backups
Power BI
UI & UX Design
Business Consulting
Data Scince
Interactive Reporting
SupTech
EnviTech
iMOF
IT Consulting
IBP
RegTech OST
EMS
Digital Transformation
You will get this
You will get this
You will get this
Backup & Restore
Backup & Restore
SQL Queries
SQL Queries
Table Design
Table Design
Database Management
Database Management
SYLLABUS
SYLLABUS
Meeting
Introduction to SQL Server (versions, basic concepts, installation, configuration, authentication, System Administrator activation)
Meeting
Introduction to SQL Server (versions, basic concepts, installation, configuration, authentication, System Administrator activation)
Meeting
Introduction to SQL Server (versions, basic concepts, installation, configuration, authentication, System Administrator activation)
Meeting
Database Creation (SQL Server Management Studio, database creation and configuration, table structures, table creation and modification)
Meeting
Database Creation (SQL Server Management Studio, database creation and configuration, table structures, table creation and modification)
Meeting
Database Creation (SQL Server Management Studio, database creation and configuration, table structures, table creation and modification)
Meeting
Table Design (SQL data types, table relationships, Primary and Foreign keys, constraints)
Meeting
Table Design (SQL data types, table relationships, Primary and Foreign keys, constraints)
Meeting
Table Design (SQL data types, table relationships, Primary and Foreign keys, constraints)
Meeting
Structured Query Language (SQL) (T-SQL, table creation, data manipulation: SELECT, WHERE, DELETE, UPDATE)
Meeting
Structured Query Language (SQL) (T-SQL, table creation, data manipulation: SELECT, WHERE, DELETE, UPDATE)
Meeting
Structured Query Language (SQL) (T-SQL, table creation, data manipulation: SELECT, WHERE, DELETE, UPDATE)
Meeting
Efficient Queries (Views, built-in functions, Stored procedures creation and parameterization)
Meeting
Efficient Queries (Views, built-in functions, Stored procedures creation and parameterization)
Meeting
Efficient Queries (Views, built-in functions, Stored procedures creation and parameterization)
Meeting
Backup and Restore (Full database backup creation, backup parameter configuration, database restoration)
Meeting
Backup and Restore (Full database backup creation, backup parameter configuration, database restoration)
Meeting
Backup and Restore (Full database backup creation, backup parameter configuration, database restoration)
Meeting
Security (User creation, role and permission assignment, database schema)
Meeting
Security (User creation, role and permission assignment, database schema)
Meeting
Security (User creation, role and permission assignment, database schema)
Meeting
Monitoring and Management (System database roles, TempDB auto-growth and size exceeding, SQL Server error log)
Meeting
Monitoring and Management (System database roles, TempDB auto-growth and size exceeding, SQL Server error log)
Meeting
Monitoring and Management (System database roles, TempDB auto-growth and size exceeding, SQL Server error log)
Meeting
Queries (Result limitation with TOP, duplicate removal with DISTINCT, comparison operators, NULL value handling, text search with LIKE and wildcards)
Meeting
Queries (Result limitation with TOP, duplicate removal with DISTINCT, comparison operators, NULL value handling, text search with LIKE and wildcards)
Meeting
Queries (Result limitation with TOP, duplicate removal with DISTINCT, comparison operators, NULL value handling, text search with LIKE and wildcards)
Meeting
Queries (Table joining and relationship establishment: Inner, Left, Right, Full Outer, and Cross joins)
Meeting
Queries (Table joining and relationship establishment: Inner, Left, Right, Full Outer, and Cross joins)
Meeting
Queries (Table joining and relationship establishment: Inner, Left, Right, Full Outer, and Cross joins)
REVIEWS
Our Customers Reviews
Cyntch has been an amazing investment partner for me. Their investment management services are easy to use.
@ Yury
I never realized how much money I was wasting on unnecessary expenses until I started using Cyntch.
@Aryan
Such a clean, beautiful template and so easy to customise. Would highly recommend.
@Arim
I accidentally stumbled upon Snitcher while looking for another tool but I am very glad I did!
@ Sam
Cyntch has been an amazing investment partner for me. Their investment management services are easy to use.
@ Yury
I never realized how much money I was wasting on unnecessary expenses until I started using Cyntch.
@Aryan
Such a clean, beautiful template and so easy to customise. Would highly recommend.
@Arim
I accidentally stumbled upon Snitcher while looking for another tool but I am very glad I did!
@ Sam
Cyntch has been an amazing investment partner for me. Their investment management services are easy to use.
@ Yury
I never realized how much money I was wasting on unnecessary expenses until I started using Cyntch.
@Aryan
Such a clean, beautiful template and so easy to customise. Would highly recommend.
@Arim
I accidentally stumbled upon Snitcher while looking for another tool but I am very glad I did!
@ Sam