You are here:

MS SQL/database design and coding for Front-End Web Developer

Advertisement


Question
Hello, Mohit Nayyar

I am a Front-End Web Developer (so I do the HTML, CSS and Javascript of a website). I consider my knowledge of database to be basic, since I took only 1 database subject in college and know how to fetch data through PHP.

I built a website for a client that was fairly simple (it contained information only). Now he wants to add a database to store user information in it. The website was built using HTML, CSS, PHP and Javascript and no Content Management System was used.

How can I get started with designing and building a database for my website?

Thank you

Regards

JK.

PS: you can redirect me to a good website or book that discusses the same issue. I know programming so don't mind technical language.

Answer
Hi Jake

I am really sorry for the delay.

There are lots of books, links and videos to start learning SQL. I will recommend few here...

Online Links
http://www.w3schools.com/sql/default.asp
http://learnsqlserver.in/
http://www.quackit.com/sql_server/tutorial/

Videos (some advance one as well)
http://msdn.microsoft.com/en-us/sqlserver/dd353197
http://channel9.msdn.com/Tags/sql+server

Regards
Mohit  

MS SQL

All Answers


Answers by Expert:


Ask Experts

Volunteer


Mohit Nayyar

Expertise

Microsoft SQL Server: T-SQL development (stored procedures, triggers, functions), Database optimization, performance tuning, high availability (Clustering, Log Shipping, Mirroring, Replication), scalability, SQL Server migration (Sybase/Oracle to SQL Server), SSIS/DTS, Data Warehousing (Kimball Methodology), ETL (SSIS), Cube (SSAS), Reporting Services (SSRS), database modeling, database administration, Security implementation and typically anything related to Microsoft SQL Server.

Experience

With over 10 years of experience in Database Administration, Development, Business Intelligence solutions and managing enterprise level database solutions based on Microsoft SQL Server.
Publications
IT Magazine: ASP, SQL

Publications
IT Magazine: ASP, SQL
SQLServerCentral.com

Education/Credentials
MCA (Masters)

Awards and Honors
Brainbench Certified: RDBMS
MCTS: DBA/Developer/BI for SQL Server 2005/SQL Server 2008
MCITP: DBA/Developer/BI for SQL Server 2005/SQL Server 2008
MCDBA: SQL Server 2000
MCP: SQL Server 6.5

©2016 About.com. All rights reserved.