The Comprehensive SQL Course 2021

SQL技能在任何地方都具有很高的市场占有率，尤其是在Netflix，Facebook，Amazon，Google等公司中……这种情况不胜枚举……简单的事实是，如果您想从事任何涉及数据的工作，那么就有可能需要知道SQL！

本课程设计用于：

以前没有SQL经验并且希望通过这一备受追捧的编程语言来发展自己技能的个人

那些有经验的人希望重新学习他们的SQL知识

无需下载或安装软件！我们将使用基于Web的应用程序Oracle APEX –您将使用在云上托管的自己的虚拟数据库进行设置！尽管我们将使用Oracle APEX，但该课程旨在突出一些主要的数据库管理系统（例如MySQL和Microsoft SQL Server）之间的关键区别，因此，您在本课程中学到的内容可以应用于支持SQL的所有平台。

本课程的讲座被安排成一小块，一口大小的小块。本课程既要全面，又要简洁，以使学习体验尽可能简单。该课程的每个技术部分都将以测验/作业四舍五入，并为您提供发展实践技能的机会。

该课程将为学生提供一个广泛的问题库部分，其中包含旨在模拟现实世界场景并将本课程中教授的所有不同SQL子句，操作和命令结合在一起的问题和演练！

MP4 | Video: h264, 1280×720 | Audio: AAC, 44100 Hz
Language: English | Size: 2.17 GB | Duration: 5h 26m

What you’ll learn
Become proficient in SQL
Students will be able to apply SQL to real world problems
Boost your CV with one of the most in-demand skills in the data analysis and software development professions
Apply what you’ve learnt across different database management systems
Oracle SQL
MySQL
Microsoft SQL Server

Requirements
Absolutely no prior knowledge required
Description
Want to learn one of the most in-demand skills in the business and technology sector?

Then this course is for you!

SQL skills are highly marketable everywhere, especially in companies like Netflix, Facebook, Amazon, Google… the list goes on and on… The simple fact is that if you want to do any work involving data, then the chances are that you need to know SQL!

This course has been designed for:

Individuals with no prior experience in SQL and looking to make that step to develop their skills in this highly sought after programming language

Those with some experience looking to brush up on their SQL knowledge

No downloads or software installation required! We will be using Oracle APEX which is a web-based application – you will be set up with your own virtual database hosted on the cloud! Although we will be using Oracle APEX the course has been designed to highlight key differences between some of the main Database Management Systems such as MySQL and Microsoft SQL Server, so what you learn in this course can be applied across all platforms supporting SQL.

The lectures in this course are arranged into short, bite-sized chunks. The course is designed to be comprehensive, but also concise in order to make the learning experience as easy as possible. Every technical section of the course will be rounded off with quizzes / assignments and give you an opportunity to develop your practical skills.

The course will provide students with an extensive Question Bank section which is full of questions and walkthroughs designed to emulate real world scenarios and combine together all of the different SQL clauses, operations and commands taught in this course!

In this course you will learn about:

Data Definition Language Commands such as CREATE, DROP, TRUNCATE, ALTER and RENAME

Data Query Language Commands using the SELECT statement

Data Manipulation Commands such as INSERT, UPDATE and DELETE

Data Control Language Commands such as GRANT and REVOKE

Transaction Control Language commands such as COMMIT and ROLLBACK

Data Types

Qualifying Column Names

Aliasing Columns and Tables

Row Level Functions

Aggregation Functions

The Where Clause

The Group By and Having Clauses

The Order By Clause

Single Table and Multiple Table Joins

Subqueries

Database Constraints

Relational Databases and Data Model Design including STAR and SNOWFLAKE Schemas

Who this course is for:
Beginners looking to learn SQL
Individuals with prior SQL knowledge looking to refresh their SQL skills
Individuals looking to pursue a career in software engineering, business intelligence or data analsysis