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!