SQL Server

Students: 2 Views: 99

Instructor admin
Last Update 10 Apr, 2025
Reviews

The Course Curriculam

admin

9 Courses 3 Students

No Review Yet

Free

Free access this course

Course Information

Course level: Intermediate
Instructor: admin
Last Updated: Apr 10, 2025
tutor-icon-ribbon-o Certificate Certificate of completion
Quizze: 1

Share This Course

Module 1: Introduction to Databases and SQL Server
Lesson 1.1: File Management System and Its Drawbacks
Lesson 1.2: Introduction to DBMS
Lesson 1.3: Types of DBMS Systems
Lesson 1.4: Network DBMS (NDBMS)
Lesson 1.5: Hierarchical DBMS (HDBMS)
Lesson 1.6: Relational DBMS (RDBMS)
Module 2: Getting Started with SQL Server
Lesson 2.1: SQL Server Versions and History
Lesson 2.2: Connecting to Server
Lesson 2.3: Authentication Modes
Lesson 2.4: SQL Server Authentication Mode
Lesson 2.5: Windows Authentication Mode
Lesson 2.6: SQL Server Management Studio and Tools
Module 3: Database Design in SQL Server
Lesson 3.1: Database Creation using GUI
Lesson 3.2: Database Creation using T-SQL Scripts
Lesson 3.3: DB Design using Files and Filegroups
Lesson 3.4: Pages and Extents
Lesson 3.5: Data File and Log File Features
Module 4: Business Integrity Constraints
Lesson 4.1: Why Business Integrity
Lesson 4.2: Features of Business Integrity
Lesson 4.3: Null / Not Null
Lesson 4.4: Default Values
Lesson 4.5: Keys (Candidate, Primary, Unique/Alternate, Foreign)
Lesson 4.6: Check Constraints
Lesson 4.7: Identity
Module 5: SQL Server Data Types
Lesson 5.1: Unicode vs. Non-Unicode
Lesson 5.2: Character Data Types (Char, Varchar, etc.)
Lesson 5.3: Numerical and Currency Data Types
Lesson 5.4: Binary and GUID Data Types
Lesson 5.5: Timestamp, Bit, and Spatial Data Types
Module 6: SQL Basics and Queries
Lesson 6.1: Types of SQL Commands (DDL, DML, DCL, TCL)
Lesson 6.2: Writing Simple Queries
Lesson 6.3: WHERE and SELECT Clauses
Lesson 6.4: Sorting, Concatenation, and Constants
Lesson 6.5: Aggregations and GROUP BY
Lesson 6.6: HAVING Clause
Lesson 6.7: TOP (n), UNION, INTERSECT, EXCEPT
Lesson 6.8: ISNULL() Function
Lesson 6.9: JOINS (Inner, Outer, Self, Cross)
Lesson 6.10: Subqueries (Single Row, Nested, Correlated, EXISTS/NOT EXISTS)
Lesson 6.11: Derived Tables, CUBE, and ROLLUP
Module 7: SQL Server Built-in Functions
Lesson 7.1: String Functions
Lesson 7.2: Data Conversion Functions
Lesson 7.3: Date and Time Functions
Lesson 7.4: Aggregate Functions
Lesson 7.5: Ranking Functions
Lesson 7.6: Common Table Expressions (CTE)
Module 8: Indexing and Performance
Lesson 8.1: Heap vs. Indexes
Lesson 8.2: Clustered and Non-Clustered Indexes
Lesson 8.3: Filtered and Covered Indexes
Lesson 8.4: Create, Alter, and Drop Indexes
Lesson 8.5: Statistics
Lesson 8.6: Performance Tuning of Queries
Module 9: Views
Lesson 9.1: Purpose of Views
Lesson 9.2: Creating, Altering, Dropping Views
Lesson 9.3: Updatable vs. Non-Updatable Views
Lesson 9.4: Schema Binding, Encryption, Check Option
Lesson 9.5: Indexed Views
Module 10: T-SQL Programming
Lesson 10.1: Declaring Variables
Lesson 10.2: Local and Global Temp Tables
Lesson 10.3: IF...ELSE and WHILE Loop
Lesson 10.4: Return Statement
Lesson 10.5: Table Variables vs. Temp Tables
Lesson 10.6: TRY...CATCH for Exception Handling
Module 11: Stored Procedures
Lesson 11.1: Need for Stored Procedures
Lesson 11.2: Creating, Altering, Dropping SPs
Lesson 11.3: Parameters (Input/Output/Optional)
Lesson 11.4: Nested and Recompiled SPs
Lesson 11.5: Complex SPs and SPs with Cursors
Module 12: Cursors
Lesson 12.1: Need for Cursors
Lesson 12.2: Cursor Types (Forward Only, Scroll)
Lesson 12.3: Static, Dynamic, Keyset Cursors
Lesson 12.4: Cursor Visibility
Module 13: User Defined Functions (UDFs)
Lesson 13.1: Need for UDFs
Lesson 13.2: Creating, Altering, Dropping
Lesson 13.3: Scalar Functions
Lesson 13.4: Inline Table-Valued Functions
Lesson 13.5: Multi-Statement Table-Valued Functions
Module 14: Triggers
Lesson 14.1: Purpose and Need for Triggers
Lesson 14.2: Creating, Altering, Dropping Triggers
Lesson 14.3: Trigger Types (AFTER, INSTEAD OF)
Lesson 14.4: Magic Tables (Inserted, Deleted)
Lesson 14.5: ROLLBACK in Triggers
Module 15: Transactions
Lesson 15.1: Introduction to Transactions
Lesson 15.2: BEGIN, COMMIT, ROLLBACK
Lesson 15.3: SAVEPOINTS
Lesson 15.4: Log File Role in Transaction Management
Lesson 15.5: Implicit vs. Explicit Transactions
Module 16: Locks and Concurrency
Lesson 16.1: Introduction to Locking & Concurrency (can be expanded later)

Shopping cart

SQL Server

SQL Server

The Course Curriculam

admin

Quick Links

Programs

Shopping cart

SQL Server

SQL Server

The Course Curriculam

admin

FOLLOW US ON:

Quick Links

Programs

Get in touch!