Microsoft SQL Course

Princeton X

Reed Courses Certificate of Completion

Digital certificate - Included

• Section 1 24:15

  • 1: 1a Introduction 03:28
  • 2: 1b Course Curriculum 06:55
  • 3: 1c How to get course requirements 01:41
  • 4: 1d Getting started on Windows, Linux or Docker 00:57
  • 5: 1e How to ask great questions 01:19
  • 6: 1f FAQ’s 01:08
  • 7: 1g source code file 08:47

• Section 2 43:03

  • 8: 2a Section Introduction 01:42
  • 9: 2b Microsoft SQL Server Installation 18:34
  • 10: 2c SQL Server Management Studio (SSMS) Installation 08:28
  • 11: 2d How to connect MS SQL (Windows Authentication) 03:40
  • 12: 2e How to connect MS SQL (SQL Server Authentication) 03:13
  • 13: 2f Download and Restore Sample Database 07:26

• Section 3 42:50

  • 14: 3c Creating Database 04:54
  • 15: 3d SQL Data Types 03:23
  • 16: 3e Column Data Types on SSMS 03:55
  • 17: 3f Creating Table 09:09
  • 18: 3g Overview of Primary Key and Foreign Key 04:04
  • 19: 3h Primary Key 04:05
  • 20: 3i Foreign Key 06:51
  • 21: 3j Creating Temporary tables 06:29

• Section 4 17:31

  • 22: 4a Section Introduction 00:48
  • 23: 4b Insert statement 08:25
  • 24: 4c Update statement 05:06
  • 25: 4d Delete statement 03:12

• Section 5 18:08

  • 26: 5a Section Introduction 00:54
  • 27: 5b CREATE table statement 02:58
  • 28: 5c DROP statement 02:10
  • 29: 5d ALTER statement 05:27
  • 30: 5e TRUNCATE statement 04:04
  • 31: 5f COMMENT in query 00:54
  • 32: 5g RENAME 01:41

• Section 6 14:13

  • 33: 6a Create Database user 03:54
  • 34: 6b GRANT permissions 06:09
  • 35: 6c REVOKE permissions 04:10

• Section 7 19:15

  • 36: 7a Section Introduction 01:13
  • 37: 7b SQL Statement basic 03:18
  • 38: 7c SELECT Statement 07:23
  • 39: 7d SELECT DISTINCT 02:42
  • 40: 7e SELECT with column headings 02:34
  • 41: 7f Column AS statement 02:05

• Section 8 10:55

  • 42: 8a SELECT WHERE Clause – theory 03:40
  • 43: 8b SELECT WHERE Clause – practical 07:15

• Section 9 13:47

  • 44: 9a Sum() 08:00
  • 45: 9b Min()-Max() 05:47

• Section 10 26:35

  • 46: 10a Order By statement 05:25
  • 47: 10b SELECT TOP clause in SQL 04:05
  • 48: 10c BETWEEN command 08:08
  • 49: 10d IN operator 04:04
  • 50: 10e Wildcard Characters and LIKE 04:53

• Section 11 13:21

  • 51: 11a Section Introduction 01:10
  • 52: 11b Group by – theory 03:11
  • 53: 11c Group by – practical 05:28
  • 54: 11d HAVING statement 03:32

• Section 12 26:43

  • 55: 12f Full outer join 01:21
  • 56: 12g Union 02:46
  • 57: 12h Cross join 03:10
  • 58: 12i Query Exercise 01:05
  • 59: 12j Solution for Query Exercise 01:08
  • 60: 12a Overview of Joins 01:56
  • 61: 12b What are Joins 02:15
  • 62: 12c Inner join 07:55
  • 63: 12d Left outer join 02:49
  • 64: 12e Right outer join 02:18

• Section 13 21:18

  • 65: 13a Section introduction 00:54
  • 66: 13b Check constraint 06:54
  • 67: 13c NOT NULL constraint 08:28
  • 68: 13d UNIQUE constraint 05:02

• Section 14 07:03

  • 69: 14a Creating Views 03:58
  • 70: 14b Reporting with multiple tables 03:05

• Section 15 26:40

  • 71: 15a Section Introduction 00:51
  • 72: 15b Timestamp 04:26
  • 73: 15c Extract from timestamp 03:11
  • 74: 15d Mathematical scalar functions 03:50
  • 75: 15e String functions 04:55
  • 76: 15f Sub Query 03:09
  • 77: 15g SELECT with calculations 06:18

• Section 16 09:05

  • 78: 16a Create stored procedure 04:36
  • 79: 16b Stored procedure with parameter 04:29

• Section 17 14:58

  • 80: 17a Section Introduction 01:07
  • 81: 17b Import Flat File 05:03
  • 82: 17c Import .csv or excel file 02:40
  • 83: 17d Export Data to Excel or any format 06:08

• Section 18 08:24

  • 84: 18a Section Introduction 00:59
  • 85: 18b Creating Database backup 03:51
  • 86: 18c Restoring Database backup 03:34

Mastering Microsoft SQL: From Beginner to Advanced

#### Module 1: Introduction to Relational Databases and SQL
- Overview of relational databases and SQL
- Understanding the importance of SQL in database management
- Setting up SQL Server and Management Studio

#### Module 2: SQL Basics
- Introduction to SQL syntax and structure
- Retrieving data with SELECT statements
- Filtering data with a WHERE clause
- Sorting data with ORDER BY clause

#### Module 3: Working with Tables
- Creating and modifying tables with CREATE TABLE and ALTER TABLE statements
- Understanding data types and constraints
- Inserting, updating, and deleting data with INSERT, UPDATE, and DELETE statements

#### Module 4: Querying Data with SQL
- Retrieving data from multiple tables with joins
- Grouping and aggregating data with GROUP BY and aggregate functions
- Filtering grouped data with a HAVING clause
- Subqueries and derived tables for complex data retrieval

#### Module 5: Manipulating Data
- Advanced data manipulation techniques with Common Table Expressions (CTEs)
- Using Window Functions for advanced data analysis
- Performing set operations with UNION, INTERSECT, and EXCEPT
- Using MERGE statement for data synchronization

#### Module 6: Stored Procedures and Functions
- Creating and executing stored procedures
- Passing parameters to stored procedures
- Creating user-defined functions for custom logic

#### Module 7: Triggers and Transactions
- Understanding triggers and their usage
- Creating and managing triggers for data integrity
- Working with transactions to ensure data consistency

#### Module 8: Advanced SQL Topics
- Working with XML and JSON data
- Implementing error handling and transactions
- Understanding query optimization techniques
- Introduction to indexing for performance tuning

#### Module 9: Security and Permissions
- Managing security and permissions in SQL Server
- Granting and revoking permissions on objects
- Securing sensitive data with encryption and masking

#### Module 10: Integration Services (SSIS) Basics
- Introduction to SQL Server Integration Services (SSIS)
- Creating and managing SSIS packages for data integration
- Performing ETL (Extract, Transform, Load) operations with SSIS

#### Module 11: Reporting Services (SSRS) Basics
- Introduction to SQL Server Reporting Services (SSRS)
- Creating and deploying reports with SSRS
- Customizing report layouts and formatting options

#### Module 12: Analysis Services (SSAS) Basics
- Introduction to SQL Server Analysis Services (SSAS)
- Building and deploying multidimensional and tabular models
- Performing data analysis with SSAS cubes and data mining

#### Module 13: Final Project and Review
- Applying learned concepts to a final project
- Reviewing key topics covered in the course
- Setting goals for further exploration and mastery

- Video Tutorials: Step-by-step video tutorials for each module.
- Hands-on Exercises: Practical exercises to reinforce learning.
- Quizzes and Assessments: Assessments to test understanding and retention of course material.
- Supplementary Resources: Additional reading materials, cheat sheets, and reference guides.
- Community Support: Access to a community forum for asking questions and sharing insights with fellow learners.

No prior knowledge or experience required

Currently there are no Q&As for this course. Be the first to ask a question.