Microsoft SQL Database Bootcamp: Get Microsoft Certified from Udemy

What's inside

Learning objectives

Understand how sql data is stored
Know how to create and manipulate tables
Create stored procedures and functions

Understand normalization
Be able to backup and restore a database

Understand how sql data is stored
Know how to create and manipulate tables
Create stored procedures and functions
Understand normalization
Be able to backup and restore a database

Syllabus

Introduction

Introduction - Welcome to the Course

Understand how data is stored and manipulated.

Understand How Data is Stored in Tables

Understand How Data is Stored in Tables Quiz

Understand Relational Database Concepts

Understand Relational Database Concepts Quiz

Understand Data Manipulation Language (DML)

Understand Data Manipulation Language (DML) Quiz

Understand Data Definition Language (DDL)

Understand Data Definition Language (DDL) Quiz

Creating Database Objects

Choose Data Types - Part 1

Choose Data Types - Part 1 Quiz

Choose Data Types - Part 2

Choose Data Types - Part 2 Quiz

Understand Tables and How to Create Them

Understand Tables and How to Create Them Quiz

Create Views

Create Views Quiz

Create Stored Procedures and Functions

Create Stored Procedures and Functions Quiz

Manipulating Data

Select Data - Part 1

Select data - Part 1 Quiz

Select Data - Part 2

Select Data - Part 2 Quiz

Insert and Update Data

Insert and Update Data Quiz

Delete Data

Delete Data Quiz

Understanding Data Storage

Understand Normalization

Understand Normalization Quiz

Understand Primary, Foreign and Composite Keys

Understand Primary, Foreign and Composite Keys Quiz

Understand Indexes

Understand Indexes Quiz

Administering a Database

Understand Database Security Concepts

Understand Database Security Concepts Quiz

Understand Database Backups and Restore

Understand Database Backups and Restore Quiz

Bonus Exam 1

Bonus Exam 2

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Provides a foundation for becoming a database engineer, potentially leading to MCSA or MCSE Data Platform certifications, which can enhance career prospects

Taught by Microsoft Expert Toby Lawrence, who has experience teaching Microsoft subjects to thousands of students, which may provide valuable insights and guidance

Covers database backups and restores, which are essential skills for database administration and ensuring data integrity, and are highly valued in the industry

Uses Microsoft SQL Server 2008, which is the edition tested on the Microsoft MTA Database Exam (98-364), but it is an older version of the software

Requires downloading a free trial of Microsoft SQL Server 2008, which may involve additional steps and potential compatibility issues for some learners

Focuses on Microsoft SQL Server 2008, which is a significantly outdated version, and may not be relevant for current industry practices or job requirements

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Microsoft SQL Database Bootcamp: Get Microsoft Certified with these activities:

Review Relational Database Concepts

Show steps

Solidify your understanding of relational database concepts before diving into the course. This will help you grasp the core principles more easily.

Show steps

Read articles on relational database design.
Watch introductory videos on database normalization.
Complete a practice quiz on key database terms.

Microsoft SQL Server 2008 Bible

Show steps

Explore a comprehensive guide to SQL Server 2008 to gain a deeper understanding of the platform. This book will provide additional context and details on the topics covered in the course.

View Putting Knowledge to Work on Amazon

Show steps

Read the chapters on database security and user management.
Study the sections on database backups and recovery.
Explore the chapters on performance tuning and optimization.

SQLZoo Tutorials

Show steps

Practice SQL queries using SQLZoo to reinforce your understanding of DML and DDL. This will give you hands-on experience with writing SQL code.

Show steps

Complete the SQLZoo tutorials on SELECT statements.
Work through the tutorials on INSERT, UPDATE, and DELETE statements.
Practice creating and altering tables using DDL statements.

Three other activities

Expand to see all activities and additional details

Show all six activities

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

Show steps

Supplement your learning with a comprehensive guide to SQL queries. This book will provide additional examples and explanations to deepen your understanding.

View SQL Queries for Mere Mortals on Amazon

Show steps

Read the chapters on SELECT statements and filtering data.
Study the sections on joining tables and using subqueries.
Practice the examples provided in the book.

Design a Simple Database

Show steps

Apply your knowledge by designing a simple database for a real-world scenario. This will help you understand how to structure data and create relationships between tables.

Show steps

Choose a scenario (e.g., library, online store, etc.).
Identify the entities and attributes for your database.
Create an ER diagram to visualize the database structure.
Implement the database schema in SQL Server.

Create a Database Backup and Restore Guide

Show steps

Document the steps involved in backing up and restoring a SQL Server database. This will solidify your understanding of database administration tasks.

Show steps

Research different backup strategies in SQL Server.
Write a step-by-step guide on how to perform a full database backup.
Write a step-by-step guide on how to restore a database from a backup.
Include screenshots and examples in your guide.

Career center

Learners who complete Microsoft SQL Database Bootcamp: Get Microsoft Certified will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator is responsible for the performance, integrity, and security of a database. This course helps you understand data storage, relational database concepts, and how to create and manipulate tables, skills that are crucial for a Database Administrator. The course also covers important topics such as database backups and restoration, as well as security concepts, allowing one to properly manage and protect data assets. Anyone looking to pursue a career as a Database Administrator should take this course.

See salaries and explore the career path for Database Administrator

Database Developer

Database Developers design and implement databases according to the requirements of an organization. This course helps a Database Developer by introducing core concepts such as how data is stored in tables, relational database concepts, and how to create stored procedures and functions, skills that are fundamental. The course also provides hands-on experience with creating database objects, which would be valuable to a Database Developer. Anyone seeking a career as a Database Developer should take this course.

See salaries and explore the career path for Database Developer

Data Modeler

A Data Modeler designs and creates data models that represent an organization's data. This course helps a Data Modeler by providing an understanding of how data is stored, relational database concepts, and how to create tables. The concepts taught in this course, such as database normalization, primary keys, and foreign keys, are very relevant to the work of a Data Modeler. This course is a wise choice for anyone looking to become a Data Modeler.

See salaries and explore the career path for Data Modeler

Cloud Database Engineer

Cloud Database Engineers build and manage databases in cloud environments. This course will help a Cloud Database Engineer by teaching the fundamentals of database management, including how data is stored, relational database concepts, and how to create database objects. The course covers key topics like database security and backups, which are essential for Cloud Database Engineers. Anyone looking to become a Cloud Database Engineer should consider taking this course.

See salaries and explore the career path for Cloud Database Engineer

Data Architect

A Data Architect designs and manages an organization's data infrastructure. This course directly helps a Data Architect by providing foundational knowledge of database concepts such as data storage, relational databases, and table creation. The course covers important concepts such as data normalization, which directly helps a Data Architect as they plan and design data architectures. Anyone looking to start a career as a Data Architect should seriously consider taking this course.

See salaries and explore the career path for Data Architect

Data Engineer

Data Engineers build and maintain the infrastructure for data processing and analysis. This course could be helpful to a Data Engineer by providing a foundation in database concepts, including data storage, relational databases, and creating database objects, which are important skills to a Data Engineer. The course covers data manipulation and creating stored procedures useful for managing and processing data. One could consider taking this course to become a Data Engineer.

See salaries and explore the career path for Data Engineer

Data Analyst

Data Analysts extract and interpret data to provide insights for business decisions. This course may be useful to a Data Analyst by helping them gain a foundational understanding of how data is structured and stored in databases. Learning about data manipulation, including inserting, updating and deleting data can assist a Data Analyst in extracting the exact data they need. Those looking to become a Data Analyst may find this course helpful.

See salaries and explore the career path for Data Analyst

Report Writer

A Report Writer designs and generates reports from databases. This course may be useful to a Report Writer as it teaches basic database concepts, including how data is stored and how to manipulate it using SQL. Understanding how to write SQL queries and work with various database concepts that this course covers will assist a Report Writer. Anyone hoping to become a Report Writer may find this course useful.

See salaries and explore the career path for Report Writer

Business Intelligence Analyst

A Business Intelligence Analyst uses data to analyze business trends and provide actionable insights. This course may assist a Business Intelligence Analyst by providing a basic understanding of databases and data manipulation. Understanding core concepts such as how data is stored and how to create and manipulate tables may be valuable to a Business Intelligence Analyst. Those interested in a role as a Business Intelligence Analyst might benefit from this course.

See salaries and explore the career path for Business Intelligence Analyst

Software Developer

Software Developers create and maintain software applications, often interacting with databases. This course may be helpful to a Software Developer as it teaches core database concepts such as how data is stored in tables, manipulating that data with insert, update and delete functionality, and creating views, functions and procedures. A Software Developer requires a basic understanding of databases to ensure smooth integration with any business application. This course may be useful to a Software Developer.

See salaries and explore the career path for Software Developer

Information Architect

An Information Architect designs and organizes information systems and structures. This course can be useful to an Information Architect, who benefits from understanding how data is stored and structured within databases. Learning about relational database concepts and data normalization, which are covered in this course, is directly relevant to the work of an Information Architect. An Information Architect might find this course useful.

See salaries and explore the career path for Information Architect

Systems Engineer

Systems Engineers design, implement, and manage complex systems, often involving databases. This course may be helpful to a Systems Engineer by providing them with fundamental database knowledge. Learning about relational database concepts and how to create and manipulate tables may be beneficial to a Systems Engineer when designing and integrating systems. Those seeking a role as a Systems Engineer may find this course useful.

See salaries and explore the career path for Systems Engineer

Systems Analyst

Systems Analysts evaluate and improve computer systems and related processes, and often interact with data systems. This course may be useful to a Systems Analyst as it helps them to better understand the underlying database structure and functionality. The course specifically covers relational database concepts and how to create tables, which is important to a Systems Analyst. Those seeking a role as a Systems Analyst may benefit from a course such as this.

See salaries and explore the career path for Systems Analyst

Technical Consultant

A Technical Consultant provides expert guidance on technology-related challenges and implementation. This course may be helpful for a Technical Consultant as it will give them a foundational understanding of database functionality. Learning about relational database concepts, security, and backups will help a Technical Consultant advise their clients on their database needs. A Technical Consultant may find this course useful.

See salaries and explore the career path for Technical Consultant

IT Support Specialist

An IT Support Specialist provides technical support to users by resolving hardware and software issues. This course may be beneficial for an IT Support Specialist who will need a basic understanding of database administration which includes an understanding of security and backups. An IT Support Specialist may need to resolve database-related issues as well which makes a course on databases useful. Those looking to work as an IT Support Specialist may find this course helpful.

See salaries and explore the career path for IT Support Specialist

Microsoft SQL Database Bootcamp

Get Microsoft Certified

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses