SQL Complete Master Course
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SQL Complete Master Course to your Wishlist.

Add to Wishlist

SQL Complete Master Course

A-Z BootCamp Course
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2 students enrolled
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use SQL to query a database Use SQL to perform data analysis
  • Be comfortable putting SQL,MySQL anda Data Analysis on their resume
  • Use SQL to perform data analysis
  • Create and manage Data allocation Tables and Manipulate Data using SQL
  • Learn the functions of Xammp server in engaging SQL in local hosting
View Curriculum
Requirements
  • No prior technical experience is required! All you need a computer!
  • Just a self enthusiastic nature for learning programming is required!
Description

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!

Check out the free preview videos for more information!

Who is the target audience?

  • Anyone interested in learning more about SQL, PostgreSQL, or basic data analysis!
Who is the target audience?
  • Anyone interested in learning more about SQL, MySQL, or basic data analysis!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
02:00:09
+
The SQL Commands(Basics)
13 Lectures 41:33
Creating a table in SQL
04:55

add Data with INSERT
01:41

see Data with SELECT
01:32

LIMIT Command
02:22

conditions with WHERE clause
02:37

Modify Data with UPDATE
02:41

change the Table structure with ALTER
03:12

Sorting with ORDER BY Clause
03:50

IN CLAUSE
05:31

Finding data patterns using LIKE clause
06:39

Selecting specific FIELDS/COLUMNS
03:29

DISTINCT
01:20

ALIAS
01:44
+
MySQL Data-Types and Constraints
2 Lectures 09:44
Data-Types
04:57

Constraints
04:47
+
JOINS and UNIONS
4 Lectures 32:04
Relational DATABASES
12:25

Foreign key Constraint
05:08

Left JOIN
11:25

Right JOIN
03:06
+
GROUPS and MySQL functions
3 Lectures 07:29
MySQL functions
00:58

GROUP by CLAUSE
04:07

HAVING clause
02:24
+
VIEWS - SQL
3 Lectures 09:46
What are VIEWS?
01:50

ALTER VIEW
01:52

DROP VIEW
06:04
+
DELETE, DROPS AND TRUNCATES
2 Lectures 07:04
DELETE data from Tables
04:02

TRUNCATE tables
03:02
About the Instructor
Rakesh Naga Chinta
5.0 Average rating
2 Reviews
20 Students
2 Courses
CEO of Hubstrike, Entrepreneur, Intern at Google, Author.


Rakesh Naga Chinta is an Entrepreneur, SDE Intern at Google, Strategic Business Analyst, Author of several best-selling books.

A Harvard Alumni, with a burning passion for problem-solving and Entrepreneurship.

Currently working as product managing intern at google, where his skills are tested and sharpened every single day.

CEO and founder of  several companies such as RILAD, Hubstrike, Internetout, Techcodebit, Appscalar, Midscore, Appendscore, etc.