SQL for Beginners course

SQL for Beginners

$280.00
8 hours
Beginner
Instructor Led OnlineTraining

Course Overview

SQL stands for Structured Query Language designed for managing data in relational database management systems and it is one of the most important, widely used programming languages in the business world. SQL is essential for any professional including technical and non-technical roles like data/business analyst, marketing, operations, finance, sales, and support.

This training course will teach you the essentials of SQL. In this course you’ll learn how to use SQL to create a database & tables, retrieve data from a database, filter data, aggregation, use functions, subqueries, join multiple tables and create views.

Skills Required

You should have basic computing knowledge.
Familiarity with relational database concepts is helpful but not essential.

Understanding Database and SQL
- Database and DBMS
- Introduction to MS SQL Server
- Introduction to Azure SQL Database
- Introduction to SQL and T-SQL
Structured Query Language (SQL) and T-SQL
- Introduction to SQL and Transact-SQL (T-SQL)
- USE Command
- Create Databases using SQL
- Drop Databases using SQL
- Creating, Altering and Removing Tables using SQL
- Commenting and Saving SQL
Data Manipulation Language
- Introduction to DML
- INSERT statements
- UPDATE statements
- DELETE statements
Retrieving Data
- Introduction to the SELECT Statement
- Retrieving Columns
- Using DISTINCT to find unique values
- Concatenating Columns
- Creating Calculated Field
- Limiting Results by using TOP Clause
Filtering Data
- Using WHERE for filtering
- Using the NOT operator
- Using the LIKE operator
- Using IS NULL and IS NOT NULL
Sorting Data Using ORDER BY
- Sorting Data
- Sorting by Multiple Columns
- Specifying Sort Direction
Aggregation and grouping
- COUNT, SUM, AVG, MIN, MAX
- Grouping by fields
- Using HAVING to filter results
Using Functions
- LEFT and Right
- SUBSTRING
- MONTH
- YEAR
- DAY
Combining multiple SELECT Results
- UNION
- UNION ALL
Using Subqueries
- Introduction to Subqueries
- Filtering by Subquery
- Subqueries in the SELECT clause
Joins
- Inner joins
- Table aliases
- Left and right outer joins
- Full outer joins
Creating and Using Views
- Introduction of Views
- Creating Views using SQL

Related Courses

Programming With C# for Beginners

$420
Python Programming for Beginners

$420

SQL for Beginners Training Course