SQL Database Design for Beginners
A 41-part course with LearnToProgram
Start Free Preview Start CourseCourse Overview
Teacher
LearnToProgram is a leading publisher of web, mobile and game development courses that are used by individuals and companies worldwide. Based outside of Hartford, Connecticut, the LearnToProgram team is dedicated to teaching more people to program... View ProfileDetails
- Total Time 5 hr, 28 min
- Lessons 41
- Attachments 142
- Exercises 122
-
185 CQ
41 Lessons in This Course
-
6 minFREEDatabases lesson 1Free4 CQ
Want to build a relational database with SQL? In this lesson, review the SQL relational database, and learn how the main elements of a database work together!
with LearnToProgramWant to build a relational database with SQL? In this lesson, review the SQL relational database, and learn how the main elements of a database work together!
-
6 minDatabases lesson 24 CQ
Eager to develop your own SQL database? Follow along with this lesson and learn the principles of database application development!
with LearnToProgramEager to develop your own SQL database? Follow along with this lesson and learn the principles of database application development!
-
13 minDatabases lesson 37 CQ
Interpreting tables and their relationships is a key component of SQL database construction. Learn to examine relationships between data in this lesson!
with LearnToProgramInterpreting tables and their relationships is a key component of SQL database construction. Learn to examine relationships between data in this lesson!
-
9 minDatabases lesson 45 CQ
Ready to write queries for your SQL database? Before you begin, learn to set database constraints to use relationships to sensibly pool your data together!
with LearnToProgramReady to write queries for your SQL database? Before you begin, learn to set database constraints to use relationships to sensibly pool your data together!
-
5 minDatabases lesson 53 CQ
Looking to polish and refine your newly created SQL database? Learn how to query in an SQL database and discover how to read data, make modifications, and more!
with LearnToProgramLooking to polish and refine your newly created SQL database? Learn how to query in an SQL database and discover how to read data, make modifications, and more!
-
4 minDatabases lesson 63 CQ
Ready to make modifications to a particular database? Learn the main SQL database commands and discover how to insert data, update, delete, and much more!
with LearnToProgramReady to make modifications to a particular database? Learn the main SQL database commands and discover how to insert data, update, delete, and much more!
-
7 minDatabases lesson 74 CQ
Optimize your SQL database by using query tools to analyze data! Follow along with Learn to Program and review how to work with SQL editors and use phpMyAdmin.
with LearnToProgramOptimize your SQL database by using query tools to analyze data! Follow along with Learn to Program and review how to work with SQL editors and use phpMyAdmin.
-
5 minDatabases lesson 83 CQ
Refine your querying ability by learning to use the SQL database select statement! Learn how to select from tables created within the database schema.
with LearnToProgramRefine your querying ability by learning to use the SQL database select statement! Learn how to select from tables created within the database schema.
-
4 minDatabases lesson 93 CQ
Bogged down by data duplicates and redundant info in your SQL database? Learn how to filter SQL database columns to eliminate duplicates and consolidate info.
with LearnToProgramBogged down by data duplicates and redundant info in your SQL database? Learn how to filter SQL database columns to eliminate duplicates and consolidate info.
-
8 minDatabases lesson 105 CQ
Ready to more accurately organize and tailor your SQL database information? In this lesson, learn the principles of SQL database output formatting.
with LearnToProgramReady to more accurately organize and tailor your SQL database information? In this lesson, learn the principles of SQL database output formatting.
-
5 minDatabases lesson 113 CQ
Looking to ensure that your SQL database columns have simple names within your programming language? Learn to add convenient column aliases to your database.
with LearnToProgramLooking to ensure that your SQL database columns have simple names within your programming language? Learn to add convenient column aliases to your database.
-
4 minDatabases lesson 123 CQ
Narrow results records in your SQL database by learning to implement WHERE clauses. Learn how to apply WHERE clauses while simultaneously using other features.
with LearnToProgramNarrow results records in your SQL database by learning to implement WHERE clauses. Learn how to apply WHERE clauses while simultaneously using other features.
-
6 minDatabases lesson 134 CQ
In this lesson, learn how to filter data by name, number, or date with simple SQL operators such as between, less than, greater than, and not equal to.
with LearnToProgramIn this lesson, learn how to filter data by name, number, or date with simple SQL operators such as between, less than, greater than, and not equal to.
-
6 minDatabases lesson 144 CQ
Ever wonder how to filter for multiple conditions at once? This lesson explains how to do just that with the SQL “or” operator and the SQL “and” operator!
with LearnToProgramEver wonder how to filter for multiple conditions at once? This lesson explains how to do just that with the SQL “or” operator and the SQL “and” operator!
-
9 minDatabases lesson 155 CQ
Ready to learn some more key SQL operations to filter data? This lesson introduces “like”, “in”, and “null” operators, and shows how to calculate values!
with LearnToProgramReady to learn some more key SQL operations to filter data? This lesson introduces “like”, “in”, and “null” operators, and shows how to calculate values!
-
4 minDatabases lesson 163 CQ
Interested in tallying up the number of items in a database table? Learn how to use the SQL count function—the simplest way to do just that!
with LearnToProgramInterested in tallying up the number of items in a database table? Learn how to use the SQL count function—the simplest way to do just that!
-
7 minDatabases lesson 174 CQ
SQL aggregate functions are an amazing way to consolidate data! In this lesson, learn how sum, average, max, and min work and how to code them!
with LearnToProgramSQL aggregate functions are an amazing way to consolidate data! In this lesson, learn how sum, average, max, and min work and how to code them!
-
7 minDatabases lesson 184 CQ
Ready for a crash course in SQL aggregate functions? This lesson goes over the major do’s and don’ts for consolidating data with this programming language!
with LearnToProgramReady for a crash course in SQL aggregate functions? This lesson goes over the major do’s and don’ts for consolidating data with this programming language!
-
9 minDatabases lesson 195 CQ
Looking for a way to merge result sets in SQL? The SQL union operator can help combine multiple tables into a single, easy to read results set!
with LearnToProgramLooking for a way to merge result sets in SQL? The SQL union operator can help combine multiple tables into a single, easy to read results set!
-
9 minDatabases lesson 205 CQ
Ready to start using the SQL group by clause to help organize data? Instead of consolidating information by table, learn how to group by criteria!
with LearnToProgramReady to start using the SQL group by clause to help organize data? Instead of consolidating information by table, learn how to group by criteria!
-
4 minDatabases lesson 213 CQ
It’s time to start filtering consolidated data! Find out how to use the SQL having clause with SQL group by to filter information by criteria.
with LearnToProgramIt’s time to start filtering consolidated data! Find out how to use the SQL having clause with SQL group by to filter information by criteria.
-
5 minDatabases lesson 223 CQ
Ready to learn more do’s and don’ts of SQL grouping? Find out how to avoid issues in data consolidation by using the SQL group by clause the right way!
with LearnToProgramReady to learn more do’s and don’ts of SQL grouping? Find out how to avoid issues in data consolidation by using the SQL group by clause the right way!
-
6 minDatabases lesson 234 CQ
Wondering how to create a SQL alias for a data table? This straightforward lesson offers a run-down on how to code table aliases and save a bunch of time!
with LearnToProgramWondering how to create a SQL alias for a data table? This straightforward lesson offers a run-down on how to code table aliases and save a bunch of time!
-
10 minDatabases lesson 246 CQ
Curious how to combine tables based on data? Try using an SQL inner join! This lesson shows how to code inner joins using the implicit and explicit methods.
with LearnToProgramCurious how to combine tables based on data? Try using an SQL inner join! This lesson shows how to code inner joins using the implicit and explicit methods.
-
12 minDatabases lesson 257 CQ
Now that the inner join has been covered, it’s time to dive into the SQL outer join! This lesson covers each type: left join, right join, and full join.
with LearnToProgramNow that the inner join has been covered, it’s time to dive into the SQL outer join! This lesson covers each type: left join, right join, and full join.
-
7 minDatabases lesson 264 CQ
Why would a developer be interested in joining a table to itself? This lesson answers just that question and demonstrates how to code for a SQL self join!
with LearnToProgramWhy would a developer be interested in joining a table to itself? This lesson answers just that question and demonstrates how to code for a SQL self join!
-
17 minDatabases lesson 279 CQ
Ready to learn how to join multiple tables in SQL? Now that the basics have been covered, find out how to work with more complex table joins!
with LearnToProgramReady to learn how to join multiple tables in SQL? Now that the basics have been covered, find out how to work with more complex table joins!
-
13 minDatabases lesson 287 CQ
In this lesson, learn how to use scalar and single column subqueries as filter conditions for a main query in the SQL programming language, using example code.
with LearnToProgramIn this lesson, learn how to use scalar and single column subqueries as filter conditions for a main query in the SQL programming language, using example code.
-
6 minDatabases lesson 294 CQ
Learn a way to easily check if a SQL database subquery returns a result or not! In this lesson, Learn to Program shows how to use the EXISTS clause.
with LearnToProgramLearn a way to easily check if a SQL database subquery returns a result or not! In this lesson, Learn to Program shows how to use the EXISTS clause.
-
6 minDatabases lesson 304 CQ
Which is a better SQL method—a subquery or a join? Compare joins and subqueries with IN and EXISTS clauses to explore which is best for your database.
with LearnToProgramWhich is a better SQL method—a subquery or a join? Compare joins and subqueries with IN and EXISTS clauses to explore which is best for your database.
-
4 minDatabases lesson 313 CQ
In this lesson, learn how to create a derived table in SQL using a subquery, and about potential issues with derived tables in large databases.
with LearnToProgramIn this lesson, learn how to create a derived table in SQL using a subquery, and about potential issues with derived tables in large databases.
-
18 minDatabases lesson 3210 CQ
Learn how to code implicit, explicit, and multiple INSERT statements in SQL, as well as how to use INSERT to copy data within or between tables.
with LearnToProgramLearn how to code implicit, explicit, and multiple INSERT statements in SQL, as well as how to use INSERT to copy data within or between tables.
-
12 minDatabases lesson 337 CQ
In this lesson, learn how to use UPDATE statements to change records in a SQL table, and how to avoid the pitfalls of this record modification method.
with LearnToProgramIn this lesson, learn how to use UPDATE statements to change records in a SQL table, and how to avoid the pitfalls of this record modification method.
-
6 minDatabases lesson 344 CQ
In this lesson, learn how to write code to permanently erase both single and multiple records in SQL tables, using DELETE, WHERE and LIKE statements.
with LearnToProgramIn this lesson, learn how to write code to permanently erase both single and multiple records in SQL tables, using DELETE, WHERE and LIKE statements.
-
4 minDatabases lesson 353 CQ
In this lesson ,learn how to use a SQL transaction for committing a series of operations as a single unit, and rolling back failed modifications.
with LearnToProgramIn this lesson ,learn how to use a SQL transaction for committing a series of operations as a single unit, and rolling back failed modifications.
-
3 minDatabases lesson 362 CQ
Interested in using transactions in the SQL programming language? In this lesson, analyze example code to see how to start a SQL transaction.
with LearnToProgramInterested in using transactions in the SQL programming language? In this lesson, analyze example code to see how to start a SQL transaction.
-
4 minDatabases lesson 373 CQ
In this lesson, learn to use the COMMIT and ROLLBACK commands in SQL to discard or finalize transaction changes so they’re visible to database users!
with LearnToProgramIn this lesson, learn to use the COMMIT and ROLLBACK commands in SQL to discard or finalize transaction changes so they’re visible to database users!
-
14 minDatabases lesson 388 CQ
In this lesson, learn to make a new SQL table with the correct column data types, and learn about the ALTER TABLE and DROP TABLE statements.
with LearnToProgramIn this lesson, learn to make a new SQL table with the correct column data types, and learn about the ALTER TABLE and DROP TABLE statements.
-
7 minDatabases lesson 394 CQ
Wondering why your SQL database is running so slowly? In this lesson, learn how to create and use SQL views for performance optimization of SQL queries.
with LearnToProgramWondering why your SQL database is running so slowly? In this lesson, learn how to create and use SQL views for performance optimization of SQL queries.
-
9 minDatabases lesson 405 CQ
Get a taste of advanced SQL features by learning how to develop, call, and drop a simple stored procedure for executing pre-optimized queries!
with LearnToProgramGet a taste of advanced SQL features by learning how to develop, call, and drop a simple stored procedure for executing pre-optimized queries!
-
7 minDatabases lesson 414 CQ
Learn how to set up, execute, and drop a simple SQL trigger with the UPDATE statement! Martin Holzke explains what parameters trigger statements take.
with LearnToProgramLearn how to set up, execute, and drop a simple SQL trigger with the UPDATE statement! Martin Holzke explains what parameters trigger statements take.
-
19140 min19-part Software Development course80 CQ
Want to add a layer of interactivity to your HTML website without wasting time on a programming language that isn’t built to last? Whether you’re new to coding or looking to brush up on old skills, you’ll find everything you need to know about JavaScript basics in these 19 lessons. Learn how to use operators, variables, conditional statements, loops, and more. By the end of this course, you should have the necessary tools to start building your own dynamic website or browser-based game.
with LearnToProgramWant to add a layer of interactivity to your HTML website without wasting time on a programming language that isn’t built to last? Whether you’re new to coding or looking to brush up on old skills, you’ll find everything you need to know about JavaScript basics in these 19 lessons. Learn how to use operators, variables, conditional statements, loops, and more. By the end of this course, you should have the necessary tools to start building your own dynamic website or browser-based game.
-
27221 min27-part Web Development course124 CQ
Learning how to code has never been so simple! This 27-lesson beginner’s course from Learn to Program teaches you how to create a website from scratch using HTML and CSS. Start with an overview of web development before delving into the structure of HTML and XHTML documents. By the end of this course, you’ll know how to code links, inputs, and comments in HTML; style and format content with CSS; and more. Each lesson is accompanied by a screencast and exercises to reinforce your understanding.
with LearnToProgramLearning how to code has never been so simple! This 27-lesson beginner’s course from Learn to Program teaches you how to create a website from scratch using HTML and CSS. Start with an overview of web development before delving into the structure of HTML and XHTML documents. By the end of this course, you’ll know how to code links, inputs, and comments in HTML; style and format content with CSS; and more. Each lesson is accompanied by a screencast and exercises to reinforce your understanding.
-
972 min9-part Software Development course42 CQ
Want to design and program your own game using one of the most common languages in PC game building? In this course, LearnToProgram teaches you how to create a basic, text-based game called “Monster."
with LearnToProgramWant to design and program your own game using one of the most common languages in PC game building? In this course, LearnToProgram teaches you how to create a basic, text-based game called “Monster."
-
24274 min24-part Web Development course150 CQ
Develop expertise in website design and turn your plain HTML webpage into a stylistic treat using CSS! By the end of this course, you’ll be able to create the perfect look and feel for any website.
with LearnToProgramDevelop expertise in website design and turn your plain HTML webpage into a stylistic treat using CSS! By the end of this course, you’ll be able to create the perfect look and feel for any website.
-
21114 min21-part Software Development course66 CQ
Want to learn a programming language that emphasizes readability without sacrificing power? Python is the one for you. In this beginner's course, Learn to Program guides you through Python’s lists, conditional statements, loops, and more. If you are already proficient in a similar object-oriented language such as C or Java, learning the essentials of Python will be a piece of cake; if you've never written a single line of code, these crystal-clear lessons will make learning a new language as painless as possible.
with LearnToProgramWant to learn a programming language that emphasizes readability without sacrificing power? Python is the one for you. In this beginner's course, Learn to Program guides you through Python’s lists, conditional statements, loops, and more. If you are already proficient in a similar object-oriented language such as C or Java, learning the essentials of Python will be a piece of cake; if you've never written a single line of code, these crystal-clear lessons will make learning a new language as painless as possible.
-
11123 min11-part Microsoft Office course68 CQ
Microsoft Access, part of the Microsoft Office Professional suite, is the go-to entry-level software for mass tracking and managing of records. In need of your own data management system for your small business? This 14-lesson course for beginners from Amicron shows you how to use Access to create tables and run queries, sort and filter data using several easy-to-use parameters, work with different data types, and more.
with AmicronMicrosoft Access, part of the Microsoft Office Professional suite, is the go-to entry-level software for mass tracking and managing of records. In need of your own data management system for your small business? This 14-lesson course for beginners from Amicron shows you how to use Access to create tables and run queries, sort and filter data using several easy-to-use parameters, work with different data types, and more.
-
36325 min36-part Web Development course181 CQ
Used on servers all over the Net, PHP is one of the most important web development tools. Learn the basics of PHP, and how to use the programming language to run, access, and edit a MySQL database!
with LearnToProgramUsed on servers all over the Net, PHP is one of the most important web development tools. Learn the basics of PHP, and how to use the programming language to run, access, and edit a MySQL database!
-
32244 min32-part Basic Computing course137 CQ
Learn the basics of how to use popular application software like Microsoft Word, Excel, and Access to compose text documents, create spreadsheets, edit images and videos, and more!
with Todd McLeodLearn the basics of how to use popular application software like Microsoft Word, Excel, and Access to compose text documents, create spreadsheets, edit images and videos, and more!
-
41328 min41-part Databases course185 CQ
Developing a relational database with SQL is within grasp in this comprehensive, beginner- to intermediate-level programming course! By the end of this course, understand how to work fluently in SQL.
with LearnToProgramDeveloping a relational database with SQL is within grasp in this comprehensive, beginner- to intermediate-level programming course! By the end of this course, understand how to work fluently in SQL.
-
22100 min22-part Software Development course59 CQ
Have you already tackled the basics of Python? Are you itching to move on to more challenging, interactive programming? In this 22-lesson, intermediate-level course, Alex Bowers from Learn to Program breaks down concepts such as user input, methods, classes, and inheritance. Start incorporating external files and databases with the help of SQL, and even write your own functions. When you’re done, put your coding skills to the test with Learn to Program’s advanced course on developing games with Python.
with LearnToProgramHave you already tackled the basics of Python? Are you itching to move on to more challenging, interactive programming? In this 22-lesson, intermediate-level course, Alex Bowers from Learn to Program breaks down concepts such as user input, methods, classes, and inheritance. Start incorporating external files and databases with the help of SQL, and even write your own functions. When you’re done, put your coding skills to the test with Learn to Program’s advanced course on developing games with Python.