The Complete Guide for SQL with Microsoft SQL Server

The Complete Guide for SQL with Microsoft SQL Server

by Abhilash Nelson
Released April 2023
Publisher(s): Packt Publishing
ISBN: 9781805121503

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Are you interested in learning SQL and database management? Our comprehensive course offers an in-depth look at the fundamentals of databases, including database types, SQL commands, table operations, and advanced concepts such as grouping sets and data types.

In the first few sections, you will learn about data manipulation, including selecting, inserting, updating, and deleting data from a database. The course then dives into more advanced topics such as stored procedures, which allow you to write reusable code that can be executed multiple times. You will also learn about views, which provide a way to organize and simplify complex SQL queries, and triggers, which enable you to automate database actions based on certain events.

The course then delves into transactions, which are essential for ensuring data consistency and reliability. You will also learn about normalization, which is the process of organizing data in a database to reduce redundancy and improve efficiency.

The final sections of the course cover database backup and restore, as well as securing the database against potential threats such as SQL injection attacks. Throughout the course, you will gain hands-on experience by working with real-world examples and scenarios.

By the end of the course, you will have a strong foundation in SQL and database management that will serve you well in any career that involves data management.

What You Will Learn

  • Understand the fundamentals of database design and management
  • Learn to write SQL queries to extract and manipulate data
  • Implement advanced SQL techniques such as subqueries and views
  • Explore the different types of SQL triggers and transactions
  • Create database backups and restore data in case of loss
  • Secure your database against potential threats like SQL injections

Audience

This course is designed for anyone interested in learning SQL and database management, including beginners with little to no prior knowledge of SQL. It is suitable for individuals looking to gain skills for a career in data analysis, database administration, or software development. This course will also benefit professionals looking to enhance their current skill set with SQL knowledge. Students pursuing degrees in computer science, information technology, or related fields can also benefit from this course.

About The Author

Abhilash Nelson: Abhilash Nelson is a pioneering, talented, and security-oriented Android/iOS mobile and PHP/Python web application developer with more than 8 years of IT experience involving designing, implementing, integrating, testing, and supporting impactful web and mobile applications. He has a master's degree in computer science and engineering and has PHP/Python programming experience, which is an added advantage for server-based Android and iOS client applications. Abhilash is currently a senior solution architect managing projects from start to finish to ensure high quality and innovative and functional design.

Table of contents

  1. Chapter 1 : Course Introduction and Table of Contents
    1. Welcome to the Course
  2. Chapter 2 : Database and Database Management Systems
    1. Introduction to Database and Database Management Systems
  3. Chapter 3 : RDBMS and NonRDBMS
    1. Introduction to RDBMS and NonRDBMS
  4. Chapter 4 : SQL Commands
    1. Different Types of SQL Commands
  5. Chapter 5 : Installing Microsoft SQL Server
    1. Step-by-Step Guide to Installing MS SQL
  6. Chapter 6 : Basic Database Operations
    1. Types of Databases in SQL Server and Basic Operations
    2. Essential Database Operations
  7. Chapter 7 : Fundamental Table Operations
    1. SQL Data Types, Constraints, and Keys
    2. Creating and Deleting Tables in SQL
    3. Altering Tables and Viewing Table Schemas in SQL
    4. Data Manipulation and Table Management in SQL
  8. Chapter 8 : Importing Sample Databases
    1. Importing the Northwind Database
  9. Chapter 9 : Using Aggregate Functions in MSSQL
    1. Introduction to Aggregate Functions in MSSQL
    2. Using MAX, SUM, AVG, and COUNT in MSSQL
  10. Chapter 10 : Clauses in MSSQL
    1. Distinct and Group By Clauses
    2. Where Clause and Operators
    3. Order By, Having, and Select Clauses
  11. Chapter 11 : Grouping Sets Clause
    1. Using the GROUPING SETS Clause in SQL Server
    2. Selecting Data with the GROUPING SETS Clause and GROUP BY Clause
  12. Chapter 12 : SQL Basic Operators
    1. Understanding Comparison and NULL Operators in SQL
    2. Using the LIKE and EXISTS Operators in SQL
  13. Chapter 13 : Union and Intersect Operators
    1. Union and Intersect Operators
  14. Chapter 14 : Introduction to Popular Data Types
    1. Exploring Exact Numeric Data Types in SQL Server
    2. Understanding Character, Binary, Date, and Time Data Types in SQL Server
  15. Chapter 15 : Popular Datatypes
    1. Creating and Inserting Data using Popular Data Types
  16. Chapter 16 : Mastering Primary Key Constraints in SQL
    1. Applying Primary Key Constraints
    2. Managing Primary Key Constraints
  17. Chapter 17 : Mastering Foreign Key Constraints in SQL
    1. Creating Foreign Key Constraints
    2. Managing Foreign Key Constraints
  18. Chapter 18 : NOT NULL and UNIQUE Constraints
    1. Using the NOT NULL Constraint
    2. Understanding the UNIQUE Constraint
  19. Chapter 19 : CHECK and DEFAULT Constraints
    1. Working with CHECK Constraints
    2. Understanding DEFAULT Constraints
  20. Chapter 20 : ER Diagrams
    1. ER Diagram Overview - Building Effective Data Models
  21. Chapter 21 : SQL String Functions
    1. SQL Popular String Functions - Part 1
    2. SQL Popular String Functions - Part 2
  22. Chapter 22 : SQL Popular Date Functions
    1. Understanding SQL Server Date Time Functions
    2. Using Date and Time Functions in SQL
  23. Chapter 23 : SQL Popular Mathematical Functions
    1. Math Made Easy: SQL Popular Mathematical Functions
  24. Chapter 24 : SQL Popular Convert Functions
    1. SQL Magic: Popular Convert Functions
  25. Chapter 25 : Joins - Introduction and Table Preparation
    1. Introduction to Joins and Join Types
    2. Table Preparation - Creating the Trainee Table
    3. Table Preparation - Creating the Fee and Semester Tables
  26. Chapter 26 : Inner Join
    1. Exploring Inner Join
  27. Chapter 27 : Outer Join
    1. Mastering Outer Joins
  28. Chapter 28 : Self Join
    1. Exploring Self Join
  29. Chapter 29 : Cross Join
    1. Mastering Cross Joins
  30. Chapter 30 : Stored Procedure Basics
    1. Features and Benefits of Stored Procedures
    2. Creating and Executing Our First Stored Procedure
  31. Chapter 31 : Stored Procedure Parameters and Return
    1. Stored Procedure Input and Return Parameters
  32. Chapter 32 : SQL Subqueries
    1. Writing SQL Subqueries
  33. Chapter 33 : SQL Views
    1. Introduction to SQL Views
  34. Chapter 34 : SQL Triggers - DDL Triggers
    1. SQL Triggers - DDL Triggers
  35. Chapter 35 : SQL Triggers - DML Trigger
    1. SQL Triggers DML Trigger - Introduction and AFTER Trigger
    2. SQL Triggers DML Trigger - INSTEAD OF Trigger and Examples
  36. Chapter 36 : SQL Transactions
    1. SQL Transactions - Introduction and States
    2. SQL Transactions - COMMIT and ROLLBACK Operations
  37. Chapter 37 : Normalization
    1. Introduction to Normalization
  38. Chapter 38 : Database Backup and Restore
    1. Backup and Restore Database
  39. Chapter 39 : Database Security
    1. Securing Your Database

Product information

  • Title: The Complete Guide for SQL with Microsoft SQL Server
  • Author(s): Abhilash Nelson
  • Release date: April 2023
  • Publisher(s): Packt Publishing
  • ISBN: 9781805121503