MS SQL Server Tutorial for Beginners: Learn in 7 Days
- Details
Training Summary
SQL Server is a leading Relational Database Management System by Microsoft. This course teaches you basic to advance level concepts of SQL Server
What should I know?
The online guide is designed for beginners with little or no SQL Server experience. But knowledge of SQL is a plus
Course Syllabus
IntroductionTutorial | What is SQL Server? Introduction, History, Editions, Instances |
Tutorial | How to Download and Install SQL Server |
Tutorial | SQL Server Architecture Explained: Named Pipes, Optimizer, Buffer Manager |
Tutorial | SQL Server Management Studio (SSMS): What is, Install, Versions |
Tutorial | SQL Server Database: Create, Alter, Drop, Restore |
Tutorial | SQL Server DataTypes: Varchar, Numeric, Date Time [T-SQL Examples] |
Tutorial | SQL Server Variable: Declare, Set, Select, Global,Local [TSQL Examples] |
Tutorial | SQL Server Table: CREATE, ALTER, DROP [T-SQL Examples] |
Tutorial | SQL Server PRIMARY KEY: T-SQL Examples |
Tutorial | SQL Server FOREIGN KEY: T-SQL Examples |
Tutorial | SQL Server IF…ELSE Statement: T-SQL Example |
Tutorial | CASE statement in SQL Server: T-SQL Example |
Tutorial | SQL Server SUBSTRING() Function: T-SQL Example |
Tutorial | SQL SERVER JOINS Tutorial: INNER, LEFT, RIGHT , OUTER |
Tutorial | Create Login, User, assign Permission: SQL Server Tutorial |
Tutorial | Oracle Vs. SQL Server: Key Differences |
Tutorial | SSIS Tutorial for Beginners: What is, Architecture, Best Practices |
Tutorial | Top 40 SSIS Interview Questions and Answers |
Tutorial | SQL Server Reporting Services (SSRS) Tutorial for Beginners |
Tutorial | Top 20 SSRS Interview Questions & Answers |
Tutorial | SSAS Tutorial: Architecture, Cube, Types (Tabular vs Multidimensional) |
Tutorial | Top 50 SQL Server Interview Questions & Answers |
Tutorial | SQL Server Tutorial for Beginners PDF |