SQL Tutorial for Beginners

About the course

Embark on a transformative journey into the world of databases with our "SQL Tutorial for Beginners" online course, meticulously designed for novice learners. In this tutorial, you'll unravel the fundamentals of SQL, mastering database querying and management. Our online course ensures an engaging learning experience, allowing beginners to grasp SQL's essentials at their own pace. Enroll now to gain proficiency in database manipulation, and join a community of learners committed to mastering the art of SQL.

How to Get The Certificate
Create an account https://learnme.academy/login/signup.php 💻 It's Free!!!

Watch All Lessons
Watch at least 60% of Lesson Duration 🎥

You can follow your course progress From Your Profile

The Certificate is free

Course content

Sections: 5

•

Activities: 2

•

Resources: 65

Welcome!!!
Get ready for a challenge at the end of this course!!

01 Introduction to SQL | SQL tutorial for beginners
02 How to install sql server 2019 on windows
03 SQL server management studio tutorial for beginners
04 Create database in SQL
05 System databases - master, model, msdb and tempdb in sql server
06 What are ddl and dml commands in SQL
07 Normalization in SQL | Types of Normal forms in SQL
08 Understanding normalization with example in SQL Server
09 Data types in SQL Server
10 NULL values in SQL : How to identify and handle them ?
11 How do you create a table in SQL
12 What are constraints in SQL | Types of constraints in SQL
13 Insert data in table in SQL | insert multiple rows in SQL
14 Not null constraint in sql server
15 What is a Unique Constraint in SQL Server
16 What is a primary key in sql server
17 Understanding Foreign Key Constraints in SQL Server
18 Check constraint in sql server
19 Select Query in SQL Server | Where clause in SQL Server
20 Operators in Sql Server
21 What is one to one relationship in sql server
22 Understanding one to many relationship in sql server
23 Understanding many to many relationship in sql server
24 What is an ER diagram in database
25 Sorting data in SQL Server
26 Grouping data in SQL Server | Group by in SQL Server
27 Having clause in SQL Server
28 Understanding Paging in sql server
29 Understanding Like Operator in SQL Server
30 Using count function in sql server
31 Select unique records from a table in sql server
32 How to take the backup of a table in sql server
33 How to update data in sql server
34 How do I DELETE data from SQL table
35 What is inner join in sql server
36 What is left join in sql server
37 Understanding right join in sql server
38 Understanding full outer join in sql server
39 How to update data in one table from another table in sql
40 How to delete data from one table after joining another table using sql
41 How to find records which are not in another table in sql
42 Find records from one table which do not exist in another in sql server
43 How to use not in query in sql server
44 Combining data using union in sql server
45 How to use union all in sql server
46 What is the difference between union and union all in sql server
47 Intersect operator in SQL Server
48 Mastering the EXCEPT Keyword in SQL Server
49 Mastering SQL Server CASE Statement
50 Subqueries in sql server
51 Mastering Derived Tables in SQL Server
52 What is CTE in SQL Server with example
53 Insert and update with cte in sql server
54 How to use multiple CTE in SQL Server
55 Temporary table in sql server with example
56 What is the difference between local temp table and global temp table
57 Truncate table in sql server | Difference between delete and truncate command
58 Merge Statement in SQL Server