Sql Masterclass: From Zero To Hero With Sql Server

The ultimate guide to SQL fundamentals, advanced techniques, and best practices

What you'll learn

Basics of SQL

Install SQL Server

Connect to SQL Server

Create & Delete database

Create, Modify & Delete tables

Various Data Types

Various Column Constraints

Table Relationships

Insert, Update & Delete data

Select statements with various criteria

Various table Joins

Built-in functions

Gropy By & Having

Table Unions

Programming with SQL: Variables, branches, loops

Temporary Tables, Table Variables

Stored Procedures & Functions

Dynamic SQL

Other advanced topics

Requirements

No prior experience with SQL is needed

No programming background is required

Some basic familiarity with computers is helpful

A computer with an internet connection is required

A strong willingness to learn SQL

Description

Do you want to master one of the most popular and powerful data languages in the world? Do you want to learn how to create, manipulate, and query databases with ease and confidence? Do you want to boost your career prospects and become a data-savvy professional?If you answered yes to any of these questions, then this course is for you!SQL (Structured Query Language) is a universal language for working with data. It allows you to communicate with databases and perform various operations on data, such as creating tables, inserting records, updating values, deleting rows, and much more.SQL is also essential for data analysis, as it enables you to extract, filter, aggregate, and transform data from multiple sources and formats. SQL skills are in high demand in many industries and roles, such as business intelligence, data science, web development, and software engineering.Why learn SQL with SQL Server?In this course, you will learn SQL with SQL Server, one of the most popular and powerful database platforms in the world. SQL Server is used by many leading companies and organizations, and it offers many features and tools for data storage, analysis, and management. SQL Server is also the number one database platform in terms of job opportunities. According to LinkedIn Jobs, at the time of writing this course description, SQL Server has more than 90K open jobs in the United States, which is more than double the second position, which is MySQL.What will this course teach you?In this course, you will learn SQL from scratch, starting with the basics and progressing to more advanced topics. You will learn how to:Install SQL Server and SMSS (SQL Server Management Studio), the tools you need to work with SQLExecute SQL statements with SMSS, using different methods and viewsUse Data Definition Language (DDL) to create and delete databases and tablesDefine data types and column constraints for your tablesUse Data Manipulation Language (DML) to insert, update, and delete data from your tablesQuery data using various clauses, operators, functions, and joinsApply sorting, grouping, aggregation, and filtering techniques to your queriesCombine data from multiple tables using unions and viewsWrite SQL programs using variables, conditional logic, loops, and subqueriesUse temporary tables and table variables to store intermediate resultsCreate and use stored procedures and functions to modularize and reuse your codeWrite dynamic SQL to generate and execute SQL statements dynamicallyUpdate data using joins and subqueriesBut this is not just a theoretical course. This is a practical course, where you will get to apply your SQL skills to real-life scenarios. I have designed this course based on my own experience working with SQL in various projects over the past two decades. You will get to solve real-world problems using SQL.What are the benefits of taking this course?By the end of this course, you will have a solid foundation in SQL and be able to write efficient and effective queries for any data-related task. You will also have access many assignments to practice your knowledge and skills.Who is this course for?This course is designed for beginners who have little or no prior experience with SQL. No programming background is required, although some basic familiarity with computers and databases is helpful. All you need is a computer with an internet connection and a willingness to learn.So what are you waiting for? Enroll now and start your journey to becoming a SQL expert!

Overview

Section 1: Introduction

Lecture 1 1. What is SQL

Lecture 2 2. DBMS, Databases, and Tables

Lecture 3 3. Install MS SQL Server and SSMS

Lecture 4 4. Use SSMS to Connect to SQL Servers

Lecture 5 5. How to execute SQL statements

Section 2: Data Definition Language

Lecture 6 6. Create & Delete Database

Lecture 7 7. Create Table & USE database

Lecture 8 8. Data Types Char, Varchar, NChar, NVarchar

Lecture 9 9. Data Types float, real & decimal

Lecture 10 10. Data Types date, time, datetime

Lecture 11 11. Column Constraints NOT NULL

Lecture 12 12. Column Constraints UNIQUE

Lecture 13 13. Column Constraints CHECK

Lecture 14 14. Column Constraints PRIMARY KEY & IDENTITY

Lecture 15 15. Modify existing tables

Lecture 16 16. Assignment 1: Questions

Lecture 17 17. Assignment 1: Answers

Lecture 18 18. Table Relationships 1 to Many

Lecture 19 19. FOREIGN KEY contraint

Lecture 20 20. Table Relationships Many to Many

Lecture 21 21. Assignment 2: Questions

Lecture 22 22. Assignment 2: Answers

Section 3: Data Manipulation Language

Lecture 23 23. Insert data with the INSERT statement

Lecture 24 24. Update data with the UPDATE statement

Lecture 25 25. Delete data with the DELETE statement

Lecture 26 26. TRUNCATE TABLE statement

Lecture 27 27. Assignment 3: Questions

Lecture 28 28. Assignment 3: Answers

Section 4: Query the Data

Lecture 29 29. SELECT statement: column manipulations

Lecture 30 30. SELECT statement: Mathematical Relationships

Lecture 31 31. SELECT statement: And or OR operators

Lecture 32 32. SELECT statement: Wildcards

Lecture 33 33. SELECT statements: IS operator

Lecture 34 34. SELECT statement: DISTINCT

Lecture 35 35. Ordering Data

Lecture 36 36. INNER JOIN

Lecture 37 37. Assignment 4: Question

Lecture 38 38. Assignment 4: Answer

Lecture 39 39. LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN

Lecture 40 40. Built-in functions: CHARINDEX, SUBSTRING

Lecture 41 41. Built-in function REPLACE

Lecture 42 42. Built-in function: CAST

Lecture 43 43. Assignment 5 Question

Lecture 44 44. Assignment 5: Answer

Lecture 45 45. Built-in functions for Dates

Lecture 46 46. Assignment 6. Question

Lecture 47 47. Assignment 6 Answer

Lecture 48 48. Built-in functions: ISNULL

Lecture 49 49. Built-in functions: Aggregation functions

Lecture 50 50. GROUP BY

Lecture 51 51. HAVING

Lecture 52 52. Assignment 7: Questions

Lecture 53 53. Assignment 7: Answers

Lecture 54 54. UNION / UNION ALL

Lecture 55 55. Assignment 8: UNION

Lecture 56 56. Assignment 8: Answers

Lecture 57 57. TOP

Lecture 58 58. VIEW

Section 5: Programming with SQL

Lecture 59 59. Variables

Lecture 60 60. Assignment 9: Variables

Lecture 61 61. Assignment 9: Answer

Lecture 62 62. IF … ELSE …

Lecture 63 63. Assignment 10 IF … ELSE …

Lecture 64 64. Assignment 10: Answer

Lecture 65 65. EXISTS

Lecture 66 66. CASE expression

Lecture 67 67. Assignment 11: Products Analysis with CASE expression

Lecture 68 68. Assignment 11: Answers & Tips for writing complicated queries

Lecture 69 69. WHILE loop

Section 6: Advanced SQL

Lecture 70 70. Temporary Tables

Lecture 71 71. Assignment 12: Temporary Tables

Lecture 72 72. Assignment 12: Answer

Lecture 73 73. Table Variables

Lecture 74 74. Temp Tables vs Table Variables

Lecture 75 75. Stored Procedure #1

Lecture 76 76. Stored Procedure #2

Lecture 77 77. User Defined Functions

Lecture 78 78. Assignment 13: Stored Procedures & Functions

Lecture 79 79. Assignment 13: Answer

Lecture 80 80. Dynamic SQL

Lecture 81 81. UPDATE with JOINS

Lecture 82 82. Subqueries

Lecture 83 83. Derived Tables

Section 7: BONUS SECTION

Lecture 84 Bonus Lecture

If you want to learn SQL to boost your career or switch to a new one, this course is for you. SQL is a highly valued skill in today's data-driven world,If you want to use data to solve challenging business questions and create insightful reports, this course is for you,If you are a business owner, a salesperson, or a marketer who wants to learn how to analyze company data better, this course is for you,If you are a developer who wants to create dynamic and interactive applications using SQL Server, one of the most widely used database systems, this course is for you