What you'll learn
Solve 100 exercises using the SQL programming language
Learn SQL with practical hands-on SQL Exercises on SQL Server and MySQL
Create database objects — tables, views and stored procedures using DML commands
Add data to a database using DML – Data Manipulation Language commands — SQL INSERT INTO
Retrieve data using DQL – Data Query Language commands
INNER, OUTER and UNION joins to combine table(s) and find patterns in data
Create complex SQL queries to filter and aggregate data
Aggregate functions COUNT(), MAX(), MIN(), SUM(), AVG() to analyze and group data
SQL Aliases to enhance SQL code readability and functionality
Delete data using TRUNCATE
Data analysis using SQL Wildcards and SQL logical operators
Analyze data using IS NULL, IS NOT NULL, BETWEEN and NOT BETWEEN etc.
Create and execute Stored Procedures
Practice for your SQL interview
Requirements
No programming experience needed — you will learn everything you need to know.
No set-up required — Everything needed to practice and master SQL is provided.
Write SQL and get immediate response and answers interactively.
Description
Are you ready to take your SQL skills to the next level? Do you want to become proficient in SQL, the industry-standard language for managing and manipulating data? Look no further! Our Udemy course, 'SQL Bootcamp Hands-on Exercises — SQL Server — Part 1 (2023),' is the perfect fit for you.Practice 100 SQL exercises interactively using SQL programming language — interactive SQL exercises with explanations. This course contains 100 SQL exercises to TEST your knowledge of SQL using a fictional Healthcare database. You will practice by writing SQL queries to create a database, create tables and insert data into tables.You will run SQL operations to add, retrieve and analyze data in a database using sorting, filtering and grouping.This complete SQL bootcamp will test and solidify your SQL skills. This course is perfect for anyone — from beginner to master SQL developers. This course is perfect if you have to prepare for a SQL interview, and you need a one-stop shop for all your exercises. The SQL exercises in this course are interactive. The exercises provide hints when you make an error, so you can correct the mistake and proceed with coding.The solutions to the problems and their explanations are provided after each section. Practice and write SQL right inside the course. Run the SQL code without switching programs or screens. You will solidify your knowledge of : DML - Data Manipulation Language commands to insert or update or delete data in the database.DDL - Data Definition Language commands to modify the data in the database.DQL - Data Query Language commands to access and retrieve data in a database.If you are looking for new and exciting challenges, this is the right course for you. You will go from zero to hero in SQL. This course is fit for those interested in learning and refreshing their SQL knowledge. This course is comprehensive and up to date for students, data engineers, data analysts and other IT professionals.Why should you take this course?SQL is in high demand for data engineering and data analysis.With the growth of cloud computing and generation of petabytes of data, SQL is one of the de-facto programming languages to access and manipulate data stored on the Cloud.Data Engineers and Software engineers are required to know SQL
Overview
Section 1: Relational vs Non-Relational Database
Lecture 1 Relational vs NoSQL Databases
Section 2: SQL Fundamentals
Lecture 2 SQL Query Block
Lecture 3 SQL Command Categories
Section 3: CREATE DATABASE
Lecture 4 What is a database?
Section 4: SQL CREATE TABLE Statement
Lecture 5 SQL Create Table
Lecture 6 Solution - Create Temporary Table
Section 5: Add Data - SQL INSERT INTO Statement
Lecture 7 Add data into a table
Lecture 8 Solution - SQL INSERT INTO
Section 6: Query Data - SQL SELECT Statement
Lecture 9 SQL SELECT
Lecture 10 Solution 3 - SQL TOP and MySQL LIMIT
Section 7: Filter Data - SQL WHERE
Lecture 11 Solution
Lecture 12 Solution
Lecture 13 Solution
Section 8: SQL TRUNCATE
Section 9: SELECT DISTINCT Statement
Lecture 14 Solution - DISTINCT
Section 10: SQL CONCAT () Function
Lecture 15 Solution - SQL CONCAT ()
Section 11: Filter Data - SQL IN Operator
Lecture 16 Solution - SQL IN
Lecture 17 Solution - SQL IN
Section 12: Filter Data - SQL NOT IN Operator
Lecture 18 Solution - SQL NOT IN
Section 13: Filter Data - SQL LIKE Operator
Lecture 19 Solution - SQL LIKE Operator and Solutions
Section 14: Sort Data - ORDER BY Clause
Lecture 20 Order By Solution
Section 15: Group Data - GROUP BY Clause
Lecture 21 Solution - SQL GROUP BY
Section 16: Group Data - SQL GROUP BY + HAVING Clauses
Lecture 22 Solution Having Clause
Section 17: Group Data - Aggregate Functions
Lecture 23 COUNT, AVG, MIN, MAX and SUM
Lecture 24 SQL GROUP Functions and Solutions
Section 18: SQL Logical Operators
Lecture 25 SQL AND, OR, NOT Logical Operators
Section 19: SQL Between Operator
Lecture 26 SQL Between and NOT Between Logical Operator
Section 20: SQL Wildcards
Lecture 27 SQL Wildcards Explained
Section 21: IS NULL and NOT NULL Operators
Lecture 28 SQL IS NULL and IS NOT NULL
Section 22: SQL ALIASES
Lecture 29 SQL ALIAS
Section 23: SQL JOINS
Lecture 30 SQL JOINS
Lecture 31 SQL JOIN, LEFT JOIN, RIGHT JOIN and UNION Solutions
Section 24: SQL VIEWS
Lecture 32 CREATE VIEW, DROP VIEW and RENAME VIEW
Section 25: Stored Procedures
Section 26: Install SQL Server on Docker (Optional)
Lecture 33 Install SQL Server on Docker (Optional)
SQL Developers,Computer Science Students,Data Analysts,Data Engineers,Clinical Informaticists,Data Scientists,Software Engineers,Anyone who wants to learn and test SQL knowledge and proficiency,Anyone studying for a SQL interview,Software Testers


Homepage

https://www.udemy.com/course/sql-bootcamp-hands-on-exercises-master-sql-part-1-2022/