Master SQL with this hands-on master class
Brief Introduction:
What you’ll learn
- Generate reports and address business challenges.
- Write Complex Queries Using Common Table Expressions (CTEs).
- Lean about GROUP by clause.
- Master SQL Joins and Window Functions (RANK, DENSE_RANK, ROW_NUMBER).
- Master SQL for Data Analytics and Business Intelligence.
- Master SQL for Data Migration and Data Manipulation.
- Create Database Objects.
Course Content
- Introduction –> 8 lectures • 15min.
- Basic Select Statement –> 11 lectures • 8min.
- Data Types –> 6 lectures • 3min.
- Selecting from a table –> 6 lectures • 5min.
- WHERE clause and ORDER BY clause –> 15 lectures • 12min.
- Functions and Operators –> 11 lectures • 8min.
- Regular Expression –> 16 lectures • 14min.
- Conditional Expressions –> 5 lectures • 5min.
- GROUP BY and HAVING Clauses –> 8 lectures • 7min.
- Generating Reports with (CUBE, ROLLUP, GROUPING SET) –> 5 lectures • 4min.
- Joins –> 8 lectures • 7min.
- Window Functions (RANK, DENSE_RANK, ROW_NUMBER) –> 8 lectures • 6min.
- Subqueries –> 11 lectures • 10min.
- Common Table Expressions (WITH Clause) –> 3 lectures • 3min.
- Set Operators(UNION, INTERSECT, EXCEPT) –> 4 lectures • 3min.
- Data Definition(Table) –> 17 lectures • 10min.
- Constraints –> 15 lectures • 12min.
- Data Manipulation –> 16 lectures • 11min.
- Transaction Control –> 4 lectures • 3min.
- Data Definition(Sequences) –> 8 lectures • 6min.
- Data Definition(Views) –> 8 lectures • 5min.
- Data Definition(Users, Roles) and Privileges –> 12 lectures • 9min.
Requirements
Brief Introduction:
The Complete SQL Bootcamp is a hands-on course designed to take you from the basics to a professional level. This comprehensive course will explore the principles of relational databases and the robust SQL programming language. It will equip developers with vital SQL skills to write queries for single and multiple tables, manipulate data within those tables, and create database objects.
Course Overview:
This step-by-step SQL course is designed to improve your SQL skills and is ideal for students who want to become proficient in SQL. Led by an experienced SQL Developer Instructor, this course offers a well-organized and engaging learning experience for those who want to master SQL.
Learning Objectives:
By the end of the course, you will learn how to:
- Retrieve Data using basic SQL SELECT Statements
- Restrict and Sort Data
- Use Aggregate Functions
- Apply Conditional Expressions
- Generate Reports with Aggregated Data Using Group Functions
- Display Data from Multiple Tables Using Joins
- Utilize Window Functions
- Work with Common Table Expressions (CTEs) using the WITH clause
- Manage Data using Subqueries and Advanced Queries
- Manage Tables using DML Statements
- Create Sequences, Synonyms, Indexes, Views, and Schema Objects
Who is this course for?
This course is designed for learners at all levels, from beginners looking for a solid foundation to SQL professionals striving for mastery. No prior knowledge is necessary. It is suitable for users of any database, including Oracle, MySQL, Microsoft SQL Server, Amazon Redshift, and MySQL.