Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
"This course was simple enough so that everyone can learn about Windows Forms and using SQLite to connect to app. Lecturer responses to problems quickly, so you can ask for help and get help in 24 hours period. Expecting some advanced topics soon! "
"Great Job of explaining some extremely useful and powerful. So, I trully enjoyed this course. Content is presented in a clear and concise.Alireza is an excellent instructor. He is so responsible for the course and problems. I would highly recommend this to anyone learning C# and SQL easily. "
"It is a excelent course for beginners. Easy to understand and well documented. The teacher's input interesting motivating."
"This class was great. The instructor was very knowledgeable and presented the course in an easy to follow way. The quality of the video was great and I recommend this course to anyone who wants to learn about database connectivity within an application "
C# developers with database designing skill are some of the highest paid programmers throughout the world right now. There couldn't be a better time to join the world of database developers.
About the course
If you are going to learn programming and get a job, this is the right course. This course is designed totally for the beginners. It helps you to learn database programming by using SQLite as a database engine and C# as application development language. Even if you aren't interested in a career change this course will give you the necessary skills to build database application and store and retrieve your data from it.
At the end of this course, you build the fully functional application with C# and SQL. There couldn't be better to build an application in less than hour. It's so fast as you can imagine. By this course, you start to learn and do it at the same time. you can see the result in your code.
What am I going to get from this course?
You will learn how to design simple SQL database and then how you can manage data from your application that you will make in C#. This course is well enough to encourage you to continue database programming.
We will be using some simple code and easy steps to do these works. I provided the source code I'm using during the course. You can download it and test it to learn it.
You can complete this course in a day and after that you can continue this type of programming by attending in similar courses in the intermediate level.
I'm here to help you to go further to change and be a success! Don't hesitate to tell me about your problems, feedbacks and etc.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction|
This is welcome lecture and I tell you what should you know to enter in this course. Also, I tell you what's the course goal and how we can do that.
In this lecture I tell you some information about how developers simplify the way we can program with database and how SQLite is useful for simple applications.
|Section 2: Install the requirements|
How to install valentina studio (free version)Preview
How to install Visual Studio (free version)Preview
|Section 3: Design and create database|
How to create your first database
After this lecture you will be able to create table for your phonebook database
|Section 4: Start programming in C# and Sqlite by creating one Phonebook application|
This is a amazing experience when you can connect to the database from C#.Net. It's so simple and nice! Also the source code of project that I have teached in the course is available for download.
In this lecture I show you how you can insert data from windows form to your table in the database. I implement it as a phonebook fields. Also, I leave here the source code of this lecture that you can download and use it.
In this lecture we learn how we can show data from table to the user in application.
In this lecture we can learn about how we can delete every record from datagrid.
This lecture is the simplest way to beautify your application. I will try to show you how we can change the form layout just by changing some controls color. I'm not going to learn you how you can design beautiful form but we can change some properties to simplify and beautify forms.
|Section 5: Advanced features|
How to update data - part1
How to update data - part2
|Section 6: Summary|
This is a final lecture and I tell you about what you have learned until now.
· Possess over 14 years of experience in Information Technology, System Development Life Cycle (SDLC).
· Creative individual with strong experience in Development, Web Application, Data Base design and implementation
· Strong skills and proven abilities to work under pressure.
· Highly experienced in technical aspect of application development and required technologies.
· Specialized in change-driven (Agile) application development methodology.