SQL Essentials
Understanding SQL Databases
In an increasingly data-driven world, a solid understanding of databases will give you a competitive advantage. In this course, you will learn the basic composition of a database, how they are structured to maximize efficiency and why SQL is the go-to language for querying databases.
Beginner    12 Lessons    120 Minutes    CPD Credits
About This Course
There’s a reason why SQL is the industry standard when working with databases. In this course, you’ll explore the optimal structure and composition of databases, before learning how effective a tool SQL is for interacting with your data.
You’ll discover how to arrange data into separate tables. You’ll explore the different relationships between tables within your database. You will learn how to combine tables using a basic JOIN command in SQL.
By the end of this course, you will have a firm grasp of databases, the utility they bring to a project and how they can be most efficiently and effectively structured. You will also have had chance to try out some SQL queries for yourself.
Learning Outcomes
-
Understand the value of SQL
-
Understand the need for arranging data in separate tables
-
Understand data relationships
-
Perform basic SQL queries
-
Perform SQL joins
Lessons
1. Understanding the Value of SQL
2. Demonstrating an SQL Query
4. Comparing Spreadsheets and Databases
5. Understanding Data Redundancy
6. Removing Redundant Data
Read More
7. Establishing Simple Relationships
8. Understanding Many to Many Relationships
9. Resolving Many to Many Relationships
10. Querying a Database
11. Performing Basic SQL Queries
12. Performing a Basic SQL Join
Learning Certificates
Showcase Your Skills
Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.
When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.
