إنشاء حساب
الرئيسية
الكورسات
IT Infrastructure & Security
SQL Server 2019 Full Beginner Course – Install, Connect & Build Databases

SQL Server 2019 Beginner Course: Learn Database Setup, Management, and SQL Fundamentals

Databases are one of the most important technologies behind modern applications, websites, business systems, and software solutions. Almost every organization relies on databases to store, organize, and manage large amounts of information efficiently. For anyone interested in programming, data analysis, backend development, or IT careers, understanding how databases work is an essential skill.

The SQL Server 2019 Beginner Course is a complete practical training program designed to help beginners start their journey with Microsoft SQL Server. The course provides a step-by-step introduction to database systems, focusing on hands-on practice and real-world skills that are used by database professionals.

Throughout this course, learners will discover how to install and configure SQL Server 2019, connect to databases using SQL Server Management Studio (SSMS), create and manage databases, and build structured tables for storing information.

This course is ideal for beginners who want to understand database fundamentals in a simple and practical way. It provides the foundation needed to continue learning SQL, database administration, backend development, and data-related technologies.

Introduction to Microsoft SQL Server and Database Fundamentals

Before working with SQL Server, it is important to understand the role of databases and why they are essential in modern technology systems.

The course begins by introducing the basic concepts of databases and explains how SQL Server is used by companies and developers to manage information.

You will learn:

  • What databases are and why they are important.
  • How database management systems work.
  • The role of Microsoft SQL Server.
  • How organizations use databases in real applications.
  • The importance of SQL skills in technology careers.

This introduction helps beginners understand the purpose of databases and how SQL Server fits into the software development ecosystem.

Installing SQL Server 2019 and Setting Up the Development Environment

The first practical step in working with SQL Server is preparing the correct software environment. The course provides a complete guide to installing the required tools for database development.

You will learn how to install:

  • SQL Server 2019 Developer Edition.
  • SQL Server Management Studio (SSMS).
  • Required database components.
  • The tools needed for practicing SQL commands.

The course explains the installation process in a simple way, making it easy for beginners to follow even without previous database experience.

Having the correct setup is essential because it allows learners to practice database creation, management, and SQL operations in a real development environment.

Understanding SQL Server Management Studio (SSMS)

SQL Server Management Studio is the main tool used for managing SQL Server databases. It provides a visual interface that allows developers and administrators to create databases, write SQL queries, and manage database objects.

In this section, learners will understand how to work with SSMS effectively.

You will learn:

  • How to open and navigate SSMS.
  • Understanding the Object Explorer.
  • Connecting to SQL Server instances.
  • Managing database components.
  • Executing SQL commands.

Learning SSMS is an important step because it is widely used by database administrators and developers in professional environments.

Connecting to SQL Server and Working with Database Systems

After installing SQL Server and SSMS, the next step is learning how to connect to the database server and start managing data.

The course explains the connection process and helps beginners understand how SQL Server communication works.

You will learn:

  • How to connect to SQL Server using SSMS.
  • Understanding server instances.
  • Managing database connections.
  • Running SQL commands.
  • Interacting with database objects.

This knowledge creates a strong foundation for working with SQL Server in real projects.

Creating and Managing Databases in SQL Server

Creating databases is one of the fundamental skills required for anyone working with SQL Server. A database provides the structure needed to store and organize information.

The course teaches learners how to create databases and manage their basic settings.

You will learn:

  • How to create a new database.
  • Understanding database structure.
  • Modifying database properties.
  • Managing existing databases.
  • Deleting databases when needed.

These skills are essential for developers and database administrators who need to build and maintain database environments.

Altering and Dropping Databases Effectively

Database management requires the ability to modify existing databases and remove unnecessary ones when required.

This course introduces important database management operations that allow learners to control their SQL Server environment.

You will understand:

  • How to modify database configurations.
  • How database changes affect stored information.
  • When databases should be removed.
  • Best practices for database management.

Learning these operations helps beginners become more comfortable working with real database systems.

Creating Tables and Structuring Database Information

Tables are the foundation of relational databases. They organize information into rows and columns, allowing data to be stored and retrieved efficiently.

The course explains how to create and manage tables inside SQL Server.

You will learn:

  • How database tables work.
  • Creating new tables.
  • Defining columns and data types.
  • Organizing information properly.
  • Understanding table structures.

This section helps learners understand how real applications store and manage their data.

Understanding Data Organization and Table Relationships

A well-designed database depends on properly organized data structures. Understanding how tables are created and connected is an important skill for database developers.

The course introduces the basics of organizing information inside SQL Server databases.

You will learn:

  • How data is structured in relational databases.
  • The importance of table design.
  • How relationships between tables work.
  • Creating organized database systems.
  • Preparing databases for future development.

These concepts are essential for building efficient and scalable database solutions.

Practical SQL Server Skills for Real-World Applications

The course focuses on practical learning rather than only theoretical explanations. By following real examples, learners gain experience similar to working on actual database projects.

You will practice:

  • Setting up SQL Server environments.
  • Managing databases.
  • Creating database structures.
  • Working with tables.
  • Using professional database tools.

These practical skills help learners become more confident when working with SQL Server in academic projects or professional environments.

Who Should Take This SQL Server 2019 Beginner Course?

This course is designed for anyone who wants to start learning databases and Microsoft SQL Server from the beginning.

It is suitable for:

  • Complete beginners in databases.
  • Computer science students.
  • Software developers.
  • Backend development learners.
  • Data analysis beginners.
  • Future database administrators.
  • IT professionals who want database knowledge.

No advanced programming or database experience is required, making this course a great starting point for learning SQL Server.

Skills You Will Gain After Completing This Course

After completing the SQL Server 2019 Beginner Course, you will have practical knowledge of working with Microsoft SQL Server and managing basic database systems.

You will be able to:

  • Install SQL Server 2019 and SSMS.
  • Connect and work with SQL Server databases.
  • Create and manage databases.
  • Build database tables.
  • Understand relational database structures.
  • Prepare for more advanced SQL learning.

These skills provide a strong foundation for continuing into SQL programming, backend development, data analysis, and professional database administration.

تاريخ التحديث
تاريخ التحديثمنذ 3 ساعات
اللغة
اللغةالإنجليزية
عدد الدروس
عدد الدروس150 درس
إجمالي الوقت
إجمالي الوقت27:04:25 ساعة
المستوى
المستوىمبتدئ

محتوى الكورس

جميع الدروس
27:04:25 - 150 درس
05:20 Install SQL Server 2019 Step by Step | Developer Edition | Free Software | Install SSMS
09:40 Connecting to SQL Server using SSMS - Part 1
15:17 Creating altering and dropping a database - Part 2
20:08 Creating and working with tables - Part 3
10:34 Adding a default constraint - Part 4
08:20 Cascading referential integrity constraint - Part 5
11:39 Adding a check constraint - Part 6
15:12 Identity Column in SQL Server - Part 7
12:50 How to get the last generated identity column value in SQL Server - Part 8
08:12 Unique key constraint - Part 9
21:54 Select statement in sql server - Part 10
17:44 Group by in sql server - Part 11
17:43 Joins in sql server - Part 12
12:01 Advanced or intelligent joins in sql server - Part 13
11:19 Self join in sql server - Part 14
11:42 Different ways to replace NULL in sql server - Part 15
04:28 Coalesce function in sql server Part 16
12:41 Union and union all in sql server Part 17
20:11 Stored procedures in sql server Part 18
18:20 Stored procedures with output parameters Part 19
16:45 Stored procedure output parameters or return values Part 20
11:10 Advantages of stored procedures Part 21
16:14 Built in string functions in sql server 2008 Part 22
14:57 LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql server Part 23
11:52 Replicate, Space, Patindex, Replace and Stuff string functions in sql server 2008 Part 24
15:26 DateTime functions in SQL Server Part 25
12:51 IsDate, Day, Month, Year and DateName DateTime functions in SQL Server Part 26
21:29 DatePart, DateAdd and DateDiff functions in SQL Server Part 27
17:26 Cast and Convert functions in SQL Server Part 28
15:51 Mathematical functions in sql server Part 29
19:07 Scalar user defined functions in sql server Part 30
11:25 Inline table valued functions in sql server Part 31
14:07 Multi statement table valued functions in sql server Part 32
16:34 Important concepts related to functions in sql server Part 33
15:17 Temporary tables in SQL Server Part 34
11:13 Indexes in sql server Part 35
16:48 Clustered and nonclustered indexes in sql server Part 36
11:02 Unique and Non Unique Indexes in sql server Part 37
12:20 Advantages and disadvantages of indexes in sql server Part 38
14:51 Views in sql server Part 39
11:37 Updatable views in sql server Part 40
13:40 Indexed views in sql server Part 41
10:02 View limitations in sql server Part 42
17:45 DML triggers in sql server Part 43
17:19 After update trigger Part 44
15:05 Instead of insert trigger Part 45
22:27 Instead of update triggers in sql server - Part 46.avi
10:03 Instead of delete triggers in sql server - Part 47.avi
17:53 Derived tables and common table expressions in sql server Part 48
12:57 CTE in sql server Part 49
15:02 Updatable common table expressions in sql server Part 50
12:22 Recursive CTE in sql server Part 51
12:11 Database normalization Part 52
13:16 Second normal form and third normal form Part 53
12:25 Pivot in sql server 2008 Part 54
24:04 Error handling in sql server 2000 Part 55
17:46 Error handling in sql server Part 56
11:18 Transactions in sql server Part 57
09:50 Transactions in sql server and ACID Tests Part 58
14:34 Subqueries in sql Part 59
07:59 Correlated subquery in sql Part 60
17:18 Creating a large table with random data for performance testing Part 61
12:26 What to choose for performance SubQuery or Joins Part 62
13:58 Cursors in sql server Part 63
10:24 Replacing cursors using joins in sql server Part 64
05:38 List all tables in a sql server database using a query Part 65
10:37 Writing re runnable sql server scripts Part 66
04:06 Alter database table columns without dropping table Part 67
27:52 Optional parameters in sql server stored procedures Part 68
07:14 Part 69 Merge in SQL Server
07:33 sql server concurrent transactions
08:50 sql server dirty read example
08:29 sql server lost update problem
05:45 Non repeatable read example in sql server
06:37 Phantom reads example in sql server
09:16 Snapshot isolation level in sql server
06:58 Read committed snapshot isolation level in sql server
12:41 Difference between snapshot isolation and read committed snapshot
05:14 SQL Server deadlock example
07:50 SQL Server deadlock victim selection
04:25 Logging deadlocks in sql server
08:58 SQL Server deadlock analysis and prevention
10:21 Capturing deadlocks in sql profiler
05:00 SQL Server deadlock error handling
10:27 Handling deadlocks in ado net
26:00 Retry logic for deadlock exceptions
07:35 How to find blocking queries in sql server
05:14 SQL Server except operator
04:41 Difference between except and not in sql server
05:29 Intersect operator in sql server
03:50 Difference between union intersect and except in sql server
08:16 Cross apply and outer apply in sql server
12:31 DDL Triggers in sql server
05:58 Server scoped ddl triggers
06:43 sql server trigger execution order
06:45 Audit table changes in sql server
08:56 Logon Triggers in SQL Server
11:54 Select into in sql server
06:36 Difference between where and having in sql server
06:46 Table valued parameters in SQL Server
09:27 Send datatable as parameter to stored procedure
09:36 Grouping Sets in SQL Server
09:01 Rollup in SQL Server
07:42 Cube in SQL Server
05:38 Difference between cube and rollup in SQL Server
12:49 Grouping function in SQL Server
12:37 GROUPING ID function in SQL Server
15:11 Debugging sql server stored procedures
09:13 Over clause in SQL Server
07:24 Row Number function in SQL Server
10:08 Rank and Dense Rank in SQL Server
04:43 Difference between rank dense rank and row number in SQL
06:23 Calculate running total in SQL Server 2012
05:10 NTILE function in SQL Server
07:27 Lead and Lag functions in SQL Server 2012
02:48 FIRST VALUE function in SQL Server
11:00 Window functions in SQL Server
05:52 Difference between rows and range
05:35 LAST VALUE function in SQL Server
04:33 UNPIVOT in SQL Server
08:16 Reverse PIVOT table in SQL Server
05:32 Choose function in SQL Server
04:00 IIF function in SQL Server
07:34 TRY PARSE function in SQL Server 2012
07:46 TRY CONVERT function in SQL Server 2012
05:46 EOMONTH function in SQL Server 2012
03:54 DATEFROMPARTS function in SQL Server
08:45 Difference between DateTime and SmallDateTime in SQL Server
05:28 DateTime2FromParts function in SQL Server 2012
10:42 Difference between DateTime and DateTime2 in SQL Server
09:04 Offset fetch next in SQL Server 2012
05:50 Identifying object dependencies in SQL Server
08:05 sys dm sql referencing entities in SQL Server
05:09 sp depends in SQL Server
12:22 Sequence object in SQL Server 2012
05:29 Difference between sequence and identity in SQL Server
09:29 Guid in SQL Server
06:39 How to check GUID is null or empty in SQL Server
12:12 Dynamic SQL in SQL Server
10:54 Implement search web page using ASP NET and Stored Procedure
10:20 Implement search web page using ASP NET and Dynamic SQL
10:28 Prevent sql injection with dynamic sql
09:32 Dynamic SQL in Stored Procedure
14:20 Sql server query plan cache
09:16 exec vs sp executesql in sql server
11:59 Dynamic sql table name variable
10:28 Quotename function in SQL Server
06:02 Dynamic SQL vs Stored Procedure
05:25 Dynamic sql output parameter
04:36 Temp tables in dynamic sql

محتوى الكورس

جميع الدروس
27:04:25 - 150 درس
05:20 Install SQL Server 2019 Step by Step | Developer Edition | Free Software | Install SSMS
09:40 Connecting to SQL Server using SSMS - Part 1
15:17 Creating altering and dropping a database - Part 2
20:08 Creating and working with tables - Part 3
10:34 Adding a default constraint - Part 4
08:20 Cascading referential integrity constraint - Part 5
11:39 Adding a check constraint - Part 6
15:12 Identity Column in SQL Server - Part 7
12:50 How to get the last generated identity column value in SQL Server - Part 8
08:12 Unique key constraint - Part 9
21:54 Select statement in sql server - Part 10
17:44 Group by in sql server - Part 11
17:43 Joins in sql server - Part 12
12:01 Advanced or intelligent joins in sql server - Part 13
11:19 Self join in sql server - Part 14
11:42 Different ways to replace NULL in sql server - Part 15
04:28 Coalesce function in sql server Part 16
12:41 Union and union all in sql server Part 17
20:11 Stored procedures in sql server Part 18
18:20 Stored procedures with output parameters Part 19
16:45 Stored procedure output parameters or return values Part 20
11:10 Advantages of stored procedures Part 21
16:14 Built in string functions in sql server 2008 Part 22
14:57 LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql server Part 23
11:52 Replicate, Space, Patindex, Replace and Stuff string functions in sql server 2008 Part 24
15:26 DateTime functions in SQL Server Part 25
12:51 IsDate, Day, Month, Year and DateName DateTime functions in SQL Server Part 26
21:29 DatePart, DateAdd and DateDiff functions in SQL Server Part 27
17:26 Cast and Convert functions in SQL Server Part 28
15:51 Mathematical functions in sql server Part 29
19:07 Scalar user defined functions in sql server Part 30
11:25 Inline table valued functions in sql server Part 31
14:07 Multi statement table valued functions in sql server Part 32
16:34 Important concepts related to functions in sql server Part 33
15:17 Temporary tables in SQL Server Part 34
11:13 Indexes in sql server Part 35
16:48 Clustered and nonclustered indexes in sql server Part 36
11:02 Unique and Non Unique Indexes in sql server Part 37
12:20 Advantages and disadvantages of indexes in sql server Part 38
14:51 Views in sql server Part 39
11:37 Updatable views in sql server Part 40
13:40 Indexed views in sql server Part 41
10:02 View limitations in sql server Part 42
17:45 DML triggers in sql server Part 43
17:19 After update trigger Part 44
15:05 Instead of insert trigger Part 45
22:27 Instead of update triggers in sql server - Part 46.avi
10:03 Instead of delete triggers in sql server - Part 47.avi
17:53 Derived tables and common table expressions in sql server Part 48
12:57 CTE in sql server Part 49
15:02 Updatable common table expressions in sql server Part 50
12:22 Recursive CTE in sql server Part 51
12:11 Database normalization Part 52
13:16 Second normal form and third normal form Part 53
12:25 Pivot in sql server 2008 Part 54
24:04 Error handling in sql server 2000 Part 55
17:46 Error handling in sql server Part 56
11:18 Transactions in sql server Part 57
09:50 Transactions in sql server and ACID Tests Part 58
14:34 Subqueries in sql Part 59
07:59 Correlated subquery in sql Part 60
17:18 Creating a large table with random data for performance testing Part 61
12:26 What to choose for performance SubQuery or Joins Part 62
13:58 Cursors in sql server Part 63
10:24 Replacing cursors using joins in sql server Part 64
05:38 List all tables in a sql server database using a query Part 65
10:37 Writing re runnable sql server scripts Part 66
04:06 Alter database table columns without dropping table Part 67
27:52 Optional parameters in sql server stored procedures Part 68
07:14 Part 69 Merge in SQL Server
07:33 sql server concurrent transactions
08:50 sql server dirty read example
08:29 sql server lost update problem
05:45 Non repeatable read example in sql server
06:37 Phantom reads example in sql server
09:16 Snapshot isolation level in sql server
06:58 Read committed snapshot isolation level in sql server
12:41 Difference between snapshot isolation and read committed snapshot
05:14 SQL Server deadlock example
07:50 SQL Server deadlock victim selection
04:25 Logging deadlocks in sql server
08:58 SQL Server deadlock analysis and prevention
10:21 Capturing deadlocks in sql profiler
05:00 SQL Server deadlock error handling
10:27 Handling deadlocks in ado net
26:00 Retry logic for deadlock exceptions
07:35 How to find blocking queries in sql server
05:14 SQL Server except operator
04:41 Difference between except and not in sql server
05:29 Intersect operator in sql server
03:50 Difference between union intersect and except in sql server
08:16 Cross apply and outer apply in sql server
12:31 DDL Triggers in sql server
05:58 Server scoped ddl triggers
06:43 sql server trigger execution order
06:45 Audit table changes in sql server
08:56 Logon Triggers in SQL Server
11:54 Select into in sql server
06:36 Difference between where and having in sql server
06:46 Table valued parameters in SQL Server
09:27 Send datatable as parameter to stored procedure
09:36 Grouping Sets in SQL Server
09:01 Rollup in SQL Server
07:42 Cube in SQL Server
05:38 Difference between cube and rollup in SQL Server
12:49 Grouping function in SQL Server
12:37 GROUPING ID function in SQL Server
15:11 Debugging sql server stored procedures
09:13 Over clause in SQL Server
07:24 Row Number function in SQL Server
10:08 Rank and Dense Rank in SQL Server
04:43 Difference between rank dense rank and row number in SQL
06:23 Calculate running total in SQL Server 2012
05:10 NTILE function in SQL Server
07:27 Lead and Lag functions in SQL Server 2012
02:48 FIRST VALUE function in SQL Server
11:00 Window functions in SQL Server
05:52 Difference between rows and range
05:35 LAST VALUE function in SQL Server
04:33 UNPIVOT in SQL Server
08:16 Reverse PIVOT table in SQL Server
05:32 Choose function in SQL Server
04:00 IIF function in SQL Server
07:34 TRY PARSE function in SQL Server 2012
07:46 TRY CONVERT function in SQL Server 2012
05:46 EOMONTH function in SQL Server 2012
03:54 DATEFROMPARTS function in SQL Server
08:45 Difference between DateTime and SmallDateTime in SQL Server
05:28 DateTime2FromParts function in SQL Server 2012
10:42 Difference between DateTime and DateTime2 in SQL Server
09:04 Offset fetch next in SQL Server 2012
05:50 Identifying object dependencies in SQL Server
08:05 sys dm sql referencing entities in SQL Server
05:09 sp depends in SQL Server
12:22 Sequence object in SQL Server 2012
05:29 Difference between sequence and identity in SQL Server
09:29 Guid in SQL Server
06:39 How to check GUID is null or empty in SQL Server
12:12 Dynamic SQL in SQL Server
10:54 Implement search web page using ASP NET and Stored Procedure
10:20 Implement search web page using ASP NET and Dynamic SQL
10:28 Prevent sql injection with dynamic sql
09:32 Dynamic SQL in Stored Procedure
14:20 Sql server query plan cache
09:16 exec vs sp executesql in sql server
11:59 Dynamic sql table name variable
10:28 Quotename function in SQL Server
06:02 Dynamic SQL vs Stored Procedure
05:25 Dynamic sql output parameter
04:36 Temp tables in dynamic sql

المزيد من الكورسات

عرض الكل
Nmap Tutorial – Finding Network Vulnerabilities

Nmap Tutorial – Finding Network Vulnerabilities

IT Infrastructure & Security

المستوي
المستوى مبتدئ
اللغة
اللغة الإنجليزية
Web3 Python on Google Colab – Ethereum Blockchain & Smart Contract Development Course

Web3 Python on Google Colab – Ethereum Blockchain & Smart Contract Development Course

IT Infrastructure & Security

المستوي
المستوى مبتدئ
اللغة
اللغة الإنجليزية
Blockchain & Smart Contracts Full Course: Build NFT Apps with Hardhat

Blockchain & Smart Contracts Full Course: Build NFT Apps with Hardhat

IT Infrastructure & Security

المستوي
المستوى مبتدئ
اللغة
اللغة الإنجليزية
Solidity Smart Contracts Course: Ethereum Development for Beginners

Solidity Smart Contracts Course: Ethereum Development for Beginners

IT Infrastructure & Security

المستوي
المستوى مبتدئ
اللغة
اللغة الإنجليزية
Solidity Smart Contracts Full Course: Beginner to Advanced Ethereum Development

Solidity Smart Contracts Full Course: Beginner to Advanced Ethereum Development

IT Infrastructure & Security

المستوي
المستوى مبتدئ
اللغة
اللغة الإنجليزية
Solidity Smart Contracts Tutorial: Ethereum Blockchain Developer Course

Solidity Smart Contracts Tutorial: Ethereum Blockchain Developer Course

IT Infrastructure & Security

المستوي
المستوى مبتدئ
اللغة
اللغة الإنجليزية
Solidity, Blockchain & Smart Contracts Course: Beginner to Expert Guide

Solidity, Blockchain & Smart Contracts Course: Beginner to Expert Guide

IT Infrastructure & Security

المستوي
المستوى مبتدئ
اللغة
اللغة الإنجليزية
Solidity Tutorial: Full Course on Ethereum, Blockchain, Smart Contracts & EVM

Solidity Tutorial: Full Course on Ethereum, Blockchain, Smart Contracts & EVM

IT Infrastructure & Security

المستوي
المستوى مبتدئ
اللغة
اللغة الإنجليزية