Posts

Showing posts from May, 2023

Introduction to SQL Server

Image
SQL Server Introduction  What is SQL Server Usage of SQL Server SQL Server Editions SQL Server Client Server Architecture SQL Server Architecture (Explained) SQL Server Tools SQL Server Services Database Management System DBMS -Services  Data Definition Data Manipulation Data Integrity Entity Relational Model (E-R Model) Entity Attributes Relationship among Data One to One One to Many Many to Many Database Models Types

Data A&E Essentials

 SQL Server Index/Topics: Introduction to SQL Server SQL Server Overview Structured Query Language (SQL) Databases Tables Create, Alter, Rename, Temp, Derieved) Data Types SQL Basic Commands  (DML, DDL, TCL, INSERT, TRUNCATE, PIVOT, MERGE, CASE, CTE) Constraints (PK, FK, CHECK, DEF, UNIQUE) Joins Subqueries Built in Functions Operators Decision Making Statements Views Indexes CLUSTERED, NON-CLUSTERED, FILTERED) Advanced SQL: Table Partitions Try Catch errors Views T-SQL Programming Stored Procedures Triggers User Defined Functions Cursors Advanced SQL Functions: Aggregate Functions String Functions Date functions system methods Ranking Functions Logical Functions Analytics functions Conversion functions Normalization Transactions (Optional) Locks (Optional) Rules and Defaults (Optional) Backup and Recovery Case Study Examples for Practice Interview Preparation tips and prac
Image
 SQL Server 2019 Installation How to Install SQL Server: Link below is to download the 2019 version of SQL Server. Click on the link below and download the .exe file as shown in the below snapshot. https://www.microsoft.com/en-us/evalcenter/download-sql-server-2019 Installation Steps to be followed to install the free version of SQL server  Follow My GitHub link to open the Installation Guide https://github.com/shaik-salman/DataEngineeringFeb2025Batch/blob/main/SQLServer2019Installation%20Guide.pdf