SQL Database Administration & Query Skills: For Beginners

Set up SQL Server 2019 and SSMS, install the basics, and connect using Windows authentication to manage databases and prepare for creating tables in the next section.

Explore the four system databases—master, model, msdb, and tempdb—and learn how each keeps SQL Server running, from configuration and templates to job scheduling and temporary storage.

Create a database and tables in SQL Server 2019 by using a new query, selecting the database, executing create statements for staff and suppliers, and refreshing the database and backups.

Learn to back up and restore your database with full and differential backups, set the backup location, and switch between single and multiuser modes for maintenance.

Back up and restore your database with sql, setting the database to single-user mode via the master database, selecting a backup location, and using restore with rollback immediate to recover.

Learn to use the select statement in SQL Server 2019 to query all columns or specific columns from staff and customer tables, execute queries, and view results.

Use comparison operators in the where clause: greater than, less than, greater than or equal to, less than or equal to, equal to, not equal to, and single quotes.

learn how to combine conditions using and, or, and not in sql queries to filter by age, department, and location.

Master the in and between operators to filter data by multiple values (departments IT, art, sales) and age ranges (20 to 30, 30 to 40) in SQL.

Learn how to insert a new record into a table, update a specific row with a where clause, and delete a record in Microsoft SQL Server 2019 for beginners.

Learn to alter and drop tables, add and modify columns, change data types, and drop databases using SQL commands like ALTER TABLE and DROP COLUMN.

Sort data with order by in sql server 2019, arranging records by columns such as first name, last name, or age in ascending or descending order. Next, group by.

Group by groups to count and summarize data, using count and aliasing to display people per department and per state, and ordering results by alias.

Explore the having clause filters grouped results after a group by, replacing the where clause when working with aggregated functions, with examples using departments, accounts, states, and age ranges.

Explore the top clause in Microsoft SQL Server 2019 to limit results with top n or top percent, and use order by for deterministic selections.

Explore aggregate functions that calculate a single value from a set of values, including count, min, max, average, sum, and length of first names.

Learn how null and not null affect values in SQL Server 2019 by identifying unassigned departments and updating records to set department values where they are null.

Learn how to use union to combine results from staff and customers into a single logical table in SQL Server 2019; ensure matching data types to avoid conversion errors.

Create tables using an identity primary key, assign a primary key to customers, and practice inserting orders to illustrate how keys uniquely identify records for future table connections.

Learn to join customers and orders with inner, left, and full outer joins using the customer ID, and select columns to see how each join affects records.

Master the basics of SQL, set up your own SQL Server, and use queries to retrieve information from your tables.