SQL server - from setup to execution

Learn how to download, install, and set up SQL Server 2019 on Windows (with Express options), and explore installation choices, firewall port configuration, and basic setup for remote connections.

Install and set up Microsoft SQL Server Management Studio. Select English and version 18 for SQL Server 2019, then launch SSMS and connect to the database engine using Windows authentication.

Create and manage a SQL Server database and its first table, configure identity and primary key columns, and explore data types such as int, varchar, and decimal for reliable storage.

Insert into a test table with the specified columns and corresponding values, including text and decimal data, then execute the query and refresh the database.

Use select to retrieve data from the test table, choosing all columns or specific columns. Apply where to filter by text, and practice inserting records with text and decimal fields.

Learn to update a specific row using the update statement, setting new values; apply a where clause to avoid altering all rows and see a practical example.

Learn how to delete a record in SQL Server using the delete statement with a where clause, test carefully, and verify results by selecting.

Learn how to sort and filter records in SQL Server using the order by and where clauses, from lowest to highest or highest to lowest, with decimal examples.

Learn to declare and set variables in SQL server using the declare keyword. Variable names start with @ and you test the value with a select.

Explore the logic of SQL Server by examining if statements and the case statement. See variable declaration and conditional flow, plus using select with case and where clauses.

Explore SQL Server authentication options, create and manage logins, map logins to databases, and assign server roles like db_data_writer and db_data_reader to control access.

Discover how a connection string encodes the server, port, instance, initial catalog, user id, and password to connect to SQL Server Express and enable secure data access.

Perform a vulnerability assessment on your database, review scan results, and generate remediation actions. Revoke unnecessary public permissions, enable transparent data encryption, and establish a secure baseline to reduce risk.

Explore a real-world attendee registry in SQL Server, featuring a table for id, name, arrival and departure times, and a pair of stored procedures to search and register arrivals.

Learn how to access and modify SQL server data using C# with ADO.NET and .NET, including stored procedures and inserts, selecting by ID and executing non query, scalar, and reader.

Learn to connect to SQL Server from Python via an ODBC driver, execute a stored procedure or simple text query, commit changes, and fetch results with a cursor.

Learn to set up a file table in SQL Server, configure a file stream directory, and enable file access through non transacted options, preparing for inserting and retrieving files.

Learn to create and use stored procedures to insert and retrieve files in a file table, handling file streams, extensions, and unique identifiers.

Learn to insert a file into SQL Server and retrieve it using C# with a single connection, using stored procedures and memory stream to handle file bytes.

Learn to create scalar valued functions in SQL Server, declare parameters, and return values with simple calculations. Compare functions with stored procedures and see how to call them in queries.

Learn to import data into a new SQL Server table from a CSV flat file, preview data, adjust column types, then complete the import and verify results.

Export data from a single table to a flat file, select the database and destination, review mappings, and run or save the export package.

Use jobs in SQL Server with the SQL Server Agent to schedule one or more steps against a test database, including recurrence, success and failure handling, and logging.

Back up a database by selecting backup options, destinations (disk or Azure storage), and types (full or differential), verify integrity, and automate schedules with compression and expiration.

Learn to configure database mail by creating a profile and accounts, entering outgoing mail server details and credentials, testing mail, and adjusting profile, logging, and security options.

Learn how to configure job notifications in SQL Server Agent by creating an operator, setting up email alerts for job failures and successes, and enabling database mail.