Microsoft SQL Database Bootcamp: Get Microsoft Certified

Learn how data is stored in tables by examining their columns and rows, and see how a database and DBMS manage relational structures for storage, retrieval, and queries.

Explore fundamental relational database concepts, including tables, rows, and attributes; learn how primary and foreign keys establish relations, with constraints and storage details using SQL Server Management Studio.

Explore DML and DDL, distinguishing data manipulation from data definition, and learn DML statements such as insert, update, delete, merge, and select, plus how transactions preserve integrity.

Explore data definition language (ddl) in SQL Server, learning how to create tables, views, constraints, and stored procedures, and how to manage objects with create, alter, drop, and truncate statements.

Explore how data types determine storage and precision in SQL Server, covering exact and approximate numerics, dates and times, character and binary strings, and money data types.

Explore char, varchar, and unicode string types, their fixed and variable lengths, and how data type precedence, collation, and implicit and explicit conversions influence storage, comparisons, and queries.

Create and define tables for parts, customers, and orders using proper ANSI syntax, establishing primary keys, constraints, and appropriate data types while applying naming standards and managing nullability.

Create views by selecting columns and rows from one or more tables. Views offer security, simplicity, and analysis, and can be created via graphical designer or sql command.

Create stored procedures and functions as the database interface using input parameters and error handling. Test in SSMS and learn how procedures enable security in selecting, inserting, or updating data.

This lecture expands data retrieval with SQL select statements, covering where clauses, combining conditions with and/or and brackets, selecting columns, and built-in functions like count, max, and getdate.

Combine results with union, intersect, and except to create comprehensive or filtered data sets. Learn inner, left, right, full, and cross joins, plus primary and foreign keys and normalization.

Learn to insert and update data in a database with insert and update statements, use the GUI to add records, and handle identity columns and where clauses.

Learn how to delete data from single or multiple tables, preserve referential integrity with foreign keys and transactions, and understand how triggers and transaction control maintain database consistency.

Understand normalization in database design, learn the five normal forms, and explore how eliminating redundancy and clarifying dependencies affects structure, performance, and maintenance.

Explore how primary keys, foreign keys, and composite keys establish table relationships, enforce integrity with unique constraints, and choose appropriate data types for robust database design.

Explore how clustered and non-clustered indexes boost query performance, weigh storage and maintenance costs, and see how primary keys auto-create a clustered index using B-trees.

Learn core database security concepts, from server and database access control to logins, authentication modes, roles, and object permissions such as grants and denies.

Master database backups and restore concepts, including full, differential, incremental, and bulk-logged recovery models. Design and test recovery plans to protect data and minimize downtime.