Beginners Introduction to SQL and Database Part II
Requirements
- Internet Connection
Description
This is a continuation of our first course, Beginner's Introduction to SQL and Databases, where we set out to create a foundation for data manipulation and data analysis using SQL. If you are new to data analysis and are looking to work with large volumes of data in an efficient and sophisticated way, this is the course for you!
In this course, we continue complete our SQL education using examples and exercises in:
Data and String Manipulation
String Functions covered such as substring, lpad and rpad, and more that will help you deal with text data
Data Aggregation
We take our aggregations to the next level by introduction GROUP BY
Data Profiling
We cover the importance of data profiling for the purpose of understanding, interpreting and communicating information about your data effectively
Sub Queries
We introduce sub queries and provide a number of scenarios on where to use sub queries
Case Statements
A necessary part of your SQL toolkit, CASE statements enable us to customize our analysis using SQL
Joins
Joins are a very foundational part of data analysis. We cover the different types of joins, provide examples and work through challenging exercises that will help you become comfortable with joins
Are you excited about your future in Analytics, Business Intelligence or Data Analysis! You should be, because after this course you'll have a foundation for success!
-- Update --
Please use the following database credentials to connect. The ones in the video are outdated.
Hi all!
Recently I migrated databases to a new server. Please use the following credentials to connect to the new server.
Host: 82.197.82.63
Username: u479841347_user
Password: LearnSQL123
Database: u479841347_sql_course
Port: 3306
Who this course is for:
- Analytics Students
- Analysts
- Product Managers
- Non-technical professionals
Instructor
- 4.4 Instructor Rating
- 1,573 Reviews
- 42,813 Students
- 8 Courses
As Analytics and Business Intelligence professional, I've had the privilege to apply analytical, technical and business expertise across a variety of domains such Marketing, Customer Success, Research and Development, Retail and Ecommerce.
Each course that I create will be aimed at helping you focus on the key aspects of the technical skills you desire to develop for the purpose of immediate application and personal acclimation.
I'm excited that you are here because it means that you want to grow your career and I want to be the there to help. I'm happy to share my experiences so that your track to success is better than mine! I've been in your shoes and together, we will get you where you want to be.