Want to learn and improve your SQL and database skills?
Everything you need to learn, practice, and improve your SQL and database development...
Short focused courses, practice questions, sample data and scripts, beginner-to-advanced roadmap, for multiple database vendors...
All immediately available - even if you think you don’t have much time to learn.
You want to learn SQL and database skills, but...
I’ve been there.
I’ve felt every one of these when learning and working with SQL.
Let me tell you a little story about a developer named John.
John picked up a new user story to work on. It involved creating an order history page, and after reading the story it seemed a little complicated.
He talked to another one of his teammates to find out more about the area of the system to work on.
His initial thoughts were that he needed to write a new query to get the data from the database, hook it up to some existing modules in his code, and get it to display on a new screen.
He opened up his IDE, which was SSMS. Browsing through the tables and running some quick queries, he got a basic understanding on what tables were needed and what was used. He checked the application code to check which tables were being used and worked out the best way to get started was to write the SQL query.
The query he would need to write was a bit more than just a simple Select from a table. It needed quite a few joins, with different types. He wrote a simple query to start and checked the results.
John slowly made more changes to the query, bringing in more tables, adding WHERE clauses to filter data, checking the results as he went.
For one particular column, he wasn’t sure how to get the right data to show.
Fortunately, he knew a few ways to do this. He tried a subquery, but then realised that a couple of joins may work better for the column. John knew this could be an option because he had learned about what a subquery was and how it worked, saving him hours of time doing research for this particular issue.
He added the joins and logic to his query and ran it.
The results looked good to him: it looked like it was the correct data.
But the only way to know for sure was to run some tests on it. He checked a few customers and orders individually and it all looked good!
The performance of the query was pretty good too, because he knew what features of SQL should be avoided and what can help with writing a query that performs well.
John was satisfied.
This process of writing this query did have its complex moments, but he was grateful he had a broad understanding of the SQL language and knew how to find the data he needed.
What if you could know how to write queries to get the results you need, that perform well, and you knew the features of SQL you wanted to use?
Database Star Academy
The online training platform for software developers who want to improve their database development and SQL skills.
Here's what you get:
33 high-quality video courses from getting started with SQL to advanced topics
Questions and Assignments
Practice questions and assignments to improve your skills
Works on Many Databases
Content that works on many databases so it’s relevant no matter which database you use
Many PDF guides to enhance your skills, including checklists and cheat sheets
Download the SQL scripts to follow along with each course
Show the steps on how to solve a problem
Low on time? There are several PDFs that show you how to use different tools easier
Badges, Achievements, Leaderboard
Earn points and badges from various activities, and see how you compare to other members on a Top 10 Leaderboard.
Join Database Star Academy
Pay the same amount each month
Pay one amount, once per year
All prices in USD.
Why Join Database Star Academy?
Courses in Database Star Academy
These are the 33 courses available in Database Star Academy, with more being added regularly.
Introduction to Oracle SQL
Learn the basics of Oracle SQL including setting up your own database and running SQL queries.
- 1Introduction (02:55)
- 2Download Oracle Express (03:16)
- 3Install Oracle Express (02:28)
- 4Download SQL Developer (03:57)
- 5Connect to your database (04:14)
- 6Create a new user (04:15)
- 7Using Oracle Live SQL (03:43)
- 8Create your first table (11:19)
- 9Add data to a table (05:50)
- 10View data in a table (05:14)
- 11View some records in a table (03:45)
- 12Update data in a table (03:49)
- 13Delete data (02:08)
- 14Conclusion (00:58)
Introduction to SQL Server
Learn the basics of SQL Server including setting up your own database and running SQL queries.
- 1Introduction (01:52)
- 2Download SQL Server Express (01:50)
- 3Install SQL Server Express (02:40)
- 4Install SQL Server Management Studio (02:35)
- 5Create your first table (10:39)
- 6Add data to a table (07:01)
- 7View data in a table (05:12)
- 8View some records in a table (03:45)
- 9Update data in a table (03:52)
- 10Delete data (02:04)
- 11Conclusion (00:57)
Introduction to MySQL
Learn the basics of MySQL including setting up your own database and running SQL queries.
- 1Introduction (01:42)
- 2Download MySQL Database and MySQL Workbench (04:49)
- 3Install MySQL (04:01)
- 4Install MySQL Workbench (01:15)
- 5Connect to the database (05:10)
- 6Create your first table (11:04)
- 7Add data to a table (05:55)
- 8View data in a table (05:09)
- 9View some records in a table (03:46)
- 10Update data in a table (03:52)
- 11Delete data (02:04)
- 12Conclusion (00:57)
Introduction to PostgreSQL
Learn the basics of PostgreSQL including setting up your own database and running SQL queries.
- 1Introduction (01:35)
- 2Download PostgreSQL and DBeaver (03:52)
- 3Install PostgreSQL (02:28)
- 4Install DBeaver (00:56)
- 5Connect to the database (02:36)
- 6Create your first table (10:13)
- 7Add data to a table (06:14)
- 8View data in a table (04:56)
- 9View some records in a table (03:41)
- 10Update data in a table (03:50)
- 11Delete data (02:07)
- 12Conclusion (00:58)
Creating a Second Table
Learn how to create a second table, relate it to the first, and write a SELECT query to get data from both tables.
- 1Introduction (02:01)
- 2Setup scripts (03:43)
- 3Capture company name (04:04)
- 4Update company name (04:39)
- 5Create a company table (04:55)
- 6Relating data (02:17)
- 7Add a new column (05:33)
- 8Update the identifying values (02:43)
- 9Add primary key (02:44)
- 10Using a foreign key (03:12)
- 11Add a foreign key (05:03)
- 12Select with join (06:52)
- 13Select with an outer join (04:43)
- 14Ordering results (02:55)
- 15Conclusion (00:58)
Improve Your Queries and Data
Learn how to improve the quality of your queries and data integrity with several SQL features
- 1Introduction (01:58)
- 2Setup scripts (05:06)
- 3Add a third table (04:49)
- 4Table aliases (04:33)
- 5Select from three tables (03:38)
- 6Column aliases (05:16)
- 7Bind variables (06:08)
- 8Check Constraints (05:56)
- 9Not Null Constraint (04:06)
- 10Unique Constraint (03:58)
- 11Conclusion (01:05)
Select Mastery Level 1
Use the sample database to write Select queries to analyse data, while learning about grouping and functions.
- 1Introduction (02:00)
- 2Setup scripts (04:24)
- 3Our requirements (02:03)
- 4Show all orders (05:59)
- 5Show number of orders (04:10)
- 6Grouping the results (05:56)
- 7Show order value (04:56)
- 8Next report requirements (01:02)
- 9Show order details (06:16)
- 10Group by person (03:07)
- 11Limit customers (02:57)
- 12Conclusion (02:00)
Select Mastery Level 2
Use the sample database to demonstrate more features of the Select query, such as subqueries and views.
- 1Introduction (01:54)
- 2Setup scripts (03:49)
- 3Our requirement (01:25)
- 4Show orders (04:22)
- 5Find latest order (03:00)
- 6What is a subquery? (02:36)
- 7Write outer query (03:06)
- 8Create a view (05:22)
- 9Conclusion (01:20)
Select Mastery Level 3
Use the sample database to demonstrate more features of the Select query, including row limiting, subqueries, and more functions.
- 1Introduction (02:01)
- 2Setup scripts (03:44)
- 3Our requirements (01:34)
- 4Select companies by order value (05:03)
- 5Operators (04:11)
- 6Lookup table (06:19)
- 7Select top 5 (03:42)
- 8Simplify query with a subquery (02:54)
- 9Conclusion (01:17)
Learn how to insert many rows at once using a variety of techniques, the Truncate statement, and auto-increment features.
- 1Introduction (01:49)
- 2Our requirement (01:57)
- 3Insert individual rows (04:43)
- 4Remove data (02:58)
- 5Insert multiple rows (05:39)
- 6Auto increment (07:08)
- 7Disable foreign keys (04:10)
- 8Transactions (04:42)
- 9Importing from a file (03:24)
- 10Conclusion (01:13)
Learn what a soft delete is, why you would use it, and how to implement it.
- 1Introduction (01:07)
- 2Our database design (03:06)
- 3What is a soft delete? (02:45)
- 4Altering the table (04:34)
- 5Delete using a trigger (06:22)
- 6Delete using a stored procedure (05:24)
- 7Selecting from the table (03:41)
- 8Inserting records (01:37)
- 9Conclusion (01:13)
Sample CSV to Normalised Database
Learn how to import some CSV files into a database and transform the design and tables into a better, normalised design.
- 1Introduction (01:49)
- 2Import a CSV File in MySQL Workbench (03:12)
- 3Import a CSV File in Oracle SQL Developer (02:51)
- 4Import a CSV File in SSMS (05:07)
- 5Import a CSV File in DBeaver (03:16)
- 6Query the Tables (04:08)
- 7Create Our Next Table (07:18)
- 8Extract Title Type (04:33)
- 9Extract Age Certification (06:04)
- 10Extract Genres (12:38)
- 11Extract Production Countries (03:23)
- 12Final Design and Select Queries (02:45)
- 13Conclusion and Next Steps (01:31)
Relational Database Design
Learn how to design an effective and efficient database, including the process of normalisation.
- 1Welcome (01:52)
- 2What is a database? (02:53)
- 3Different types of databases (01:22)
- 4Benefits of relational databases (07:07)
- 5What is data modeling and the design process (01:44)
- 6Determine the goal of the database (02:33)
- 7Consider the current system (02:05)
- 8Gathering requirements of the database (02:48)
- 9Finding exceptions to the rules (04:35)
- 10Identifying entities (07:11)
- 11Defining the attributes (07:47)
- 12Normalisation (01:40)
- 13First normal form (01:34)
- 14First normal form: student (05:18)
- 15First normal form: subject (02:05)
- 16First normal form: teacher (02:25)
- 17First normal form: university (02:45)
- 18Relationships (02:41)
- 19Second normal form (01:39)
- 20Second normal form: student and subject (09:53)
- 21Second normal form: teacher (02:22)
- 22Second normal form: university (03:22)
- 23Third normal form (01:08)
- 24Third normal form: student and subject (06:50)
- 25Third normal form: teacher and university (01:48)
- 26Third normal form completed (02:43)
- 27Data types and precision (03:52)
- 28Integrity constraints (01:29)
- 29Naming conventions (01:46)
- 30Lookup tables (01:38)
- 31Auditing tables (02:40)
- 32Implementation and next steps (01:20)
Advanced Database Modeling
Learn a range of advanced tips and strategies for modeling different scenarios, and overcoming common issues found when designing databases.
- 1Introduction (01:48)
- 2Multiple values in one column (05:46)
- 3Alternatives in one column (04:33)
- 4Entity Attribute Value (08:16)
- 5New tables for each group (04:45)
- 6New columns for each similar value (05:40)
- 7Storing calculated fields (04:20)
- 8Use a soft delete (04:36)
- 9Audit tables (05:44)
- 10Names (03:32)
- 11Addresses (03:55)
- 12Phone numbers (01:58)
- 13Currency (03:39)
- 14Email address (02:54)
- 15IP address (02:28)
- 16Use VARCHAR instead of CHAR (03:59)
- 17Primary Key Constraints with duplicates (05:24)
- 18Lookup tables and Check Constraints (03:53)
- 19Polymorphic association (03:40)
- 20Not Null (02:38)
- 21Conclusion (01:01)
Case Study: Database Design 1
This is a case study that shows you how to design a database for a social media website.
- 1Introduction (01:40)
- 2Our requirement (01:59)
- 3The first table (04:07)
- 4Posts table (03:54)
- 5Comments on posts (03:44)
- 6Likes on posts (03:41)
- 7Add a photos table (02:53)
- 8Comments on photos (03:06)
- 9Likes on photos (02:09)
- 10Modifying our design (06:21)
- 11Add videos table (03:00)
- 12Replying to comments (03:44)
- 13Our final design (01:50)
Oracle PL/SQL Level 1
Learn the basics of Oracle's procedural language (PL/SQL) by writing a simple Hello World program, using variables, conditions, and loops.
- 1Introduction (01:51)
- 2Your first program (05:26)
- 3Variables (04:56)
- 4Number variables (05:17)
- 5Modify variables (02:57)
- 6Constants (05:48)
- 7Conditions (06:18)
- 8Loops (05:57)
- 9Conclusion (01:08)
Oracle PL/SQL Level 2
Learn how to create procedures and functions, and how to work with exceptions.
- 1Introduction (01:05)
- 2Create a simple stored procedure (05:10)
- 3Parameters (06:13)
- 4Output parameters (04:36)
- 5Functions (04:42)
- 6Exceptions (05:44)
- 7Raising exceptions (03:22)
- 8Conclusion (01:13)
Oracle PL/SQL Level 3
Learn how to use Select, Insert, Update, and Delete statements in PL/SQL, and learn about cursors.
- 1Introduction (01:11)
- 2Inserting data (04:01)
- 3Updating data (04:57)
- 4Deleting data (02:21)
- 5Selecting data (03:32)
- 6Explicit cursors (03:51)
- 7Handling multiple rows with loops and cursors (03:42)
- 8Selecting multiple columns (03:19)
- 9Conclusion (01:10)
This course teaches you what a trigger is, why to use one, and includes many examples.
- 1Welcome (01:14)
- 2What is a trigger? (04:39)
- 3Before Insert trigger (09:10)
- 4After Insert trigger (05:39)
- 5Instead Of trigger (06:00)
- 6Edit a trigger (03:27)
- 7Drop a trigger (01:11)
- 8Enable and disable a trigger (02:11)
- 9Before Update trigger (06:06)
- 10After Update of a Row trigger (02:52)
- 11After Update of a Value trigger (03:02)
- 12Before Delete trigger (03:25)
- 13After Delete trigger (02:10)
- 14Before Insert statement-level trigger (02:18)
- 15Database Logon trigger (02:47)
- 16Compound trigger (04:32)
- 17Compound trigger: complex constraint (06:09)
- 18New and old values (02:37)
- 19Debugging a trigger (07:32)
- 20Call a stored procedure from a trigger (03:43)
- 21Restrictions, privileges, and tips (02:27)
- 22Mutating table error (06:48)
- 23Viewing information about triggers (03:24)
- 24Conclusion (00:39)
Subqueries in SQL Server
Learn what subqueries are and how to use them in SQL Server.
- 1Introduction (00:56)
- 2Loading sample data (03:11)
- 3What is a subquery? (01:43)
- 4Scalar subquery (08:48)
- 5Single row subquery (05:17)
- 6Multi-row subquery (08:03)
- 7Correlated subquery (09:39)
- 8Subqueries in the FROM clause (05:09)
- 9Using subqueries to clean up SELECT queries (06:45)
- 10Subqueries in the HAVING clause (04:30)
- 11Subqueries in the SELECT clause (04:19)
- 12Updating data with a subquery (04:55)
- 13Inserting data with a subquery (03:46)
- 14Deleting data with a subquery (04:55)
- 15Conclusion (00:59)
Create a Bank Database
This course will explain the concepts of transactions, auto incrementing, and check constraints.
- 1Introduction (01:59)
- 2Load the sample database (02:13)
- 3Add a transaction record (05:40)
- 4Generate unique IDs (10:18)
- 5Data quality with Check Constraints (06:39)
- 6Using a transaction (10:44)
- 7Multiple sessions (08:22)
- 8Conclusion (00:50)
Views in SQL Server
This course teaches you about views in SQL Server: what they are, how to create them, and when to use them.
- 1Introduction (01:11)
- 2What is a view? (02:27)
- 3Setting up sample data (03:11)
- 4Create a view (04:40)
- 5Create a view with multiple tables (02:34)
- 6Inserting data in a view (02:40)
- 7Updating data in a view (02:27)
- 8Non-updatable views (05:27)
- 9Rename and drop views (02:45)
- 10Find information about a view (03:16)
- 11Indexed views (05:01)
- 12Conclusion (00:36)
Stored Procedures in SQL Server
In this course, you'll learn all about stored procedures in SQL Server: what they are, why to use them, how to create them, and a range of features that are available.
- 1Introduction (01:46)
- 2Stored procedure basics (02:32)
- 3Create a stored procedure (05:41)
- 4Drop a stored procedure (01:21)
- 5Modify a stored procedure (03:13)
- 6Set Nocount On (02:07)
- 7Parameters (07:29)
- 8Text Parameters (02:41)
- 9Optional Parameters (04:37)
- 10Variables (03:23)
- 11Storing results in variables (03:41)
- 12Output parameters (04:43)
- 13Inserting data (03:03)
- 14Updating data (02:48)
- 15Deleting data (01:30)
- 16If and Else (06:35)
- 17While loop (03:41)
- 18Error handling with Try Catch (04:39)
- 19Throwing errors (05:21)
- 20Raising errors (04:15)
- 21Conclusion (00:37)
CTEs in SQL Server
In this course, you'll learn about CTEs (Common Table Expressions) and how to use them in SQL Server to improve your queries.
- 1Introduction (01:19)
- 2What is a CTE? (05:17)
- 3Benefits of CTEs (01:03)
- 4Two CTEs in one query (05:05)
- 5CTE in Create View (01:56)
- 6CTE in Create Table as Select (03:42)
- 7CTE in Update Statement (02:29)
- 8What is a recursive CTE? (01:04)
- 9Recursive CTE example (05:12)
- 10Indenting results of recursive queries (04:19)
- 11Preventing infinite loops (02:45)
- 12Conclusion (00:46)
Introduction to Data Warehousing
This course explains what data warehousing and ETL is, and shows you how to create and populate a data warehouse.
- 1Welcome (01:19)
- 2What is a data warehouse? (03:17)
- 3Transaction vs analytical databases (01:59)
- 4What is business intelligence? (02:16)
- 5Our sample database (00:44)
- 6Setting up SQL Server (07:26)
- 7Setting up the sample database (03:30)
- 8Overall process (02:30)
- 9Dimensional modeling (04:17)
- 10Current AdventureWorks ERD (03:55)
- 11Create the fact table (09:00)
- 12Create the dimension tables (18:46)
- 13ETL (01:51)
- 14Download and install Visual Studio (04:42)
- 15Create the project and first step (11:39)
- 16Get data from multiple tables (13:00)
- 17Populate the customer dimension (11:57)
- 18Populate the salesperson dimension (07:21)
- 19Populate the address dimension (02:37)
- 20Populate the date dimension (04:50)
- 21Populate the fact table (14:46)
- 22Populate the second fact table (04:45)
- 23Summary of steps (03:12)
- 24Run SQL queries (03:55)
- 25Conclusion (00:54)
Write Faster SQL
This course shows you how you can improve the performance of your SQL queries. You'll learn how to find slow areas, many strategies to improve the queries, and how to measure the results.
- 1Welcome (02:10)
- 2Start with your own experience (05:29)
- 3Ask other people (03:23)
- 4Look at the data dictionary (09:25)
- 5Look at other tools (04:34)
- 6Choose a query (07:10)
- 7Measure your query (05:20)
- 8Analyse execution plan (06:36)
- 9Create indexes (10:00)
- 10Remove Distinct (05:11)
- 11Remove calculated fields from Where and Joins (04:57)
- 12Remove unneded tables and columns (04:21)
- 13Use Union All instead of Union (03:14)
- 14Use Exists (03:42)
- 15Avoid wildcard matching (03:48)
- 16Use bind variables (05:47)
- 17Change Union to Case (05:28)
- 18Use a temp table (05:47)
- 19Partition data (09:08)
- 20Change correlated subqueries to joins (03:39)
- 21Avoid cursors (05:01)
- 22Compare the data (06:02)
- 23Compare the performance (04:35)
- 24Deploy the changes (02:01)
- 25Making further changes (01:38)
Understanding Complex Queries
In this course, you'll learn a step-by-step process to understand complex SQL queries, and several tips on how to improve readability and formatting of the query to make it easier to understand.
- 1Introduction (01:44)
- 2Open your query (04:59)
- 3Auto format (04:34)
- 4Manual format (07:57)
- 5Diagram the tables (04:15)
- 6Add columns to the diagram (05:20)
- 7Add filtering columns to the diagram (04:56)
- 8Extra information and review (03:44)
- 9Run a small part of the query (03:49)
- 10Add comments (05:03)
- 11Add aliases (04:58)
- 12Run more of the query (02:31)
- 13Improve joins (03:19)
- 14Remove unnecessary keywords (05:15)
- 15Convert to CTE (02:44)
- 16Subquery to join (03:14)
- 17Conclusion (00:53)
Case Study: Show a Page of Records
This course is a case study that shows you step-by-step how to write a query that shows a page of records. You'll learn about pagination, row limiting, subqueries, grouping, string aggregation, and more.
- 1Introduction (01:30)
- 2Our sample database (02:48)
- 3Show the books (03:07)
- 4Get the number of sales (06:32)
- 5Add the publisher (03:07)
- 6Add row limiting and pagination (08:08)
- 7Show authors (04:35)
- 8Find authors for books (04:41)
- 9Add to main query (05:41)
Complex Queries 1: Sales Report
This course will show you step-by-step how to write a complex query. We’ll use several SQL features (advanced grouping, aggregate functions, subqueries) to write a sales report on a book database.
- 1Introduction (01:36)
- 2Our sample database (02:48)
- 3Our requirement (01:29)
- 4Show all orders (02:44)
- 5Count orders by date (04:24)
- 6Count book sales (03:04)
- 7Count sales by year (04:05)
- 8Show an overall total (04:22)
- 9Count and sum sales by year (03:56)
- 10Count and sum sales by year and month (04:03)
- 11Clarify data and exclude some orders (06:14)
Complex Queries 2: Shipping Report
This course demonstrates several SQL features to help build a report on shipping destinations for online orders. You’ll learn how to use grouping, window functions, and analysing data to see if the query is correct.
- 1Introduction (01:34)
- 2Our sample database (02:48)
- 3Our requirement (01:56)
- 4Show city and country (03:22)
- 5Show order count (05:49)
- 6Show customer count (07:17)
- 7Missing cities (03:37)
- 8Order details (03:34)
- 9Include customer details (02:23)
- 10Include shiping method (02:07)
- 11Add order value (02:07)
- 12Add order count (03:09)
- 13Final queries (02:02)
Certification: Oracle Certified Associate (1Z0-071)
This course is a study guide for the Oracle SQL Certified Associate (1Z0-071) exam).
Watch the videos and take the practice exam at the end of the course to help you study for this certification.
- 1Course intro (02:58)
- 2Exam information (05:30)
- 3Exam tips (03:34)
- 4Setting up the sample database (03:53)
- 5Explain the relationship between a database and SQL (03:03)
- 6Identify the connection between an ERD and a database using SQL SELECT statements (05:43)
- 7Describe the purpose of DML (02:27)
- 8Build a SELECT statement to retrieve data from an Oracle Database table (12:22)
- 9Use the ORDER BY clause to sort SQL query results (06:46)
- 10Limit the rows that are retrieved by a query (12:11)
- 11Use ampersand substitution to restrict and sort output at runtime (06:21)
- 12Describe the different types of joins and their features (06:30)
- 13Use SELECT statements to access data from more than one table using equijoins and nonequijoins (10:58)
- 14Join a table to itself by using a self-join (06:01)
- 15View data that generally does not meet a join condition by using outer joins (03:10)
- 16Use various types of functions available in SQL (01:34)
- 17Use character, number, and date functions in SELECT statements (10:26)
- 18Use analytical functions in SELECT statements (13:00)
- 19Use conversion functions (01:47)
- 20Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions (11:46)
- 21Apply general functions and conditional expressions in a SELECT statement (07:03)
- 22Describe the use of group functions (05:56)
- 23Group data by using the GROUP BY clause (03:51)
- 24Include or exclude grouped rows by using the HAVING clause (02:25)
- 25Use a set operator to combine multiple queries into a single query (06:52)
- 26Control the order of rows returned (01:58)
- 27Define subqueries (01:08)
- 28Describe the types of problems subqueries can solve (05:11)
- 29Describe the types of subqueries (01:28)
- 30Use single-row and multiple-row subqueries (06:33)
- 31Use correlated subqueries (03:12)
- 32Update and delete rows using correlated subqueries (07:19)
- 33Use the EXISTS and NOT EXISTS operators (04:02)
- 34Use the WITH clause (03:34)
- 35Insert rows into a table (08:50)
- 36Update rows in a table (05:00)
- 37Delete rows from a table (06:14)
- 38Describe the features of multitable INSERTs (08:18)
- 39Control transactions (10:40)
- 40Merge rows in a table (05:42)
- 41Describe the purpose of DDL (01:56)
- 42Describe data types that are available for columns (01:21)
- 43Create a simple table (11:28)
- 44Create constraints for tables (06:45)
- 45Describe how schema objects work (01:45)
- 46Query various data dictionary views (04:06)
- 47Create and maintain indexes including invisible indexes and multiple indexes on the same columns (05:03)
- 48Drop columns and set column UNUSED (04:08)
- 49Perform flashback operations (04:41)
- 50Create and use external tables (04:20)
- 51Create simple and complex views with visible/invisible columns (06:18)
- 52Create, maintain and use sequences (03:52)
- 53Differentiate system privileges from object privileges (03:10)
- 54Grant privileges on tables and on a user (03:21)
- 55Distinguish between privileges and roles (01:17)
SQL Developer Jumpstart
This course will help you get started quickly with Oracle SQL Developer.
- 1Welcome (04:20)
- 2Download SQL Developer (04:21)
- 3Download and install Oracle Express (05:50)
- 4Tour of SQL Developer (05:31)
- 5Connections (11:03)
- 6Database Object Browser (06:39)
- 7Preferences (20:46)
- 8SQL files (08:40)
- 9Running queries (07:46)
- 10Query builder (05:22)
- 11Importing data into a table (05:20)
- 12Exporting tables and database (05:52)
- 13Exporting results (05:16)
- 14Functions (04:40)
- 15Procedures (03:41)
- 16Debugging (06:01)
- 17Code navigation (03:20)
- 18View menu (08:13)
- 19Data modeler overview (01:46)
- 20Versioning (11:11)
- 21Reports (05:26)
- 22Tools menu (02:35)
- 23Window menu (02:12)
- 24Features and extensions (03:35)
- 25Conclusion (01:06)
Introduction to SQL*Plus
Learn the basics of SQL*Plus, Oracle's command-line tool for working with Oracle databases.
- 1What is SQL*Plus? (01:14)
- 2Open SQL*Plus and connect to a database (06:06)
- 3Creating a table (05:07)
- 4Copy and paste text (02:12)
- 5Insert data into a table (03:12)
- 6Selecting data (02:26)
- 7Describe statement (01:09)
- 8Formatting columns (08:30)
- 9Formatting data (02:34)
- 10Command line formatting (01:58)
- 11Send query results to a file (01:52)
- 12Create HTML reports (02:44)
- 13Run an SQL file (03:25)
- 14Performance in SQL*Plus (05:29)
- 15Setting defaults using the login file (02:39)
- 16Run operating system commands (01:17)
- 17Run PL/SQL blocks (02:39)
- 18Conclusion (00:33)
Introduction to Toad for Oracle
Learn how to get started with Toad for Oracle and a demonstration of many of its features.
- 1What is Toad? (03:00)
- 2Download Toad (03:28)
- 3Install Toad (02:39)
- 4Quick tour (02:07)
- 5Create a database connection (04:47)
- 6Edit, import, export, and auto connect for connections (03:25)
- 7Run SQL statements (02:34)
- 8Navigator and multiple SQL statements (04:01)
- 9Working with files (02:56)
- 10Export query results (04:14)
- 11Working with desktops (00:50)
- 12Jump search (01:53)
- 13Find and replace (02:50)
- 14Find in files (01:54)
- 15Using bookmarks (02:24)
- 16Explain plans (05:10)
- 17Changing schema (01:16)
- 18Schema browser (02:58)
- 19Filtering the schema browser (02:30)
- 20Database browser (01:06)
- 21Session browser (03:09)
- 22Working with the data grid (01:40)
- 23Searching the data grid (01:35)
- 24Filtering in the data grid (02:34)
- 25Editing data sets (03:51)
- 26Insert and delete rows in the data grid (01:40)
- 27Describe objects (01:47)
- 28Object search (02:44)
- 29Create, alter, and drop objects (03:28)
- 30Create, modify, and view object privileges (02:20)
- 31Using the object palette (02:51)
- 32Copy data to another table (02:09)
- 33Compare data wizard (03:02)
- 34Compare objects (02:04)
- 35Compare schemas (02:15)
- 36Compare files (03:37)
- 37Exporting data (01:24)
- 38Importing data (03:43)
- 39Code completion templates (02:30)
- 40Code snippets (01:49)
- 41Using the code formatter (02:24)
- 42Configuring the code formatter (01:57)
- 43Improving the view of your code (02:40)
- 44Strip code feature (01:27)
- 45Make code feature (02:11)
- 46SQL recall (02:25)
- 47Import or export saved SQL (02:27)
- 48Load database objects (01:00)
- 49Create a new object (01:50)
- 50Extract procedure (01:59)
- 51DBMS output (02:18)
- 52Setting up the debugger (01:43)
- 53Start debugging (02:06)
- 54Debug results and the call stack (01:54)
- 55Breakpoints (02:24)
- 56Watches (02:01)
- 57Smart watches (01:39)
- 58Workspaces (02:01)
- 59Shortcut keys (01:27)
- 60Working with projects (03:12)
- 61Conclusion (00:43)
Join Database Star Academy
Here's what you get:
Pay the same amount each month
Pay one amount, once per year
All prices in USD.
What our customers are saying:
His explanations are so clear
Ben has simplified sub-queries for me, regex, and many other topics. I feel slow when reading a lot of explanations off the internet, but his explanations are so clear, they make these topics easy to understand.
The "SQL Interview Questions & Answers", which I nearly didn't read, was full of answers I had on how to use CTE, DBMS-Output, temp tables. And then I put them all in a folder that are easy to refer back to.
On top if it all, I don't have to sift through a 10 minute you tube to find the 10 seconds of information I'm looking for. I also get emails from Database Star on topics I didn't even knew I had questions on - like how to manage your time, and book recommendations like "Clean Code" by Robert C. Martin.
Nancy T // Database Star Academy member
Videos are simple, informative, and easy to understand
I think I am one of the guys who joined you almost from the beginning of the launch of your academy (correct me if I am wrong). And, this is the first time in my IT career I have ever subscribed to any site such as yours.
After being with you for some time, I now feel that I have not made any mistake by subscribing to your site. I have learnt a lot by following your site which cannot be described in words. Examples given after each topic are very useful. The videos are simple, informative and easy to understand. There is also a lot of general content which is very useful in developing the subject.
I am extremely grateful to you for that. I am also happy to see you coming up with different flavors of SQL (SQL Server, MySQL & Postgress SQL). It would be easy for a person to refer to one single site for everything. In fact, I am looking forward to detailed stuff related to Oracle DBA and other related topics. Hope, it is on the way.
Korlahalli S // Database Star Academy member
Progression is well designed
The brevity of lessons are more manageable and the progression is well designed.
Merri H // Database Star Academy member
Good breakdown by difficulties
A large content, well structured. High quality video and sound. Good breakdown of difficulties by a succession of videos.
Santiano // Database Star Academy member
You are responsive and you are listening!
Before I bought the course I mailed you with few questions. AND YOU ANSWERED. Trust me, this is a rare thing...with you answering, I knew you are not a bot.
Your courses are short and full of practical knowledge + you are responsive and you are listening!
Michal Z // Database Star Academy member
Everything is in one place
Your explanations are so clear and concise that you don’t need to go on and on and on as I have heard others do.
I do like that everything is in one place and I’m not trying to go to five or six different courses or YouTube videos for one topic.
Donna M // Database Star Academy member
The finest, most lucid, considerate learning source that I have ever experienced
I have been in the IT industry now, for over 40 years. In the late 1990's, I begin to gravitate specifically to Oracle products. In my pursuits of capturing a reliable and coherent source for specific Oracle based knowledge, I have kissed a many frogs.
I say this loud and without anyone persuading me, that Database Star is the finest, most lucid, considerate learning source that I have ever experienced. The gentleman who produces their products (Ben Brumm), actually listens to your input.
He is personable, bright, responsive and provides extremely helpful materials that deal with real world scenarios. I have several people that I peronally mentor and I always refer them to Database Star.
Michael I // Database Star Academy member
I have gotten a great many new ideas and have done refresher type reviews on many subject presented in the course of a year.
Its a great tool, and gives me the opportunity to see how other do the things I do.
James W // Database Star Academy member
If somebody want to learn postgreSQL DB from the "ground" that is the great pace to start.
Sandor V // Database Star Academy member
I highly recommend Database Star for those who want to make their future career in data analytics or related fields to learn the basic concepts and foundations.
The curriculum is well organized and easy to understand. I found Database Star while I was searching documents to improve my database and SQL skills. Ben used to send me different links and resources even before I became a member of Database Star.
Abebe T // Database Star Academy member
100% Satisfaction Guarantee
The Database Star Academy comes with my no-questions-asked, 30-day money-back guarantee.
You are fully protected by our 100% Satisfaction-Guarantee. If you are not satisfied with your membership, then let me know within the first 30 days of purchasing, and I will provide you with a full and prompt refund.
I'm confident that you'll get some value for your membership within the first 30 days!
Ben Brumm // Course Teacher
I've been working with databases and SQL for many years, after completing my computer science degree in 2007, majoring in Oracle databases. I've been a software consultant ever since.
I've also obtained the Oracle SQL Expert certification.
I created this membership to teach SQL and database skills to many people. I want you to be able to improve your knowledge and skills with SQL and databases.
Frequently Asked Questions
I've been teaching SQL and databases to coworkers and on my blog for years. I'm also a certified Oracle SQL Expert and passionate about writing good SQL.
The membership site is focused on SQL, so you'll be getting your knowledge straight from someone who knows it, rather than a broad "software development" membership.
You can cancel at any time - simply click the Cancel button inside the membership site, or in your PayPal account. Or contact me.
You'll get an email with details on how to register for the course on Database Star.
Once you register, you'll be able to log in to an area of the site that has a list of all the modules, videos, and downloadable material. You'll then be charged every month.
While I would prefer that you didn't do that, there's nothing stopping you. It would take you a while to go through and download the hundreds of videos though.
This is for you if...
You want to get better at working with databases
You don't have a lot of time to study and improve your skills and want to know the right thing to study.
You want to solve problems you're having on your database
You want to make your queries run faster
You want to understand how certain SQL features work
Why Enrol in Database Star Academy?
You'll get immediate access to all materials.
You'll learn from someone who has experience with databases and SQL.
You'll get focused education, not broad education like you get in college.
You can cancel at any time.
You don't have to pay thousands to travel or enrol in an in-person training class
One more thing...
The Database Star Academy is what I'm most proud of on my website. I truly enjoy helping and teaching others to improve their skills and solve problems.
If you're interested in learning and improving your SQL and database skills, I encourage you to enrol in Database Star Academy today.
Pay the same amount each month
Pay one amount, once per year