SQL - Learn SQL using SQL Server

Learn to create a bookstore database in SQL Server using SQL Server Management Studio, including connecting, writing a first query, and the master and dbo schema.

Learn to create tables in SQL Server using the interface and via a create table query, defining books and authors with ids, titles, language, and publication dates.

Learn to add a new column to an existing table using the alter table statement in SQL Server, including defining the column type (float) and verifying the change.

Learn how to remove a table in SQL Server, both via the graphical interface and the drop table statement, with emphasis on caution since deletion is permanent.

Learn to insert data into SQL Server tables using the SQL Server interface and an insert statement, including adding rows to book and author tables, handling dates and escaping quotes.

Learn how to retrieve data from a SQL Server table using the interface and by writing a select statement, including top 1000 rows and all columns.

Filter SQL query results by applying the where clause after a select statement, using conditions like first name equals 'Tom' or age equals 27 to retrieve specific authors.

Discover how to filter and sort data with SQL keywords such as distinct, and, or, like, in, between, and not, and apply order by to shape result sets.

use group by with aggregate functions to analyze authors by gender and age, including filtering by over 18, renaming results, and ordering to show averages, counts, min and max.

Learn to update and delete rows in SQL Server tables using update set and delete from with a where clause. See examples like updating author 989 and deleting 100.

Learn how to join tables in SQL Server using inner, left, right, and full outer joins on related columns like author_id, returning authors with their books and handling unmatched rows.