SQL Bootcamp Hands-On Exercises — Learn SQL by Coding (2023)

Focused View

Benjamin Sila

1:01:45

153 View

1 - Relational vs NonRelational Database

1 - Relational vs NoSQL Databases.mp4

03:15

1 - Relational vs NonRelational.html

1 - nosql database what is nosql.zip

2 - SQL Fundamentals

2 - SQL Query Block.mp4

00:59

3 - SQL Command Categories.mp4

01:22

3 - CREATE DATABASE

4 - What is a database.mp4

05:05

4 - SQL CREATE TABLE Statement

4 - Create temporary table using SELECT INTO statement.html

5 - Create Global Temporary Table.html

5 - SQL Create Table.mp4

03:28

6 - Solution Create Temporary Table.mp4

00:20

6 - create-temporary-table.zip

5 - Add Data SQL INSERT INTO Statement

7 - Add data into a table.mp4

01:38

7 - SQL DML Commands.html

8 - 3-insert-into-patient.zip

8 - Solution SQL INSERT INTO.mp4

00:07

6 - Query Data SQL SELECT Statement

9 - SQL SELECT.mp4

02:46

10 - Solution 3 SQL TOP and MySQL LIMIT.mp4

00:17

7 - Filter Data SQL WHERE

11 - Solution.mp4

00:13

12 - Solution.mp4

00:13

13 - Solution.mp4

00:13

8 - SQL TRUNCATE

9 - SELECT DISTINCT Statement

14 - Solution DISTINCT.mp4

00:23

10 - SQL CONCAT Function

15 - Solution SQL CONCAT.mp4

00:27

11 - Filter Data SQL IN Operator

16 - Solution SQL IN.mp4

00:30

17 - Solution SQL IN.mp4

00:34

12 - Filter Data SQL NOT IN Operator

18 - Solution SQL NOT IN.mp4

00:08

13 - Filter Data SQL LIKE Operator

19 - Solution SQL LIKE Operator and Solutions.mp4

02:49

14 - Sort Data ORDER BY Clause

20 - Order By Solution.mp4

00:39

15 - Group Data GROUP BY Clause

21 - Solution SQL GROUP BY.mp4

00:51

16 - Group Data SQL GROUP BY HAVING Clauses

22 - Solution Having Clause.mp4

03:47

17 - Group Data Aggregate Functions

23 - COUNT AVG MIN MAX and SUM.mp4

04:48

24 - SQL GROUP Functions and Solutions.mp4

01:31

18 - SQL Logical Operators

25 - SQL AND OR NOT Logical Operators.mp4

03:32

19 - SQL Between Operator

26 - SQL Between and NOT Between Logical Operator.mp4

02:31

20 - SQL Wildcards

27 - SQL Wildcards Explained.mp4

01:21

21 - IS NULL and NOT NULL Operators

28 - SQL IS NULL and IS NOT NULL.mp4

01:05

22 - SQL ALIASES

29 - SQL ALIAS.mp4

04:35

23 - SQL JOINS

30 - SQL JOINS.mp4

04:26

31 - SQL JOIN LEFT JOIN RIGHT JOIN and UNION Solutions.mp4

00:53

24 - SQL VIEWS

32 - CREATE VIEW DROP VIEW and RENAME VIEW.mp4

00:29

25 - Stored Procedures

9 - Stored Procedure.html

26 - Install SQL Server on Docker Optional

33 - Install SQL Server on Docker Optional.mp4

06:30

33 - Udemy-How-To-Install-SQL-Server-on-Docker.pdf

33 - sql server installation guide.zip

Description

Learn SQL by Coding. Learn SQL with Quizzes, Exercises and Real-World Examples.

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

Who is this for?

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

More details

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 - Learn SQL by Coding (2023),' is the perfect fit for you.
Learn SQL with Hands-On Quizzes, Exercises, Real-World Examples and Enhance Your Coding Skills with interactive SQL coding exercises using SQL programming language â€” 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
Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Benjamin Sila

Instructor's Courses

My name is Benjamin — a data engineer and accomplished leader. I am a Master Data Management (MDM) Engineer adept in IBM® InfoSphere® Master Data Management (InfoSphere MDM) and Informatica Data Governance. I'm a Healthcare Information Exchange (HIE) Subject Matter Expert (SME) with experience designing and building mission-critical Healthcare data products in AWS and Azure. I will teach you in a simple way using a real-world Healthcare use case to keep you engaged and learning the best of what I've learnt in my career. Learning shouldn't be death by PowerPoint. We will practice in a developer environment. This is easy stuff. You can do it. My Subject areas are : SQL, and Data EngineeringWhy Should you learn SQL?SQL is in high demand for data engineering and data analysis.SQL is a de-facto programming language to access data in the Cloud.Data Engineers and Software engineers are required to know SQL. The average base pay of a Data Engineer is $102,864 / yrDon't delay. Your future awaits you. Select a course and begin.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.