Bundle Combo - SQL Programming (with Microsoft SQL Server and MySQL)
Self-paced videos, Lifetime access, Study material, Certification prep, Technical support, Course Completion Certificate
Summary
- Uplatz Certificate of Completion - Free
Add to basket or enquire
Overview
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.
Certificates
Uplatz Certificate of Completion
Digital certificate - Included
Course Completion Certificate by Uplatz
Course media
Description
SQL Programming with MS SQL Server - Course Syllabus
Introduction to Microsoft SQL Server
Select and Where
SQL Sub Languages - Order By Clauses
Any - All - Select Into - Insert Into - Case
Delete - Top - Aggregate Functions - Wild Cards
Insert - Update - Is Null Commands
In - Between - Table Alias
SQL Comments - SQL Operators
Joins
Union All - Union - Group By - Having - Exists - Not Exists
Null Functions - Transact SQL
Examples - If - Conditional Statements
Goto Statement - Looping Construct
Sub Programs - Stored Procedures
Stored Procedure Examples
Modifying and Dropping a Stored Procedure
Dynamic Queries - Procedure Returning Values - Functions
Break - Continue - Exception Handling
Structured Exception Handling
Multiple and Nested Try Catch Blocks
Using Anonymous Block - Table Valued Functions
Backup DB - Differential Example - DDL Statements
User Defined DB - Creating DB with GUI - Query - Commands
Database Constraints and Domain Integrity Constraints
Primary Key and Composite Key
Creating 1-to-1 Relationship - Indexes
Views and Types of Views
Auto Increment - SQL Date Operations
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
Who is this course for?
Everyone
Requirements
Passion & determination to achieve big goals in life!
Career path
- 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
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Provider
Uplatz is leading global provider of IT & Technology training.
We have a strong network of qualified and experienced tutors. Uplatz provides training on cutting-edge technologies such as Data Science, Machine Learning, AWS, Microsoft Azure, Google Cloud, IBM Cloud, Data Engineering, Python, R, Java, SAP, Oracle, SAS, Salesforce, Web Development Stack, JavaScript, ReactJS, AngularJS, NodeJS, JSP & Java Servlets, MongoDB, BI Tools such as Tableau, Spotfire, Power BI, DW & ETL tools such as Informatica, IBM DataStage, Talend, DevOps, Project Management, Software Testing, and many more.
We provide training courses in both online formats - 1) live tutor-led, 2) self-paced videos
We feel proud to say that we are making learning affordable by keeping prices of all our courses very low. Our course prices are listed at almost 90% discounted rate from average market price.
Our Vision
- To become a global leader in the learning sector by providing training on job-oriented technologies
Our Mission
- To provide high-quality training on industry-demanded technologies
- To make learning affordable for the masses by keeping our prices extremely low
- To help our talented students get a high-paying job in the market
Will I get a Certificate of Course Completion?
Course Completion Certificate is awarded by Uplatz
What are your top courses?
- Data Science
- Machine Learning
- Cloud Computing - AWS, Azure, Google Cloud, IBM Cloud, and more
- Data Engineering
- SAP modules such as S/4HANA Finance, EWM, TRM, FICO, BPC, HCM, WM, MM, PP, PM, QM, SD, TRM, SuccessFactors, UI5 and Fiori, S/4HANA Logistics, TM, etc.
- Oracle
- SAS
- Salesforce
- BI Tools - Tableau, Power BI, Spotfire, MicroStrategy, etc.
- DW & ETL Tools - Informatica, Talend, IBM DataStage, etc.
- Project Management & DevOps
- Software Testing
- Digital Marketing & SEO
Will I be provided study material, tutor notes and practice assignments?
Uplatz provides tutor notes, practice assignments, practice sessions, and a lot of useful study material for free. This will help you in job interviews and certification exams.
In case of tutor-led online training, will I have access to the recorded sessions?
Yes. All live classes get recorded and life-time access on the recordings is provided.
Course Search and Enrollment
Simply search the course of your choice! We have a portfolio of more than 1000 courses with the premium ones highlighted clearly. Just search for the course that you want to take or simply use our online course finding tool to help you choose the best courses as per your needs and market demand.
Uplatz differentiates itself by providing extremely affordable learning to all and that too in the comfort of their homes.
Just contact us for a customized quote, your preferable timings, your affordability, and we'll work out the best course for you that will provide you not only a great return on investment but also to help you get a job with a premium salary. We'll also get you prepared for the certification exams.
Add to basket or enquire
Legal information
This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
