What you'll learn
Know the ins-and-outs of querying a SQL database
Create your own databases, tables, stored procedures, functions, and more
Use real world examples to build elegant and efficient SQL queries
Become familiar with the most popular enterprise-level database management tools

Description
This isn't just a theory course - you will learn SQL using practical, real-world examples, and enterprise-level tools.

SQL is an incredibly in-demand skill for software developers, data scientists, and business analysts alike. Bring your career to the next level with an understanding of SQL and database management.

Become job ready - use this course to learn to use SQL the way you would in an enterprise setting.

In this course we will cover

The three primary pillars of SQL:

Data query language (DQL)

Data modification language (DML)

Data definition language (DDL)

Creating and modifying tables, views, stored procedures, functions, and more.

Analyzing large datasets with aggregate functions.

Primary, foreign, and composite keys.

Joining multiple database tables together.

Logical operators and comparison operators.

String functions, mathematical functions, and date functions.

Advanced SQL queries using self-joins and sub-queries.

Installation and use of Microsoft SQL Server Management Studio as well as SQL Server.

...and much more!

This course has something for all learning styles - each module is taught through lectures, practical examples, live coding, and assessments. You can listen to the lectures, code along through the practical examples, and then test yourself using the assessments to monitor your progress.

Refer to the promotional video and free previews for a glimpse into what the course has to offer, and the course structure.

Who this course is for
Developers looking to add database components to their applications
Those interested in learning SQL, and how to use SQL in a real-world enterprise environment
Anyone interested in data science and analytics
Anyone looking to add SQL to their resume with confidence