Best SQL Courses

Find the best online SQL Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free SQL Courses.

The Complete SQL Bootcamp 2021: Go from Zero to Hero

Become an expert at SQL!

Created by Jose Portilla - Head of Data Science, Pierian Data Inc.

"]

Students: 386210, Price: $159.99

Students: 386210, Price:  Paid

Learn how to use SQL quickly and effectively with this course!

You'll learn how to read and write complex queries to a database using one of the most in demand skills - PostgreSQL. These skills are also applicable to any other major SQL database, such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and much more.

Learning SQL is one of the fastest ways to improve your career prospects as it is one of the most in demand tech skills! In this course you'll learn quickly and receive challenges and tests along the way to improve your understanding!

In this course you will learn everything you need to become a SQL Pro! Including:

  • Get started with PostgreSQL and PgAdmin , two of the world's most popular SQL tools

  • Learn he basics of SQL syntax

  • Analyzing data using aggregate functions with GROUP BY commands

  • Running advanced queries with string operations and comparison operations

  • Learn to use logical operators to add logic flow to your SQL queries

  • Learn common SQL JOIN commands

  • Learn to create tables and databases with constraints on data entries

  • Learn to use Python to further advanced your SQL skills

  • and much, much more!

This is course that put's you in control, having you set up and restore databases right at the start of the course, instead of watching someone else code. Every section comes with fresh challenge questions and tasks, modeled after real world tasks and situations.

I've spent years as an instructor both online and in-person at Fortune 500 companies, and this course is built to combine the best of both worlds, allowing you to learn at your own pace through an interactive environment. You will start with the basics and soon find yourself working with advanced commands, dealing with timestamp data and variable character information like a seasoned professional.

SQL is one of the most in demand skills for business analysts, data scientists, and anyone who finds themselves working with data! Upgrade your skill set quickly and add SQL to your resume by joining today!

I'll see you inside the course!

Check out the free preview videos for more information!

Introduction to Databases and SQL Querying

A step by step introduction to the concept of Databases and Introduction to SQL Querying.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 379414, Price: Free

Students: 379414, Price:  Free

This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.

SQL Masterclass: SQL for Data Analytics

SQL course covering basic to advanced SQL topics for SQL Database ( PostgreSQL ). Elucidates SQL Database for beginners

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 325848, Price: $29.99

Students: 325848, Price:  Paid

6 Reasons why you should choose this SQL course

  1. Carefully designed curriculum teaching you everything in SQL that you will need for Data analysis in businesses

  2. Comprehensive - covers basics, advanced SQL statements, PostgreSQL, mySQL, interview tips and performance tuning tips as well

  3. Business related examples and case studies based on SQL techniques, PostgreSQL, mySQL, data analysis techniques

  4. Ample practice exercises because, like any other data analysis tools, SQL requires practice

  5. Downloadable resources covering important topics on SQL

  6. Your queries on SQL and anything covered in the Masterclass will be responded by the Instructor himself

A Verifiable Certificate of Completion is presented to all students who undertake this SQL course.

Why should you choose this course?

This is a complete tutorial on SQL which can be completed within a weekend. SQL is the most sought after skill for Data analysis roles in all the companies. PostgreSQL, mySQL are highly desired skills for database management and data analysis roles. So whether you want to start a career as a data scientist or just grow you data analysis skills, this course will cover everything you need to know to do that.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. They have an in-depth knowledge in advanced SQL, PostgreSQL, mySQL, database management, and various data analysis tools available in the market.

We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of SQL as an analytical tools. Kudos to the instructor! - Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts. Each section contains a practice assignment for you to practically implement your learning. Solution to Assignment is also shared so that you can review your performance.

By the end of this course, your confidence in using SQL will soar. You'll have a thorough understanding of how to use SQL for Data analytics as a career opportunity.

Go ahead and click the enroll button, and I'll see you in lesson 1!

Cheers

Start-Tech Academy

FAQ's

Why learn SQL?

  1. SQL is the most universal and common used database language.It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put,If you want to access databases then yes, you need to know SQL.

  1. It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people get interested data from database. It is also an English like language so anyone who can use English at a basic level can write SQL query easily.

  1. SQL is one of the most sought-after skills by hiring employers.

  1. You can earn good money

How much time does it take to learn SQL?

SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.

What are the steps I should follow to learn SQL?

  1. Start learning from the basics of SQL. The first 10 sections of the course cover the basics.

  2. Once done with the basic try your hands on advanced SQL. Next 10 sections cover Advanced topics

  3. Next few sections will cover help you with interviews and Vivas.

  4. Practice your learning on the exercise provided in every section.

What's the difference between SQL and PostgreSQL?

SQL is a language. Specifically, the "Structured Query Language"

PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS's, others of which are Oracle, Informix, MySQL, and MSQL.

All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it's all still SQL.

Which is better, PostgreSQL or MySQL?

Both are excellent products with unique strengths, and the choice is often a matter of personal preference.

PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.

Open source development will bring more features to subsequent releases of both databases.

Who uses these databases?

Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.

What's special about this course?

The course is created on the basis of three pillars of learning:

  1. Know (Study)

  2. Do (Practice)

  3. Review (Self feedback)

Know

We have created a set of concise and comprehensive videos to teach you all the SQL related skills you will need in your professional career.

Do

We also provide Exercises to complement the learning from the lecture video. These exercises are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.

Review

Check if you have learnt the concepts by executing your code and analyzing the result set. Ask questions in the discussion board if you face any difficulty.

Bonus Lectures

Apart from this, their is a bonus section which covers important topics from the view of job interviews and Vivas.

The Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of SQL in today's corporate world.

The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert

Become an In-demand SQL Master by creating complex databases and building reports through real-world projects

Created by Colt Steele - Developer and Bootcamp Instructor

"]

Students: 252320, Price: $89.99

Students: 252320, Price:  Paid

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is a gentle but comprehensive introduction to MySQL, one of the most highly in-demand skills in the business sector today.  

Whether you work in sales or marketing, you run your own company, or you want to build your own apps, mastering MySQL is crucial to answering complex business problems and questions using insights from data. The Ultimate MySQL Bootcamp introduces you to a solid foundation in databases in a way that’s both informative and engaging. Yes, that’s right, it’s possible to make an engaging course on databases.  

In this course, you will:

  • Learn the ins and outs of SQL syntax

  • Generate reports using sales and user data

  • Analyze data using Aggregate Functions

  • Run complex queries using MySQL logical operators and string functions

  • Write all the common SQL joins

  • Work with large datasets containing thousands of entries

  • Build a web app using MySQL and NodeJS

  • Design and implement complex database schemas

  • Learn to navigate the treacherous world of storing dates and times

  • Clone the database structure of a photo sharing social network

  • Write Javascript code to generate fake data sets

  • And more!

This course is also chock full of exercises, challenges, projects, and opportunities for you to practice what you’re learning. Apply what you’re learning to real-world challenges such as finding a website’s power users, calculating your top students, identifying bots on a site, or determining which hashtags generate the most traction on a site. Along the way, you’ll also get to meet my pet cat, Blue! (She’s really cute.)

Why Learn MySQL

Consistently ranked the most in-demand skill in recent employer surveys, SQL is a fantastic way to increase your income and boost your professional development. So many companies today use MySQL, including Twitter, Uber, Airbnb, Dropbox, Github, Kickstarter, Udemy, Slack, and many others. Unsure about the difference between SQL and MySQL? MySQL is the most popular open source SQL database out there, so it’s a great choice to begin your learning journey. We’ll talk a lot more about the difference between SQL and MySQL in the course, but 95% of what you learn about MySQL in this course will apply to other databases such as Postgres, Oracle, and Microsoft SQL Server.

Why This Course Is Different  

This isn’t going to be a course where you watch me code for 20 hours; it’s a course with ample opportunity for you to get your hands dirty writing code (even within the first 7 minutes of the course).

My teaching experience is rooted in the classroom. I’ve spent years teaching programming, web development, and databases to my in-person bootcamp students. This course combines the best of my offline courses with the convenience of learning online, in a setting that’s best for you.   

Upon completing this course, you’ll be able to interact with and query any SQL database out there. You’ll also be able to generate reports with ease, answer company performance questions using data, and integrate MySQL into complete applications.

So let’s do this! Enroll today and start learning SQL!

Advanced Databases and SQL Querying

Learn advanced T-SQL Querying concepts. Go from a beginner SQL programmer to writing complex SQL Queries.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 198265, Price: Free

Students: 198265, Price:  Free

This course is an advanced TSQL Querying course. The course expects that student are already aware of basic database concepts and are comfortable writing basic TSQL queries like SELECT, JOINS etc. Students are expected to have taken my previous course (Introduction to databases and Querying). This course cover advanced concepts like Views, Triggers, Dynamic Queries etc. The TSQL Scripts for all demos are uploaded. The course about 2+hours and has assignments at the end of each concept.

If you looking for your next database job or trying to improving your existing database knowledge and apply in your projects, this is the course for you.

SQL – MySQL for Data Analytics and Business Intelligence

SQL that will get you hired – SQL for Business Analysis, Marketing, and Data Management

Created by 365 Careers - Creating opportunities for Business & Finance students

"]

Students: 112931, Price: $99.99

Students: 112931, Price:  Paid

How important is database management in the age of big data and analytics?

It is really important.   

How many employers would be happy to hire employees who can use data for the purposes of business intelligence?   

All of them.

 

How many people have these skills?

Not enough.

 

This is why now is the time to learn SQL and gain a competitive advantage in the job market. Remember, the average salary of a SQL developer is $92,000! That’s a lucrative career.   

How come?   

Well, when you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business. For instance, Database management is the foundation for data analysis and intelligent decision making.   

Worried that you have no previous experience? 

Not an issue. We will start from the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.   

Why take this course in particular? Isn’t it like the rest of the SQL courses out there?

 

We would like to think it isn’t. Our team worked hard to create a course that is:

 

  • Easy to understand

     

  • Time efficient and concise

     

  • Shows how SQL can be crucial for data analytics and business intelligence   

  • Comprehensive – it covers several topics not shown in other SQL courses   

  • Practical – it teaches you how to work with a real-life database   

  • Corresponds to professional best practices

     

  • Taught in MySQL – The most popular SQL database management system

     

  • Contains plenty of downloadable exercises, course notes, and quiz questions

     

Some of these aspects have been covered in other courses. Others haven’t. However, no one provides such a variety of topics in one place.

 

We firmly believe this course is the best training material out there. It is a truly interactive experience preparing you for a real-life working environment.   

We love teaching   

So far, over 210,000 students have enrolled in our courses here on Udemy. Teaching is what we do best, and we take pride in going the extra mile to create the best content for you, our students. Our mission is to help you bridge the gap between theoretical knowledge taught at school and in universities and the practical application required at the workplace.   

So, why do you need to enroll in this course and learn SQL?

 

  1. Salary/Income. As we pointed out earlier, learning SQL is a great opportunity. There is a significant surge in demand for skills revolving around database management, database administration, and business analysis relying on data. Companies will pay top dollars for specialists who have such know-how

     

  2. Profession of the future. In the years to come, data will only grow in importance and size. Therefore, it is great to pick up a skill that will likely increase in demand over the years to come

     

  3. Analytical reasoning. Programming languages are a great way to train your mind. Furthermore, understanding a business task and looking for its solution through writing code can be really interesting and stimulating once you become familiar with the basics

     

What about certificates? Do you provide a certificate?

Upon completion of the course, you will be able to download a certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess.

 

Sounds awesome, right?

 

So, what are you waiting for? Click the “Take this course” button, and let’s begin this journey together!

 

The Complete Oracle SQL Certification Course

Don't Just Learn the SQL Language, Become Job-Ready and Launch Your Career as a Certified Oracle SQL Developer!

Created by Imtiaz Ahmad - Senior Software Engineer & Trainer @ Job Ready Programmer

"]

Students: 106525, Price: $149.99

Students: 106525, Price:  Paid

LAST UPDATED: November 2020

(Source Code Included for Lectures)

Get ready to acquire some seriously marketable programming skills! You can't consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company's biggest asset is their data. All databases require the language SQL to store and retrieve data. Salaries for junior level SQL Developers are upwards of $70,000 - $90,000 dollars a year! The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we're going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you've completed the course (in 2 months), you can call your self an Oracle SQL Master! Oracle is the most popular relational database in the world! This course will prepare you to be job-ready in just 1 month of study and practice.

All exercises and solutions are in the lectures. In several lectures I ask students to pause the video and complete the assignment before resuming to watch my solution. MAKE SURE YOU WORK OUT THE PROBLEMS ON YOUR OWN BEFORE MOVING ON TO MY SOLUTION!!

With over 62,000 enrolled students and a 4.5 star-rating, this is a Udemy best-selling course.

Do you have no prior experience in SQL development? This course is perfect for you. Don't take it from me, take it from actual students that took this course:

"I am a beginner and the way this course starts is perfect for the person who has no introduction of SQL or Oracle."

Do you have prior experience, but need a refresher or to fine-tune your skills? This is the course for you. Again, I'll let my students do the talking:

"I had a good base of knowledge from my last employment. This course is constantly proving useful to supercharge my actual knowledge base. Very good one!"

Have you taken a SQL course before, but felt confused on certain topics or not completely satisfied in your abilities? A lot of my students had shared similar concerns:

"I had previously taken a college course about databases and SQL, but these ten hours of content were more clear and useful than the course and textbook."

Topics covered in this course :

  • Basics of Tables

  • SELECT and WHERE Clause

  • WHERE, AND & OR with Operators

  • BETWEEN, IN and NULL

  • Single Table Queries

  • Single Row Functions

  • Grouping Functions

  • GROUP BY and HAVING Clause

  • Joins

  • Inner and Outer Joins

  • EXISTS & NOT EXIST Operators

  • Creating Your Own Tables

  • Using ALTER

  • Creating Tables with SELECT & UPDATE Data

  • DELETE, TRUNCATE, and DROP Commands

  • System Tables, Pseudo Columns & Deleting Duplicates (Newly Added)

  • Views and Other Objects and Commands (Newly Added)

Ethical Hacking – SQL Injection Attack

Learn Website hacking using SQL Injection Attack - Database Penetration testing

Created by Sunil K. Gupta - HACKER | 36 Udemy Courses | 55000+ STUDENTS

"]

Students: 89159, Price: Free

Students: 89159, Price:  Free

SQL Injection (SQLi) refers to an injection attack wherein an attacker  can execute malicious SQL statements (also commonly referred to as a  malicious payload) that control a web application’s database server .

The impact SQL injection can have on a business is far reaching. A  successful attack may result in the unauthorized viewing of user lists,  the deletion of entire tables and, in certain cases, the attacker  gaining administrative rights to a database, all of which are highly  detrimental to a business.   

In this course, you will perform SQL injection attacks on websites . This course is a practical course in which you are going to perform practicals based on sql injection attack .

NOTE: This course is created for educational purposes only .

NOTE: This course is a product of Sunil Gupta and no  other organisation is associated with it or a certification exam.  Although, you will receive a Course Completion Certification from Udemy.

Oracle SQL Developer: Mastering its Features + Tips & Tricks

Use Oracle SQL Developer like a Pro: Learn the features & tricks that will help you be the most efficient SQL developer

Created by Carlos from Standout-Dev Academy - Software Development Director & Chief Educator

"]

Students: 70817, Price: $74.99

Students: 70817, Price:  Paid

* List Price temporarily reduced from $74.99 to $19.99

Oracle SQL Developer is currently the most popular tool among database developers and Oracle SQL learners, however, since it makes it so easy to start firing commands and querying a database, many people don't feel the need to investigate its features, and end up using only what is obvious, visible, and enabled by default.

If you are one of them, this course will help you get out of that group and start using Oracle SQL Developer more smartly.

Even if you have some time using the tool and are currently using some of its features, there's most likely something in this course that you don't know and can be helpful to you.

Learn the features that can help you work with your Oracle database better and faster:

  • Install and customize SQL Developer in a way that works and feels best for you.

  • Take full advantage of the most useful features of the tool.

  • Create and share beautiful and interactive reports.

  • Take advantage of features that will make you more effective and efficient at work.

  • Learn a lot of tricks and enjoy being seen as an SQL Developer expert.

All Oracle SQL Developer features are free. Take advantage of them:

This course was created because there appears to be a pattern among Oracle SQL courses and the database community in general: “If you are able to install it and connect to a database, you are good to go".

What's more: Experience shows that even developers who are already working with Oracle databases as part of their job, tend to not look for ways to work faster in SQL Developer, and usually only investigate features they don't currently use when it is strictly necessary for their jobs.

The goal of this course is to fill the gap most SQL courses leave about this great tool so that it can serve as a foundation if you are planning to learn Oracle SQL, and also to help you take advantage of the tool's features if you are already working with Oracle databases as part of your job, so that you can be more efficient and productive, and thus, stand out.

Content and Overview:

The course includes more than 3 hours of content and covers many of the most useful features of SQL Developer.

There is usually one lecture per feature, so, if for any reason you are not interested in any of the included tips, you can simply skip it, and go directly to the one you want to learn about.

The course content will continue to be updated over time, to make sure you always know about the most important features available to you, as new versions of Oracle SQL Developer are released.

Learn these tips and apply them to your work, and you will not only be well prepared to work more smartly and efficiently, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers.

Oracle SQL – A Complete Introduction

Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples.

Created by Ben Brumm - IT Software Consultant

"]

Students: 68457, Price: Free

Students: 68457, Price:  Free

Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work.

This course will teach you the basics of the SQL language on an Oracle database.

It uses video lectures to teach you Oracle SQL, covering database topics such as:

  • Setting up your Oracle environment
  • Basic terminology
  • Reading data using a SELECT statement
  • What can be done using a SELECT statement
  • Functions
  • Data types
  • Joins, set operators, subqueries
  • Inserting, updating and deleting data
  • Creating tables

The course materials run for approximately 4 hours and are split into multiple sessions.

It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn.

Why should you take this course?

There are many benefits of taking my Oracle SQL course:

  • You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours
  • Avoid paying thousands of dollars for training.
  • You can also study in your own time!
  • Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)!

If you want to learn Oracle SQL from someone who has experience, then take this course.

SQL for Data Analysis: Weekender Crash Course for Beginners

Using MySQL but applicable to Oracle SQL, Microsoft SQL Server, and PostgreSQL. Taught by a Data Scientist and PM.

Created by A Course You'll Actually Finish - A Course Series

"]

Students: 65932, Price: $124.99

Students: 65932, Price:  Paid

Buff up your resume/CV and become interview-ready by learning real-world SQL in this course.

This SQL course has been taken by fine marketing folks at Google, Facebook, Amazon, Lyft, and Udemy.

Your Story:

Bill was looking to move into a more analytical role and saw SQL as a requirement in the job listings he saw.  He wanted to add "SQL" as a skill to his resume/CV with a clean conscience and back it up if any questions arose in the interview.  But getting there would take forever. Better to just "fake it til' you make it"... right?

Joe was working in a marketing position at a small company. He had a bunch of creative ideas but sometimes felt like he was shooting in the dark and guessing at what customers were doing. If only he had some insights about user behavior so he could be a more data-driven marketer. But data analysis is only for technical folks… right?

Our Story:

David and Pete joined Udemy with little to no technical experience. But after a lot of trial and error, headaches, and help from their friends, they got good enough to uncover unique insights for themselves, their team, and their company using SQL. They were able to discover interesting things about user behavior, create dashboards to track and measure progress on team goals, pull data for the exec team to use in investor pitch decks, and get data driven about decisions they made. They've since helped many team members buff up their data analysis skills and helped students land jobs!

What You'll Learn:

If you have no technical background, don't be afraid! We've distilled our knowledge and experience using SQL into a short course so that by the end, you'll have the raw skills to do some real data analysis for your company using SQL - a language virtually EVERY company uses. Note: this courses teaches you real-world SQL - not just the theory in abstract, but real skills you can use to get more data-driven in your current job. 

How This Course is Structured:

  • In this course we'll be pretending we're a real business (i.e. Blockbuster) so the stuff you learn will be easy to apply to your own situation/company. No abstract/theoretical mumbo jumbo.
  • We'll go through queries a real business would run while also teaching you the raw skills undergirding those queries so you can adapt those skills to create custom queries for your own specific purposes
  • To reinforce learning, we have exercises and quizzes scattered throughout the course so you can learn by doing
  • We'll have a bonus section where new lectures will be added occasionally (including student-requested lectures, more advanced topics, strategies for getting unstuck, etc.)
  • We'll be actively involved in the discussion board answering any questions you might have! Don't be afraid to ask!

A Note About Pedagogy:

We know what it's like to buy a book, feel good about yourself, never finish it and have nothing to show for it. We don't want that to happen with this course. We want this to be a course you'll actually finish. We believe half of learning is motivation and engagement, so we've tried extra hard to make this course fun, relevant, entertaining, and punchy - no frills, no dragging things out, just the good stuff. Heck, you might even find yourself skipping a party to spend time with your new best friends (i.e. us)!

FAQs:

  1. Do I need to purchase any software to take this course? Nope! Everything we use to do data analysis with MySQL is completely free. We'll walk you through the installation and set-up of any software we'll be using.
  2. Can I take this course with Linux? The set-up and installation lectures we've created are for Windows and Mac, and we don't currently have specific installation lectures for Linux.

The Ultimate Guide in Becoming a SQL Server DBA

Everything you wanted to know about becoming a SQL Server DBA but were afraid to ask

Created by Raphael Asghar - Production SQL Database Administrator

"]

Students: 61017, Price: Free

Students: 61017, Price:  Free

The primary purpose of this course is to give the student a sample of what the SQL Server administration is about, what are the requisites courses in becoming a SQL DBA, some guidelines as to what to expect from the job, and get some hands on experience in installing and navigating through SQL Server management studio. The course will provide a summary of courses needed that will enable the student to prepare for the real world IT industry.  These courses are SQL Administration part 1, SQL Administration part 2, SQL Administration part 3, SSRS part 1, SSRS part 2, Learn T-SQL and SSIS. Collectively, it's all that a SQL dba needs to secure a job.

SQL for Beginners: Learn SQL using MySQL and Database Design

Understand SQL using the MySQL database. Learn Database Design and Data Analysis with Normalization and Relationships

Created by Tim Buchalka's Learn Programming Academy - Professional Programmers and Teachers - 1.22M students

"]

Students: 58416, Price: $89.99

Students: 58416, Price:  Paid

Have you heard that database skills are essential for developers to be skilled in and understand?

Are you wanting to understand SQL and databases in general, but don't know where to start?

Maybe you have a pressing need to learn about Database Design and/or Data Analysis but have not found a good place to learn.

Or perhaps you are a developer who wants to improve your career options by having skills in SQL and MySQL, one of the worlds most popular databases.

Whatever the reason you have arrived here, this course will...

Help you understand and apply SQL with MySQL, including Database Design and Data Analysis.

Having database skills is absolutely vital for developers to avoid getting left behind and to maximise job and consulting opportunities.

Key concepts you will learn and work with in this course.

SQL (Structured Query Language - very much an in-demand technology).
MySQL (one of the worlds most popular and widely used databases).
Database Design
Data Analysis

The database design section (normalization and relationships) isn't covered in the majority of SQL courses on Udemy.  You will struggle to find another MySQL course that has a section on this.   This section alone, will give you a huge edge over other applicants for jobs.

Through the course you will go through creating an example database for a cinema online booking system using concepts taught in the database design section.

Creating, Modifying and Deleting Tables in a Database (DDL)
Inserting, Updating and Deleting Data from Tables (DML)
Select Queries
Joins
Aggregate Functions
Subqueries
Database Design
Creating Databases.

In addition there are installation videos covering MySQL on Windows, Mac or Linux.

Not only does the course teach you SQL, but there are multiple exercises for you to try with video solutions to further help you understand the material.

Also note that while MySQL is the database of choice in this course, the SQL skills you acquire will work largely with any database.

Why enrolling in this course is the best decision you can make.

Become skilled as a database developer generally needs you to learn SQL, a database, and then database design.  Often this will require multiple courses.  However you learn all those topics, and data analysis in this one course.

Jon Avis, the instructor, has 4 years experience working as an IT Systems Engineer, and works with SQL and Databases everyday.  Part of his role as a Systems Engineer is to teach complex, technical subjects to colleagues which makes him the ideal instructor for this course.

Essentially, you are learning from someone who has all the professional training, skills, and experience needed to  teach you how to become proficient with SQL, MySQL and Database design as quickly as possible.

If you are ready to get that first paid programming job, or to move up to a more senior programming position, then this course is for you!

After completing this course, you will have the necessary skills to be able to use SQL confidently, have a solid understanding of MySQL and be skilled in database design.

The sooner you sign up for this course, the sooner you will have the skills and knowledge you need to increase your job or consulting opportunities.  

SQL and MySQL skills are in high demand, as is Database Design, and you will understand and be able to use both after going through this course.

Your new job or consulting opportunity awaits!  

Why not get started today?

Click the Signup button to sign up for the course!

Microsoft SQL for Beginners

A comprehensive course to teach you how to complete SQL queries using Microsoft SQL Server and the T-SQL language.

Created by Brewster Knowlton - Business Intelligence Expert

"]

Students: 50710, Price: $44.99

Students: 50710, Price:  Paid

Do you want to learn a skill that can help you earn nearly $100,000 per year? If so, then this course is for you!

SQL (Structured Query Language) is the language we use to interact with databases that store data. This allows us to retrieve data with ease and simplicity. As terms like business intelligence and big data become more familiar, businesses will need more people to learn the SQL language.

This course will teach you how to use the SQL language within Microsoft SQL Server, one of the most popular database engines in the world.

You will have plenty of video lessons to teach you the majority of the content. Each section includes practice problems or additional e-books to help reinforce what you learn in the video tutorials.

70-461, 761: Querying Microsoft SQL Server with Transact-SQL

From Tables and SELECT queries to advanced SQL. SQL Server 2012, 2014, 2016, 2017, 2019, exams 70-461 and 70-761

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 38912, Price: $129.99

Students: 38912, Price:  Paid

Previously available as seven separate courses, now presented in one big course.

Reviews

"The instructor explain the things in great details. Very easy to follow." - Linda Shen

"Excellent course, valuable lessons, very well taught at a great pace." - Shane Tanberg

"Must get tutorial. Love it" - Hayford I Osumanu

"Perfect step by step guide to learning. Best I've seen." - Charles Schweiger

"This course is very well thought out. Its one of the better 70-461 courses on Udemy." - Isrrael M

-------------------------

This course is the foundation for the Microsoft Certificate 70-461: "Querying Microsoft SQL Server 2012" and 70-761 "Querying Data with Transact-SQL".

Session 1

The basics presented are: how to install SQL Server, and how to create and drop tables.

We then try to create a more advanced table, but find that we need to know more about data types - so we go into some detail about data types and data functions, the foundation of T-SQL.

Session 2

We'll create tables which use these, and then INSERT some data into them. Then we'll write queries which will retrieve and summary this data, using SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY.

We'll then JOIN these tables together to find where we are missing data and where we have inconsistent data. We'll then UPDATE and DELETE data from the tables. This will allow up to fully complete objective number 1 from the 70-461 exam.

Session 3

We'll now use that data to create views, which enable us to store these SELECT queries for future use, and triggers, which allow for code to be automatically run when INSERTing, DELETEing or UPDATEing data.

We'll look at the database that we developed in session 2, and see what is wrong with it. We'll add some constraints, such as UNIQUE, CHECK, PRIMARY KEY and FOREIGN KEY constraints, to stop erroneous data from being added some data. By doing this, we will complete objectives 2, 3, 4 and 5 from the 70-461 exam

Session 4

We will further encapsulate our routines by creating procedures, allowing us to EXECUTE parameterised commands with just one statement, and we'll add some error handling with TRY, CATCH and THROW.

We'll also combine datasets together, by looking at UNION and UNION ALL, INTERSECT and EXCEPT, CASE, ISNULL and Coalesce, and the mighty MERGE statement. By doing this, we will complete objectives 11, 12, 13 and parts of 6 and 18 from the 70-461 exam.

Session 5

We'll will now be creating aggregate queries, working through objective 9 of the exam 70-461. We'll be reviewing the ranking functions ROW_NUMBER, RANK, DENSE_RANK and NTILE. We'll look at the 8 analytic functions news to SQL Server 2012, such as LAG, LEAD, FIRST_VALUE and LAST_VALUE.

We'll look at alternative ways of grouping and adding totals, using ROLLUP, CUBE, GROUPING SETS and GROUPING_ID. If you want to take the 70-461 exam, we'll also look at the geometry and geography data types, plotting locations on a grid, together with functions and aggregates.

Session 6

We'll will now be creating sub-queries, working through objectives 7b-e of the exam 70-461. We'll be created correlated subqueries, where the results of the subquery depend on the main query. We'll be looking at Common Table Expressions using the WITH statement, and we'll be using what we have learned to solve a common business problem.

We'll be looking at functions (objective 14), including the three different types of User Defined Functions (UDF): scalar functions, inline table functions, and multi-statement table functions. We'll then complete objective 6 by looking at synonyms and dynamic SQL, and objective 8 by looking at the use of GUIDs. We'll also look at sequences.

We'll have a look at XML. Finally, for SQL Server 2016 and later (exam 70-761), we'll examine JSON and Temporal Tables.

Session 7

In this session we'll be looking at transactions, seeing how to explicitly start and end them, and finding out how they can block other users in the database. Then we'll see about how to indexes and their role in optimising queries. 

We'll also see how we can use Dynamic Management Views to see how we can improve our use of indexes. We'll then look at how to write a cursor, and when to use this row-based operation, and the impact of using scalar UDFs.

No prior knowledge is required - I'll even show you how to install SQL Server on your computer for free!

There are regular quizzes to help you remember the information.

Once finished, you will know what how to manipulate numbers, strings and dates, and create database and tables, create tables, insert data and create analyses, and have an appreciation of how they can all be used in T-SQL.

Master SQL For Data Science

Become a SQL query wizard and never be afraid to look at a large SQL query again!

Created by Imtiaz Ahmad - Senior Software Engineer & Trainer @ Job Ready Programmer

"]

Students: 32818, Price: $139.99

Students: 32818, Price:  Paid

LAST UPDATED: November 2020

This course will turn you into a SQL query wizard. You'll learn the skills you need to extract critical insight from data sitting in a database. There are over 100 puzzles scattered throughout the course with in-depth solutions providing plenty of opportunity for you to practice. After completing the course and all of it's assignments, I promise you, you'll never be afraid to look at a large SQL query again. 

Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, rollups and cubes, window functions, transposing & ranking data and using conditional expressions in very interesting ways. 

With over 17,000 students and a 4.6 rating, you won't find a better source to learn SQL for Data Science elsewhere.

Don’t just take it from me, take it from other students that have taken this course.

★★★★★ Here’s reviews from real students that took this course ★★★★★

★★★★★ You really can't beat this course for the value. The instructor is excellent (clear explanations, easy to understand, extremely knowledgeable), and his style of constantly requiring the student to apply what they've just learned with practice queries proves to be a very effective method of learning. He covers an amazing amount of ground in just 9 hours. It was just the refresher course I needed after not having done much SQL in the past year.

★★★★★ Just one word - Exceptional!! Don't give a second thought, just go for it. Thanks a lot Mr.Imtiaz Ahmad. The way concepts are explained in the lectures are quite good. The assignments gave me so much confidence and I feel so happy that I am quite well versed in SQL now. Watch the videos, try out the assignments on your own and practice as much as you can with different problems.

★★★★★ It's a brilliant course that can help to understand SQL from easy concepts to difficult tasks. Besides, the explanations are always clear, so they let me learn a lot without searching for additional information in Internet. The course contains lots of practical tasks that allowed me not only to understand queries, but to also use them correctly.

★★★★★ Great! I really like the exercises that are included. They are essential to learning the course content.

★★★★★ After attending the course and doing most of the exercises, I feel very confident in SQL world. The course is designed well and every lesson gives you good amount of knowledge. Explanation and exercises are worth learning and practicing.

Topics covered in this course:

  • What is a Database

  • Installing Postgres

  • Creating Tables

  • SELECT Statement

  • WHERE Clause

  • AND & OR

  • Filtering Operators

  • ORDER BY

  • LIMIT

  • DISTINCT

  • Renaming Columns

  • Functions

  • GROUP BY & HAVING Clauses

  • Aggregation Queries

  • Subqueries

  • CASE Clause

  • Correlated Subqueries

  • Table Joins

  • INNER and OUTER Joins

  • UNION, UNION ALL and EXCEPT Clauses

  • Window Functions for Analytics

  • + over 100 puzzles distributed throughout the course

Enroll today to become a Master SQL Data Science Developer. As always, I offer a 30 day money back guarantee if you're not satisfied, but you won't need it.

The Complete Oracle SQL Bootcamp (2021)

Become an In-demand SQL Professional & Pass Oracle SQL 1Z0-071 (OCA) Certification Exam Confidently!

Created by Oracle Master Training • 100,000+ Students Worldwide - Oracle Architect & Best Selling Instructor

"]

Students: 30585, Price: $109.99

Students: 30585, Price:  Paid

Last Course Updates:

(May, 2021): 3-Real SQL(200+ High-Quality Questions) Certification Exam Samples are added!

(Apr, 2021): New Lectures and Quiz Questions are added!

(Feb, 2021): Closed-Captions are updated!

Important Notice: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL.

Are you a student ready to learn SQL for your lessons?

Do you want to get a better job?

Are you bored with watching a lot of stuff, but could not learn anything?

Do you think you know SQL, but you cannot write SQL codes?

Are you looking for a really professional course?

Then this is the course you are looking for.

You have come to the right place!

In this course, all the subjects are explained in a professional order.

   If you are new to SQL, no problem! You can easily learn with all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects.

   After completing this course, you will learn all that you need to know. If you don't see something in this course, it means you really don't need to know it for now.

   Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.

So come on, what are you waiting for?

Get this course, and go get a better job!

Benefits of Taking This SQL Course:

Knowing SQL can get you a better job or improve the one you have and it can earn you $80-100k+ in the IT Industry. It's a skill that will put you more in demand in the biggest technology companies in the IT industry, and make your software life easier, this is why it's so popular and backed by Oracle.

This course will help you quickly get up to speed with Oracle SQL. I will demystify the query skill and help you understand the essential concepts of how to write SQL codes easily and thinking analytically against the problem in your company.

Student Reviews Prove This Course's Worth:

Those who have reviewed the course have pointed out that the instruction is clear and easy to follow, as well as thorough and highly informative. Other students enjoy the use of relevant examples throughout the course, as these make the content even easier to comprehend.

Many students had also taken other SQL courses in the past, only to find that this SQL course was their favorite. They enjoyed the structure of the content and the high-quality audio/video.

Check out all of the great reviews in the review section ... a lot of happy students :-)

Important Notice:

Knowing SQL is "mandatory" for any IT Professionals and having good SQL knowledge will be a "GREAT PLUS" for you!

If you want to Become a Job-Ready SQL Professional who can pass any Oracle SQL Exam confidently, this course will be the next step for you!

So let’s do this! I'll see you in the first lecture!

Free SQL 101 Class Bootcamp Beginners Intro to SQL NYC

Gentle Introduction to Non Programmers on SQL for Analytics. 1 day Bootcamp Course Begineers Hands-on. Project: New York

Created by Shivgan Joshi - Free Python Class Bootcamp Big Data Science NYC 312 285 6886

"]

Students: 29045, Price: Free

Students: 29045, Price:  Free

SQL 101 Bootcamp is build up based on the SQL classes for Analytics taken in NYC, New York by Shivgan Joshi. Having taught at various bootcamps in NYC and gathering feedback from students this course addresses all the major topics you need to get started for Analytics in SQL  if you have never programmed.

This course will help you answer and critically think and implement:

  1. Create a DB design for your day to day work data that you use in Excel

  2. Understand what you can do and what you cannot do. Or rather how hard or simple it is to do some analytical steps in SQL.

  3. Understand Data Wrangling using Group, Joins and UNION to get data in the format you need

  4. For any data that comes to you new tools get new insights

  5. Get Excel equivalent functions for SQL commands

  6. Understand the data wrangling terms often used in Data Analytics that remain common to all languages (Python / R / SQL)

Other areas that will be introduced to are:

  1. Understand why SQL is needed as a solution to limitation of excel

  2. Connect to the SQL Server database and execute a simple query.

  3. Include a search condition in a simple query.

  4. Use various functions to perform calculations on data.

  5. Organize data obtained from a query before it is displayed on-screen.

  6. Use New York City data for running on SQL

SQL for Data Analysis: Beginner MySQL Business Intelligence

Learn SQL database querying w/ MySQL Workbench. Perfect for SQL beginners and first-time coders.

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 27830, Price: $139.99

Students: 27830, Price:  Paid

See why this is one of the TOP RATED SQL/MySQL Courses on Udemy:

"Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!"

- Maggi M.

"I totally loved this course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"John's deep understanding of SQL and database analysis and ability to explain those tools to a newcomer with 0 experience, is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the easiest way to understand SQL. Excited to see more courses from John!"

- Steven M.

______________________________

SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence professional should have in the arsenal.

In this course, you’ll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior.

But don't worry, you're not alone! We'll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL and database analysis skills along the way.

______________________________

COURSE OUTLINE:

  • SQL Intro & MySQL Setup

    We’ll start with a quick intro to the SQL landscape and it's common "flavors" (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we'll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)

  • SQL Database Fundamentals (Part 1)

    Once we have our tools installed, we'll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions.

  • Analyzing Data from Single Tables with MySQL

    In this section we'll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data.

    [MID-COURSE MYSQL PROJECT]

  • SQL Database Fundamentals (Part 2)

    The second half of the course is all about anayzing data from multiple tables in MySQL, so we'll begin with a quick review of relational databases and database analysis: primary vs. foreign keys, relationship cardinality, normalization, etc.

  • Analyzing Multiple Tables via MySQL JOINS

    In this section, we'll review the most common types of SQL joins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database.

    [FINAL MYSQL PROJECT]

IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we'll cover database administration tools in a separate course).

______________________________

Enroll today and get LIFETIME access to:

  • 5+ hours of high-quality video

  • Downloadable MySQL ebook

  • Quizzes and homework assignments

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

If you’re looking for a hands-on, practical guide to mastering data analysis with SQL/MySQL, this is the course for you!

Happy analyzing!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Microsoft SQL Server – An Introduction (2018 edition)

A quick tour of T-SQL, DBA and SSRS (all part of Microsoft SQL Server)

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 27199, Price: Free

Students: 27199, Price:  Free

This course is a brief presentation of SQL Server.

We will install a version of SQL Server Express for free, install it, and create a database and table.

We'll also add some data and retrieve it.

We'll then look at the SELECT statement with its 6 main clauses (SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY).

Following this, we'll create SQL Views and Procedures, connect it to Excel, and have a brief look at SSRS (SQL Server Reporting Services) and backup and restore a database.

No prior knowledge is required - just a willingness to learn.

See you on the course.

Python + SQL + Tableau: Integrating Python, SQL, and Tableau

See the full picture: Learn how to combine the three most important tools in data science: Python, SQL, and Tableau

Created by 365 Careers - Creating opportunities for Business & Finance students

"]

Students: 27095, Price: $139.99

Students: 27095, Price:  Paid

Python, SQL, and Tableau are three of the most widely used tools in the world of data science.

Python is the leading programming language;

SQL is the most widely used means for communication with database systems;

Tableau is the preferred solution for data visualization;

To put it simply – SQL helps us store and manipulate the data we are working with, Python allows us to write code and perform calculations, and then Tableau enables beautiful data visualization. A well-thought-out integration stepping on these three pillars could save a business millions of dollars annually in terms of reporting personnel.

Therefore, it goes without saying that employers are looking for Python, SQL, and Tableau when posting Data Scientist and Business Intelligence Analyst job descriptions. Not only that, but they would want to find a candidate who knows how to use these three tools simultaneously. This is how recurring data analysis tasks can be automated.

So, in this course we will to teach you how to integrate Python, SQL, and Tableau. An essential skill that would give you an edge over other candidates. In fact, the best way to differentiate your job resume and get called for interviews is to acquire relevant skills other candidates lack. And because, we have prepared a topic that hasn’t been addressed elsewhere, you will be picking up a skill that truly has the potential to differentiate your profile.

Many people know how to write some code in Python.

Others use SQL and Tableau to a certain extent.

Very few, however, are able to see the full picture and integrate Python, SQL, and Tableau providing a holistic solution. In the near future, most businesses will automate their reporting and business analysis tasks by implementing the techniques you will see in this course. It would be invaluable for your future career at a corporation or as a consultant, if you end up being the person automating such tasks.

Our experience in one of the large global companies showed us that a consultant with these skills could charge a four-figure amount per hour. And the company was happy to pay that money because the end-product led to significant efficiencies in the long run.

The course starts off by introducing software integration as a concept. We will discuss some important terms such as servers, clients, requests, and responses. Moreover, you will learn about data connectivity, APIs, and endpoints.

Then, we will continue by introducing   the real-life example exercise the course is centered around – the ‘Absenteeism at Work’ dataset. The preprocessing part that follows will give you a taste of how BI and data science look like in real-life on the job situations. This is extremely important because a significant amount of a data scientist’s work consists in preprocessing, but many learning materials omit that

Then we would continue by applying some Machine Learning on our data. You will learn how to explore the problem at hand from a machine learning perspective, how to create targets, what kind of statistical preprocessing is necessary for this part of the exercise, how to train a Machine Learning model, and how to test it. A truly comprehensive ML exercise.

Connecting Python and SQL is not immediate. We have shown how that’s done in an entire section of the course. By the end of that section, you will be able to transfer data from Jupyter to Workbench.

And finally, as promised, Tableau will allow us to visualize the data we have been working with. We will prepare several insightful charts and will interpret the results together.

As you can see, this is a truly comprehensive data science exercise. There is no need to think twice. If you take this course now, you will acquire invaluable skills that will help you stand out from the rest of the candidates competing for a job.

Also, we are happy to offer a 30-day unconditional no-questions-asked-money-back-in-full guarantee that you will enjoy the course.

So, let’s do this! The only regret you will have is that you didn’t find this course sooner!

SQL Foundations

A beginners guide to SQL commands and Database Design. Learn it through quick and easy steps.

Created by Sagar Uppuluri - Software Architect and a passionate trainer

"]

Students: 26400, Price: Free

Students: 26400, Price:  Free

SQL is an integral part of majority of software projects and is important for you to gain familiarity with the language if you are an IT aspirant. 

This course covers the topics related to database design and query design, and helps you assimilate the topics in a way that you should be able to understand and design the schema. 

It covers the most essential features of the language and explains them through simplified and easy to understand examples. Includes DDL, DML and Query commands along with hints about the other essential features.  Core focus will be on table design and explaining the features such as query and joins with their mathematical approach so that you can effectively design complex queries.

It includes SQL scripts related to the lectures under the resources section which are intended to help students expedite the learning by means of executing the same scripts taught in the video.

SQL Tutorial for Beginners – Learn SQL using 30 scenarios

A comprehensive course to teach you SQL on Mac and Windows using Azure Data Studio, Microsoft SQL Server and T-SQL

Created by Valuetech Academy - Learn SQL skills efficiently

"]

Students: 26188, Price: Free

Students: 26188, Price:  Free

SQL Tutorial for Beginners in 2020- Learn SQL quickly using 30 Scenarios on Mac and Windows

A comprehensive course to teach you SQL on Mac and Windows.

If you are looking for a complete SQL tutorial for beginners, this tutorial is a great way to learn SQL using 30 real-time scenarios.

You will be able to write SQL queries confidently by just practicing the 30 scenarios in this SQL Tutorial.

You can learn SQL on Mac and Windows from this SQL Tutorial. This SQL Tutorial will cover all the topics of Structured Query Language(SQL) starting from scratch. This tutorial is great for beginners who want to learn SQL and for professionals who want to brush up their SQL Skills.

Structured Query Language(SQL) is supported by various database management systems(DBMS).

In this SQL Tutorial, we will be using SQL Server to learn SQL on both Mac and Windows.

Microsoft's SQL Server is one of the most popular database management systems(DBMS) in the world and learning SQL using SQL Server can help you earn nearly $100,000 per year.Even if you use a different DBMS like MySQL, you can benefit a lot from this SQL Tutorial as more than 90% of the SQL skills you learn in this tutorial is easily transferable to other database management systems(DBMS).

What you'll learn from this SQL Tutorial:

1.Start from scratch installing SQL Server on Mac and Windows in 2020.

2.Learn SQL quickly using 30 real world Scenarios

3.Learn SQL using Azure Data Studio on Mac and Windows

4.Download and Restore a sample database(AdventureWorks) to SQL Server on Mac and Windows

5.Download and Install Azure Data Studio on Mac and Windows

6.Model real-world scenarios and write SQL queries across multiple tables

This beginner's course is for you if you want to learn SQL Skills in Mac or Windows.

Advanced SQL : SQL Expert Certification Preparation Course

Complete Your Oracle SQL Knowledge From Intermediate to Advanced Level and Become a Database SQL Expert in Oracle!

Created by Oracle Master Training • 100,000+ Students Worldwide - Oracle Architect & Best Selling Instructor

"]

Students: 25372, Price: $109.99

Students: 25372, Price:  Paid

"One", "Enough", "Ultimate" Course to make you an "SQL Expert!".

Advance Your SQL Knowledge and Get Better Income From Your Job, like $100k.

Get Oracle's SQL Expert Certification.

Oracle has two Certification Exams for SQL;

The first one (SQL Fundamentals) covers the basic subjects (All of these subjects are covered in my first course.)

The second one (SQL Expert) covers more advanced subjects including the basic ones. (All the advanced subjects (and more) for this exam are covered in this course.)

All the subjects are explained in detail, and exampled as many as I can do with Oracle's HR schema. You can check the subjects from Oracle's related pages.

Now, you are looking at a course that will make you pass this exam.

  • You can ask any questions about this course from discussion board.

  • Your questions will be answered as soon as possible.

You can check my website for more details.

What are you going to learn from this course? 

  • Introducing Database Objects

  • Data Dictionary Views

  • Creating, Using and Managing Sequences

  • Creating, Using and Analyzing Synonyms

  • Understanding and Using Indexes

  • Managing Views

  • Materialized Views

  • Creating and Using Advanced Subqueries

  • Advanced Data Manipulation

  • Controlling Schema Objects)

  • Administering User Privileges and Roles

  • Hierarchical Queries (Tree Structure)

  • Writing Advanced Scripts

  • Generating Dynamic SQL Scripts

  • Analytical SQL Functions

  • Regular Expressions

  • And much more beyond these... (+Quizzes, +Bonus Lectures, +New Updates)...

More?

  • Hundreds of Examples

  • Professional Course Design,

  • Well-organised Content

  • In-Depth Subjects (All subjects are explained with all details)

  • Lifetime Author Support.

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises

Created by Kirill Eremenko - Data Scientist

"]

Students: 24348, Price: $89.99

Students: 24348, Price:  Paid

Are you interested in a career in Data Science or Data Analytics?

In that case, inevitably you are going to encounter databases in your work.

But how do you interact with databases?

The answer is simple: SQL 

SQL stands for Structured Query Language and this is one of the main tools used to organize databases, input data into them and extract it on request.

In this course you will learn how to create queries in a popular variation of SQL called PostgreSQL. 

And even if at your workplace you are using a different variation (e.g. Oracle, SQL Server or MySQL), you will find that the skills you learn in this course are easily transferable.

But there are many SQL courses out there, so the question is:

What makes this course stand out?

The unique advantage of this course is that in addition to learning SQL you will also master the concepts of Database Design.

We will cover off topics such as:

- OLAP vs OLTP databases (Online Analytics Processing & Online Transaction Processing): you will understand exactly how and why the designs of these two types of Databases differ

- Normalization of Databases: we will show you the theory behind normalization AND together we will practice how to normalize a Database step-by-step

Why is that important?

Knowing how databases are designed is not a compulsory skill to have for a Data Scientist / Analyst. However, it's a HUGE added benefit.

These skills will allow you to better interact with databases and derive results and extract insights from your data faster.

This course is designed with the Data Scientists and Analysts in mind, so if you want to propel your Data Science career, then this course is for you!

We look forward to seeing you inside,

Kirill & Ilya

Advanced SQL: MySQL Data Analysis & Business Intelligence

Master advanced SQL database coding w/ MySQL Workbench. My SQL course takes your SQL analysis skills to new heights!

Created by Maven Analytics - Award-Winning Analytics & Business Intelligence Training

"]

Students: 23339, Price: $129.99

Students: 23339, Price:  Paid

IMPORTANT NOTE: This is an advanced SQL course, which builds on the skills covered in our introductory MySQL courses. Please review the prerequisite skills or complete the beginner SQL course before taking this one!

______________________________

See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:

"I totally loved this course! Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning -- I wanted to keep charging on to the next lesson!"

- Ann S.

"This is an excellent advanced course! I've taken both SQL courses from Maven Analytics and highly recommend both. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work!"

- Dan S.

"John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John!"

- Steven M.

______________________________

COURSE DESCRIPTION:

If you want to develop practical, real-world analytics & BI skills using advanced SQL, you're in the right place.

This course is unlike anything you’ve seen before, guaranteed. Instead of using random sample data and obscure demos, we’ll be working with a rich, custom-built eCommerce database that we’ve designed from scratch to help you apply your SQL skills to real projects and learn how to truly THINK like an analyst.

You’ll be playing the role of a newly hired Database Analyst for Maven Fuzzy Factory, an eCommerce start-up, and will be working directly with the CEO, Marketing Director and Website Manager to help grow the business and analyze performance along the way. You'll use a range of advanced SQL tools and techniques, and work through actual projects that data analysts and business intelligence professionals work on every day.

______________________________

COURSE OUTLINE:

  • Prerequisite SQL Skills Assessment

    In this section we'll address the core SQL/MySQL skills that you should be comfortable with before starting the course, including SELECT statements, aggregate functions, and table joins. If you aren't sure how your skills stack up, we've included a quiz to assess your baseline SQL knowledge.

  • MySQL Setup & Install

    For students who haven't completed our intro course, we'll demonstrate exactly how to download and install the tools that we'll need to access MySQL, including MySQL Community Server & MySQL Workbench. We'll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we'll analyze throughout the course.

  • Traffic Analysis & Optimization

    In this section we’ll use MySQL to analyze where our website traffic is coming from, how different sources perform in terms of traffic volume and conversion rates, and how we can adjust bids to optimize our budgets.

  • Website Measurement & Testing

    In this section we'll dive into page-level website data to compare traffic and conversion rates, and use MySQL to build and analyze conversion funnels to help optimize the customer purchase experience.

    ***MID-COURSE PROJECT: Preparing data for the executive board meeting

  • Channel Analysis & Optimization

    In this section we’ll dig deeper into our traffic channel mix, explore paid vs. free traffic, break down performance by device type, and write advanced SQL queries to conduct some time-series analyses to understand trending and seasonality.

  • Product-Level Analysis

    In this section we’ll use MySQL to break down product-level sales and conversion rates, analyze cross-selling patterns, and use refund rates to keep a pulse on quality.

  • User-Level Analysis

    In this section we’ll take a closer look at user behavior and repeat sessions, and use MySQL techniques to identify our most valuable customers and explore which channels they are coming from.

    ***FINAL PROJECT: Building a data-driven growth story for potential investors

______________________________

Unlike other SQL courses, this one is uniquely designed to sharpen your business intelligence and analytical thinking skills; as you complete course projects and exercises, you’ll actually see patterns and trends emerging in the data based on your findings. For those looking to pursue a career in analytics, this course is a must.

Enroll today and get LIFETIME access to:

  • 8+ hours of high-quality video

  • Downloadable MySQL ebook

  • Quizzes and hands-on projects

  • Mid-course and Final SQL projects

  • 30-day money-back guarantee

IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we'll cover database administration tools in a separate course).

Happy analyzing!

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

______________________________

Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!

Oracle SQL Performance Tuning Masterclass 2021

Become an Expert on Oracle SQL Tuning and Solve All The Performance Problems of Your SQL Queries and the Database!

Created by Oracle Master Training • 100,000+ Students Worldwide - Oracle Architect & Best Selling Instructor

"]

Students: 22133, Price: $119.99

Students: 22133, Price:  Paid

Here is the most comprehensive SQL Tuning course that you will not need to take any other courses in anywhere.

This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge on Oracle SQL Tuning.

The most common problem of working with SQL is, performance problems. Most of the developers don't know how to write well-performing queries. So in time, this problem grows and becomes a problem for both the developer and the company.

This course will teach you how to tune your SQL statements and database step by step for a perfect performance! You will learn how to write fast, reliable, and secure queries. Besides, you will learn the database architecture and will be able to optimize the database workloads.

Once you complete this course, you will recognize the database terms better and will use the most appropriate one for the performance.

Once you complete this course, you will be able to:

  • Find the poorly performing queries

  • Learn Advanced Query Tuning Techniques

  • Understand the Database Architecture to perform Better Tuning Techniques

  • Learn Advanced Indexing Techniques to Maximize Database Performance

  • Learn how to use various Performance Tuning Tools

  • Compare BAD vs GOOD Queries with Hands-on Examples.

  • Gather Statistics for the bad SQLs

  • Interpret the Execution Plans with different methods

  • Choose an appropriate SQL tuning approach

  • Guide the Oracle Optimizer for a better execution

  • Use various tuning techniques like using bind variables, different types of indexes, and much more.

  • Improve the performance of the queries & database

  • Gain Complete Knowledge in Oracle SQL and Performance Tuning!

Briefly, the knowledge of SQL Tuning is a "must" for IT Professionals and this course is the magic pill for that you're seeking for Becoming a Performance Expert!

If you want to step ahead in your career, "SQL & Performance Tuning" should be your next step.

See you in the first lecture!

Oracle Database 12c SQL Certified Associate 1Z0-071

Become Oracle SQL Certified ( OCA ) / Covers ORACLE university track 100%. All the presentations & scripts are attached

Created by Khaled Alkhudari - Sr Oracle Developer/ Sr system analyst

"]

Students: 22003, Price: $129.99

Students: 22003, Price:  Paid

ORACLE is database number one in the world .

if you know Oracle SQL, then you can learn any SQL easily  ( mysql, sql server,PostgreSQL, ..).

This is one of the most amazing Udemy courses in Oracle SQL.

 

The course covers the oracle university track 100% for :

 

“Oracle Database 12c SQL Certified Associate 1Z0-071”

 

The course starts from zero level to Expert Level, I guarantee for you that you will understand every single lesson in this course because it was created in a very attractive way, you will not feel bored in any lesson in this course.

 

Just watch the videos and do the examples and you will be ready passing the exam.

 

You will find all the presentations and all the SQL scripts attached in every chapter, so no need to waste your time repeating any example I did.

 

Simply this course is the best….

SQL Injection Attacks: The 2021 Guide

Learn hands-on how to perform and defend against one of the most devastating web attacks - SQL injections

Created by Christophe Limpalair - Co-Founder of Cybr and developer at heart

"]

Students: 20919, Price: Free

Students: 20919, Price:  Free

About the course:

Welcome to this course on SQL injection attacks! In this course, we explore one of the biggest risks facing web applications today.

We start out by creating a safe and legal environment for us to perform attacks in. Then, we cover the core concepts of SQL and injections. After that, we learn SQL injection techniques with the help of cheat sheets and references. At that point, we start to gather information about our target in order to find weaknesses and potential vulnerabilities.

Once we've gathered enough information, we go full-on offensive and perform SQL injections both by hand and with automated tools. These attacks will extract data such as tokens, emails, hidden products, and password hashes which we then proceed to crack.

After successfully attacking and compromising our targets, we take a step back and discuss defensive controls at the network, application, and database layers. We also look at actual vulnerable code and show ways of fixing that vulnerable code to prevent injections.

Please note: Performing these attacks on environments you do not have explicit permissions for is illegal and will get you in trouble. That is not the purpose of this course. The purpose is to teach you how to secure your own applications.

-----------------------

Topics we will cover together:

  1. How to set up a Kali Linux Virtual Machine for free

  2. How to configure and create safe & legal environments using containers inside of Kali

  3. How to get started with OWASP ZAP (a free alternative to Burp Suite)

  4. A quick refresher of what SQL is and how it works

  5. An explanation of what SQL injections are and how they work

  6. SQL injection techniques with cheat sheets and references

  7. How to gather information about your target in order to find potential vulnerabilities

  8. How to perform SQL injections by hand with a proxy tool (ZAP)

  9. How to perform SQL injections with automated tools (SQLMap)

  10. How to use results from successful and unsuccessful injections to further exploit the application (ie: crack passwords)

  11. How to defend against SQL injections at the network layer

  12. How to defend against SQL injections at the application layer

  13. How to defend against SQL injections at the database layer

  14. How to find vulnerabilities by looking at code

  15. Proper coding techniques to prevent SQL injections

-----------------------

Requirements:

To understand how SQL injections work and how to perform them as well as defend against them, you must have:

  • Experience working with web applications

  • Experience with SQL

Suggestion: You may also wish to take our free Introduction to Application Security (AppSec) course to familiarize yourself with the concepts of Application Security.

-----------------------

Instructor

My name is Christophe Limpalair, and I have helped thousands of individuals pass IT certifications and learn how to use the cloud for their applications. I got started in IT at the age of 11 and unintentionally fell into the world of cybersecurity.

As I developed a strong interest in programming and cloud computing, my focus for the past few years has been training thousands of individuals in small, medium, and large businesses (including Fortune 500) on how to use cloud providers (such as Amazon Web Services) efficiently.

I've taught certification courses such as the AWS Certified Developer, AWS Certified SysOps Administrator, and AWS Certified DevOps Professional, as well as non-certification courses such as Introduction to Application Security (AppSec), Lambda Deep Dive, Backup Strategies, and others.

Working with individual contributors as well as managers, I realized that most were also facing serious challenges when it came to cybersecurity.

Digging deeper, it became clear that there was a lack of training for AppSec specifically. As we explore in the course, SQL injections are far too common and can be devastating to organizations.

It's time to take security into our own hands and to learn how to build more secure software in order to help make the world a safer place! Join me in the course, and we'll do just that!

I welcome you on your journey to learning more about SQL injections, and I look forward to being your instructor!

SQL Server Crashes and Critical Failures

A Step By Step Approach To Recovering The Most Critical SQL Server Databases

Created by Mike West - Chief Data Janitor

"]

Students: 20712, Price: Free

Students: 20712, Price:  Free

Software crashes. WE can't stop that. What WE can do is prepare ourselves through education and practice to be able to act quickly and resolve these critical issues.

In the early days of SQL Server many support calls were server down issues that ended up being bugs in SQL Server. While this still happens, today many of those calls aren't the fault of SQL Server.

For example. On Microsoft's case history of database corruption 99% of ALL database corruption can be traced back to the IO subsystem.

Either way, when SQL Server crashes it can be a traumatic experience for a DBA. If a production box crashes during core hours WE need to know what steps to take to resolve the problem as quickly and as cleanly as possible.

This course will take US beyond where to look. WE will cover RECOVERY INTERNALS and the fundamentals of how to analyze, diagnose and resolve critical errors.

WE will cover the SQL Server Error Logs in great detail. One of the first places as SQL Server DBAs WE look to diagnose critical failures is the SQL Server Error logs.

WE will cover server startup failures and analyze SQL Server stack dumps. Additionally, we will analyze several commonly occurring exception signatures.

WE will create a troubleshooting task list as use it as a template for resolving these crashes and critical errors.

While this course has no prerequisites a strong background in SQL Server is highly recommended.