SQL & Databases Course
Next cohort starts Sep 23rd, 2023
About the course
Data Querying and summarization are essential skills in your journey to becoming an adept data scientist. SQL is one of the most popular data management languages, allowing you to work with several databases like SQL Server, Oracle, PostGreSQL, MariaDB, among many more. This course teaches you to transform and manipulate data with SQL and how SQL is used to generate business insights.
You will also learn:
- What are design schemas
- How relationships are defined between tables
- How data transformation can be automated using stored procedures
- How to query data in relational database management systems (RDBMS) and NoSQL databases
Curriculum
Project
New-Wheels, a vehicle resale company, has launched an app with an end-to-end service from listing the vehicle on the platform to shipping it to the customer's location. This app also captures the overall after-sales feedback given by the customer. In this project, we will create a pipeline to organize and maintain the data using SQL database and answer the business questions and create a quarterly business report for the CEO of the company.
Tools & Concepts
MySQL, Normalizing Data Schemas with DDL, Querying the Data with DML, Tables Views and Functions, Automating data transformation with Stored Procedures
Get to Know Your Mentors
Earn Your Certificate
Showcase & verify your SQL expertise with a certificate of completion from Great Learning which you can share in the certifications sections of your LinkedIn profile, on printed resumes, CVs or other documents.
Note: The image is for illustrative purposes only. The actual certificate may be subject to change at the discretion of Great Learning.
This course is for you, if you
- Want to build hands-on SQL skills, such as Querying, Manipulating, and Managing data.
- Are an early career or mid-level professional looking to gain skills in creating databases.
- Want to learn how SQL is used in Data Science projects.
- Are looking to grow in the field of data engineering and data architecture.
You will learn to
- Use SQL as a Data Manipulation Language (DML).
- Design Data Pipelines in MySQL Database by using Data Architecture concepts.
- Create Data Definition Language (DDL) to create user-defined functions and automate data transformation using stored procedures.
- Generate insights from a huge volume of inconsistent data.
Why SQL?
- Fluency in SQL is required in more than 42% of all data jobs.
- SQL is recognized by the American National Standards Institute as an essential part of the IT Industry.
- SQL is the primary data management tool at leading organizations, such as Microsoft, Oracle, Google, among many others.
- SQL is compatible with industry databases, such as MS SQL Server, Oracle Database, MySQL, and many others.
About The Course
Data Querying and summarization are essential skills in your journey to becoming an adept data scientist. SQL is one of the most popular data management languages, allowing you to work with several databases like SQL Server, Oracle, PostGreSQL, MariaDB, among many more. This course teaches you to transform and manipulate data with SQL and how SQL is used to generate business insights.
You will also learn:
- What are design schemas
- How relationships are defined between tables
- How data transformation can be automated using stored procedures
- How to query data in relational database management systems (RDBMS) and NoSQL databases
Curriculum
Week 0 | Pre-work
The objective of this session is to ensure that you are able to properly install MySQL on your system.
Week 1 | Querying data with SQL
1 Real-world Case Study
Key Skills
- Importing the database
- Fetching the data
- Filtering the data
The most fundamental skill to be developed by anyone working in the data field is to know how to query data using a structural language (SQL) and organize data for analysis and insight generation.
In this module, you will learn how to setup MySQL, become acquainted with MySQL and learn how to write basic queries like SELECTING and FILTERING data. You will also learn how to extract data from databases and filter the dataset that suits your business requirements.
Week 2 | Advanced Querying to Extract Business Insights
1 Real-world Case Study
Key Skills
- Aggregating the data
- Joining the data
- Window functions
- Sub-queries
- Order of execution
Data is not always in the shape that you need it in to calculate your key business metrics. You'll need to be able to transform, aggregate, join, use window functions and subqueries to get data into the shape you need to answer your business questions.
In this module, you will learn how to aggregate data using SUM, AVG, MIN, MAX, Join data using INNER, LEFT, RIGHT, FULL, and SELF joins, Calculate metrics at different levels of detail by using window functions like ROW_NUMBER, RANK, DENSE_RANK, LEAD, and LAG function. In addition, for modular execution, you will need to write queries within queries to accomplish a variety of tasks and for this you will learn how to use SUB-QUERIES.
Week 4 | Hands-on Project Lab session
Practice Project
In this hands-on, 2-hour, mentor-guided project solution session you will utilize everything you have learned so far and to work on a problem statement.
Week 5 | Project Support Session
The primary objective of this session is to address all project-related questions and review all previously covered concepts to help you complete your project.
Week 6 | Project Submission
Submit your 2-week long, hands-on project to ensure that you have learned how to utilize SQL to generate insights to solve a real-world problem.
Week 0 | Pre-work
The objective of this session is to ensure that you are able to properly install MySQL on your system.
Week 1 | Querying data with SQL
1 Real-world Case Study
The most fundamental skill to be developed by anyone working in the data field is to know how to query data using a structural language (SQL) and organize data for analysis and insight generation.
In this module, you will learn how to setup MySQL, become acquainted with MySQL and learn how to write basic queries like SELECTING and FILTERING data. You will also learn how to extract data from databases and filter the dataset that suits your business requirements.
Key Skills
- Importing the database
- Fetching the data
- Filtering the data
Project
New-Wheels, a vehicle resale company, has launched an app with an end-to-end service from listing the vehicle on the platform to shipping it to the customer's location. This app also captures the overall after-sales feedback given by the customer. In this project, we will create a pipeline to organize and maintain the data using SQL database and answer the business questions and create a quarterly business report for the CEO of the company.
Tools & Concepts
MySQL, Normalizing Data Schemas with DDL, Querying the Data with DML, Tables Views and Functions, Automating data transformation with Stored Procedures
Get to Know Your Mentors
Ali Masri
Lead Data Engineer - Ford Motor Company
Hassan Waqar Ahmad
Customer Engineer Specialist - Data Analytics, Google
Abhijit Krishna Menon
Data Engineer - Amazon
Earn Your Certificate
Showcase & verify your SQL expertise with a certificate of completion from Great Learning which you can share in the certifications sections of your LinkedIn profile, on printed resumes, CVs or other documents.
Note: The image is for illustrative purposes only. The actual certificate may be subject to change at the discretion of Great Learning.
Week 3 | Data Modelling and Architecture
1 Real-world Case Study
The primary usage of a SQL database is to "organize & automate" data movement so that organisations can operationalize the backend to seamlessly generate insights. In order to do this, you need to be adept at the concepts of data architecture and how to move data through the Ingestion, Transaction, and Consumption layers—so that your clean, standardized, and filtered data can be directly used for analysis and insight generation.
In this module, you will understand how to create databases, how to ingest data into SQL tables, how to create stored procedures and functions to automate data movement, and how to create views for business consumption.
Key Skills
- Data Pipeline
- Data Understanding
- Architecture Solution Diagram
- Creating - Table, Stored Procedure View, Function
- Data Ingestion in table using stored procedure
Get Started
By submitting the form, you agree to our Terms and Conditions and our Privacy Policy.
Please share your contact details and the team will reach out to you soon.
Learn from highly skilled professionals in the field of Data Science who have engineered data solutions across industry verticals & have real-world, hands-on work experience with SQL & Databases
Self Paced - NoSQL Databases
NoSQL Databases, also called “non-SQL” or "not only SQL", are used for storing data differently in a non-tabular fashion instead of relational tables. Here, the data is not stored in any predetermined structure with relationships.
- File formats and comparison
Gain familiarity with comparing various file formats in a NoSQL database. - Introduction to MongoDB
MongoDB is a cross-platform document-oriented NoSQL database, which provides scalability and flexibility, along with querying and indexing. Learn how to implement a NoSQL database using MongoDB. - SQL operations
SQL operations are used to perform logical operations, arithmetic operations, and many other operations.
This course is for you, if you
- Want to build hands-on SQL skills, such as Querying, Manipulating, and Managing data.
- Are an early career or mid-level professional looking to gain skills in creating databases.
- Want to learn how SQL is used in Data Science projects.
- Are looking to grow in the field of data engineering and data architecture.
You will learn to
- Use SQL as a Data Manipulation Language (DML).
- Design Data Pipelines in MySQL Database by using Data Architecture concepts.
- Create Data Definition Language (DDL) to create user-defined functions and automate data transformation using stored procedures.
- Generate insights from a huge volume of inconsistent data.
Why SQL?
- Fluency in SQL is required in more than 42% of all data jobs.
- SQL is recognized by the American National Standards Institute as an essential part of the IT Industry.
- SQL is the primary data management tool at leading organizations, such as Microsoft, Oracle, Google, among many others.
- SQL is compatible with industry databases, such as MS SQL Server, Oracle Database, MySQL, and many others.
Week 2 | Advanced Querying to Extract Business Insights
1 Real-world Case Study
Data is not always in the shape that you need it in to calculate your key business metrics. You'll need to be able to transform, aggregate, join, use window functions and subqueries to get data into the shape you need to answer your business questions.
In this module, you will learn how to aggregate data using SUM, AVG, MIN, MAX, Join data using INNER, LEFT, RIGHT, FULL, and SELF joins, Calculate metrics at different levels of detail by using window functions like ROW_NUMBER, RANK, DENSE_RANK, LEAD, and LAG function. In addition, for modular execution, you will need to write queries within queries to accomplish a variety of tasks and for this you will learn how to use SUB-QUERIES.
Key Skills
- Aggregating the data
- Joining the data
- Window functions
- Sub-queries
- Order of execution
Week 3 | Data Modelling and Architecture
1 Real-world Case Study
The primary usage of a SQL database is to "organize & automate" data movement so that organisations can operationalize the backend to seamlessly generate insights. In order to do this, you need to be adept at the concepts of data architecture and how to move data through the Ingestion, Transaction, and Consumption layers—so that your clean, standardized, and filtered data can be directly used for analysis and insight generation.
In this module, you will understand how to create databases, how to ingest data into SQL tables, how to create stored procedures and functions to automate data movement, and how to create views for business consumption.
Key Skills
- Data Pipeline
- Data Understanding
- Architecture Solution Diagram
- Creating - Table, Stored Procedure View, Function
- Data Ingestion in table using stored procedure
Week 4 | Hands-on Project Lab session
In this hands-on, 2-hour, mentor-guided project solution session you will utilize everything you have learned so far and to work on a problem statement.
Practice Project
Week 5 | Project Support Session
The primary objective of this session is to address all project-related questions and review all previously covered concepts to help you complete your project.
Week 6 | Project Submission
Submit your 2-week long, hands-on project to ensure that you have learned how to utilize SQL to generate insights to solve a real-world problem.
Self Paced - NoSQL Databases
NoSQL Databases, also called “non-SQL” or "not only SQL", are used for storing data differently in a non-tabular fashion instead of relational tables. Here, the data is not stored in any predetermined structure with relationships.
- File formats and comparison
Gain familiarity with comparing various file formats in a NoSQL database. - Introduction to MongoDB
MongoDB is a cross-platform document-oriented NoSQL database, which provides scalability and flexibility, along with querying and indexing. Learn how to implement a NoSQL database using MongoDB. - SQL operations
SQL operations are used to perform logical operations, arithmetic operations, and many other operations.
Ali Masri
Lead Data Engineer - Ford Motor Company
Learn from highly skilled professionals in the field of Data Science who have engineered data solutions across industry verticals & have real-world, hands-on work experience with SQL & Databases
Hassan Waqar Ahmad
Customer Engineer Specialist - Data Analytics, Google
Abhijit Krishna Menon
Data Engineer - Amazon
Structured Query Language (SQL) has been one of the cornerstones of database management and is an indispensable part of data science. With the amount of data increasing exponentially, SQL plays an essential role in organizing incomprehensible data.
Organizations across all industries are relying on SQL to manage critical business data, with many roles requiring proficiency in the tool.
SQL & Databases Course
Structured Query Language (SQL) has been one of the cornerstones of database management and is an indispensable part of data science. With the amount of data increasing exponentially, SQL plays an essential role in organizing incomprehensible data.
Organizations across all industries are relying on SQL to manage critical business data, with many roles requiring proficiency in the tool.
Next cohort starts Sep 23rd, 2023
