Sql Course
Get Price Quote
Part 1: INTRODUCTION OF DBMS AND INSTALLATIONS PROCESS
Data, Databases and RDBMS Software’s
Advantages of SQL Server
Uses, Database Engine Many Component and OLTP Databases
BI Tool Components & Data Science Components
Uses of SQL, Real-time Usages, SQL versus Microsoft T-SQL [MSSQL]
Instance Name and Server Name, Features, Collation, Admin Users
Real-time Projects Included, Job Responsibilities; Versions and Editions of SQL Server
SQL Server and SSMS Installation, SQL Server - Career Options
SQL Server Pre-requisites: SQL Server 2019 / 2017/2014/2012 Installations
PART 2: BASICS SQL AND SSMS TOOL
SSMS, Different Connections (Local and Remote)
Sys Databases, Creating Objects with GUI
Insertions of data, Limit, Storage capacity
Sys Files, Commands with script, Select
Scanning and Retrieving of data(Basic Level)
PART 3: DATABASE CREATIONS AND COMANDS (DDL AND DML)
Creating DB, Entitles (Tables)
All about “SELECT”
Diff Data types in SQL, Select with simple and where conditions,
Different kinds of Operators OR, AND, IN, LIKE, NOT LIKE, Wild cards, IS, IS NOT OPERATORS, TOP AND DISTINCT keywords and Many more.
...more