It’s Festive Season! Enjoy 30% Off
Use code FESTIVE30 at checkout
+100 XP
+ Certificate
Interactive SQL Tutorial: Learn SQL Commands and Practice SQL Online
Interactive SQL tutorial: learn what is SQL & SQL data types
English
Popular
Featured
5 other students just bought this course!
watching now
271
Students Beginner
What Will You 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
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
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.
About the Instructor
Reviews
315
Students
173,732
Massive audience
Courses
16
BitDegree Foundation is the team of in-house BitDegree course creators who offers the possibility to learn in a fun and engaging way. Their interactive courses are visually appealing, educational, and functional all at the same time.
Needless to say, more than one person has worked to make these courses available for you to learn from. BitDegree is combining the efforts of multiple experts to bring you the highest quality educational material.
On BitDegree, learning on these interactive courses, you can improve your programming skills. You can find a variety of courses from the basic ones to more advanced level trainings. You can learn such programming languages as Java, JavaScript, Python, HTML, CSS, and others. If you are an absolute beginner and want to find the easiest way to learn coding, these courses are the perfect option for you. So, choose the best course for yourself and deep dive into learning!
Course reviews
