Bundle Combo - SQL Programming (with Microsoft SQL Server and MySQL)

Uplatz offers this comprehensive bundle course on SQL Programming with Microsoft SQL Server and MySQL.It is a self-paced course with video lectures. You will be awarded Course Completion Certificate at the end of the course.

Master in-demand SQL skills

This course will equip you with the expertise to design, build, and manage relational databases using two of the most popular database management systems (DBMS) in the world: Microsoft SQL Server and MySQL.

Why take this course?

• Gain proficiency in SQL, a critical skill for data analysis, reporting, and application development.
• Learn to create, manipulate, and query data in both Microsoft SQL Server and MySQL.
• Understand the core functionalities and explore the differences between these two industry-standard platforms.
• Write efficient SQL queries to retrieve and analyze data for various purposes.

What you'll learn:

• Foundational SQL concepts like tables, columns, data types, and relationships.
• Writing essential SQL statements like SELECT, INSERT, UPDATE, and DELETE.
• Working with advanced queries like JOINs, WHERE clauses, and functions.
• Managing database objects like users, roles, and permissions (focus on security best practices).
• Exploring specific features of both Microsoft SQL Server (T-SQL) and MySQL.

SQL Programming with MS SQL Server - Course Syllabus

1. Introduction to Microsoft SQL Server

2. Select and Where

3. SQL Sub Languages - Order By Clauses

4. Any - All - Select Into - Insert Into - Case

5. Delete - Top - Aggregate Functions - Wild Cards

6. Insert - Update - Is Null Commands

7. In - Between - Table Alias

8. SQL Comments - SQL Operators

9. Joins

10. Union All - Union - Group By - Having - Exists - Not Exists

11. Null Functions - Transact SQL

12. Examples - If - Conditional Statements

13. Goto Statement - Looping Construct

14. Sub Programs - Stored Procedures

15. Stored Procedure Examples

16. Modifying and Dropping a Stored Procedure

17. Dynamic Queries - Procedure Returning Values - Functions

18. Break - Continue - Exception Handling

19. Structured Exception Handling

20. Multiple and Nested Try Catch Blocks

21. Using Anonymous Block - Table Valued Functions

22. Backup DB - Differential Example - DDL Statements

23. User Defined DB - Creating DB with GUI - Query - Commands

24. Database Constraints and Domain Integrity Constraints

25. Primary Key and Composite Key

26. Creating 1-to-1 Relationship - Indexes

27. Views and Types of Views

28. Auto Increment - SQL Date Operations

29. Hosting

SQL Programming with MySQL - Course Syllabus

1. Basics of Databases

• Data Models and basic terminologies

• Advantages and disadvantages of DBMS

2. SQL Basic Understanding

• What is SQL?

• What SQL Can do?

• SQL Process

• ACID Properties

• What is ER Model?

• Best Practices

• Database Normalization

3. Introduction to SQL

• SQL Commands

• SQL Constraints

• Types of Keys

• MySQL Hands-on

4. SQL Basic Commands with demonstration

5. Basics and Aggregation Functions

6. Regular Expression Functions

7. SQL Comparison Clauses

• exists

• not exists

• create table like

• case when

• NULL Functions

8. SQL String Functions

9. SQL Numerical Function

10. Introduction to Date Functions

11. SQL Joins – Introduction and demonstration

12. Introduction MySQL Workbench

13. Stored Procedures and Views

Everyone

Passion & determination to achieve big goals in life!

• Data Engineer
• Data Analyst
• Data Scientist
• Database Developer
• Application Developer
• Software Engineer
• Database Administrator (DBA)
• SQL Programmer
• Business Intelligence (BI) Developer
• Software Developer
• Systems Analyst
• IT Consultant
• Data Consultant
• Cloud Engineer

Currently there are no Q&As for this course. Be the first to ask a question.

Uplatz Certificate of Completion

Digital certificate - Included