SQL Masterclass: From Zero to Hero with SQL Server (2024)

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

Created by: Frank Liu
Full Stack Senior Software Developer

What Will I 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

Target audience

• 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