Skip Nav

Welcome to SQLCourse.com!

Online tools to practise and improve SQL skills

❶Players start on their home planets, where they can build new spaceships and mine resources that can be used to create or upgrade additional spaceships. Learn more at Online Proctored Exams.

News & Offers

SQL Quiz Test
Share this page
Examples in Each Chapter

Introduction to SQL Certification holders earn much more than their non-certified counterparts. Scroll through the list and click on any question to view the answer. What is the final exam like? The final exam is fully based upon the courseware that is provided along with the SQL Programming Skills Certification. If you have gone through the courseware properly you should not have a problem clearing the exam.

An instructor to guide you through the course and to whom you can direct your questions. The SQL Programming Skills Certification certificate can be used to prove your certified status and does not mention the words "online".

An online transcript that can be used to prove your certified credentials on the internet at any time. What learning aids will I get? How do I get certified? The process of getting yourself certified is very simple. Log in to the instructor led course using your password.

ExpertRating Online SQL Course Instructor This course includes a knowledgeable and caring instructor who will guide you through your lessons, facilitate discussions, and answer your questions.

What are the course start dates? ExpertRating instructor led courses commence every month, you can always choose a suitable date for your course commencement in any month.

Online Visual Basic Course helps to create graphical applications and build Windows and Web applications. The ExpertRating Visual Basic Certification will help boost your resume by equipping you with knowledge to create graphical user interface applications. An experienced professional guides you through a structured approach to database design and development. Learn how to use the Oracle database management system to plan, organize, and manage your data.

Introduction to Oracle will provide you with a practical hands-on approach to relational databases concepts. Learn how Microsofts powerful database can help you store and manage information you have collected about your business, home, or community. Learn how to create real-world business databases using Microsoft Access. Read More Microsoft Access Course Introduction Learn how to store, locate, print, and automate access to all types of information.

In this six-week online course, you will see how to design the tables that most businesses need to manage customers, products, orders, receipts, invoices, and mailing labels. Learn to solve real-world business problems with Microsoft Access Learn how to create forms that automatically do much of the work for you, such as calculating totals and applying sales tax.

Read More Crystal Reports Course Crystal Reports 10 Make the points you want to make by converting raw database or accounting information into impressive and meaningful reports. Learn how to connect to a database, read the information stored inside, and display it exactly the way you want. Learn how to create an interactive Web site, allowing visitors to post and retrieve information provided by you or your sites visitors.

Read More More Courses Week One Wednesday-Lesson 01 In the first lesson, you'll explore the basic structure and history of relational databases. Then, you'll understand what SQL is and how it is used with a relational database.

This lesson will talk about important query terms that enable you to communicate with your database, as well as syntax rules that will enable you to create clear and understandable queries while avoiding system generated errors.

You'll be able to sort single and multiple columns and you'll know how to specify sort directions such as ascending and descending order. You'll also learn additional query terms that will help you customize your SQL queries. Friday-Lesson 04 Today, you'll learn how to reformat retrieved data with calculated fields and functions.

You'll also learn how to create alternate names for columns and you'll discover the secret behind merging columns with the concatenation symbol.

Week Three Wednesday-Lesson 05 This lesson will discuss gathering significant statistics from data using aggregate functions. You'll also learn how to use the GROUP BY clause in conjunction with an aggregate function to gather important statistics from a table. Then you'll find out how to use the HAVING clause in conjunction with an aggregate function to filter groups of data from a table. Friday-Lesson 06 Today's lesson is all about subqueries. You'll learn how to extract data from multiple tables simultaneously, how to use calculated fields in subqueries, how to use the DATEPART function in subqueries, and how to use aggregate functions in subqueries.

Then this lesson will talk about qualificationa technique used to combine a table name with a column name so there's no question about which table the column name refers to.

Week Four Wednesday-Lesson 07 In this lesson, you'll learn how to use joins to gather information from two or more tables simultaneously. You'll learn how to use the inner join, self-join, natural join, and the outer join.

Then you'll become familiar with the term Cartesian product. You'll learn how to insert partial and complete rows into a table, and how to update information already stored in a table.

Youll find out how to transfer data to a new table, how to transfer data to an existing table, and how to delete rows from a table. The whole course contains 5 parts, starting with SQL fundamentals. Khan Academy allows users to watch videos without registering; however, after registration via Facebook, Google, or email they can ask questions regarding videos and participate in discussions.

A tutorial is a set of exercises that aims to acquaint you with new topics. At any time, you can consult the Reference section for background on the appropriate theory, explained with interactive examples. After completing each tutorial, you can take a quiz to show how well you understand the topic. The Assessments section offers several mini projects; each includes 15 questions of varying levels of difficulty. The course is available without registration, however, you can create an account with your email.

This is recommended if you want to publish comments or contribute to the site. There are plenty of easy-to-understand examples, but no interactive exercises to practice what you have learned. All courses available at TutorialsPoint. Although Udacity is profit-oriented, some courses are available for free. For this reason, Python fundamentals are required. The course consists of video lessons, and each lesson includes a final quiz.

The lessons are divided into four parts:. The course ends with a project that focuses on building a database-backed Python module to run a game tournament. SQL Problems and Solutions is an interactive textbook which lets you visualize tables and execute queries against a sample database. The tutorial explains the basic concepts and constructs of SQL and provides examples at various levels of expertise.

Unlike video courses, all tutorials and articles are completely free. Based around specific projects, they include step-by-step written instructions and screenshots to help you practice and master your skills.

In fact, this is more of an article than tutorial. It consists of two parts: In the second article, users learn about indexes, data types, and some rather more complex query structures. The course is based on Microsoft SQL Server , which is why the author provides newbie users with a guide on how to get started using this database engine.

The tutorial presents free tools to get you started, a guide leading you through the setup process, step-by-step explanations of how to download and activate a sample database, and much more. An especially great thing with Essential SQL is that Kris is personally involved in the teaching process. When there are problems or doubts, he strongly encourages readers to contact him. A significant drawback of this course is its lack of a structured learning program.

Most of the articles are available without registration; however, some content requires users to sign up with an email account. The essence of this course is perfectly described by the following review: Indeed, the tutorial looks much more like a story, where each chapter has some theoretical content, related questions, and exercises. You can learn the basics of creating and manipulating tables, get familiar with data migration, and start understanding data manipulation and transactions.

To keep the book simple, the site uses SQLite3 to teach you how to design data and work with it. Udemy is a leading global platform where experts create courses and offer them to the public, either at no charge or for a tuition fee.

There are several free SQL courses for both beginners and advanced users. SoloLearn is an online SQL training platform that offers a variety of free courses on programming languages. Based on the MySQL database, the SQL Fundamentals course covers the basics of database fundamentals such as query syntax, filtering records, aggregate functions, and joining tables, even teaching more advanced concepts like subqueries, set operations, and views.

The lessons are short but focused, allowing you to stay on target to finish the course in a relatively short period of time. Each module is followed by an interactive quiz, and the last module presents a summary with two challenges.

Delivered through a convenient and user-friendly platform, the Fundamentals course allows you to learn SQL at your own pace and from any device, such as your PC, tablet, or smartphone.

While the course is free, it does require registration, though the process is very simple. This website provides users with a set of tutorials on managing MySQL databases and manipulate data. The Basic MySQL tutorial helps you get familiar with the fundamentals, including managing databases, creating tables, querying and modifying data using various MySQL statements and other constructs.

SQLCourse provides easy-to-understand SQL instructions and allows you to practice what you learn with an on-line interpreter. The resources of both websites, SQLCourse and SQLCourse2 , are available without registration, however, you can sign up with your email to get free access to newsletters, whitepapers, and other premium contents.

Although it looks old-fashioned, Database Journal is a great comprehensive source of knowledge. Guru99 has a wealth of tutorials on a wide variety of subjects. Some of the tutorials are written, while others are video-based. The topics in respective sections are explained clearly and precisely. In addition to the section text, diagrams and funny pictures help to explain the material in an easy and accessible manner.

Sections conclude with a short summary, and you can also take an SQL Quiz to test your acquired knowledge. It covers basic database concepts such as ACID and how RDBMS work; provides examples of simple and complex queries, transactions, triggers, and views; and tackles issues like having Java executing inside an Oracle Server, handling foreign and legacy data, and normalization. The SQL examples given in the book are for the Oracle database. All of this is presented in a light way, with well-thought-out examples.

This course covers database design and the use of database management systems for applications. Courses are taught by Professor Jennifer Widom , co-author of four academic books covering beginning and advanced introductions to database systems. In brief, these courses cover: The Stanford Database Course has four major elements: Courseware , Readings , Discussion Forum , and Wiki.

Training for Microsoft SQL Server certifications

Main Topics

Privacy Policy

The basics of each SQL command will be covered in this introductory tutorial. Unless otherwise stated, the interpreter will support everything covered in this course. If you're already familar with the basics of SQL, you can still use this as a refresher, and practice some SQL statements.

Privacy FAQs

Popular Microsoft SQL Server training. If you’re ready to learn how to harness Microsoft SQL Server to deliver mission-critical performance, gain faster insights on data, or drive your hybrid cloud strategy, you’re in the right place.

About Our Ads

IT Pros and Developers, take our free, on-demand SQL Server courses – and take your skills to a whole new level. With our selection of SQL training opportunities, you can learn how to implement and manage database solutions, migrate to the cloud with the ability to scale on demand, work with powerful reporting features, and see how SQL Server integrates with SharePoint. SoloLearn is an online SQL training platform that offers a variety of free courses on programming languages. One of their courses is SQL Fundamentals — a great resource for fast, effective, and fun SQL .

Cookie Info

Get started with databases—from choosing your programming language to understanding stored procedures—by watching our SQL tutorials. Whether you want to execute a SQL transaction, run SQL. Why Learn SQL. We live in a data-driven world: people search through data to find insights to inform strategy, marketing, operations, and a plethora of other categories. There are a ton of businesses that use large, relational databases, which makes a basic understanding of SQL a great employable skill not only for data scientists, but for.