Microsoft SQL Server Bootcamp: Zero to Hero

Learn how to install SQL Server Management Studio (SSMS), download the latest 19 preview, run setup as administrator, and connect to SQL servers to create databases, tables, and queries.

Connect to Microsoft SQL Server with Windows authentication in SQL Server Management Studio by entering the local or remote server name or IP, selecting database engine, and opening Object Explorer.

Create a database in SQL Server Management Studio by logging in, selecting new database, naming it, and reviewing default data and log file structure.

This lecture provides an overview of column data types in SSMS and demonstrates creating a new table with types such as integer, decimal, money, image, text, and float.

Create a new table in SQL Server using either a create statement or the SQL Server Management Studio designer, defining id, product_name, and product_description, and set the primary key.

Create local and global temporary tables in SQL Server with single or double hash prefixes. These temp tables reside in tempdb, behave like regular tables, and are dropped when completed.

Learn to use the update statement to modify a products table, filtering with where id = 3 to change Acer laptop to IBM laptop.

Learn how to write delete queries in SQL Server, delete all rows or specific records with where clauses, and understand the risks of deleting data permanently.

Learn to use the drop table statement to delete a table and its data, indexes, triggers, constraints, and permissions in a query window.

Master the alter statement to modify table structures in SQL, including adding and dropping columns and changing data types, illustrated with student_details and customers tables.

learn how to rename a table or database in sql server using the simple right-click rename, and see that the data remains unchanged.

Create a database user in SQL Server Management Studio by creating a login, mapping it to a database, and reviewing grant or revoke permissions for secure access.

Learn the basics of SQL statements, write select queries with distinct to remove duplicates, customize column headings, perform calculations, and use count as an aggregate function on real-world queries.

Master the basics of sql statements, including select, insert, update, and delete, and learn to create databases, tables, and indexes using ansi and iso standards.

Master the select statement by writing clean queries, connecting to a local AdventureWorks database, and selecting specific columns or all columns with from, where, and star.

Learn to use the distinct keyword to remove duplicates in a query and return a unique result set without altering the table, as shown with select distinct.

Learn how to select and alias columns, concatenate first name and last name into a single full name column with a space, and assign custom column headings in SQL queries.

Learn to filter data with the where clause in SQL Server, using and, or, and like operators on first name, last name, and company name in Adventure Works 2019.

Explore the sum aggregation function in SQL Server by totaling the line total in sales order details, using group by on sales order id and aliasing as total.