Complete SQL Training & Certification

Focused View

Vivek PMP,Tejaswini G

1:55:06

78 View

1. Introduction

1. Course Introduction.mp4

02:05

2. What is a Relational Database Management System.mp4

09:37

3. What is SQL.mp4

03:18

4. History Of SQL.mp4

01:50

5. MySQL Installation.mp4

13:41

2. Basic Concepts in SQL

1. Basic Concepts in SQL.mp4

08:54

3. The SQL Environment

1. Data types in SQL.mp4

14:54

2. Operators and Expressions in SQL.mp4

00:05

3. Statements in SQL.mp4

06:26

4. Data Definition Language (DDL) commands

1. Create Table.mp4

17:18

2. Alter Table.mp4

13:57

3. Truncate And Drop.mp4

05:46

4. Constraints.mp4

00:05

5. Indexes.mp4

00:05

6. Data Dictionary.mp4

00:05

5. Data Manipulation Language(DML)

1. Inserting Data into Tables.mp4

00:05

2. Update.mp4

07:19

3. Delete.mp4

08:06

6. Data Query Langauge(DQL)

1. Select.mp4

00:05

2. Where Clause.mp4

00:05

3. group by having.mp4

00:05

4. Order By.mp4

00:05

7. Data Control Language Commands

1. Grant.mp4

00:05

2. Revoke.mp4

00:05

8. Transaction Control Language(TCL)

1. Commit.mp4

00:05

2. Rollback.mp4

00:05

3. Savepoint.mp4

00:05

4. Set Transaction.mp4

00:05

9. Sub Queries

1. SubQueries.mp4

00:05

10. Set Operators (Union, Intersect, Except)

1. Set Operators (Union, Intersect, Except).mp4

00:05

11. Joins

1. Joins (Inner Join, Outer Join, Cross Join etc.).mp4

00:05

12. Views

1. Views.mp4

00:05

13. Procedures

1. Procedures.mp4

00:05

14. Functions

1. Functions.mp4

00:05

15. Triggers

1. Triggers.mp4

00:05

16. Injections

1. Injections.mp4

00:05

Description

Master SQL, Work With Complex Databases, Build Reports, and More!

What You'll Learn?

SQL Basics & Advance
Use of SQL to perform data analysis
Job oriented SQL for Data Analysis
Obtain the Skills that are Necessary to Land a Job as a SQL Developer

Who is this for?

Anyone interested in learning SQL

Anyone who is interested in passing Oracle SQL exam!

What You Need to Know?

No prior technical experience is required! All you need a computer!

More details

Description
The Complete SQL Training & Certification course is designed to provide comprehensive training in Structured Query Language (SQL), a standard programming language for managing and manipulating relational databases. This course is suitable for BOTH beginners who have little to no prior experience with SQL as well as intermediate learners looking to enhance their SQL skills and earn a certification.
Throughout this course, you will learn the fundamental concepts of SQL, including database design, querying, data manipulation, and database management. You will gain hands-on experience by working with popular database management systems like MySQL, Oracle, or Microsoft SQL Server.
Key Topics Covered:
Introduction to Databases: Understand the basics of databases, their types, and the importance of database management systems (DBMS).
SQL Fundamentals: Learn the fundamentals of SQL syntax, data types, operators, and functions.
Database Design: Explore the principles of database design, normalization, and entity-relationship modeling to create efficient and scalable databases.
Querying Data: Master the SELECT statement to retrieve data from one or multiple tables using various filtering, sorting, and joining techniques.
Data Manipulation: Understand how to insert, update, and delete data in SQL databases.
Advanced Querying: Dive deeper into complex SQL queries involving subqueries, aggregate functions, and advanced join operations.
Database Management: Learn about database administration tasks such as creating tables, defining constraints, and managing indexes.
Views and Stored Procedures: Explore the creation and utilization of views and stored procedures to simplify database operations and enhance security.
Transaction Management: Understand the concepts of transactions, isolation levels, and locking mechanisms to ensure data integrity and consistency.
Performance Optimization: Learn techniques to optimize SQL queries and improve database performance.
Working with Multiple Database Systems: Gain experience in working with different database management systems like MySQL, Oracle, or Microsoft SQL Server.
Real-world Applications: Apply SQL concepts and skills to practical scenarios such as data analysis, reporting, and data integration.
Certification: Upon successful completion of the course, you will receive a certificate of completion from UDEMY, indicating your proficiency in SQL. This certification can enhance your resume, demonstrate your SQL skills to potential employers, and open doors to various job opportunities in data analysis, database administration, and software development.
Whether you aspire to become a database professional or want to leverage SQL skills in your existing role, the Complete SQL Training & Certification course equips you with the knowledge and practical experience needed to excel in the world of databases and data management.
Who this course is for:
Anyone interested in learning SQL
Anyone who is interested in passing Oracle SQL exam!

User Reviews

Rating

average 0

Total votes0

Focused display

Mr Vivek has more than 19 + years of industry experience in Project & Quality Management in well know Automotive and Non-automotive industries.His area of specialization includes Project Management, Six Sigma, New product development, Supplier quality assurance, New Supplier development, Supply Management and Supply chain management.He possesses excellent negotiation, organizational, relationship management, problem solving and interpersonal skills with cross-cultural adaptation and creative abilities.Training Portfolio : Six Sigma / PMP & CAPM Training / Primavera P6 / MS Project / Design Thinking / Advance Excel / Soft Skills etc.Professional Qualification :Bachelor of EngineeringMBA (Finance)PMI - PMP CertifiedSix Sigma Black Belt CertifiedScrum Fundamental CertifiedDesign Thinking CertifiedCertified Internal Auditor

Tejaswini G

Instructor's Courses

Tejaswini has more than 15+ years of experience in Data Analysis, Software development, Project Management etc. As a Passionate trainer, she thoroughly unlocks the potentials of audience by incorporating and transforming their values and skills.Training Portfolio : Data Analysis, SQL, Advance Excel, VBA, Scrum, Personality Development, Business English, Digital Marketing.Professional Qualification :MCM (Master in computer management)Scrum CertifiedSix Sigma CertifiedOracle SQL, Java Certified

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.