SQL Learn SQL 101, 202 and 303 all in 1 Course. 10X Learning

SQL Learn SQL 101, 202 and 303 all in 1 Course. 10X Learning, available at $19.99, has an average rating of 4.35, with 24 lectures, 3 quizzes, based on 49 reviews, and has 2605 subscribers.

You will learn about Create a Database From Scratch Understand Almost All SQL Syntax Be able to write both Basic and Complex SQL Statements without help Insert Update and Delete Data in a SQL Database This course is ideal for individuals who are This SQL Course is for everyone from those woh have never seen SQL Management Studio to the guys who need help remembering what to do in SQL or Do you know Crystal Reports and you want to make your reports faster or Is your application slow and you don't understand how you can speed it up. It is particularly useful for This SQL Course is for everyone from those woh have never seen SQL Management Studio to the guys who need help remembering what to do in SQL or Do you know Crystal Reports and you want to make your reports faster or Is your application slow and you don't understand how you can speed it up.

Enroll now: SQL Learn SQL 101, 202 and 303 all in 1 Course. 10X Learning

Summary

Title: SQL Learn SQL 101, 202 and 303 all in 1 Course. 10X Learning

Price: $19.99

Average Rating: 4.35

Number of Lectures: 24

Number of Quizzes: 3

Number of Published Lectures: 24

Number of Published Quizzes: 3

Number of Curriculum Items: 27

Number of Published Curriculum Objects: 27

Original Price: $129.99

Quality Status: approved

Status: Live

What You Will Learn

Create a Database From Scratch
Understand Almost All SQL Syntax
Be able to write both Basic and Complex SQL Statements without help
Insert Update and Delete Data in a SQL Database

Who Should Attend

This SQL Course is for everyone from those woh have never seen SQL Management Studio to the guys who need help remembering what to do in SQL
Do you know Crystal Reports and you want to make your reports faster
Is your application slow and you don't understand how you can speed it up.

Target Audiences

This SQL Course is for everyone from those woh have never seen SQL Management Studio to the guys who need help remembering what to do in SQL
Do you know Crystal Reports and you want to make your reports faster
Is your application slow and you don't understand how you can speed it up.

Do you work with SQL every day and not understand it?
Do you see people who know SQL and make more money than you ?
Do you have an Interview coming up where you know SQL would look amazing on your resume?

I taught myself SQL overnight 15 years ago for a job interview, and have made it my career ever since. My career went from rags to riches because of what I teach you in this course. I have a real passion for SQL server and how to use it to make your applications more productive. I have taught people how to use SQL for the passed 10 years and I am here to teach you .

I designed this course to teach everyone how to use it to Query and Manipulate mass amounts of data. I teach you from the basics to very complex SQL statements. If you have never used SQL before I will teach you the basics from start to finish. If you use SQL every day I will teach you some of my pro tips that will help you get your job done faster and make you look like a amazing developer.

I will cover everything from creating a database to using aggregate functions and triggers and why you should use them.

I am committed to delivering the best product possible If you love my course give me a great review. If you are not satisfied with my course please request a refund and I will happily give it I want to make you a more powerful developer and if i didn’t do that It is my duty to give you a refund. Along with your refund request please tell me why you are not happy with my course and what I could have done better to teach you.

Course Curriculum

Chapter 1: Introduction: SQL

Lecture 1: Introduction Here we talk about SQL

Lecture 2: Hit The HD Button

Lecture 3: What is a Database and Where Does SQL Fit In

Chapter 2: Creating Our First Database and Basic SQL Queries

Lecture 1: Lets Create our First Database

Lecture 2: Inserting Data Into Tables Using SQL Enterprise Manager

Lecture 3: Basic Select Statement

Lecture 4: Anatomy of a Select statement

Lecture 5: Sub-queries in T-SQL

Lecture 6: Creating Test Data Using T-SQL

Lecture 7: Update Statement in T-SQL

Lecture 8: The Delete Statement

Lecture 9: More about the Where clause

Chapter 3: Joins Group By and Aggregate functions

Lecture 1: Inner Joins in SQL

Lecture 2: Left Outer Joins

Lecture 3: Group By Clauses in a SQL Database

Lecture 4: Aggregate Functions

Chapter 4: Advanced DB

Lecture 1: Create Alter Drop

Lecture 2: Scalar UDF

Lecture 3: Join to a Subquery

Lecture 4: Table UDF

Lecture 5: Views

Lecture 6: Stored Procedure

Lecture 7: Triggers in SQL Management Studio

Chapter 5: Random Tips to Make SQL Easier

Lecture 1: Using Templates To Store SQL At Your Fingertips

Instructors

Rico Rodriguez
SQL Architect, Senior Software Developer, Project Manager

Rating Distribution

1 stars: 2 votes
2 stars: 4 votes
3 stars: 6 votes
4 stars: 18 votes
5 stars: 19 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu