Beginner SQL with MySQL and JDBC

Focused View

Sadhu Sreenivas

13:10:38

11 View

1. Introduction

1. SQL Beginner Course - Agenda.mp4

08:40

2. MySQL - Installation and Set up

1. MySQL Set up.mp4

28:50

3. Introduction to SQL

1. Introduction to SQL.mp4

31:52

4. DDL Commands

1. DDL Commands - Create.mp4

32:34

2. DDL Commands - Alter and Drop.mp4

21:50

5. DML Commands

1. DML Commands - Insert, Update and Delete.mp4

28:29

6. The Query Command

1. The Query Command - Select.mp4

20:18

2. select command with where clause.mp4

30:18

7. Aggregate functions

1. SQL Aggregate Functions.mp4

25:26

8. Group By and Having clauses

1. Group By and Having Clauses.mp4

30:10

9. SQL MySQL Constraints

1. Introduction to SQLMySQL Constaints.mp4

32:24

2. Not Null and Unique Constraints.mp4

30:39

3. Primary Key Constraint and Auto_Increment.mp4

40:11

4. Default and Check constraints.mp4

24:27

5. Foreign Key Constraint.mp4

26:04

6. Referential Actions for Foreign Key.mp4

22:09

10. SQLMySQL Joins

1. Introduction to Joins.mp4

24:00

2. Join Queries on world database.mp4

35:29

11. SQLMySQL Views

1. Using views in MySQL.mp4

21:47

12. DCL Commands

1. DCL Commands - grant and revoke.mp4

30:35

13. TCL Commands

1. TCL Commands - commit and rollback.mp4

19:55

14. JDBC - Java Database Connectivity

1. JDBC-MySQL Environment Set up.mp4

29:50

2. Steps to connect to MySQL Database.mp4

31:27

3. CRUD Operations using JDBC.mp4

27:12

4. Aggregate functions with JDBC.mp4

18:10

5. Using PreparedStatement Interface.mp4

30:42

6. Using CallableStatement Interface.mp4

22:17

7. Transaction management using JDBC.mp4

18:40

8. Handling Metadata using JDBC.mp4

12:54

15. Mini Project

1.1 author.zip

1.2 book.zip

1.3 dbconnector.zip

1.4 main.zip

1.5 screenshot 2023-09-18 132213.zip

1. Mini Project using MySQL and JDBC.mp4

33:19

Description

Beginner SQL with MySQL and JDBC

What You'll Learn?

Understand basics of Database Management Systems with focus onMySQL
Understand and use Basic SQL Commands
Comfortably work with MySQL and perform CRUD operations
Understand and write JDBC applications with MySQL
A simple mini project using JDBC and MySQL

Who is this for?

students, beginner programmers, aspiring database programmers, data scientists, java developers, data engineers

What You Need to Know?

No programming knowledge but basic understating of databases

More details

Description
The course, "Introduction to SQL," is designed for absolute beginners who want to embark on their journey into the world of databases and structured query language (SQL). The course provides a comprehensive introduction to SQL concepts, focusing on practical skills needed for data retrieval, manipulation, and basic database design.
Key Learning Objectives:
Understanding Databases:
Introduction to databases and their significance in information management.
Overview of relational databases and SQL as a language for data manipulation.
Basic SQL Syntax:
Learning the fundamental structure of SQL queries.
Executing simple SELECT statements for data retrieval.
Data Manipulation:
Inserting new records into a database with the INSERT statement.
Updating and deleting data using the UPDATE and DELETE statements.
Filtering and Sorting Data:
Using the WHERE clause to filter query results.
Sorting data with the ORDER BY clause.
Working with Multiple Tables:
Understanding relationships between tables.
Performing basic JOIN operations to combine data.
Data Aggregation and Grouping:
Introduction to aggregate functions (SUM, AVG, COUNT).
Grouping data using GROUP BY for summary analysis.
Database Design Principles:
Basics of designing a relational database.
Real-world Applications:
Application of SQL skills in practical scenarios.
Engaging in hands-on exercises to reinforce learning.

Upon completion of this course, participants will have a solid understanding of SQL fundamentals. They will be able to confidently perform basic data operations, write simple queries, and design basic relational databases. This course serves as an essential stepping stone for those looking to explore more advanced concepts in SQL and database management.
This course is perfect for individuals who are curious about databases, data analysis, or anyone starting their journey into the world of SQL.
Who this course is for:
students, beginner programmers, aspiring database programmers, data scientists, java developers, data engineers

User Reviews

Rating

average 0

Total votes0

Focused display

R&D Expert, Developer, and Trainer.Expertise in Java Technologies (Java SE & Servlets, JSPs, Hibernate, Spring boot) Web Technologies (HTML, XML technologies, JavaScript Libraries, PHP) Database technologies: MySQL, Oracle, DB2 (with SQL and PL/SQL) Anonymity Networks and Security.Areas of Interest: Information Security, Computer Networks, Database Systems, Cloud Computing and Java & Web Technologies (HTML5, JavaScript and XML technologies)Trained over 500 people on Java Technologies, C/C++, SQL, Python and Advanced Java.Real-time practical exposure and training

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.