SQL Course for Beginners

In this Video Course, learn SQL and its concept. SQL Server is a relational database management system (RDBMS) developed by Microsoft. RDBMS is the basis for SQL, and for all modern database systems such as Microsoft SQL Server, Oracle, MySQL, and Microsoft Access. We have covered Microsoft SQL Server in this course. The course is for beginners and consists of 38 lessons, and more than 100 live running queries, including creating new databases and tables.

• SQL Introduction 07:10

  • 1: SQL Course Intro 01:06
  • 2: SQL Introduction 02:24
  • 3: SQL vs NoSQL 03:40

• SQL - Installation & Setup 04:25

  • 4: Install SQL Server 2022 on Windows 11 04:25

• SQL - Create and Insert 06:45

  • 5: Create a new database Preview 01:22
  • 6: Create a new table Preview 02:38
  • 7: Insert records 02:45

• SQL - Select Records 07:02

  • 8: SELECT Statement 01:45
  • 9: SELECT DISTINCT Statement 01:39
  • 10: WHERE Clause 03:38

• SQL - Order Records 03:44

  • 11: ORDER BY Keyword 03:44

• SQL - Operators 19:13

  • 12: AND Operator 02:39
  • 13: OR Operator 02:26
  • 14: NOT Operator 02:04
  • 15: IN Operator 03:16
  • 16: BETWEEN Operator Preview 03:42
  • 17: LIKE Operator 05:06

• SQL - Built-in Functions 10:31

  • 18: MAX() Function 02:06
  • 19: MIN() Function 02:08
  • 20: SUM() Function 01:55
  • 21: AVG() Function 01:51
  • 22: COUNT() Function 02:31

• SQL - Constraints 17:42

  • 23: NOT NULL Constraint 02:59
  • 24: UNIQUE Constraint 04:01
  • 25: PRIMARY Key Constraint 02:25
  • 26: FOREIGN Key Constraint 04:06
  • 27: CHECK Constraint 04:11

• SQL - Commands 04:42

  • 28: ASC Command 02:17
  • 29: DESC Command 02:25

• SQL - Alter and Update 08:34

  • 30: ALTER TABLE Statement 02:16
  • 31: UPDATE Statement 03:58
  • 32: Aliases 02:20

• SQL - Advanced 24:38

  • 33: Stored Procedures 06:06
  • 34: CREATE INDEX Statement 02:46
  • 35: SELECT INTO Statement 03:22
  • 36: SELECT TOP Clause 03:22
  • 37: Backup a Database 01:59
  • 38: Views 05:11
  • 39: Drop a Table 01:52

Welcome to our Microsoft SQL Server Course!!!

The course begins with SQL Introduction and free versions provided by Microsoft for SQL Server. Then, we have shown how to set up and install it on both Windows 10 and Windows 11. We proceed further with creating a new database and table, to perform various operations on it. With that, we have also covered live-running queries in every lesson.

Note: The flow would be step-by-step and the explanations would include a tutorial-like format, to make it easier for beginners to understand a new database and table and its concepts, with live running queries as examples. With that, we have also created some quizzes to polish your SQL skills.

**Course Highlights**

38 lessons

2h video with live running examples

100+ examples

While learning, you will get an opportunity to work on various hands-on exercises and understand the role of databases in a real-world application.

What you'll learn

• Learn how to work with Databases from scratch

• Get a SQL Crash Course (2024)

• Learn how to query SQL

• Maintaining the Database

• Writing optimal queries

• Database Beginners
• Web Developers
• Application Developers
• Programmers

Basic knowledge of Computer usage

Become a Database Administrator. The Average Database Administrator's salary in the UK is £61,339 (Reed.co.uk Salary Calculator)

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

Certificate of Completion

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included