SQL Programming with Microsoft SQL Server

Uplatz offers complete course on SQL Programming with Microsoft SQL Server. This is video-based online course (self-paced training). You will be awarded Course Completion Certificate at the end of the course.

SQL Programming with Microsoft SQL Server involves working with the Microsoft SQL Server database management system using the SQL language. Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft, and it is widely used for managing and querying relational databases.

Here's a description of SQL Programming with Microsoft SQL Server:

1. Database Management

   • SQL Server enables users to create, modify, and manage relational databases. It provides tools for creating and maintaining database structures, including tables, indexes, views, and stored procedures.

2. Transact-SQL (T-SQL)

   • Microsoft SQL Server uses Transact-SQL (T-SQL), an extension of SQL, as its programming language. T-SQL includes additional features such as procedural programming constructs, local variables, and error handling, making it a powerful language for database programming.

3. Stored Procedures and Functions

   • SQL Server supports the creation of stored procedures and user-defined functions. These database objects allow developers to encapsulate SQL logic on the server, improving code reusability, security, and performance.

4. Triggers

   • Triggers in SQL Server are special types of stored procedures that automatically execute in response to certain events, such as data modifications. Triggers are useful for enforcing business rules and maintaining data integrity.

5. Views

   • Views provide a way to present a subset of data from one or more tables in a structured manner. They can simplify complex queries and restrict access to sensitive information.

6. Indexing and Query Optimization

   • SQL Server includes features for optimizing query performance, such as the ability to create indexes on tables. Proper indexing can significantly enhance the speed of data retrieval.

7. Security Features [this topic is not in scope of this course]

   • SQL Server provides robust security features, including user authentication, role-based access control, and encryption. Database administrators can define permissions at various levels to control access to data and database objects.

8. Integration Services (SSIS) [this topic is not in scope of this course]

   • SQL Server Integration Services (SSIS) is a part of the SQL Server suite that enables the creation of data integration and workflow solutions. It is used for tasks such as ETL (Extract, Transform, Load) processes.

9. Reporting and Analysis Services (SSRS and SSAS) [this topic is not in scope of this course]

   • SQL Server Reporting Services (SSRS) allows the creation, management, and delivery of reports, while SQL Server Analysis Services (SSAS) provides online analytical processing (OLAP) and data mining functionality.

10. Database Maintenance and Monitoring [this topic is not in scope of this course]

    • SQL Server offers tools for database administrators to perform routine maintenance tasks, monitor performance, and troubleshoot issues. This includes features like SQL Server Management Studio (SSMS) and dynamic management views.

SQL Programming with Microsoft SQL Server involves leveraging these features and tools to design, implement, and maintain database solutions that meet the needs of applications and businesses. It is an essential skill for developers, database administrators, and other professionals working with SQL Server databases.

Reed courses certificate of completion

Digital certificate - Included

Uplatz Certificate of Completion

Digital certificate - Included

• SQL Programming with Microsoft SQL Server - all lectures 54:44:11

  • 1: Part 1 - Introduction to MS SQL Server 1:10:58
  • 2: Part 2 - Introduction to MS SQL Server 18:18
  • 3: Part 3 - Introduction to MS SQL Server 52:34
  • 4: Part 1 - Select and Where 56:53
  • 5: Part 2 - Select and Where 04:45
  • 6: Part 3 - Select and Where 1:04:46
  • 7: Part 1 - SQL Sub Languages - Order By Clauses 1:05:10
  • 8: Part 2 - SQL Sub Languages - Order By Clauses 1:00:17
  • 9: Part 1 - Any - All - Select Into - Insert Into - Case 1:02:19
  • 10: Part 2 - Any - All - Select Into - Insert Into - Case 1:02:33
  • 11: Part 1 - Delete - Top - Aggregate Functions - Wild Cards 53:32
  • 12: Part 2 - Delete - Top - Aggregate Functions - Wild Cards Preview 1:02:23
  • 13: Part 1 - Insert - Update - Is Null Commands 1:08:20
  • 14: Part 2 - Insert - Update - Is Null Commands 29:10
  • 15: Part 3 - Insert - Update - Is Null Commands 42:03
  • 16: Part 1 - In - Between - Table Alias 45:02
  • 17: Part 2 - In - Between - Table Alias 45:47
  • 18: Part 1 - SQL Comments - SQL Operators 34:34
  • 19: Part 2 - SQL Comments - SQL Operators 51:22
  • 20: Part 1 - Joins Preview 1:04:02
  • 21: Part 2 - Joins Preview 1:03:10
  • 22: Part 1 - Union All - Union - Group By - Having - Exists - Not Exists 1:02:02
  • 23: Part 2 - Union All - Union - Group By - Having - Exists - Not Exists 1:08:16
  • 24: Part 1 - Null Functions - Transact SQL 1:02:03
  • 25: Part 2 - Null Functions - Transact SQL 1:08:15
  • 26: Part 1 - Examples - If - Conditional Statements 1:02:26
  • 27: Part 2 - Examples - If - Conditional Statements 1:08:05
  • 28: Part 1 - Goto Statement - Looping Construct 1:06:06
  • 29: Part 2 - Goto Statement - Looping Construct 1:02:01
  • 30: Part 1 - Sub Programs - Stored Procedures 1:07:59
  • 31: Part 2 - Sub Programs - Stored Procedures 56:16
  • 32: Part 1 - Stored Procedure Examples 1:01:16
  • 33: Part 2 - Stored Procedure Examples 1:08:02
  • 34: Part 1 - Modifying and Dropping a Stored Procedure 58:48
  • 35: Part 2 - Modifying and Dropping a Stored Procedure 1:01:42
  • 36: Part 1 - Dynamic Queries - Procedure Returning Values - Functions 51:21
  • 37: Part 2 - Dynamic Queries - Procedure Returning Values - Functions 1:16:36
  • 38: Part 1 - Break - Continue - Exception Handling 56:58
  • 39: Part 2 - Break - Continue - Exception Handling 1:06:52
  • 40: Part 1 - Structured Exception Handling 48:48
  • 41: Part 2 - Structured Exception Handling 1:01:48
  • 42: Part 1 - Multiple and Nested Try Catch Blocks 52:56
  • 43: Part 2 - Multiple and Nested Try Catch Blocks 1:05:03
  • 44: Part 1 - Using Anonymous Block - Table Valued Functions 1:05:10
  • 45: Part 2 - Using Anonymous Block - Table Valued Functions 1:01:07
  • 46: Part 1 - Backup DB - Differential Example - DDL Statements 46:28
  • 47: Part 2 - Backup DB - Differential Example - DDL Statements 1:03:37
  • 48: Part 1 - User Defined DB - Creating DB with GUI - Query - Commands 48:29
  • 49: Part 2 - User Defined DB - Creating DB with GUI - Query - Commands 1:11:56
  • 50: Part 1 - Database Constraints and Domain Integrity Constraints 35:28
  • 51: Part 2 - Database Constraints and Domain Integrity Constraints 41:09
  • 52: Part 1 - Primary Key and Composite Key 47:01
  • 53: Part 2 - Primary Key and Composite Key 37:48
  • 54: Part 1 - Creating 1-to-1 Relationship - Indexes 31:56
  • 55: Part 2 - Creating 1-to-1 Relationship - Indexes 50:09
  • 56: Part 1 - Views and Types of Views 1:09:05
  • 57: Part 2 - Views and Types of Views 1:22:05
  • 58: Part 1 - Auto Increment - SQL Date Operations 26:34
  • 59: Part 2 - Auto Increment - SQL Date Operations 29:15
  • 60: 29 - Hosting 25:17

SQL Programming with Microsoft SQL Server - Course Syllabus

1. Introduction to Microsoft SQL Server
2. Select and Where
3. SQL Sub Languages - Order By Clauses
4. Any - All - Select Into - Insert Into - Case
5. Delete - Top - Aggregate Functions - Wild Cards
6. Insert - Update - Is Null Commands
7. In - Between - Table Alias
8. SQL Comments - SQL Operators
9. Joins
10. Union All - Union - Group By - Having - Exists - Not Exists
11. Null Functions - Transact SQL
12. Examples - If - Conditional Statements
13. Goto Statement - Looping Construct
14. Sub Programs - Stored Procedures
15. Stored Procedure Examples
16. Modifying and Dropping a Stored Procedure
17. Dynamic Queries - Procedure Returning Values - Functions
18. Break - Continue - Exception Handling
19. Structured Exception Handling
20. Multiple and Nested Try Catch Blocks
21. Using Anonymous Block - Table Valued Functions
22. Backup DB - Differential Example - DDL Statements
23. User Defined DB - Creating DB with GUI - Query - Commands
24. Database Constraints and Domain Integrity Constraints
25. Primary Key and Composite Key
26. Creating 1-to-1 Relationship - Indexes
27. Views and Types of Views
28. Auto Increment - SQL Date Operations
29. Hosting

Anyone who wants to make a mark in this world!

Passion and determination to achieve your goals!

• SQL Server Developer
• SQL Programmer
• Database Engineer
• Data Engineer
• Data Analyst
• Data Scientist
• Machine Learning Engineer
• SQL BI Developer
• Reporting Analyst
• Software Developer
• Application Developer
• Database Administrator
• Data Architect
• SQL Engineer
• SQL Application Support Analyst
• BI Specialist
• SQL Analyst
• Data Transformation Analyst
• Data Modeler
• Quantitative Engineer
• Data Consultant
• MS SQL DBA