Course Description:
This course provides a comprehensive introduction to the language of relational databases: Structured Query Language (SQL). You will learn how to read and write complex SQL queries in a relational database (PostgreSQL). The skills you will learn are also largely applicable to any other major database system, such as MySQL, SQL Server, Oracle Database, and much more.The best way to learn SQL is by writing lots of SQL queries; and with this in mind,this course has been designed with over 80 coding challenges where you get to write SQL queries and create database objects. These challenges are based on real-world scenarios and are designed for optimal understanding.
Â
This course has 5 modules; each end with an exercise which helps to gauge your understanding of the learned concepts as you progress through the course.You will start with the basics and soon find yourself writing advanced SQL queries.
- Basic computer literacy including ability to create and manipulate files and install software.
- Â
- You will need to have a Windows-based computer to download and run Microsoft SQL Server.
- Â
- This course is suitable for everyone who has a desire to learn and advance in their career. No prior SQL knowledge is needed.
- Â
- Anyone interested in learning SQL or data analysis!
- Â
- If you work in marketing, finance, local government, accounting, operations, sales, manufacturing, healthcare, financial services, or any other industry/function that collects data.
- Â
- Someone who wants to learn skills that give them the potential to earn a high salary and have a rewarding career
- Â
- Learn structured query language (SQL) to an intermediate/advanced level.
- Â
- Be able to write data retrieval queries and evaluate the result set.
- Â
- Be able to write SQL statements that modifies existing data.
- Â
- Be able to write SQL statements that create database objects.
- Â
- Understand the structure and design of relational databases.
- Â
- Understand the importance and major issues of database security and the maintenance of data integrity.
- Â
Data Analysis with Python Course Outline
The Data Analysis with SQL course starts with an introduction of the concepts of databases and relational database management systems. You will be guided through the installation of Azure Data Studio.
In this module, you will be introduced to databases. You will create a database instance. You will learn some of the basic SQL statements such as SELECT, WHERE, COUNT, DISTINCT and many more. You will learn how to use string patterns and ranges to search data and how to sortdata. You will write and practice basic SQL hands-on on a live database.
In this module, you will learn how to group data in result sets using the GROUP BY and HAVING statements. You will also practice composing nested queries and execute select statements to access data from multiple tables using JOIN statements.
In this module, you will learn how to build more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and window functions. You will learn how to use conditional expressions with statements such as CASE, COALESCE and NULLIF.
In this module, you will explore the fundamental concepts behind databases, tables, and the relationships between them. You will then create an instance of a database, discover SQL statements that allow you to create and manipulate tables, and then practice them on your own live database.