Course Details
Skill Level
Beginner
Certificate
Available
What You Will Learn?
- The basics of coding in SQL
- How to write commands and queries
- Data types, tables and the rest of the core concepts of SQL
Description
Data Is Key
Data should be the driving factor of any business. You need to collect data and efficiently search through it to make any strategy, operation or marketing decision. There are loads of companies that use large databases. Hence, understanding how to interact with databases is a very employable skill to have if you are looking to start your career as a data scientist or analyst.
The SQL Tutorial You Need
This SQL tutorial is the perfect tool for any beginner looking to learn SQL. What is SQL? In short, it is a programming language that is used for database interaction and manipulation. By starting this SQL tutorial you will be able to learn how to collect data and store it in a database. Moreover, what features you will need to consider if you plan to implement efficient data collection. This course mixes practice, theory and visual representation to provide you with the best educational experience possible. Practice SQL online without any danger of losing your data.
Manage Data With Ease
Learn SQL commands by executing the most useful queries and table aggregation statements by practicing real-time. By the end of this SQL tutorial, you will have a clear understanding of how databases work and how different SQL queries interact with your data. This SQL tutorial goes over all of the most popular SQL commands to teach you every tool you will need for your next project using SQL. What are you waiting for? Enroll and learn SQL!
Requirements
- No pre-knowledge is required - enthusiasm is all you need!
- A PC or Mac is required. Mobile not supported yet;
- No special software is required in advance of the course.
Curriculum
Section 1: Manipulation
- Lecture 1: Introduction
- Lecture 2: Relational Databases
- Lecture 3: Statements & creating tables
- Lecture 4: Insert
- Lecture 5: Select
- Lecture 6: Alter
- Lecture 7: Update
- Lecture 8: Delete
- Lecture 9: Constraints
- Lecture 10: Summary
Section 2: Queries
- Lecture 1: Intro
- Lecture 2: Select
- Lecture 3: Aliases
- Lecture 4: Distinct
- Lecture 5: Where
- Lecture 6: Like I
- Lecture 7: Like II
- Lecture 8: Is Null
- Lecture 9: Between
- Lecture 10: And
- Lecture 11: Or
- Lecture 12: Order By
- Lecture 13: Limit
- Lecture 14: Case
- Lecture 15: Summary
Section 3: Aggregate functions
- Lecture 1: Intro
- Lecture 2: Count
- Lecture 3: Sum
- Lecture 4: Min and Max
- Lecture 5: Average
- Lecture 6: Round
- Lecture 7: Group By (Part 1)
- Lecture 8: Group By (Part 2)
- Lecture 9: Having
- Lecture 10: Summary
Section 4: Multiple tables
- Lecture 1: Intro
- Lecture 2: Combining Tables Manually
- Lecture 3: Combining Tables
- Lecture 4: Inner Join
- Lecture 5: Left Join
- Lecture 6: Primary Key vs Foreign Key
- Lecture 7: Cross Join
- Lecture 8: Union
- Lecture 9: With
- Lecture 10: Summary
