Complete SQL With MySQL – SQL Bootcamp – SQL Interview Q & A

Complete SQL With MySQL – SQL Bootcamp – SQL Interview Q & A, available at $79.99, has an average rating of 3.95, with 159 lectures, 17 quizzes, based on 241 reviews, and has 16654 subscribers.

You will learn about Create, query and manipulate databases and schemas Exclusive join & sub-query techniques – Data Integrity – Foreign Keys Database transactions – Locking & Non-locking reads – Managing AUTOCOMMIT Emulation of set operators like INTERSECT and MINUS – UNION & UNION ALL Data Aggregation – ROLLUP, GROUPING() – Group Functions using Joins Analytical functions DENSE_RANK(), FIRST_VALUE(), CASE(), IF(), etc. Stored Procedures / Views / Triggers – Solve most complex of data handling problems This course is ideal for individuals who are Fresher or working – Seeking or on the job – You must learn SQL even if you are or not a core IT professional or Aspiring to become data analyst, data scientist, database admin particularly must learn SQL or Python, Java, PHP, .Net or any programmers / developers must learn SQL or From clerk to manager / office administrator must learn SQL It is particularly useful for Fresher or working – Seeking or on the job – You must learn SQL even if you are or not a core IT professional or Aspiring to become data analyst, data scientist, database admin particularly must learn SQL or Python, Java, PHP, .Net or any programmers / developers must learn SQL or From clerk to manager / office administrator must learn SQL.

Enroll now: Complete SQL With MySQL – SQL Bootcamp – SQL Interview Q & A

Summary

Title: Complete SQL With MySQL – SQL Bootcamp – SQL Interview Q & A

Price: $79.99

Average Rating: 3.95

Number of Lectures: 159

Number of Quizzes: 17

Number of Published Lectures: 159

Number of Published Quizzes: 17

Number of Curriculum Items: 180

Number of Published Curriculum Objects: 180

Original Price: ₹1,199

Quality Status: approved

Status: Live

What You Will Learn

Create, query and manipulate databases and schemas
Exclusive join & sub-query techniques – Data Integrity – Foreign Keys
Database transactions – Locking & Non-locking reads – Managing AUTOCOMMIT
Emulation of set operators like INTERSECT and MINUS – UNION & UNION ALL
Data Aggregation – ROLLUP, GROUPING() – Group Functions using Joins
Analytical functions DENSE_RANK(), FIRST_VALUE(), CASE(), IF(), etc.
Stored Procedures / Views / Triggers – Solve most complex of data handling problems

Who Should Attend

Fresher or working – Seeking or on the job – You must learn SQL even if you are or not a core IT professional
Aspiring to become data analyst, data scientist, database admin particularly must learn SQL
Python, Java, PHP, .Net or any programmers / developers must learn SQL
From clerk to manager / office administrator must learn SQL

Target Audiences

Fresher or working – Seeking or on the job – You must learn SQL even if you are or not a core IT professional
Aspiring to become data analyst, data scientist, database admin particularly must learn SQL
Python, Java, PHP, .Net or any programmers / developers must learn SQL
From clerk to manager / office administrator must learn SQL

Learning SQL – The fastest way to reach your career goals

What is the most crucial thing in the today’s world to thrive in the business? The plain and unequivocal answer is the DATA and so are the DATABASES. Hence skills of being able to query, manipulate, aggregate, analyze and administer the database have just not been consistently on top demand but also the demand has kept expanding ever. The good news is that – you can not only launch yourself quickly in the career by learning an ANSI standardized language called SQL, but grow by leaps and bounds. Learning SQL is the fastest way to reach your career goals. Why? Because SQL is plain English like language and largely remains unchanged over all of the most prominent database systems commercially available.

Why MySQL?

MySQL is world’s #2 database system after Oracle. Initially launched as Open Source database system, which still it is, but now owned by Oracle Corporation. It is free yet robust as such most of the databases are working from MySQL Database engines. MySQL has ANSI standard SQL implementation and MySQL is easily available from net to download and install. SQL being an ANSI standard language, you can use the knowledge that you’ll gain over any platform – Oracle, PostgreSQL, SQL Server, DB2, SQLite, and similar others. So by now you must have understood that the scope for SQL is wide and unending.

Why only this particular course?

While most courses are designed around just explaining syntax and forms of statements, this course is particularly designed with focus on SQL interpretation and accuracy. SQL is simple indeed, resembling English. But many a times it is common for people, including experienced ones, to write SQL queries without realizing that they are getting an output/result which only seems to be correct under existing conditions of the data, but might not be always, if the data changes over the period of time. Take it for granted that you will learn to write only an accurate and efficient SQL. Rather you will feel confident in SQL by the end of this course – ready to demonstrate your expertise.
Of course, anyway you will go through the curriculum and contents of this course, but I most earnestly advise you to compare those contents with any of the other courses offered anywhere. This SQL course is not only most comprehensive, deep and example driven, but you will find at least 40% of the topics are exclusively covered, not even mentioned in the other courses. The lessons are concise yet complete with an average duration of around 7 minutes.
23+ years of my expertise has gone into scripting contents and instructional design of this course. Each lesson is accompanied with downloadable transcript of lesson narration and including code wherever relevant, which if followed along with watching the lesson can enhance your learning experience, which is an exclusive feature of this course.
Apart from around 20 odd hours of video content, spread over 20 sections, you have a separate section with 100s of interview questions with ideal answers thereof to help in last minute preparation for an interview. This is another exclusive feature of this course.

My authority in building this exclusive course

I have been in the field of Database Administration (DBA) for almost 24 years and still continued, simultaneous with imparting training at all levels. My teaching experience is deeply rooted in the corporate, where courses are required to be offered as per trends in the industry, which this course is also a product of.

Earnest invitation to evaluate this course

You need to go through the curriculum to believe in all that forgoing expression. Evaluate the worth of this course by comparing it with other courses around. Remember, the titles are not important but the depth is; the examples, the explanation, the logical sequence of topics, the delivery, are all the other aspects which sets this course in the class of its own.Check out the free preview lessons, which are also aplenty as compared to displayed by other similar courses.

And all this comes with 30 days full money back guarantee. No questions asked.

What else you are waiting for. Enroll now to become most sought after SQL master!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Promo

Lecture 2: Course Introduction

Chapter 2: DBMS Terminologies

Lecture 1: What is DBMS?

Lecture 2: What is RDBMS?

Lecture 3: Introduction to SQL

Chapter 3: Installation and Basic Exposure

Lecture 1: Installation of MySQL on Windows

Lecture 2: Sample schema EMPLOYEES (Must read Note under Resources)

Lecture 3: MySQL – Basic SELECT Statement

Chapter 4: Selecting Rows – WHERE Clause

Lecture 1: MySQL – Operator AND

Lecture 2: MySQL – Operator OR

Lecture 3: MySQL – AND & OR Precedence

Lecture 4: MySQL – IN & NOT IN Operators

Lecture 5: MySQL – BETWEEN & NOT BETWEEN Operators

Lecture 6: MySQL – Search Condition IS NULL

Lecture 7: MySQL – LIKE Operator

Lecture 8: MySQL – ORDER BY Clause

Lecture 9: MySQL – LIMIT Clause

Lecture 10: MySQL – Pipe Operator

Chapter 5: Displaying Specific Columns – Projection

Lecture 1: MySQL – Specifying Projection

Lecture 2: MySQL – Column Alias

Lecture 3: MySQL – Arithmetic Expression

Lecture 4: MySQL – DISTINCT Operator

Lecture 5: MySQL – IFNULL() Function

Lecture 6: MySQL – COALESCE() Function

Lecture 7: MySQL – String Concatenation

Lecture 8: 26-MySQL – Displaying Dates

Lecture 9: MySQL – Temporal Operator INTERVAL

Chapter 6: SQL Nested Query Techniques

Lecture 1: MySQL – Nested Query

Lecture 2: MySQL – Multivalue Subquery

Lecture 3: MySQL – Set Comparison Subquery

Lecture 4: MySQL – Correlated Subquery

Lecture 5: MySQL – EXISTS Operator

Lecture 6: MySQL – NULL Subqueries

Lecture 7: MySQL – ALL Operator

Lecture 8: MySQL – Operator ANY

Chapter 7: SQL Joins

Lecture 1: MySQL – INNER JOIN clause

Lecture 2: MySQL – Filtering INNER JOIN Results

Lecture 3: MySQL – Non-Equi Join

Lecture 4: MySQL – OUTER JOIN Clause

Lecture 5: MySQL – FULL JOIN Simulation

Lecture 6: MySQL – Join Table With Itself

Chapter 8: MySQL Aggregation

Lecture 1: MySQL – Group Functions Introduction

Lecture 2: MySQL – Group Functions Simple Use

Lecture 3: MySQL – Group Functions WHERE Clause

Lecture 4: MySQL – GROUP BY Clause

Lecture 5: MySQL – HAVING Clause

Lecture 6: MySQL – Finding Maximum of Average

Lecture 7: MySQL – Group Function With Join

Lecture 8: 49-MySQL – Group Function In Subquery

Chapter 9: Create, Alter & Drop Table

Lecture 1: MySQL-CREATE TABLE Statement

Lecture 2: MySQL-Creating Table From Existing

Lecture 3: MySQL-Adding Columns to Table

Lecture 4: MySQL-Dropping Columns

Lecture 5: MySQL-CREATE TABLE LIKE

Lecture 6: MySQL-DROP TABLE Statement

Chapter 10: Data Integrity and Constraints

Lecture 1: MySQL – Data Integrity Concepts

Lecture 2: MySQL – Creating Primary Key With Table

Lecture 3: MySQL – Dropping and Adding Primary Key

Lecture 4: MySQL – UNIQUE Constraint

Lecture 5: MySQL – CHECK Constraint

Lecture 6: MySQL – DEFAULT Constraint

Lecture 7: MySQL – NOT NULL Constraint

Lecture 8: MySQL – FOREIGN KEY Constraint

Lecture 9: MySQL – FOREIGN KEY ON DELETE CASCADE Clause

Lecture 10: MySQL – FOREIGN KEY ON DELETE SET NULL Clause

Lecture 11: MySQL – FOREIGN KEY ON UPDATE CASCADE Clause

Chapter 11: MySQL DML – Data Manipulation Language

Lecture 1: MySQL – Single Row INSERT Operation

Lecture 2: MySQL – Multi-Row INSERT Operation

Instructors

Prashant Munshi
Distinguished Database Admin & Corporate Trainer

Rating Distribution

1 stars: 3 votes
2 stars: 6 votes
3 stars: 28 votes
4 stars: 69 votes
5 stars: 135 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