Microsoft SQL Server Online Course


Price:
Sale price€450.00

Data is one of the most critical assets of any business, and thus it needs to be stored and accessed quickly and securely. A database is a repository of data to handle a large amount of information by storing, retrieving, and managing data. Nowadays, almost every company in the world is handled through databases. SQL is the standard query language to work and deal with relational databases. Relational databases manage data in tables, making them efficient and flexible structures for storing and accessing information. SQL is the core of relational databases and allows users to insert, search, update, and delete database records. It also provides many other manipulations and operations, including optimizing and maintaining databases.
TechClass Microsoft SQL Server online course will introduce you to SQL and its essential functionalities for the on-demand and practical applications. Throughout this course, you will learn how to create and manage relational databases. You will gain hands-on experience with SQL Server databases to manage, control, and query data stored in relational databases, as well as stored procedures, functions, indexes, and triggers. By the end of this course, you will be prepared to enter the fantastic world of data engineering towards fantastic job opportunities in the industry.

Learning outcomes

  • Learn about data, databases, relational databases, and data types
  • Learn about SQL and its capabilities, characteristics, and use cases
  • Get familiar with the concept of ER diagram and how it is created
  • Get familiar with primary and foreign keys
  • Learn how to install and set up SQL Server database and Microsoft SQL Server Management Studio
  • Learn how to create tables and databases using SQL statements
  • Get familiar with SQL commands for filtering and sorting data
  • Learn about the different ways of joining tables and the SQL queries that perform them
  • Learn lots of useful SQL statements to query databases and get various types of information
  • Get hands-on experience with Views, Indexes, Functions
  • Learn how to define roles and give permissions to users

Table of contents

Chapter 1: Intro to Course

  • 1.1. Welcome!
  • 1.2. About TechClass Data Science Department
  • 1.3. Learning Outcome
  • 1.4. Your Expectations, Goals, and Knowledge
  • 1.5. Copyright Notice
  • 1.6. Abbreviations

Chapter 2: Introduction

  • 2.1. What are Databases?
  • 2.2. Relational Databases
  • 2.3. Database Management Systems
  • 2.4. Why DBMS?
  • 2.5. What is SQL?
  • 2.6. Most Used Relational Databases
  • 2.7. SQL Elements
  • 2.8. An Overview of SQL Basic Statements
  • 2.9. Quiz

Chapter 3: Requirements for Relational Databases

  • 3.1. Introduction
  • 3.2. Entity
  • 3.3. Attribute
  • 3.4. Relationship
  • 3.5. Cardinality of Relationships
  • 3.6. Entity Relationship Diagram
  • 3.7. Quiz

Chapter 4: Relational Database Modeling

  • 4.1. Introduction
  • 4.2. Relations
  • 4.3. Mapping Entities into Relations
  • 4.4. Primary and Foreign Keys
  • 4.5. Mapping Relationships into Relations
  • 4.6. Data Types
  • 4.7. Quiz

Chapter 5: Microsoft SQL Server Database

  • 5.1. Introduction to Microsoft SQL Server Database
  • 5.2. Download Microsoft SQL Server
  • 5.3. How to Install SQL Server
  • 5.4. SQL Server Management Studio
  • 5.5. Connect to SQL Server
  • 5.6. Quiz

Chapter 6: Basic SQL Statements

  • 6.1. Introduction
  • 6.2. CREATE DATABASE Statement
  • 6.3. CREATE TABLE Statement
  • 6.4. INSERT Statement
  • 6.5. SELECT Statement
  • 6.6. WHERE Clause
  • 6.7. ALTER Statement
  • 6.8. UPDATE Statement
  • 6.9. DELETE Statement
  • 6.10. DROP and TRUNCATE Statements
  • 6.11. Import Flat File to SQL Server
  • 6.12. Quiz

Chapter 7: Filtering, Sorting and Aggregate Data with SQL

  • 7.1. Introduction
  • 7.2. Filtering
  • 7.3. Filtering with Logical Operators
  • 7.4. Wildcards
  • 7.5. Sorting
  • 7.6. Arithmetic Functions
  • 7.7. Aggregations
  • 7.8. Grouping Data
  • 7.9. Conditions on Grouped Data
  • 7.10. Quiz

Chapter 8: Subqueries and Joins in SQL

  • 8.1. Introduction
  • 8.2. Aliases
  • 8.3. INNER JOIN
  • 8.4. LEFT JOIN, RIGHT JOIN
  • 8.5. CROSS JOIN
  • 8.6. SELF JOIN
  • 8.7. Subqueries
  • 8.8. UNION
  • 8.9. Quiz

Chapter 9: More SQL Skills

  • 9.1. Introduction
  • 9.2. Views
  • 9.3. Indexes
  • 9.4. Functions
  • 9.5. Stored Procedures
  • 9.6. Triggers
  • 9.7. Backup and Restores
  • 9.8. Users and Roles
  • 9.9. Reporting
  • 9.10. Quiz

Chapter 10: Some Tips

  • 10.1. Query injection
  • 10.2. Optimization Tips
  • 10.3. Security Tips
  • 10.4. General Tips

Chapter 11: Final Tasks

  • 11.1. Final Project
  • 11.2. Self-study Essay

Chapter 12: Finishing the Course

  • 12.1. What We Have Learned
  • 12.2. Where to Go Next?
  • 12.3. Your Opinion Matters
  • 12.4. Congrats! You did it!

Payment & Security

Payment methods

American Express Apple Pay Mastercard PayPal Visa

Your payment information is processed securely. We do not store credit card details nor have access to your credit card information.


Security

Customer Reviews

Based on 3 reviews
100%
(3)
0%
(0)
0%
(0)
0%
(0)
0%
(0)
P
Peter Weber
Guter Kurs

Ales gut TechClass!

S
Sophie B.
practical and nice

PROJECT, project and always projects. I personally learn a lot when I attempt the final Project.

J
Juha M.
Great course!

Great course and fast support. Explained complicated topics in a very easy way.

You may also like

Recently viewed