facebook
favorite button
member since icon
Since May 2023
Instructor since May 2023
Learn SQL scripts, stored procedures, stored functions
course price icon
From 17 £ /h
arrow icon
In this class I start with teaching simple SQL like joins, cte functions etc. Later we will jump to advance sql like writing stored procedures, stored functions etc. Also I will cover very basic database designing concepts. Like the approach how to design good data base depending on the volume, performance etc.
Location
location type icon
Online from Germany
Age
Children (7-12 years old)
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Duration
60 minutes
The class is taught in
English
Hindi
Skills
Availability of a typical week
(GMT -04:00)
New York
at teacher icon
Online via webcam
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
You can learn programming basics, object oriented programming basics. For beginners start with basic programming concepts and then gradually advancing to advance real world projects based on advance modelling approached or based AI ML solutions.
Read more
This course will be focusing on the programming basics. Student can choose his choice of language to learn like python, c#, vb.net or vba. This course will focus base constructs of programming like functions, classes, conditional, decision, repetitive constructs etc.
Read more
Show more
arrow icon
Similar classes
arrow icon previousarrow icon next
verified badge
Pardeep
Mastering MS SQL Server: Database Development and Management

Description:

Unlock the full potential of database development and management with our comprehensive MS SQL Server course. Whether you're a budding database administrator, software developer, or IT professional, this course is designed to equip you with the skills and knowledge needed to harness the power of Microsoft SQL Server.

What You'll Learn:

Introduction to MS SQL Server:

Understand the fundamentals of relational databases.
Explore the architecture and components of MS SQL Server.
Database Design and Normalization:

Design efficient and normalized database structures.
Learn best practices for creating scalable and maintainable databases.
SQL Querying:

Master Transact-SQL (T-SQL) for querying and manipulating data.
Implement stored procedures, functions, and triggers.
Data Modeling and Indexing:

Create effective data models for optimal performance.
Implement and optimize indexes for fast query execution.
Advanced Querying and Reporting:

Explore advanced querying techniques for complex data retrieval.
Generate meaningful reports using SQL Server Reporting Services (SSRS).
Data Security and Permissions:

Implement robust security measures to protect sensitive data.
Manage user roles and permissions effectively.
Backup and Recovery Strategies:

Develop comprehensive backup and recovery plans.
Learn to restore databases in the event of data loss.
Real-World Projects:

Database Development: Design and implement a fully functional database for a real-world scenario.
Performance Optimization: Identify and optimize slow-performing queries and database structures.
Why Choose Our Course:

Hands-On Labs: Apply your knowledge through hands-on labs and real-world scenarios.
Expert Instructors: Learn from experienced database administrators and SQL Server professionals.
Career Guidance: Receive insights into career paths in database development and administration.
Certification Preparation: Prepare for Microsoft SQL Server certifications to boost your credentials.
Who Is This Course For:

Database Administrators
Software Developers
IT Professionals
Students and Enthusiasts interested in database management
Join us in this immersive journey to become a master of MS SQL Server. Enroll now to acquire the skills needed to build and manage robust databases that drive business success!
verified badge
Amin
Data skills can change your career, and you don't need to be a "math person" or have a technical background to learn them. If you can use a computer and you're curious, you can do this. In just 10 hours of one-to-one lessons, you'll go from "I don't know where to start" to analyzing real data on your own.

Maybe you're a student who needs to analyze data for a course or a thesis. Maybe you're looking for your first job in data, finance or business and want a skill that employers ask for. Maybe you already use Excel every day, but your reports take hours and you suspect there's a faster way. Or maybe you've never written a line of code and the idea feels intimidating. This class is built for all of you, and every lesson starts from where you are today.

I'm an engineer, and I work with data, statistics and programming (SQL, Python, R, Excel) every day. I don't teach theory for its own sake. I teach the way I use these tools in real work: you get a real question, a real dataset, and a clear method for turning one into the other.

In 10 hours, you will be able to:

Write SQL queries on your own. Select, filter, sort and group data, combine several tables with JOINs, and answer real questions such as "which product sold the most each month?"
Clean and analyze data in Excel. Use lookup formulas, conditional calculations and PivotTables, and build clear charts, instead of spending hours on manual work.
Build your first Power BI dashboard. Import data, clean it with Power Query, create interactive visuals, and share a report that looks professional.
Explain your results. Turn a business question into a query or a dashboard, check that your results make sense, and present them to someone who doesn't know the data.
Show a finished project. Leave with a portfolio-ready analysis you can use in an interview or in your thesis.

How the 10 hours are organized (we adapt this to your level and goal)

Hours 1-2: Foundations. We define your goal, check your level, and cover your first SQL queries (SELECT, WHERE, ORDER BY).
Hours 3-4: SQL in depth. Grouping and summarizing data, JOINs across tables, and cleaning messy data.
Hours 5-6: Excel for analysis. Advanced formulas, PivotTables, and charts.
Hours 7-8: Power BI. Importing and cleaning data, building visuals, and creating an interactive dashboard.
Hours 9-10: Your project. We put everything together on a realistic dataset (sales, finance, HR or your own data), and I give you feedback and a plan for what to practice next.

If you already know some Excel or SQL, we skip what you know and spend more time on what you need. If you want to go deeper later (for example advanced DAX, Python or statistics), we can continue from the same foundation.

How the lessons work

Every lesson is one-to-one and tailored to you. You practice on your own screen with my guidance, so you learn by doing rather than by watching. Between sessions I can give you short exercises if you want extra practice, and you can send me questions anytime. If you have your own files or work data (anonymized, of course), we can use them, which makes the learning much more relevant. Otherwise I provide practice datasets.

I explain in English or French (or Arabic if that's easier for you), and I'm patient. There are no silly questions. If something doesn't click, I'll explain it another way until it does.

Who this class is for

Students in business, economics, engineering, science or social sciences
Job seekers and career changers who want a first step into data analysis
Professionals who want to automate reports and work faster
Complete beginners. No previous experience with SQL or Power BI is needed.
message icon
Contact Shalini
repeat students icon
1st lesson is backed
by our
Good-fit Instructor Guarantee
Similar classes
arrow icon previousarrow icon next
verified badge
Pardeep
Mastering MS SQL Server: Database Development and Management

Description:

Unlock the full potential of database development and management with our comprehensive MS SQL Server course. Whether you're a budding database administrator, software developer, or IT professional, this course is designed to equip you with the skills and knowledge needed to harness the power of Microsoft SQL Server.

What You'll Learn:

Introduction to MS SQL Server:

Understand the fundamentals of relational databases.
Explore the architecture and components of MS SQL Server.
Database Design and Normalization:

Design efficient and normalized database structures.
Learn best practices for creating scalable and maintainable databases.
SQL Querying:

Master Transact-SQL (T-SQL) for querying and manipulating data.
Implement stored procedures, functions, and triggers.
Data Modeling and Indexing:

Create effective data models for optimal performance.
Implement and optimize indexes for fast query execution.
Advanced Querying and Reporting:

Explore advanced querying techniques for complex data retrieval.
Generate meaningful reports using SQL Server Reporting Services (SSRS).
Data Security and Permissions:

Implement robust security measures to protect sensitive data.
Manage user roles and permissions effectively.
Backup and Recovery Strategies:

Develop comprehensive backup and recovery plans.
Learn to restore databases in the event of data loss.
Real-World Projects:

Database Development: Design and implement a fully functional database for a real-world scenario.
Performance Optimization: Identify and optimize slow-performing queries and database structures.
Why Choose Our Course:

Hands-On Labs: Apply your knowledge through hands-on labs and real-world scenarios.
Expert Instructors: Learn from experienced database administrators and SQL Server professionals.
Career Guidance: Receive insights into career paths in database development and administration.
Certification Preparation: Prepare for Microsoft SQL Server certifications to boost your credentials.
Who Is This Course For:

Database Administrators
Software Developers
IT Professionals
Students and Enthusiasts interested in database management
Join us in this immersive journey to become a master of MS SQL Server. Enroll now to acquire the skills needed to build and manage robust databases that drive business success!
verified badge
Amin
Data skills can change your career, and you don't need to be a "math person" or have a technical background to learn them. If you can use a computer and you're curious, you can do this. In just 10 hours of one-to-one lessons, you'll go from "I don't know where to start" to analyzing real data on your own.

Maybe you're a student who needs to analyze data for a course or a thesis. Maybe you're looking for your first job in data, finance or business and want a skill that employers ask for. Maybe you already use Excel every day, but your reports take hours and you suspect there's a faster way. Or maybe you've never written a line of code and the idea feels intimidating. This class is built for all of you, and every lesson starts from where you are today.

I'm an engineer, and I work with data, statistics and programming (SQL, Python, R, Excel) every day. I don't teach theory for its own sake. I teach the way I use these tools in real work: you get a real question, a real dataset, and a clear method for turning one into the other.

In 10 hours, you will be able to:

Write SQL queries on your own. Select, filter, sort and group data, combine several tables with JOINs, and answer real questions such as "which product sold the most each month?"
Clean and analyze data in Excel. Use lookup formulas, conditional calculations and PivotTables, and build clear charts, instead of spending hours on manual work.
Build your first Power BI dashboard. Import data, clean it with Power Query, create interactive visuals, and share a report that looks professional.
Explain your results. Turn a business question into a query or a dashboard, check that your results make sense, and present them to someone who doesn't know the data.
Show a finished project. Leave with a portfolio-ready analysis you can use in an interview or in your thesis.

How the 10 hours are organized (we adapt this to your level and goal)

Hours 1-2: Foundations. We define your goal, check your level, and cover your first SQL queries (SELECT, WHERE, ORDER BY).
Hours 3-4: SQL in depth. Grouping and summarizing data, JOINs across tables, and cleaning messy data.
Hours 5-6: Excel for analysis. Advanced formulas, PivotTables, and charts.
Hours 7-8: Power BI. Importing and cleaning data, building visuals, and creating an interactive dashboard.
Hours 9-10: Your project. We put everything together on a realistic dataset (sales, finance, HR or your own data), and I give you feedback and a plan for what to practice next.

If you already know some Excel or SQL, we skip what you know and spend more time on what you need. If you want to go deeper later (for example advanced DAX, Python or statistics), we can continue from the same foundation.

How the lessons work

Every lesson is one-to-one and tailored to you. You practice on your own screen with my guidance, so you learn by doing rather than by watching. Between sessions I can give you short exercises if you want extra practice, and you can send me questions anytime. If you have your own files or work data (anonymized, of course), we can use them, which makes the learning much more relevant. Otherwise I provide practice datasets.

I explain in English or French (or Arabic if that's easier for you), and I'm patient. There are no silly questions. If something doesn't click, I'll explain it another way until it does.

Who this class is for

Students in business, economics, engineering, science or social sciences
Job seekers and career changers who want a first step into data analysis
Professionals who want to automate reports and work faster
Complete beginners. No previous experience with SQL or Power BI is needed.
Good-fit Instructor Guarantee
favorite button
message icon
Contact Shalini